CLOB字段的修改

/* 修改CLOB对象（是在原CLOB对象基础上进行覆盖式的修改） */
public static void clobModify(Connection con, Statement stmt,
String infile, String clobColumnName, String tabName, String id,
String idColumName) throws SQLException {
/* 设定不自动提交 */
boolean defaultCommit = con.getAutoCommit();
con.setAutoCommit(false);
try {
/* 查询CLOB对象并锁定 */
String sql = "SELECT " + clobColumnName + " FROM " + tabName
+ " WHERE " + idColumName + "='" + id + "' FOR UPDATE";
// System.out.println("clobModify String sql= "+sql);
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
/* 获取此CLOB对象 */
oracle.sql.CLOB clob = (oracle.sql.CLOB) rs
.getClob("R_XML_DESCRIP");
// System.out.println(clob);
// System.out.println("infile= "+infile);
Writer clobWriter = clob.getCharacterOutputStream();
clobWriter.write(infile);
clobWriter.flush();
clobWriter.close();
}
/* 正式提交 */
con.commit();
} catch (Exception ex) {
/* 出错回滚 */
con.rollback();
ex.printStackTrace();
}
/* 恢复原提交状态 */
con.setAutoCommit(defaultCommit);
}