开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
WebPrint.java
资源名称：OA.rar　[点击查看]
上传用户：mingda
上传日期：2017-06-20
资源大小：27691k
文件大小：23k
源码类别：

OA系统

开发平台：

Java

WebPrint.java：源码内容
  1. /**
  2. 公司：北京方成科技发展有限公司
  3. 作者：梅勇
  4. 日期：2001.08.24
  5. */
  6. import java.io.*;
  7. import java.text.*;
  8. import java.util.*;
  9. import javax.servlet.*;
  10. import javax.servlet.http.*;
  11. import java.sql.*;
  12. import explato.database.*;
  13. import sun.io.ByteToCharConverter; 
  17. import org.xml.sax.* ;
  18. import org.apache.xerces.dom.TextImpl;
  19. import org.w3c.dom.Attr;
  20. import org.w3c.dom.Document;
  21. import org.w3c.dom.NamedNodeMap;
  22. import org.w3c.dom.Node;
  23. import org.w3c.dom.NodeList;
  24. import dom.DOMParserWrapper;
  25. import dom.wrappers.DOMParser;
  28. public class WebPrint extends HttpServlet {
  29. private String strXml="";
  30. private ResultSet rs = null;
  31. private ResultSet rs1 = null;
  32. private Connection con = null;
  33. private ConnectionManager cm=null;
  34. private Document document=null;
  36.     public void doPost(HttpServletRequest req,
  37.                       HttpServletResponse res)
  38.         throws IOException, ServletException
  39.     {
  40. //设置演示版,
  41.      long Time1=1026000000+10454400;
  42.      long curTime=0;
  43.      curTime=System.currentTimeMillis();
  44.      curTime=curTime/1000;
  45.     
  46.      //每天的时间为 86400
  47. if(curTime>Time1){ 
  48.      System.out.println("演示版已到期,系统将不正常!"); 
  49.      return ;
  50. }
  51. //------------------
  53.         res.setContentType("text/html;charset=UTF-8");
  54.         PrintWriter out = res.getWriter();
  56. try {
  57.        ServletContext application = getServletContext();
  58. //ConnectionManager cm= (ConnectionManager)application.getAttribute("fcConPoolManager");
  59. cm=(ConnectionManager)application.getAttribute ( "fcConPoolManager" );
  60. //demo是配置文件中逻辑数据库的名字，同时也是连接池的名字
  62. // String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
  63. // String sConnStr = "jdbc:odbc:ereport"; 
  64. // Class.forName(sDBDriver);
  65. // con = DriverManager.getConnection(sConnStr,"sa",""); 
  67. con = cm.getConnection( "demo" );     //或者  con = cm.getConnection( "demo", 30000 );   //30000是不能马上取到连接时的等待时间(以毫秒计)
  70. //-----------------------
  71. /*
  72. Statement stmt = con.createStatement();
  73. //rs = stmt.executeQuery("SELECT * FROM test");
  74. con.setAutoCommit(false);
  75. stmt.executeUpdate("insert into test values('aaa','adfsdfsd')");
  76. int tran1=stmt.getUpdateCount();
  77. if (tran1>0){
  78. con.commit();
  79. }else{
  80. con.rollback();
  81. }
  82. // out.println("tran1="+tran1);
  83. /*String tt;
  84. while (rs.next()) {
  85. tt = rs.getString("fstr1");
  86. out.print("<LI>" + rs.getString("fstr2") + "</LI>");
  87. out.print("<pre>" + tt + "</pre>");
  88. }
  89. rs.close();*/
  90. //----------------------
  91. } catch (Exception e){
  92. //out.println("读表发生错误");
  93. }
  94. finally {
  95. if( con != null ){
  96. cm.freeConnection( "demo", con );
  97. }
  98. }
  99. //-------------------------------------------------------
  100. //strKey为？后的值
  101. String strKey=new String(req.getQueryString());
  102. //计算前台SEND来的XML串 存入strXml中
  103. BufferedReader in = req.getReader();
  104. String line = null;
  105. strXml="";
  106. while ((line = in.readLine()) != null) {
  107.       strXml=strXml+line;
  108.     }        
  109. //parse XML串
  110.     try {
  111.         DOMParserWrapper parser =
  112.         (DOMParserWrapper)Class.forName("dom.wrappers.DOMParser").newInstance();
  113.         document = parser.parseXml(strXml);
  114. }
  115. catch (Exception e) {
  116.     }
  117. //--------------------------------------------------------
  118. //用一个CASE语句来处理各种方法
  119. if (strKey.equals("fc_insert")) out.print(fc_insert());
  120. if (strKey.equals("fc_insert1")) out.print(fc_insert1()); //新增主子表
  121. if (strKey.equals("fc_update1")) out.print(fc_update1()); //新增主子表
  122. if (strKey.equals("fc_select")) out.print(fc_select());
  123. if (strKey.equals("fc_FieldToTable")) out.print(fc_FieldToTable());
  124. if (strKey.equals("twors")) out.print(twors());//两个结果集的测试
  125. if (strKey.equals("sqltoxml")) out.print(sqltoxml());//两个结果集的测试
  127. if (strKey.equals("dsnSetSession")) 
  128. {
  129. Node root = document.getChildNodes().item(0);
  130.         String strName=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
  131.         String strValue="";
  132.         try {
  133.          //当此节点值为空时
  134.          strValue=root.getChildNodes().item(1).getChildNodes().item(0).getNodeValue();
  135. }
  136. catch (Exception e) {   }
  138. HttpSession session = req.getSession(true);
  139. session.setAttribute(strName, strValue);
  140. out.print("");
  141. }
  142. if (strKey.equals("dsnGetSession")) 
  143. {
  144. Node root = document.getChildNodes().item(0);
  145.         String strName=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
  146. HttpSession session = req.getSession(true);
  147. String strSR=session.getAttribute(strName).toString();;
  148. out.print(strSR);
  149. }
  151. if (strKey.equals("loadprint")) { 
  152. String strX="function%20detachPage%28%29%7B%20htmlToptmp%3DhtmlTop%3B%20htmlBottomtmp%3DhtmlBottom%3B%20var%20iStart%3D0%3B%20var%20iEnd%3D0%3B%20var%20lngEndLine%3Dt.rows.length-tabCauda%3B%20var%20colwidthXML%3DLoadUserData%28%22setcolwidth%22%2C%22ReportColWidth%22+ReportName%29%3B%20effectiveWidth%3DparseInt%28repWidth-tabLeft-tabRight%29%3B%20var%20oXML1%3Dnew%20ActiveXObject%28%22Microsoft.XMLDOM%22%29%3B%20oXML1.async%3D%22false%22%3B%20oXML1.loadXML%28%22%3Croot%3E%22%20+colwidthXML+%22%3C/root%3E%22%29%3B%20sumcol%3D0%3B%20var%20compressRate%3D1%3B%20if%28prnSet.compressWidth%3D%3D1%29%20%7B%20for%20%28var%20j%3D0%3Bj%3CMaxCols%3Bj++%29%7B%20if%20%28oXML1.documentElement.childNodes.item%28j%29.getAttribute%28%22colSelect%22%29%3D%3D%22block%22%29%7B%20sumcol%3Dsumcol+parseInt%28oXML1.documentElement.childNodes.item%28j%29.getAttribute%28%22colWidth%22%29%29%3B%20%7D%20%7D%20compressRate%3DeffectiveWidth/%28sumcol+MaxCols%29%3B%20if%28compressRate%3E%3D1%20%29%20%7B%20compressRate%3D1%3B%20%7D%20compressColWidth%28compressRate%29%3B%20%7D%20var%20hcompressRate%3D1%3B%20var%20t_outerHTMLbak%3Dt.outerHTML%20%3B%20if%28prnSet.compressHeight%3D%3D1%29%20%7B%20cur1%3D0%3B%20for%20%28var%20i%3DtabHead%3Bi%3ClngEndLine%3Bi++%29%20%7B%20cur1%3Dcur1+parseInt%28t.rows%28i%29.offsetHeight%29%3B%20%7D%20hcompressRate%3D%28repHeight-tabBottom-tabTop-PageHeadHeight-PageCaudaHeight-heightTop-heightBottom%29/%28cur1+lngEndLine-tabHead%29%3B%20if%28hcompressRate%3E%3D1%20%29%20%7B%20hcompressRate%3D1%3B%20%7D%20compressRowHeight%28hcompressRate%2CtabHead%2ClngEndLine%29%3B%20%7D%20if%20%28prnSet.compressFont%21%3D1%29%20%7B%20var%20compressFont%3D0%3B%20if%28hcompressRate%3CcompressRate%29%20%7B%20compressFont%3DhcompressRate%3B%20%7D%20else%20%7B%20compressFont%3DcompressRate%3B%20%7D%20if%28compressFont%3C1%29%7B%20t.style.fontSize%3DparseFloat%28t.style.fontSize%29*compressFont%3B%20%7D%20%7D%20setAutoturnRow%28%29%3B%20cur1%3D0%3B%20var%20sOtherPage%3D%22%22%3B%20for%20%28var%20i%3DtabHead%3Bi%3ClngEndLine%3Bi++%29%20%7B%20cur1%3Dcur1+parseInt%28t.rows%28i%29.offsetHeight%29%3B%20sOtherPage%3Dt.rows%28i%29.getAttribute%28%22otherpage%22%29%3B%20if%20%28sOtherPage%3D%3D%221%22%20%7C%7C%20cur1%3E%3DrepHeight-tabBottom-tabTop-PageHeadHeight-PageCaudaHeight-heightTop-heightBottom%7C%7C%20i%3D%3DlngEndLine-1%29%7B%20if%20%28sOtherPage%3D%3D%221%22%20%7C%7C%20cur1%3D%3DrepHeight-tabBottom-tabTop-PageHeadHeight-PageCaudaHeight-heightTop-heightBottom%29%20%7B%20cur1%3D0%3B%20%7D%20else%20%7B%20cur1%3DparseInt%28t.rows%28i%29.offsetHeight%29%3B%20%7D%20sumcol%3D0%3B%20var%20bFind%3Dfalse%3B%20iStart%3D0%3B%20iEnd%3D0%3B%20if%20%28sOtherPage%3D%3D%221%22%20%7C%7C%20i%3D%3DlngEndLine-1%29%7B%20perPageHTML%3DperPageHTML+t.rows%28i%29.outerHTML%20%3B%20%7D%20for%20%28var%20j%3D0%3Bj%3CMaxCols%3Bj++%29%7B%20if%20%28oXML1.documentElement.childNodes.item%28j%29.getAttribute%28%22colSelect%22%29%3D%3D%22block%22%29%7B%20sumcol%3Dsumcol+parseInt%28oXML1.documentElement.childNodes.item%28j%29.getAttribute%28%22colWidth%22%29%29*compressRate%3B%20%7D%20if%20%28sumcol%3E%3DeffectiveWidth%20%7C%7C%20j%3D%3DMaxCols-1%29%7B%20if%20%28sumcol%3C%3DeffectiveWidth%29%7B%20iEnd%3Dj%3B%20sumcol%3D0%3B%20%7D%20else%20%7B%20iEnd%3Dj-1%3B%20sumcol%3DparseInt%28oXML1.documentElement.childNodes.item%28j%29.getAttribute%28%22colWidth%22%29%29*compressRate%3B%20%7D%20var%20s1%3DHideCol%28strCol%2CiStart%2CiEnd%29%3B%20bFind%3Dtrue%3B%20PageDataAdd%28Pages%29%3B%20arrPage%5BPages%5D%3DhtmlTop+htmlBottom+tabstyle+s1%3B%20arrPage%5BPages%5D%3DarrPage%5BPages%5D+PageHeadHTML%3B%20arrPage%5BPages%5D%3DarrPage%5BPages%5D+perPageHTML+PageCaudaHTML+%22%3C/Table%3E%22%20+%22%3Cimg%20%3E%22%3B%20if%20%28i%3D%3DlngEndLine-1%29%7B%20if%28cur1%3ErepHeight-tabBottom-tabTop-PageHeadHeight-PageCaudaHeight-heightTop-heightBottom%29%7B%20PageDataAdd%28Pages+1%29%3B%20arrPage%5BPages+1%5D%3DhtmlTop+htmlBottom+tabstyle+s1%3B%20arrPage%5BPages+1%5D%3DarrPage%5BPages+1%5D+PageHeadHTML+PageCaudaHTML+%22%3C/Table%3E%22+%22%3Cimg%20%3E%22%3B%20biglabel.innerHTML%3Dbiglabel.innerHTML%20+%22%3Cdiv%20class%3DpreviewDiv%20%3E%u6B63%u5728%u8BA1%u7B97...%3C/DIV%3E%22%3B%20Pages%3DPages+1%3B%20%7D%20%7D%20biglabel.innerHTML%3Dbiglabel.innerHTML%20+%22%3Cdiv%20class%3DpreviewDiv%20%3E%u6B63%u5728%u8BA1%u7B97...%3C/DIV%3E%22%3B%20Pages%3DPages+1%3B%20if%20%28%28j%3D%3DMaxCols-1%20%29%20%26%26%20%28iEnd%3D%3Dj-1%29%20%29%7B%20var%20s1%3DHideCol%28strCol%2CMaxCols-1%2CMaxCols-1%29%3B%20bFind%3Dtrue%3B%20PageDataAdd%28Pages%29%3B%20arrPage%5BPages%5D%3DhtmlTop+htmlBottom+tabstyle+s1%3B%20arrPage%5BPages%5D%3DarrPage%5BPages%5D+PageHeadHTML%3B%20arrPage%5BPages%5D%3DarrPage%5BPages%5D+perPageHTML+PageCaudaHTML+%22%3C/Table%3E%22+%22%3Cimg%20%3E%22%3B%20if%20%28i%3D%3DlngEndLine-1%29%7B%20if%28cur1%3ErepHeight-tabBottom-tabTop-PageHeadHeight-PageCaudaHeight-heightTop-heightBottom%29%7B%20PageDataAdd%28Pages+1%29%3B%20arrPage%5BPages+1%5D%3DhtmlTop+htmlBottom+tabstyle+s1%20%3B%20arrPage%5BPages+1%5D%3DarrPage%5BPages+1%5D+PageHeadHTML+PageCaudaHTML+%22%3C/Table%3E%22+%22%3Cimg%20%3E%22%3B%20biglabel.innerHTML%3Dbiglabel.innerHTML%20+%22%3Cdiv%20class%3DpreviewDiv%20%3E%u6B63%u5728%u8BA1%u7B97...%3C/DIV%3E%22%3B%20Pages%3DPages+1%3B%20%7D%20%7D%20biglabel.innerHTML%3Dbiglabel.innerHTML%20+%22%3Cdiv%20class%3DpreviewDiv%20%3E%u6B63%u5728%u8BA1%u7B97...%3C/DIV%3E%22%3B%20Pages%3DPages+1%3B%20%7D%20iStart%3DiEnd+1%3B%20%7D%20%7D%20perPageHTML%3D%22%22%3B%20%7D%20if%28sOtherPage%21%3D%221%22%29%20perPageHTML%3DperPageHTML+t.rows%28i%29.outerHTML%20%3B%20%7D%20mdblRate%3D1%3B%20htmlTop%3D%22%22%3B%20htmlBottom%3D%22%22%3B%20t.outerHTML%3Dt_outerHTMLbak%3B%20t.style.display%3D%22none%22%3B%20for%28var%20i%3D0%3Bi%3CPages%3Bi++%29%7B%20arrPage%5Bi%5D%3Dfc_RepStr%28arrPage%5Bi%5D%2C%22%28P%29%22%2CPages+%22%22%29%3B%20%7D%20%7D%20%20";
  153. out.println(strX);
  154. }
  160. }
  164. //下面是自定义的方法
  165. //--------------------------------------
  166. //两个结果集的示例,第一个用连接池打开,第二个用一般方式打开
  167. private String twors() {
  168. // Node root = document.getChildNodes().item(0);
  169.  //   String sField=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
  170.   //  String sTable=root.getChildNodes().item(1).getChildNodes().item(0).getNodeValue();
  171. String strSql="select flngVoucherID,fstrVoucherTypeName from Voucher" ;
  172. String sTmp="";
  173. try {
  174. Statement stmt = con.createStatement();
  175. rs = stmt.executeQuery(strSql);
  176. while (rs.next()) {
  177. String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
  178. String sConnStr = "jdbc:odbc:ereport"; 
  179. Class.forName(sDBDriver);
  180. Connection con1 = DriverManager.getConnection(sConnStr,"sa",""); 
  181. String sT=rs.getString(1);
  182. Statement stmt1 = con1.createStatement();
  183. rs1 = stmt1.executeQuery("select fstrAccountName from voucherdetail Where flngVoucherId="+sT);
  184. while (rs1.next()) {
  185. System.out.println("科目:"+rs1.getString(1));
  186. }
  187. }
  188. }
  189. catch (Exception e){
  190. sTmp=e.getMessage() ;
  191. }
  192. return sTmp;
  193. }
  194. //--------------------------------------
  195. private String fc_FieldToTable() {
  196. Node root = document.getChildNodes().item(0);
  197.     String sField=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
  198.     String sTable=root.getChildNodes().item(1).getChildNodes().item(0).getNodeValue();
  199. String strSql="select "+sField+" From "+sTable ;
  200. String sTmp="";
  201. try {
  202. Statement stmt = con.createStatement();
  203. rs = stmt.executeQuery(strSql);
  204. }
  205. catch (Exception e){
  206. sTmp=e.getMessage() ;
  207. }
  208. return sTmp;
  209. }
  210. //--------------------------------------
  211. private String fc_select() {
  212. Node root = document.getChildNodes().item(0);
  213.     String strSql=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
  214.     String strPageNo=root.getChildNodes().item(1).getChildNodes().item(0).getNodeValue();
  215. int iPageNo=Integer.parseInt(strPageNo,10);//页号
  216.     String strPageSize=root.getChildNodes().item(2).getChildNodes().item(0).getNodeValue();
  217. int iPageSize=Integer.parseInt(strPageSize,10);//页尺寸
  218. strSql=fcTrans(strSql);
  219. //System.out.println(strSql);
  220. String strX = "<root>";
  221. String sTmp = "";
  222. int iField=1;
  223. int iCount=1;
  224. int i=1;
  225. try {
  226. Statement stmt = con.createStatement();
  227. rs = stmt.executeQuery(strSql);
  228.         ResultSetMetaData rsmd=rs.getMetaData();
  229. while (rs.next()) {
  230. //每页30行
  231. if (i>(iPageNo-1)*iPageSize && i<=iPageNo*iPageSize) {
  232.         strX = strX + "<record>";
  233. iCount=rsmd.getColumnCount();
  234.         for (iField = 1 ; iField<=iCount ;iField++ ) 
  235. {
  236. //当有NULL字段名时,表示此则无需给值.用fcnull标记名区分.
  237. String colName=rsmd.getColumnName(iField);
  238. if (colName==null) {
  239. strX = strX + "<fcnull></fcnull>" ;
  240. }
  241. else {
  242. String sT=rs.getString(iField);
  243. if (sT==null) sT="";
  244.             strX = strX + "<fc>" + sT +"</fc>" ;
  245.             }
  246. }
  247.         strX = strX + "</record>";
  248.         }
  249.         i = i + 1;
  250. }
  251. i=i-1;
  252. if (i>0) {
  253. strX = strX + "<pages>"+i+"</pages>";
  254. }
  255. strX = strX + "</root>";
  256. rs.close();
  257. }
  258. catch (Exception e){
  259. sTmp=e.getMessage() ;
  260. System.out.println(sTmp);
  261. }
  263. return strX ;
  265. }
  267. //--------------------------------------
  268. private String fc_insert() {
  269. Node root = document.getChildNodes().item(0);
  270.     String strSql=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
  271. strSql=fcTrans(strSql);
  272. String sTmp = "";
  273. // CallableStatement cstmt=null;
  274. try {
  275. Statement stmt = con.createStatement();
  276. // stmt.executeQuery(strSql);
  278. stmt.executeUpdate(strSql);
  279. /*
  280. cstmt=con.prepareCall("{call sp_getID(?)}");
  281. cstmt.registerOutParameter(1,java.sql.Types.INTEGER,1);
  282. cstmt.executeUpdate();
  283. sTmp="<dsnID>"+ cstmt.getInt(1)+"</dsnID>";
  284. */
  285. }
  286. catch (Exception e){
  287. sTmp=e.getMessage() ;
  288. }
  290. return sTmp ;
  292. }
  293. //--------------------------------------
  294. private String fc_insert1() {
  295. //凭证增加
  296. Node root = document.getChildNodes().item(0);
  297. String sTmp = "";
  298. CallableStatement cstmt=null;
  299. try {
  300. Statement stmt = con.createStatement();
  301. int i;
  302. //System.out.println(root.getChildNodes().getLength());
  303.     String strSql=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
  304. strSql=fcTrans(strSql);
  305. stmt.executeUpdate(strSql);
  307. String sID="1"; //存主表新生成的ID
  309. try {
  310. //SQL Server 的存储过程,用于计算自动ID
  311. cstmt=con.prepareCall("{call sp_getID(?)}");
  312. cstmt.registerOutParameter(1,java.sql.Types.INTEGER,1);
  313. cstmt.executeUpdate();
  314. sID=""+cstmt.getInt(1);
  315. }
  316. catch (Exception e1){
  317. try {
  318. //计算MS Access数据库的主表ID
  319. String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
  320. String sConnStr = "jdbc:odbc:webprint"; 
  321. Class.forName(sDBDriver);
  322. Connection con1 = DriverManager.getConnection(sConnStr,"sa",""); 
  323. Statement stmt1 = con1.createStatement();
  324. rs1 = stmt1.executeQuery("select max(flngSendOutID) From SendOut");
  325. if (rs1.next()) {
  326. sID=rs1.getString(1);
  327. }
  328. }
  329. catch (Exception e2){
  330. }
  331. }
  333. //追加子表内容
  334. for(i=1;i<root.getChildNodes().getLength();i++) {
  335.     strSql=root.getChildNodes().item(i).getChildNodes().item(0).getNodeValue();
  336. strSql=fcTrans(strSql);
  337. strSql=strSql+sID+" )";
  338. stmt.executeUpdate(strSql);
  339. }
  341. }
  342. catch (Exception e){
  343. System.out.println(e.getMessage()) ;
  344. }
  346. return sTmp ;
  348. }
  349. //--------------------------------------
  350. private String fc_update1() {
  351. //凭证修改
  352. Node root = document.getChildNodes().item(0);
  353. String sTmp = "";
  354. String strSql="";
  355. try {
  356. Statement stmt = con.createStatement();
  357. int i;
  359. for(i=0;i<root.getChildNodes().getLength();i++) {
  360.     strSql=root.getChildNodes().item(i).getChildNodes().item(0).getNodeValue();
  361. strSql=fcTrans(strSql);
  362. stmt.executeUpdate(strSql);
  363. }
  365. }
  366. catch (Exception e){
  367. System.out.println(e.getMessage()) ;
  368. }
  370. return sTmp ;
  372. }
  373. //--------------------------------------
  374. private String SqlToField(String strSql) {
  375. //用一个SQL语句返回一个字段的第一个记录值
  376. String strR =  "";
  377. try {
  378. Statement stmt = con.createStatement();
  379. rs = stmt.executeQuery(strSql);
  380. if (rs.next()) {
  381.     strR = rs.getString(1) ;
  382. }
  383. rs.close();
  384. stmt.close();
  385. }
  386. catch (Exception e){
  387. //out.println("读表发生错误");
  388. }
  389. return strR;
  391. }
  394. //--------------------------------------
  395. //通用函数
  396. private String rTrim(String str){
  397.      String rstr = str;
  398.   if(str == null)
  399.          {
  400.     rstr = "";
  401.   }
  402.          else
  403.          {
  404.     if(str.length() == 0) rstr = "";
  405.     if(str.length() > 0)
  406.     {
  407.       for(int i = str.length() ; i  >  0 ; i--)
  408.              {
  409.      if(str.substring(i-1,i).equals(" "))  
  410.        rstr = rstr.substring(0,i-1);
  411.      else break;
  412.    }
  413.      } 
  414.        
  415.   }
  416.   return rstr;
  417. } 
  419. //--------------------------------------------
  420. private String  XmlOut(ResultSet oRs , String sRowEntityName,long EntFormat ) 
  421. {
  422. String sSet="";
  423. try {
  424. //oRs.first();
  425. while (oRs.next())
  426. {
  427.     sSet = sSet + RecordToXMLEntity(oRs, sRowEntityName, EntFormat) ;
  428. }
  429. }
  430. catch (Exception e)
  431. {
  432. return e.getMessage();
  433. }
  434. return sSet ;
  435. }
  437. private String  RecordToXMLEntity(ResultSet oRs , String EntityName,long EntFormat)
  438. {
  439. String sEty ="";
  440. int iField=1;
  441. int iCount=1;
  442.     try {
  443.     ResultSetMetaData rsmd=oRs.getMetaData();
  444. iCount=rsmd.getColumnCount();
  445. if (EntFormat==1) 
  446. {
  447. //属性
  448.         sEty = "<" + EntityName ;
  450.         for (iField = 1 ; iField<=iCount ;iField++ ) 
  451. {
  452.             sEty = sEty + " " + rsmd.getColumnName(iField) +"='" + oRs.getString(iField) +"'" ;
  453. }
  454.         sEty = sEty + "/>" + "n";
  456. }
  457. else
  458. {
  459. //节点
  460.     sEty = "<" + EntityName +">" +"n" ;
  461.         for (iField = 1 ; iField<=iCount ; iField++) 
  462.         {
  463.             sEty = sEty +"<" +  rsmd.getColumnName(iField) +">" + oRs.getString(iField) +"</" + rsmd.getColumnName(iField) +">";
  464.         }
  465.         sEty = sEty +"n" +"</" + EntityName +">" +"n";
  467. }
  468. }
  469. catch (Exception e)
  470. {
  471. }
  472. return sEty;
  473. }
  474. //-----------------------------------------------------
  475. private Attr[] sortAttributes(NamedNodeMap attrs) {
  477.     int len = (attrs != null) ? attrs.getLength() : 0;
  478.     Attr array[] = new Attr[len];
  479.     for ( int i = 0; i < len; i++ ) {
  480.         array[i] = (Attr)attrs.item(i);
  481.     }
  482.     for ( int i = 0; i < len - 1; i++ ) {
  483.         String name  = array[i].getNodeName();
  484.         int    index = i;
  485.         for ( int j = i + 1; j < len; j++ ) {
  486.             String curName = array[j].getNodeName();
  487.             if ( curName.compareTo(name) < 0 ) {
  488.                 name  = curName;
  489.                 index = j;
  490.             }
  491.         }
  492.         if ( index != i ) {
  493.             Attr temp    = array[i];
  494.             array[i]     = array[index];
  495.             array[index] = temp;
  496.         }
  497.     }
  499.     return(array);
  501. } // sortAttributes(NamedNodeMap):Attr[]
  504. private  String fcTrans(String sSource) 
  505. {
  506. //
  507. //XML节点中的汉字经8859_1==>UTF-8转换后用System.out.println输出正常
  509. String unicodesR ="";
  510. try {
  511. byte [] by = sSource.getBytes("8859_1"); //GB2312
  512. unicodesR = new String(by,"UTF-8");
  513. }
  514. catch (Exception e)
  515. {
  516. }
  517. //System.out.println(unicodesR);
  518. return unicodesR;
  519. ///
  522. }
  523. //--------------------------------------------
  524. //WebCode中用
  525. private  String sqltoxml() 
  526. {
  527. Node root=document.getChildNodes().item(0);
  529. String strpage=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
  530. String strsql=root.getChildNodes().item(1).getChildNodes().item(0).getNodeValue();
  531. strsql=fcTrans(strsql);
  532. String strsearch=root.getChildNodes().item(2).getChildNodes().item(0).getNodeValue();
  533. String strrownum=root.getChildNodes().item(3).getChildNodes().item(0).getNodeValue();
  534. String showcheckbox=root.getChildNodes().item(4).getChildNodes().item(0).getNodeValue();
  535. String blnempty=root.getChildNodes().item(5).getChildNodes().item(0).getNodeValue();
  536. //加空行
  537. showcheckbox=showcheckbox.toUpperCase();
  538. int intpage=Integer.parseInt(strpage);//开始页
  539. int intrownum=Integer.parseInt(strrownum);//页尺寸
  540. String strX="";
  541. try {
  543. //建立数据库连接
  544. Statement stmt = con.createStatement();
  547. //执行查询建立结果集
  548. //-----------------
  549. //System.out.print(strsearch);
  550. int i=1;
  551. if (strsearch.compareTo("###")!=0){
  552. rs = stmt.executeQuery(strsql);
  553. boolean bfind=false;
  555. while(rs.next()){
  556. String searchone=rs.getString(1);
  557. //out.print(searchone);
  558. if (searchone.equals(strsearch)){
  559. bfind=true;
  560. break;
  561. }
  562. i=i+1;
  563. }
  564. rs.close();
  565. if (bfind==true){
  566. if (i<=intrownum){
  567. intpage=1;
  568. }
  569. else {
  570. if (i%intrownum>0){
  571. intpage=i/intrownum+1;
  572. }
  573. else {
  574. intpage=i/intrownum;
  575. }
  576. }
  577. }
  578. //自动定位到当前选择所在值的页
  579. }
  580. //out.print("intpage="+intpage);
  581. //-----------------
  582. // System.out.print(intpage);
  586. rs = stmt.executeQuery(strsql);
  588. ResultSetMetaData rsmd=rs.getMetaData();
  590. strX="<root>";
  591. String sLabel="";
  592. int k=0;
  593. int thisrow=0;
  594. int pagenumber=0;//总页数
  595. int iFind=0; //控制在开始处插入一个空白行
  596. while (rs.next()) {
  597. if (blnempty.equals("true") && iFind==0) {
  598. //插入一个空白行
  599. strX=strX+"<tr height='16'>";
  600. for (i=1;i<=rsmd.getColumnCount();i++) {
  601.         strX = strX + "<td></td>";
  602. }
  603. strX=strX+"</tr>";
  604. iFind=1;
  605. }
  607. if (k>=(intpage-1)*intrownum && k<(intpage)*intrownum){
  608. strX = strX + "<tr>";
  609. for (i=1;i<=rsmd.getColumnCount();i++) {
  610.         sLabel=rsmd.getColumnLabel(i);
  611.         //System.out.println(rsmd.getColumnTypeName(i));
  612. String sT=rs.getString(i);
  613. if (sT==null) sT="";
  614.         strX = strX + "<td>" + sT + "</td>";
  615. }
  616. if (showcheckbox.equals("TRUE"))
  617.   strX = strX + "<td width='30'><input type='checkbox'></input></td>"+"</tr>";
  618.                 else 
  619.                     strX = strX + "</tr>";
  620. }
  621. k=k+1;
  622. }
  624. if (k%intrownum>0)
  625.      pagenumber=k/intrownum+1;
  626.         else 
  627.             pagenumber=k/intrownum;
  629. strX=strX+"<pagenumber>"+pagenumber+"</pagenumber><intpage>"+intpage+"</intpage></root>";
  632. } catch (Exception e){
  633. strX=e.getMessage();
  634. }
  635. return strX;
  636. }
  638. }