Spring JdbcTemplate 应用(四)

转自：http://rockjava.iteye.com/blog/305244

 

用 JdbcTemplate 进行批量插入或更新操作，直接看代码吧，不多说了。

 

代码只是测试用的一个小例子。

 

 

public int insertContractAch(List list) throws DataAccessException {
    final List temList = list;
    String sql = "insert into contract_ach_t " +
            " values(?,to_date(?,'yyyy-mm-dd'),?,?) ";
    try{
        int[] ii = this.getJdbcTemplate().batchUpdate(sql, new MyBatchPreparedStatementSetter(temList));
        return ii.length;
    }catch (org.springframework.dao.DataAccessException e) {
        e.printStackTrace();
        throw new DataAccessException(e.getMessage());
    }
}
/**
 * 处理批量插入的回调类
 * */
private class MyBatchPreparedStatementSetter implements BatchPreparedStatementSetter{
    final List temList;
    /**通过构造函数把要插入的数据传递进来处理*/
    public MyBatchPreparedStatementSetter(List list){
        temList = list;
    }
    public int getBatchSize() {
        return temList.size();
    }

    public void setValues(PreparedStatement ps, int i)
            throws SQLException {
        ContractAchVO contractAchVO = (ContractAchVO)temList.get(i);
        ps.setString(1, contractAchVO.getContractCode());
        ps.setString(2, contractAchVO.getCreateDate());
        ps.setString(3, contractAchVO.getEmployeeId());
        ps.setString(4, contractAchVO.getPercent());
    }
}