<form id="hz9zz"></form>
    • <form id="hz9zz"></form>
    

      

      <nobr id="hz9zz"></nobr>
      <form id="hz9zz"></form>
      3.   
          
      明輝手游網中心：是一個免費提供流行視頻軟件教程、在線學習分享的學習平臺！
                   
        
                           
        
                        		  
        
                 
              
                
      jsp讀取大對象CLOB并生成xml文件示例
                
                  發表時間：2024-01-24             來源：明輝站整理相關軟件相關文章人氣：          
              
      [摘要]<%@ page contentType="text/html; charset=gb2312" %> <%@ page info="database handler"%> <%@ page import="java....

                              <%@ page contentType="text/html; charset=gb2312" %> 
      <%@ page info="database handler"%> 
      <%@ page import="java.io.*"%> 
      <%@ page import="java.net.*"%> 
      <%@ page import="java.lang.*"%> 
      <%@ page import="java.util.*"%> 
      <%@ page import="java.sql.*"%> 
      <%@ page import="javax.servlet.*"%> 
      <%@ page import="javax.servlet.http.*"%> 
      <%@ page import="oracle.sql.CLOB"%> 
      <%@ page import="oracle.jdbc.driver.OracleResultSet"%> 

      <html> 
      <head> 
      <meta content="text/html; charset=gb2312" http-equiv="content-type"> 
      </head> 
      <body> 
      <% 
      int i=0; 
      String parID = request.getParameter("id_no"); 
      String strSql; 
      String content=""; 

      try{ 
      String xmlFile = "/usr/local/tomcat/webapps/vehicles/test.xml"; 

      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
      String dburl="jdbc:oracle:thin:@192.168.15.250:1521:ycdb"; 
      Connection con=DriverManager.getConnection(dburl,"training","deep1704sea"); 
      Statement stmt=con.createStatement(); 

      //使用流讀取CLOB或BLOB列 
      strSql = "select xmlgen.getxml('select * from account_holder where id_no=''0001''') from dual "; 
      ResultSet rs=stmt.executeQuery(strSql); 
      if(rs.next()){ 
      CLOB clob = ((OracleResultSet)rs).getCLOB(1); 
      if(clob!=null){ 
      Reader is = clob.getCharacterStream(); 
      BufferedReader br = new BufferedReader(is); 
      String s = br.readLine(); 
      while(s!=null){ 
      //byte[] temp = s.getBytes("iso-8859-1"); 
      //s = new String(temp); 
      content += s; 
      s=br.readLine(); 
      } 
      } 
      } 
      //out.println(content); 

      //將從數據庫中讀出的內容寫到文件中 
      FileOutputStream fo = new FileOutputStream(xmlFile); 
      PrintStream so = new PrintStream(fo); 
      so.println(content); 
      so.close(); 

      rs.close(); 
      stmt.close(); 
      con.close(); 

      }catch(Exception e){ 
      out.println(e); 
      } 
      %> 
      </body> 
      </html> 




              
              
                 
              
                                            
                              		       
                          
                           		  
        
                            
      
日韩精品一区二区三区高清