PreparedStatement pstmSel = conn.prepareStatement(INS_TOPIC_UPDATE);
pstmSel.setInt(1, topic.getTopicId());
ResultSet rs = pstmSel.executeQuery();
if (rs.next())
{
oracle.sql.CLOB clob = (oracle.sql.CLOB) ((com.mchange.v2.c3p0.impl.NewProxyResultSet)rs).getClob("topicContent");
//weblogic.jdbc.vendor.oracle.OracleThinClob clob = (weblogic.jdbc.vendor.oracle.OracleThinClob)rs.getClob("topicContent");
Writer outStream = clob.getCharacterOutputStream();
//data是传入的字符串,定义:String data
char[] c = CodeFilter.htmlEncode(topicContent).toCharArray();
outStream.write(c, 0, c.length);
outStream.flush();
outStream.close();
}
conn.commit();
rs.close();
pstmSel.close();
Oracle clob字段的插入
最新推荐文章于 2022-11-16 14:23:46 发布