<%@ page contentType="text/html; charset=gb2312" %> <%@ page language="java"%> <%@ page info="database handler"%> <%@ page import="java.io.*"%> <%@ page import="java.lang.*"%> <%@ page import="java.util.*"%> <%@ page import="java.sql.*"%> <%@ page import="javax.servlet.*"%> <%@ page import="javax.servlet.http.*"%> <html> <head> <meta content="text/html; charset=gb2312" http-equiv="content-type"> </head> <body> <% int i=0; String temp=null; String parCode = request.getParameter("code"); String strSql; try{ Connection con; Statement stmt; ResultSet rs; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url="jdbc:oracle:thin:@192.168.15.248:1521:ycdb"; con=DriverManager.getConnection(url,"webcfcquery","kill859"); //out.println("<center>jdbcÁ¬½ÓOracleÊý¾Ý¿â</center><br><br>"); stmt=con.createStatement(); strSql = "select account_holder,description from account_holder "; if(parCode!=null) strSql += " where account_holder='"+ parCode +"'"; rs=stmt.executeQuery(strSql); FileOutputStream fo=new FileOutputStream("/usr/local/tomcat/webapps/vehicles/treasurer_voucher.xml"); PrintStream so = new PrintStream(fo); while(rs.next()){ String col1=rs.getString(1); String col2=rs.getString(2); try{ if(i==0){ so.println("<?xml version=\"1.0\" encoding=\"gb2312\" ?>"); so.println("<ufinterface roottag=\"voucher\" billtype=\"gl\" subtype=\"\" replace=\"Y\" receiver=\"1051\" sender=\"1101\" isexchange=\"Y\" filename=\"»á¼ÆÆ¾Ö¤.xml\">"); so.println("<voucher id=\"1234560102\">"); // ×¢Ò⣺ÕâÖÖд·¨ÔÚxmlÎļþÏÔʾʱ»á±¨´í£¬²»ÖªµÀΪʲô£¿ so.println("<custcode>"+col1+"</custcode>"); so.print("<custcode>"); if(col2==null) { //Èç¹û²»Åж϶ÔÏócol2ÊÇ·ñΪnullÖµ£¬ÄÇôÔÚ½øÐбàÂëת»»Ê±¿ÉÄÜ»á³öÏÖNullPointerExceptionÒì³£ so.print(col2); } else { //ÒòÎªÇ°ÃæÒѾ¶¨ÒåxmlÎļþµÄ±àÂëÏÔʾ·½Ê½ÊÇgb2312£¬ËùÒÔÔÚ½«×Ö·û´®col2дÈëxml֮ǰÐèת»»³Égb2312£¬ÕâÑùÔÚxmlÎļþÖкº×Ö²ÅÄÜÕý³£ÏÔʾ¡£ byte[] temp_col = col2.getBytes("gb2312"); col2 = new String(temp_col); so.print(col2); } so.println("</custcode>"); } }catch(Exception e){ out.println(e.toString()); } i++; } so.println("</voucher>"); so.println("</ufinterface>"); so.close(); }catch(Exception e){ out.println(e); } %> </body> </html>
ÍÆ¼öÐÅÏ¢
- ÔÝÎ޼Ǽ
ÈÈÃÅÐÅÏ¢
- nohup: redirecting stderr to stdou....
- ʹÓÃlog_formatΪNginx·þÎñÆ÷ÉèÖøüÏêϸµÄÈÕÖ¾¸ñʽ
- jquery easyUI--dataGrid-Json
- [Ô´´]·ÂGoogle Reader¡¢ÐÂÀË΢²©¡¢ÌÚѶ΢²©µ....
- ÀûÓÃKeepalived+mysql¹¹½¨¸ß¿ÉÓÃMySQLË«Ö÷×Ô¶....
- Nginx+keepalivedʵÏÖ¸ºÔؾùºâºÍË«»úÈȱ¸¸ß¿ÉÓÃ
- jqueryʵÏÖÒ³Ãæ¼ÓÔØ½ø¶ÈÌõ
- Rolling cURL: PHP²¢·¢×î¼Ñʵ¼ù
- codeigniter ·ÓÉÖÕ¼«ÓÅ»¯(url rewrite)
- linuxÏÂÉèÖÃsshÎÞÃÜÂëµÇ¼
×î½ü¸üÐÂ
- java urlÖØÐ´¼¼Êõ(UrlReWriter)
- [ת]JavaµÄÊý×飨Array£©¡¢Vector¡¢ArrayLis....
- jsp»·¾³ÏÂajaxÂÒÂëÎÊÌâµÄ½â¾ö
- JSP¼¼Êõ Ö¸Áî ÂÒÂëÎÊÌâ ÔËÐÐÔÀíºÍ¾Å´óÒþʽ¶ÔÏó web¿ª·¢µÄË....
- JAVA ˮӡ ͼƬ ÎÄ×Ö
- java¶þ½øÖÆ£¬ÔÂë¡¢·´Âë¡¢²¹Â롢λÔËËã
- Java WebÓ¦ÓÃÆô¶¯¼ä¸ôÖ´ÐеijÌÐò
- jspÉú³ÉxmlÎļþʾÀý
- javaÖÐÀà±äÁ¿¡¢Àà·½·¨¡¢ÊµÀý±äÁ¿¡¢ÊµÀý·½·¨
- JSPÒ³ÃæµÄÎåÖÖÌø×ª·½·¨
ÆÀÂÛ