<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*,com.jspsmart.upload.*"%>
<jsp:useBean id="mySmartUpload" scope="page" class="com.jspsmart.upload.SmartUpload" />
<HTML>
<BODY BGCOLOR="white">
<%
int count=0; Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.129:1521:ORCL","zw","zw"); Statement stmt = con.createStatement( ResultSet.TYPE_FORWARD_ONLY ,ResultSet.CONCUR_UPDATABLE );
ResultSet rs = stmt.executeQuery("SELECT news_picture FROM news where news_id=11111111111111");
if (rs.next()){
mySmartUpload.initialize(pageContext); mySmartUpload.upload(); if (!mySmartUpload.getFiles().getFil(0).isMissing()){ try { mySmartUpload.getFiles().getFile(0).fileToField(rs,"news_picture");
out.println(rs.rowUpdated());
rs.updateRow();
count++;
} catch(Exception e) {
out.println("An error occurs : " + e.toString());
} } }
out.println(count + " file(s) uploaded in the database."); rs.close();
stmt.close();
con.close();
%>
</BODY>
</HTML>注:news_picture为Blob字段
news_id=11111111111111 确有记录。
<%@ page language="java" import="java.sql.*,com.jspsmart.upload.*"%>
<jsp:useBean id="mySmartUpload" scope="page" class="com.jspsmart.upload.SmartUpload" />
<HTML>
<BODY BGCOLOR="white">
<%
int count=0; Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.129:1521:ORCL","zw","zw"); Statement stmt = con.createStatement( ResultSet.TYPE_FORWARD_ONLY ,ResultSet.CONCUR_UPDATABLE );
ResultSet rs = stmt.executeQuery("SELECT news_picture FROM news where news_id=11111111111111");
if (rs.next()){
mySmartUpload.initialize(pageContext); mySmartUpload.upload(); if (!mySmartUpload.getFiles().getFil(0).isMissing()){ try { mySmartUpload.getFiles().getFile(0).fileToField(rs,"news_picture");
out.println(rs.rowUpdated());
rs.updateRow();
count++;
} catch(Exception e) {
out.println("An error occurs : " + e.toString());
} } }
out.println(count + " file(s) uploaded in the database."); rs.close();
stmt.close();
con.close();
%>
</BODY>
</HTML>注:news_picture为Blob字段
news_id=11111111111111 确有记录。
解决方案 »
- 简单字符串替换问题
- 新手!!请路个的给指点一下!
- jspSmartUpload 求助
- 如何让线程轮寻每一个socket链接,并处理收到的数据
- SOS!!!老大人救小弟呀!关于<@ include file="">的问题
- getRunStart和getRunLimit的使用,难道就没有人知道吗?
- 请问各路高手,万年历的农历编号是怎么算的?
- TomCat4.x 怎么和IIS整和 TomCat4.x带的文档都是3.x的 用的也是jk的说明
- 用JAVA开发短信业务的问题
- 曾经见到有人介绍C和JAVA一起学的帖子,还介绍了两本书,请问谁知道这个帖子吗?
- JDBC 2.0要下载才有吗?如果是,请问哪有, sun上怎么没有
- 紧急求助!谢谢!
有可能是你的jdbc驱动不支持可更新的记录集,
我以前在mysql上也遇到过
我是这样解决的:
1 修改smartupload的源码,在File类增加一个getInputStream的方法取得输入流
2 创建PreparedStatement,用setBinaryStream方法写入