<%@ 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 确有记录。