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

最新推荐文章于 2017-05-04 16:19:00 发布

andunkafei

最新推荐文章于 2017-05-04 16:19:00 发布

阅读量1.1k

点赞数

分类专栏：【Jsp】文章标签： jsp xml import string exception training

本文链接：https://blog.csdn.net/andunkafei/article/details/131577

版权

【Jsp】专栏收录该内容

5 篇文章 0 订阅

订阅专栏

<%@ 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>

andunkafei

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
jsp读取大对象CLOB并生成xml文件示例

<% int i=0; String parID = request.getParameter("id_no"); String strSql; String content=""; try{ String xmlFile = "/usr/local/t
复制链接

扫一扫