jsp读取大对象CLOB并生成xml文件示例--JSP中文网

做最专业的JSP中文网站

当前位置：首页--程序代码--原子代码

JSPCN文章目录分类

JSP配置	[219]	JSP基础	[136]
中文问题	[69]	上传问题	[27]
JAVABEAN	[46]	数据库	[212]
文件操作	[126]	图片声音	[17]
JSP其他	[57]	时间相关	[16]
JAVAMAIL	[72]	STRUTS	[144]
开发工具	[28]	教程系列	[157]
JSP实例	[89]

JAVA基础	[421]	APPLET	[78]
JAVA网络	[179]	Applica	[115]
Servlet	[98]	XML	[163]
J2ME	[257]	J2EE	[374]
考试相关	[63]	JAVA线程	[90]
EJB	[261]	Swing	[26]
Java API	[141]	声音图片	[28]
异常处理	[33]	JAVA实例	[290]
JAVA类	[139]	SUN	[89]
Hibernate	[6]	JMX	[8]
Spring	[34]

本版推荐文章

本版热点文章

相关文章链接

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

作者：未知文章来源：www.jspcn.net
访问次数：738次加入时间：2004年10月13日

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

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