Spring JdbcTemplate 批量插入或更新操作

 Spring JdbcTemplate 批量插入或更新操作

用 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());  
    }  
} 

方法二：

//插入很多书(批量插入用法)
public void insertBooks(List<Book> book)
{
  final List<Book> tempBook=book;
  String sql="insert into book(name,pbYear) values(?,?)";
  jdbcTemplate.batchUpdate(sql,new BatchPreparedStatementSetter()
  {
   public void setValues(PreparedStatement ps,int i)throws SQLException
   {
    String name=tempBook.get(i).getName();
    int pbYear=tempBook.get(i).getPbYear();
    ps.setString(1,name);
    ps.setInt(2,pbYear);
   }
   public int getBatchSize()
   {
    return tempBook.size();
   }
  });
   
}