blob字段的修改

/* 修改BLOB对象（是在原BLOB对象基础上进行覆盖式的修改） */
public static void blobModify(Connection con, Statement stmt,
String infile, String blobColumnName, String tabName, String id,
String idColumName) throws SQLException {
byte[] b = infile.getBytes();
/* 设定不自动提交 */
boolean defaultCommit = con.getAutoCommit();
con.setAutoCommit(false);
ResultSet rs=null;
try {
/* 查询CLOB对象并锁定 */
String sql_sel = "SELECT " + blobColumnName + " FROM " + tabName
+ " WHERE " + idColumName + "='" + id + "' FOR UPDATE";
String sql_up="update mutual set receive=empty_blob() where id='"+id+"'";
//System.out.println("blobModify String sql= "+sql);
stmt.executeUpdate(sql_up);
//con.commit();
rs=stmt.executeQuery(sql_sel);
if (rs.next()) {
//获取此CLOB对象 
oracle.sql.BLOB blob = (oracle.sql.BLOB) rs.getBlob(1);
// System.out.println(clob);
// System.out.println("infile= "+infile);
OutputStream blobWriter = blob.getBinaryOutputStream();
//blob=oracle.sql.BLOB.empty_lob();
blobWriter.write(b, 0, b.length);
blobWriter.flush();
blobWriter.close();
}
//正式提交 
con.commit();/**/
} catch (Exception ex) {
/* 出错回滚 */
//con.rollback();
ex.printStackTrace();
}finally{
try{
if(rs!=null){
rs.close();
rs=null;
}
 }catch (Exception e) {}
}
/* 恢复原提交状态 */
//con.setAutoCommit(defaultCommit);
}