📄 jsp读取大对象clob并生成xml文件示例.htm
字号:
<td bgcolor="#666666"><font color="#333333"><strong><font color="#FFFFFF">热点文章链接</font></strong></font><font color="#FFFFFF"> </font></td>
</tr>
<tr>
<td>
<table width="100%" height="2" border="0" cellpadding="2" cellspacing="0" bgcolor="#FFFFFF">
<a href="13004003160.html" target=_blank>JSP生成验证码源程序</a> [<font color="red">18695</font>]<br><a href="13004003159.html" target=_blank>JSP彩色验证码</a> [<font color="red">4417</font>]<br><a href="1300400279.html" target=_blank>一个读取xml文件内容的类</a> [<font color="red">3707</font>]<br><a href="1300400285.html" target=_blank>JSP中读文件和写文件的例子</a> [<font color="red">3144</font>]<br><a href="1300400417.html" target=_blank>将一图片同比例缩小绘制</a> [<font color="red">1887</font>]<br><a href="1300400278.html" target=_blank>jsp读取大对象CLOB并生成xml文件示例</a> [<font color="red">1850</font>]<br><a href="1300400377.html" target=_blank>从网上抓取指定URL源码的方案</a> [<font color="red">1701</font>]<br><a href="1300400330.html" target=_blank>多线程学习初步</a> [<font color="red">1163</font>]<br></table></td>
</tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0" bordercolor="#666666">
<tr>
<td bgcolor="#666666"><font color="#333333"><strong><font color="#FFFFFF">相关文章链接</font></strong></font><font color="#FFFFFF"> </font></td>
</tr>
<tr>
<td> <table width="100%" height="2" border="0" cellpadding="2" cellspacing="0" bgcolor="#FFFFFF">
<a href="13004003160.html" target=_blank>JSP生成验证码源程序</a> [2005-04-11]<br><a href="20012061.html" target=_blank>JSP与XML的结合</a> [2004-02-02]<br><a href="200120101.html" target=_blank>使用xml+jsp技术实现网页内容动态显示的方案</a> [2004-02-09]<br><a href="200120136.html" target=_blank>XML入门之11问答</a> [2004-02-20]<br><a href="200120137.html" target=_blank>XML入门精解之CSS和XSL</a> [2004-02-20]<br><a href="200120138.html" target=_blank>XML入门精解之文件格式定义（DTD）</a> [2004-02-20]<br><a href="200120139.html" target=_blank>XML 入门篇，具体实现 XML 的三种方式</a> [2004-02-20]<br><a href="200120140.html" target=_blank>XML基础教程</a> [2004-02-20]<br><a href="200120141.html" target=_blank>XML入门精解之结构与语法</a> [2004-02-20]<br><a href="200250264.html" target=_blank>Jakarta Struts学习之新手上路</a> [2004-09-20]<br><a href="200120272.html" target=_blank>用JDOM操作XML文件</a> [2004-09-23]<br><a href="1300400279.html" target=_blank>一个读取xml文件内容的类</a> [2004-09-26]<br><a href="200120282.html" target=_blank>简析JAVA的XML编程</a> [2004-09-26]<br><a href="1300390283.html" target=_blank>用JDOM包实现生成XML文件的简单示例</a> [2004-09-26]<br><a href="200120284.html" target=_blank>用JDOM简化XML编程</a> [2004-09-28]<br></table></td>
</tr>
</table></td>
<td width="1%" align="left" valign="top" bgcolor="#666666"> </td>
<td width="73%" align="left" valign="top" bgcolor="#FFFFFF"> <table width="100%" height="726" border="0" cellpadding="2" cellspacing="0" bgcolor="#CCCCCC">
<tr>
<td height="36" align="center" valign="middle" bgcolor="#FFFFFF" style="word-break:break-all" class="title"><strong>jsp读取大对象CLOB并生成xml文件示例</strong></td>
</tr>
<tr>
<td height="40" align="right" valign="middle" bgcolor="#FFFFFF" style="word-break:break-all">作者：unkown
文章来源：<a href="http://www.programfan.com" target=_blank>www.programfan.com</a><br>
访问次数：
<iframe name="ad" frameborder=0 width=30 height=10 scrolling=no src=../count.jsp?news_id=278></iframe>
次 加入时间：2004-09-26</td>
</tr>
<tr>
<td height="2" align="left" valign="top" bgcolor="#CCCCCC"></td>
</tr>
<tr>
<td height="649" align="left" valign="top" bgcolor="#FFFFFF" style="word-break:break-all">
<table width="100%" height="92%" border="0" cellpadding="6" cellspacing="0">
<tr>
<td height="623" align="left" valign="top" class="content"><%@ page contentType="text/html; charset=gb2312" %><br><%@ page info="database handler"%><br><%@ page import="java.io.*"%><br><%@ page import="java.net.*"%><br><%@ page import="java.lang.*"%><br><%@ page import="java.util.*"%><br><%@ page import="java.sql.*"%><br><%@ page import="javax.servlet.*"%><br><%@ page import="javax.servlet.http.*"%><br><%@ page import="oracle.sql.CLOB"%><br><%@ page import="oracle.jdbc.driver.OracleResultSet"%><br><br><html><br><head><br><meta content="text/html; charset=gb2312" http-equiv="content-type"><br></head><br><body><br><%<br> int i=0;<br> String parID = request.getParameter("id_no");<br> String strSql;<br> String content="";<br> <br> try{<br> String xmlFile = "/usr/local/tomcat/webapps/vehicles/test.xml";<br> <br> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");<br> String dburl="jdbc:oracle:thin:@192.168.15.250:1521:ycdb";<br> Connection con=DriverManager.getConnection(dburl,"training","deep1704sea");<br> Statement stmt=con.createStatement();<br> <br> //使用流读取CLOB或BLOB列 <br> strSql = "select xmlgen.getxml('select * from account_holder where id_no=''0001''') from dual "; <br> ResultSet rs=stmt.executeQuery(strSql);<br> if(rs.next()){<br> CLOB clob = ((OracleResultSet)rs).getCLOB(1);<br> if(clob!=null){<br> Reader is = clob.getCharacterStream();<br> BufferedReader br = new BufferedReader(is);<br> String s = br.readLine();<br> while(s!=null){<br> //byte[] temp = s.getBytes("iso-8859-1");<br> //s = new String(temp);<br> content += s;<br> s=br.readLine();<br> } <br> } <br> } <br> //out.println(content);<br> <br> //将从数据库中读出的内容写到文件中<br> FileOutputStream fo = new FileOutputStream(xmlFile);<br> PrintStream so = new PrintStream(fo);<br> so.println(content);<br> so.close();<br> <br> rs.close();<br> stmt.close();<br> con.close();<br><br> }catch(Exception e){<br> out.println(e);<br> }<br>%><br></body><br></html><br><br></td>
</tr>
</table></td>
</tr>
</table>
<table width="100%" height="61" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="29" align="right" valign="middle"><a href="../read_review.jsp?news_id=278">查看该新闻的相关评论</a></td>
</tr>
<tr>
<td height="16" align="right" valign="middle"> </td>
</tr>
<tr>
<td height="1" align="right" valign="middle" bgcolor="#999999"></td>
</tr>
</table>
<table width="100%" height="48" border="0" cellpadding="3" cellspacing="0" bgcolor="#FFFFFF">
<tr bgcolor="#FFFFFF">
<td width="53%" height="48" align="left" valign="top">
<!-- -->
<form name="form3" action="../sendmail.jsp" method="post" onSubmit="return formCheck3()">
<table width="92%" height="206" border="0" cellpadding="2" cellspacing="0" bgcolor="#FFFFFF">
<tr bgcolor="#999999">
<td><font color="#333333"><strong>给我写信</strong></font></td>
</tr>
<tr>
<td height="32" align="center"> <input name=subject type=text size="25" class=inputCls value="邮件主题" onClick="this.value=''" onFocus=this.select() onMouseOver=this.focus()></td>
</tr>
<tr>
<td height="32" align="center"> <INPUT name=from type=text class=inputCls id="from" value="您的邮件" size="25" onClick="this.value=''" onFocus=this.select() onMouseOver=this.focus()>
</td>
</tr>
<tr align="left">
<td height="102" align="center"> <TEXTAREA name="content" rows=6 cols=23 class="textare"></TEXTAREA></td>
</tr>
<tr align="center">
<td> <input type="submit" name="Submit2" class=mybutton value="发送邮件">
</td>
</tr>
</table>
</form>
<!-- -->
</td>
<td width="1%" bgcolor="#999999"></td>
<td width="47%" align="left" valign="top">
<!-- review -->
<form action="../fill_review.jsp" method=post name="form2" onsubmit="return formCheck2()">
<input type="Hidden" name="news_id" value="278">
<table width="92%" height="181" border="0" cellpadding="2" cellspacing="0" bgcolor="#FFFFFF">
<tr bgcolor="#999999">
<td height="20" colspan="2"><font color="#333333"><strong>发表评论</strong></font></td>
</tr>
<tr align="left">
<td width="38%" align="center"></td>
<td width="62%" height="7" align="center"></td>
</tr>
<tr align="center">
<td align="right">您的网名：</td>
<td align="left"> <input name="review_name" type="text" class=inputCls size="14" maxlength=13 value=""></td>
</tr>
<tr align="center">
<td align="right">您的邮箱： </td>
<td align="left"> <input name="review_email" type="text" class=inputCls size="14" maxlength=20 value=""></td>
</tr>
<tr align="center">
<td height="94" colspan="2"> <TEXTAREA name="review_content" rows=5 cols=23 class="textare"></TEXTAREA>
</td>
</tr>
<tr align="center">
<td colspan="2"> <input name="submit" type=submit class=mybutton value="发表评论"></td>
</tr>
</table>
</form>
<!-- review end -->
</td>
</tr>
</table>
<table width="100%" height="79" border="0" cellpadding="2" cellspacing="2" bgcolor="#FFFFFF">
<tr>
<td height="20" align="left" valign="top" bgcolor="#999999"><font color="#333333"><strong>相关文章链接</strong></font></td>
</tr>
<tr>
<td height="53" align="left" valign="top"><a href="13004003160.html" target=_blank>JSP生成验证码源程序</a> [2005-04-11]<br><a href="20012061.html" target=_blank>JSP与XML的结合</a> [2004-02-02]<br><a href="200120101.html" target=_blank>使用xml+jsp技术实现网页内容动态显示的方案</a> [2004-02-09]<br><a href="200120136.html" target=_blank>XML入门之11问答</a> [2004-02-20]<br><a href="200120137.html" target=_blank>XML入门精解之CSS和XSL</a> [2004-02-20]<br><a href="200120138.html" target=_blank>XML入门精解之文件格式定义（DTD）</a> [2004-02-20]<br><a href="200120139.html" target=_blank>XML 入门篇，具体实现 XML 的三种方式</a> [2004-02-20]<br><a href="200120140.html" target=_blank>XML基础教程</a> [2004-02-20]<br><a href="200120141.html" target=_blank>XML入门精解之结构与语法</a> [2004-02-20]<br><a href="200250264.html" target=_blank>Jakarta Struts学习之新手上路</a> [2004-09-20]<br><a href="200120272.html" target=_blank>用JDOM操作XML文件</a> [2004-09-23]<br><a href="1300400279.html" target=_blank>一个读取xml文件内容的类</a> [2004-09-26]<br><a href="200120282.html" target=_blank>简析JAVA的XML编程</a> [2004-09-26]<br><a href="1300390283.html" target=_blank>用JDOM包实现生成XML文件的简单示例</a> [2004-09-26]<br><a href="200120284.html" target=_blank>用JDOM简化XML编程</a> [2004-09-28]<br></td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="38" bgcolor="D00C0C">
<div align="center"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif">Copyright
© 2002-2005 </font><a href="http://www.jspcn.net"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif"><b>JSP</b></font></a><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif">CN.net. All rights reserved.</font></div></td>
</tr>
<tr>
<td height="3" bgcolor="#000000"><img src="images/spacer.gif" width="1" height="3"></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -