读书人

Oracle clob字段的安插

发布时间: 2012-07-03 13:37:43 作者: rapoo

Oracle clob字段的插入

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(); 

读书人网 >其他数据库

热点推荐