easypoi大批量数据导出避免oom

最新推荐文章于 2025-12-15 16:16:53 发布

原创最新推荐文章于 2025-12-15 16:16:53 发布 · 850 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#java #开发语言

该代码段展示了在Java中处理大数据导出的场景。方法接受queryParams和page参数，使用PageHelper进行分页，查询ConsultationWorkForceEntity列表，然后转换为WorkingScheduleListExport对象集合，用于Excel导出。数据转换过程中涉及字符串拼接和BeanUtils的属性复制。

//这个方法会被循环调用 page每次+1
			IExcelExportServer iExcelExportServer = (queryParams, page) -> {
				if (queryParams instanceof PageRequest) {
					PageHelper.startPage(page, CommonConstants.Number.TEN_THOUSAND_INTEGER);
					List<ConsultationWorkForceEntity> consultationWorkForceList = consultationWorkForceMapper.findAll(findWorkingScheduleDTO);
					if (CollectionUtils.isNotEmpty(consultationWorkForceList)) {
						List<WorkingScheduleListExport> exportList = new ArrayList<>();
						List<WorkingScheduleListVO> consultationWorkForceVoList = buildWorkingScheduleVO(consultationWorkForceList);
						for (WorkingScheduleListVO workingScheduleListVO : consultationWorkForceVoList) {
							WorkingScheduleListExport workingScheduleListExport = new WorkingScheduleListExport();
							StringBuilder builder = new StringBuilder();
							if (StringUtils.isNotBlank(workingScheduleListVO.getRoomName())) {
								builder.append(workingScheduleListVO.getRoomName());
							}
							if (StringUtils.isNotBlank(workingScheduleListVO.getVideoNumber())) {
								if (StringUtils.isNotBlank(workingScheduleListVO.getRoomName())) {
									builder.append(SymbolConstant.VIRGULE);
								}
								builder.append(workingScheduleListVO.getVideoNumber());
							}
							String roomName = builder.toString();
							if (StringUtils.isBlank(roomName)) {
								roomName = SymbolConstant.MIDLINE;
							}
							BeanUtils.copyProperties(workingScheduleListVO, workingScheduleListExport);
							workingScheduleListExport.setRoomName(roomName);
							exportList.add(workingScheduleListExport);
						}
						return new ArrayList<>(exportList);
					}
				}
				return null;
			};
			workbook = ExcelExportUtil.exportBigExcel(exportParams, WorkingScheduleListExport.class, iExcelExportServer, new PageRequest());