JAVA如何更新oracle clob字段数据

JAVA如何更新oracle clob字段数据。

//一个可更新的结果集

Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

                ResultSet  rs =  stmt.executeQuery(sql);

                rs.next();

 

//强制转化成oracle 的clob对象

               CLOB responseClob = (CLOB) rs.getClob(clobName);

//oracle clob对象特有的putChars方法追加字符。

responseClob.putChars(responseClob.length()+1,clob.toCharArray());

                rs.updateRow();

                rs.close();

                con.commit();

                con.close();

转载于:https://www.cnblogs.com/fggry/p/3202600.html