jsp里更新Clob类型字段数据

最新推荐文章于 2015-01-07 18:46:58 发布

weixin_30270889

最新推荐文章于 2015-01-07 18:46:58 发布

阅读量89

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/harbin1900/p/8480966.html

版权

ResultSet rs = null;
Connection conn = new dbconn().getconnect();
Statement stmt = null;
int news=0;
              conn.setAutoCommit(false);
     stmt = conn.createStatement();
sql="update wx_active_t t set t.wx_plan_id="+plan_name+",t.active_code='"+active_code+"',t.active_content=empty_clob() where t.id="+active_id;

     news= stmt.executeUpdate(sql);

String sqlt="select active_content from wx_active_t where id="+active_id+" for update ";

rs = stmt.executeQuery(sqlt);
if(rs.next())
{
System.out.println(javautil.gb2iso(sContent));
oracle.sql.CLOB clob= (oracle.sql.CLOB)rs.getClob("active_content");
outStream = clob.getCharacterOutputStream();
char[] c = javautil.gb2iso(sContent).toCharArray();
outStream.write(c,0,c.length);
outStream.flush();
outStream.close();
conn.commit();
conn.close();
}

转载于:https://www.cnblogs.com/harbin1900/p/8480966.html