时间: 2021-07-31 作者:daque
<%@ page contenttype="text/html; charset=utf8" %> <%@ 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=utf8" 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>