jsp读取大对象CLOB并生成xml文件示例
来源:互联网 发布:批量下载歌词软件 编辑:程序博客网 时间:2024/04/28 21:11
<%@ 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 Fwww.169mnk.comileOutputStream(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 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 Fwww.169mnk.comileOutputStream(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>
- jsp读取大对象CLOB并生成xml文件示例
- jsp读取大对象CLOB并生成xml文件示例
- jsp生成xml文件示例
- jsp生成xml文件示例
- jsp生成xml文件示例
- JSP Oralcle CLOB 文件读取
- jsp生成xml文件示例-JSP教程,Jsp/Servlet
- 读取XML文件并生成DataTable
- 读取Oracle数据库大对象(CLOB)
- 读取Clob字段的xml并解析此xml
- Java生成和解析XML格式文件和字符串的实例代码【dom4j中的SAXReader对象读取并解析xml文件】
- Android 读取文件并将内容生成XML文件
- 通过xStream读取xml文件生成Java对象和Java对象生成xml文件
- Java读取一个xml文件并生成相应的类
- java实现xml文件读取并保存到对象
- JAVA-读取XML文件并将值赋给对象
- 读取xml文件小示例
- jsp 读取xml文件
- 第一天
- 二叉树遍历非递归实现
- Linux GTK 缩放 (Scaling) — 缩放pixbuf和缩放并合并pixbuf
- 【Cocos2d-X开发学习笔记】第30期:游戏中数据的存储(下)
- C语言 数组、字符串长度及所占内存
- jsp读取大对象CLOB并生成xml文件示例
- UVA 437The Tower of Babylon (dp + DAG最长序列)
- Linux find命令
- 在activity的属性里加上这条属性,被该activity遮挡的Activity不会调用onStop()
- hdu(1719)Friend
- wim 显示 配置在/etc/vim文件夹下,新建vimrc.local
- Linux下的定时器类实现(select定时+线程)
- java内部类
- 一个读取xml文件内容的类