jsp读取大对象CLOB并生成xml文件示例


答案：

                        <%@ 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>
上一个：Tomcat5+Mssql server 2000数据库连接池配置之旅
下一个：JRun3.0配合IIS的安装全过程
更多图片编程知识: