Spring dao框架——操作clob和blob数据类型

操作步骤：

1.配置spring支持获取本地化jdbc操作对象

<!-- nativeJdbcExtractor 和 oracleLobHandler Bean 都设置为 lazy-init="true"，这是因为 -->

<!-- nativeJdbcExtractor 需要通过运行期的反射机制获取底层的 JDBC 对象， -->

<!-- 所以需要避免在 Spring 容器启动时就实例化这两个Bean。 -->

<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.C3P0NativeJdbcExtractor"

lazy-init="true" />

2.提供oracleLobHandler

<bean id="oracleLobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler"

lazy-init="true">

    <property name="nativeJdbcExtractor" ref="nativeJdbcExtractor"></property>

</bean>

3.写code，继承jdbc模板，使用execute方法内部类AbstractLobCreatingPreparedStatementCallback

    private LobHandler lobHandler;

/**

 * @return the lobHandler

 */

    public LobHandler getLobHandler() {

    return lobHandler;

    }

/**

 * @param lobHandler the lobHandler to set

 */

public void setLobHandler(LobHandler lobHandler) {

this.lobHandler = lobHandler;

}

public void getInsertPutImage(String txtUrl,String imgUrl) throws IOException {

//写文本

final File clobIn = new File(txtUrl);

final InputStream clobIs = new FileInputStream(clobIn);

final InputStreamReader clobReader = new InputStreamReader(clobIs);

//写图片

final File blobIn = new File(imgUrl);

final InputStream blobIs = new FileInputStream(blobIn);

getJdbcTemplate().execute(insertOracleSql, new         AbstractLobCreatingPreparedStatementCallback(this.lobHandler) {

@Override

protected void setValues(PreparedStatement ps, LobCreator lobCreator)

throws SQLException, DataAccessException {

ps.setLong(1, 1l);

lobCreator.setClobAsCharacterStream(ps, 2, clobReader, (int)clobIn.length());

lobCreator.setBlobAsBinaryStream(ps, 3, blobIs, (int)blobIn.length());

}

});

clobReader.close();

blobIs.close();

}

AbstractLobCreatingPreparedStatementCallback 参数需要提供一个lobHander对象，使用时需要提供set方法。