Spring JdbcTemplate存Oracle Clob

import org.springframework.jdbc.core.support.AbstractLobCreatingPreparedStatementCallback;
import org.springframework.jdbc.support.lob.DefaultLobHandler;
import org.springframework.jdbc.support.lob.LobCreator;
import org.springframework.jdbc.support.lob.LobHandler;
import org.springframework.jdbc.support.lob.OracleLobHandler;
import org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExtractor;

//存
private LobHandler lobHandler = new DefaultLobHandler();;
CommonsDbcpNativeJdbcExtractor nativeJdbcExtractor;  //注1
String sql = "insert into gg (test1,colb1) values ('',?)";
final String content = ""   //Clob的值
OracleLobHandler handler = new OracleLobHandler();
handler.setNativeJdbcExtractor(this.nativeJdbcExtractor);
this.lobHandler = (LobHandler) handler;
jdbcTemplate.execute(sql, new AbstractLobCreatingPreparedStatementCallback(this.lobHandler){
protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException,
DataAccessException
    {
      lobCreator.setClobAsString(ps, 1 , content ); //设置详细的CLOB字段的内容
     }
}

//取


String sql = "select clob1 from gg where id= ?"
jdbcTemplate.query(sql ,
                new Object[] {new Integer(1 )},
                  new  AbstractLobStreamingResultSetExtractor() {
                     protected void streamData(ResultSet rs) throws  SQLException, IOException, DataAccessException {
                          lobHandler.getClobAsCharacterStream(rs, 1 ); //得到Clob，需要自己处理
                      }
                   });
     
//注1：nativeJdbcExtractor是需要注入的类
<property name = "nativeJdbcExtractor" >
          <bean  class =    "org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExtractor"/>
</property>