JdbcTemplate使用—-batchUpdate批量增删改

• 批量修改

List list = new ArrayList(); // 存放需要操作数据的集合
String updateSql = "update eprk_person set age = ? where pk_person = ?";
getJdbcTemplate().batchUpdate(updateSql,new BatchPreparedStatementSetter(){

    public int getBatchSize(){
        list.size();
    }

    public void setValues(PreparedStatement ps, int i) throws SQLException{
        ps.setBigDecimal(1,10);
        ps.setString(2,"123");
    }
});

• 批量插入

List list = new ArrayList(); // 存放需要操作数据的集合
String insertSql = "insert into eprk_person(pk_person,age) values(?,?)";
getJdbcTemplate().batchUpdate(updateSql,new BatchPreparedStatementSetter(){
    Iterator iter = set.iterator();
    public int getBatchSize(){
        list.size();
    }

    public void setValues(PreparedStatement ps, int i) throws SQLException{
        PersonVO element = (PersonVO)iter.next();
        ps.setBigDecimal(1,element.getPk_person());
        ps.setString(2,element.getAge());
    }
});