public static void insertClob(String dbName, String clobContent){
String insertSql = "insert into TFA_GAIA_HIS_VALID_RULE_SNAP (RULE_CONTENT) values(?)";
PreparedStatement preStatement = null;
try {
dbconn = getConnection(dbName);
preStatement = dbconn.prepareStatement(insertSql);
StringReader reader = new StringReader(clobContent);
preStatement.setCharacterStream(1, reader, clobContent.length());
int insertResult = preStatement.executeUpdate();
log.error("插入CLOB类型数据成功" + insertResult + "条");
}
catch (SQLException e) {
log.error("插入CLOB类型数据失败:", e);
}
finally {
cleanup(dbconn, preStatement, null);
}
}