对数据库clob型执行插入操作

java.sql.PreparedStatement pstmt = null;
ResultSet rs = null;
String query = "";
 
conn.setAutoCommit(false);
       query = "insert into clobtest_table(id,picstr) values(?,empty_clob())";
java.sql.PreparedStatement pstmt = conn.prepareStatement(query);
pstmt.setString(1,"001");
pstmt.executeUpdate();
pstmt = null
       query = "select picstr from clobtest_table where id = '001' for update";
pstmt = con.prepareStatement(query)
rs= pstmt.executeQuery();
 
oracle.sql.CLOB clobtt = null;
if(rs.next()){
    clobtt = (oracle.sql.CLOB)rs.getClob(1);
}
Writer wr = clobtt.getCharacterOutputStream();
wr.write(strtmp);
wr.flush();
wr.close();
rs.close();
con.commit();
--------
你照着上面的例子写
你写的是有问题的，Colb要使用流来读写，byte[]不行