使用批量插入解决
列如:
一次插800条
while(rowList.size()>0){
List<Map<String, Object>> list1 = StringUtil.getBatchList(rowList, 800);
service.importBankAcc(list1);
}
public static List getBatchList(List prjList,int length){
if(prjList.size()<length){
length = prjList.size();
}
List list = new ArrayList();
list.addAll(prjList.subList(0, length));
prjList.removeAll(list);
return list;
}