在人生的舞台上，你就是故事里的主角。因为你就是你，独一无二的你，无需去攀比，只要扮演好自己的角色，无需计较谁的戏份多。
<%@ 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> 到此这篇关于javascriptp读取大对象CLOB并生成xml文件示例就介绍到这了。从来没有得罪过人的人，注定不能与人深交，过分的平与与宽容，反而丧失了做人的准则与尊严。更多相关javascriptp读取大对象CLOB并生成xml文件示例内容请查看相关栏目，小编编辑不易，再次感谢大家的支持！