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