主要就是batchUpdate函数
用法如下:
insert:
String cmdTmp = "INSERT INTO %s(CREATE_DATE, UPDATE_TIME, XXX_ID, XXXID, XXX_TYPE) VALUES(?, ?, ?, ?, ?)";
String cmd = String.format(cmdTmp, tableName);
List<Object[]> batchArgs=new ArrayList<Object[]>();
for(Integer i = 0; i < createTimeList.size(); i++){
batchArgs.add(new Object[]{createTimeList.get(i),
updateTimeList.get(i),
XXXIdList.get(i),
XXXIdList.get(i),
XXXTypeList.get(i)});
}
jdbcTemplate.batchUpdate(cmd, batchArgs);
update的用法和insert一样,将sql语句换成insert即可。
jdbcTemplate是注入进来的
@Autowired
JdbcTemplate jdbcTemplate;