Oracle Blob 插入

mport java.io.File;
import java.io.FileInputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import oracle.jdbc.driver.OracleResultSet;
/**
 * @author wang.xiaoshan
 *
 */
public class InsertBlob {
    /**
     * @param args
     */
    public static void main(String[] args) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            conn = DriverManager.getConnection(
                    "jdbc:oracle:thin:@192.168.1.2:1521:ppfs", "ppfs", "ppfs");
            File file = new File("c://BT-3000TM_lib_ref_3.pdf");
            FileInputStream fis = new FileInputStream(file);
            stmt = conn.createStatement();
            stmt.executeUpdate("insert into blob_test(id,obj) values('1', empty_blob())");
            rs = stmt.executeQuery("select id,obj from blob_test where id = '1' for update");
            if (rs.next()) {
                oracle.sql.BLOB blobData = ((OracleResultSet)rs).getBLOB("obj");
                OutputStream os = blobData.getBinaryOutputStream();
                int length = -1;
                byte [] buffer = new byte[4096];
                while ((length = fis.read(buffer)) != -1) {
                    os.write(buffer,0,length);
                }
                os.close();
            }
            fis.close();
            conn.commit();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (stmt != null) {
                    stmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
}