批量插入固定条数

  批量插入可以参考上篇文章:(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,等待下次的数据填入
  }
  }

posted @ 2019-11-14 11:07  宣纸泛黄  阅读(154)  评论(0)    收藏  举报