批量插入固定条数
批量插入可以参考上篇文章:(https://blog.csdn.net/qq_35387940/article/details/100007472)
List<Map<String, Object>> interfreqList = new ArrayList<>();
List<Map<String, Object>> cellinterfreqList = (List<Map<String, Object>>) paramMap.get("cellInterFreq");
for(Map<String, Object> cellinterfreq : cellinterfreqList){
cellinterfreq.put("fsk_cgi", uuid);
cellinterfreq.put("status", 1);
cellinterfreq.put("taskid", taskid);
interfreqList.add(cellinterfreq);
}
int listSize = interfreqList.size();
int maxSize = listSize - 1;
for(int i = 0; i < listSize; i++){
//分批次处理
newList.add(interfreqList.get(i));//循环将数据填入载体list
if (pointnum == newList.size() || i == maxSize) { //载体list达到要求,进行批量操作
//调用批量插入
iDtManager.insertcellinterfreq(newList,city_abbr);
newList.clear();//每次批量操作后,清空载体list,等待下次的数据填入
}
}

浙公网安备 33010602011771号