1:批量插入
1:java代码
2:xml
2:批量更新
1:mapper层
2:xml
3:批量查询
//条数查询.
Integer count = abCompanyBillRepo.countByExample(companyBillDTO);
if (count == 0) {
return ResultBaseUtils.transSuccess(Lists.newArrayList(), companyBillDTO.getCurrentPage(), companyBillDTO.getLimit(),
count);
}
//查询次数
int queryNumber = count / 500 + 1;
//查询起始数
int startNumber = 0;
//分批查询组装,最后一起导出,每次查询500条
List<CompanyBillDTO> abCompanyBillPageRespVOList = Lists.newArrayList();
for (int i = 0; i < queryNumber; i++) {
log.info("总条数count:{},查询起始数startNumber:{},查询次数queryNumber:{}", count, startNumber, queryNumber);
companyBillDTO.setCurrentPage(startNumber);
companyBillDTO.setLimit(500);
//获取账单明细数据.
List<CompanyBillDTO> companyBillDTOList = abCompanyBillRepo.selectByPageExport(companyBillDTO);
//页面新增扩展字段信息组装
List<CompanyBillDTO> companyBillDTOS = this.addExtraColumn(companyBillDTOList);
abCompanyBillPageRespVOList.addAll(companyBillDTOS);
startNumber += 500;
}