public AjaxResult dealData(List<Object> list) throws Exception {
if(list.size()>0){
int num=100;
List<Object> objectList = new ArrayList<>();
for (int i=0; i<list.size();i++){
Object object = list.get(i);
Object Object1 = ObjectMapper.selectObjectById(object.getId());
if(null == Object1 ){
objectList.add(object);
}else{
object.setEmpNum(object.getId());
objectMapper.updateObject(object);
}
if(objectList.size()>0){
if((i+1)%num==0 || i+1== list.size()){
objectMapper.insertBatchObject(objectList);
objectList.clear();
}
}
}
}
return AjaxResult.success("同步成功");
}
数据批量写入数据库优化
最新推荐文章于 2022-02-14 20:50:16 发布