关于如何使用JdbcTemplate实现在WebLogic812,Oracle9i上的CLOB数据的写操作-JSP教程,Java技巧及代码

进行写操作的方法

import java.sql.*;import org.springframework.jdbc.core.*;import org.springframework.jdbc.core.support. abstractlobcreatingpreparedstatementcallback;import org.springframework.jdbc.support.lob.lobcreator;import org.springframework.jdbc.support.lob.lobhandler;import org.springframework.jdbc.support.lob.*;import org.springframework.jdbc.support.nativejdbc.*;
public void storemessatecontent(jdbctemplate jdbctemplate, string msg) throws      sqlexception {    string sql = "insert into test (content)" +        "values (?)";    try {      oraclelobhandler handler = new oraclelobhandler();      handler.setnativejdbcextractor(new weblogicnativejdbcextractor());      this.lobhandler = (lobhandler) handler;      jdbctemplate.execute(sql,                           new abstractlobcreatingpreparedstatementcallback(this.          lobhandler) {        protected void setvalues(preparedstatement ps, lobcreator lobcreator) throws            sqlexception {          lobcreator.setclobasstring(ps, 1, msg); //设置详细的clob字段的内容        }      }      );    }    catch (exception ex) {      throw new sqlexception(          "update clob type column [content]  error!");    }  }
程序测试环境:welogic812+springframework1.1+oracle9i