中科汇联网站建设手册,上海公司名称注册查询网,wordpress速度和cms,保定网站开发接口想要提高查询速度#xff0c;需要减少查询数据库的次数#xff0c;需要把循环里面的查询提出来一次性查询完毕#xff0c;然后通过java代码来获取响应的值。如下所示#xff1a;
ListOrderInfoHtVO orderInfoList orderInfoService.getOrderInfoHtlist(query…接口想要提高查询速度需要减少查询数据库的次数需要把循环里面的查询提出来一次性查询完毕然后通过java代码来获取响应的值。如下所示
ListOrderInfoHtVO orderInfoList orderInfoService.getOrderInfoHtlist(query);if(CollectionUtils.isNotEmpty(orderInfoList)){ListInteger orderIdList orderInfoList.stream().map(OrderInfoHtVO::getOrderId)
.collect(Collectors.toList());ListString orderNoList orderInfoList.stream().map(OrderInfoHtVO::getOrderNumber)
.collect(Collectors.toList());ListInvoiceStatusVO invoiceStatusVOList applayInvoiceInfoService.
getInvoiceStatusByOrderList(orderIdList,orderNoList,orderInfoList);MapInteger,ListInvoiceStatusVO invoiceStatusVOMap invoiceStatusVOList.stream().
collect(Collectors.groupingBy(InvoiceStatusVO::getOrderId));ListApplayInvoiceHongChongCountVO applayInvoiceHongChongCountVOList applayInvoiceInfoService
.searchApplayInvoiceHongChongCountListByOrderNoList(orderNoList);MapString,ListApplayInvoiceHongChongCountVO applayInvoiceHongChongCountVOMap applayInvoiceHongChongCountVOList.stream()
.collect(Collectors.groupingBy(ApplayInvoiceHongChongCountVO::getOrderNo));ListPackageGoodsCountVO packageGoodsCountVOList orderInfoService
.searchPackageGoodsCountListByOrderIdList(orderIdList);MapInteger,ListPackageGoodsCountVO packageGoodsCountVOMap packageGoodsCountVOList.stream()
.collect(Collectors.groupingBy(PackageGoodsCountVO::getOrderId));for (OrderInfoHtVO orderInfoHtVO : orderInfoList) {if(CollectionUtils.isNotEmpty(invoiceStatusVOMap.get(orderInfoHtVO.getOrderId()))){orderInfoHtVO.setInvoiceStatus(invoiceStatusVOMap.get(orderInfoHtVO.getOrderId()).get(0).getInvoiceStatus());
}else{orderInfoHtVO.setInvoiceStatus(0);
}if(CollectionUtils.isNotEmpty(applayInvoiceHongChongCountVOMap.get(orderInfoHtVO.getOrderNumber()))){orderInfoHtVO.setIsHongChong(applayInvoiceHongChongCountVOMap.get(orderInfoHtVO.getOrderNumber()).get(0).getIsHongChong());
}else{orderInfoHtVO.setIsHongChong(0);
}if(CollectionUtils.isNotEmpty(packageGoodsCountVOMap.get(orderInfoHtVO.getOrderId()))){orderInfoHtVO.setIsPackage(packageGoodsCountVOMap.get(orderInfoHtVO.getOrderId()).get(0).getIsPackage());
}else{orderInfoHtVO.setIsPackage(0);
}}}
