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());
}
});
评论前必须登录!
注册