java 写blob字段

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import oracle.sql.BLOB;

public class AddPicture {

    /**
     * @param args
     */
    public static void main(String[] args) {
        // TODO Auto-generated method stub
        Connection conn = null;
        try
        {
            //need input the name of manager
            //add the picture's path
            String strName = "78976";
            String strPhoto = "C:/001.jpg";
            Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

            String str="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
           
            conn = DriverManager.getConnection(str,"scott","tigger");
           
            BLOB blob = null;  

            conn.setAutoCommit(false);  
           
            File binaryFile = new File(strPhoto);
            FileInputStream instream = new FileInputStream(binaryFile);

           
            File file = new File(strPhoto);

            InputStream fin = new FileInputStream(file);
           
            PreparedStatement pstmt = conn.prepareStatement("UPDATE USER_INFO SET PHOTO = EMPTY_BLOB() WHERE USER_ID = ?");
              
            pstmt.setString(1,strName); 
           
            pstmt.executeUpdate();
           
            pstmt = conn.prepareStatement("SELECT * FROM USER_INFO WHERE USER_ID = ? FOR UPDATE");
           
            pstmt.setString(1,strName);  
            ResultSet rset = pstmt.executeQuery();  
            if (rset.next())
            {
                blob = (BLOB) rset.getBlob("PHOTO");  
            }
                                       
            pstmt = conn.prepareStatement("UPDATE USER_INFO SET PHOTO = ? WHERE USER_ID = ?");
                      
            OutputStream outstream = blob.setBinaryStream(1L);
           
            int size = blob.getBufferSize();
            byte[] buffer = new byte[size];
            int length = -1;
           
            while ((length = instream.read(buffer)) != -1)
                outstream.write(buffer, 0, length);
            instream.close();
            outstream.close();
                   
            pstmt.setBlob(1,blob);  
            pstmt.setString(2,strName);  
           
            int i = pstmt.executeUpdate();
            conn.commit();
            pstmt.close();
            fin.close();       
            conn.close();
        }
        catch(Exception ex)
        {
            ex.printStackTrace();
        }
        finally
        {
            if(conn != null)
            {
                try {
                    conn.close();
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
            }           
        }
    }

}