JdbcTemplate批处理
final List<Student> students = dao.queryStudents();
//定义sql
String insertSql = "insert into student (id,name,age) values ( ?, ?, ?)";
jdbcTemplate.batchUpdate(insertSql, new BatchPreparedStatementSetter(){
@Override
public void setValues(PreparedStatement ps, int i) throws SQLException {
Student item = students.get(i);
ps.setString(1, item.getId());
ps.setString(2, item.getName());
ps.setString(3, item.getAge());
}
@Override
public int getBatchSize() {
return students.size();
}
});