<%@ 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 确有记录。
解决方案 »
- 优先级问题
- 新手求意见 定义的一学生类,并创建类的对象。
- 求用JAVA做出万年历从已知的1900年1月1日开始
- 求把正方形的图标 转换为 平行4边形图标算法
- 求助.!类的问题或者是参数问题.
- 用jxl修改excel,程序运行后打开excel文档,总是提示“不能读取文件”,附小段程序,求救
- 请问在SWT Designer文件中,swt.jar jface.jar文件在哪里?
- 怎样删除树???
- {求助}关于windows下java窗口事件的的处理。
- borland 的JBUILDER 是否是最优秀的JAVA编译器?
- JDBC 2.0要下载才有吗?如果是,请问哪有, sun上怎么没有
- 紧急求助!谢谢!
有可能是你的jdbc驱动不支持可更新的记录集,
我以前在mysql上也遇到过
我是这样解决的:
1 修改smartupload的源码,在File类增加一个getInputStream的方法取得输入流
2 创建PreparedStatement,用setBinaryStream方法写入