方法一:循环调用插入单条记录的方法,效率真心让人捉急 (3万条数据,快三分钟)
public int saveGwghidlist1(List<Gwghid> list) {
int xh=0;
deleteGwghidByCondition("");
if(list.size()>0){
for (Gwghid gwghid: list) {
xh++;
gwghidDAO.saveGwghid(gwghid);
System.out.println(xh);
}
}
return xh;
}
方法二:在mapper.xml中循环插入<foreach> (可行,但是要要分批插入,因为oracle,有sql限制64k?不确定哈)
serviceimpl
public int saveGwghidlist(List<Gwghid> list) {
int xh=0;
deleteGwghidByCondition("");
if(list.size()>0){
for (Gwghid gwghid: list) {
xh++;
gwghidDAO.saveGwghid(gwghid);
System.out.println(xh);
}
}
return xh;
}