- 1、最快,一条sql搞定
- insert(select)
- update(select)
- 2、其次,jdbc处理
@Autowired
private JdbcTemplate jdbcTemplate;
public int batchInsertTemp(final List<Test> list){
String sql="insert into test(ID, NAME) values(?,?)";
jdbcTemplate.batchUpdate(sql, new org.springframework.jdbc.core.BatchPreparedStatementSetter() {
public void setValues(PreparedStatement ps, int i) throws SQLException {
Long id = list.get(i).getId();
String name = list.get(i).getName();
ps.setLong(1, id);
ps.setString(2, name);
}
public int getBatchSize() {
return CollectionUtils.isEmpty(list)?0:list.size();
}
});
return 0;
}
- 3、最慢,for循环一条一条处理
for(Test t : list){
//update
}