`

使用preparedStatement插入CLOB数据

阅读更多
Connection con = db.getConnectionDBClass();
String sqlstr = "insert into orgweb.clobtable value(?,?)";
con.setAutoCommit(false); //设置为非自动提交事务
CLOB clob = new CLOB((OracleConnection)con); //创建一个实例化对象
clob = oracle.sql.CLOB.createTemporary((OracleConnection)con, true, 1);
clob.putString(1, content); //为对象赋值
OracleConnection ocon = (OracleConnection)con;
OraclePreparedStatement ops = (OraclePreparedStatement)ocon.prepareCall(sqlstr);
ops.setString(1, name);
ops.setCLOB(2, clob);
ops.executeUpdate();

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics