进行写操作的方法 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 
|