easycode模板，创作不易，谢谢支持！

package cn.dmp.common.easycode; import cn.hutool.core.bean.BeanUtil; import cn.hutool.core.bean.copier.CopyOptions; import cn.hutool.json.JSONUtil; import cn.hutool.poi.excel.ExcelUtil; import cn.hutool.poi.excel.ExcelWriter; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.StringUtils; import org.apache.commons.lang3.time.DateFormatUtils; import org.apache.poi.ss.usermodel.*; import org.springframework.stereotype.Component; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.lang.reflect.Field; import java.net.URLEncoder; import java.util.*; import java.util.stream.Collectors; import java.util.stream.IntStream; @Component @Slf4j public class EasyCodeUtils { public static final String ALLOW_ERR = "1"; // 允许容错 private static Map<String, DataConverter> converters = new HashMap<>(); public EasyCodeUtils(List<DataConverter> converterList) { for (DataConverter dataConverter : converterList) { converters.put(dataConverter.getConverterName(), dataConverter); log.info("Registering converter {}", dataConverter.getConverterName()); } } /** * EasyCode模板工具类 * * @param workbook * @param blod * @return */ public static CellStyle borderStyle(Workbook workbook, boolean blod, boolean isErr) { CellStyle cellStyle = workbook.createCellStyle(); cellStyle.cloneStyleFrom(cellStyle); cellStyle.setBorderBottom(BorderStyle.THIN); cellStyle.setBottomBorderColor(IndexedColors.BLACK.getIndex()); cellStyle.setBorderLeft(BorderStyle.THIN); cellStyle.setLeftBorderColor(IndexedColors.BLACK.getIndex()); cellStyle.setBorderRight(BorderStyle.THIN); cellStyle.setRightBorderColor(IndexedColors.BLACK.getIndex()); cellStyle.setBorderTop(BorderStyle.THIN); cellStyle.setTopBorderColor(IndexedColors.BLACK.getIndex()); // 指定单元格格式为文本 DataFormat dataFormat = workbook.createDataFormat(); cellStyle.setDataFormat(dataFormat.getFormat("@")); // 设置单元格字体样式 Font font = workbook.createFont(); if (blod) { font.setBold(true); // 加粗 } if (isErr) { font.setColor(Font.COLOR_RED); } cellStyle.setFont(font); // 设置单元格垂直居中 cellStyle.setVerticalAlignment(VerticalAlignment.CENTER); cellStyle.setAlignment(HorizontalAlignment.CENTER); return cellStyle; } private static void setHeader(List<String> cols, Workbook workbook, Sheet sheet) throws IOException { Row header = sheet.createRow(0); int i = 0; for (String title : cols) { Cell cell = header.createCell(i, CellType.STRING); cell.setCellValue(title); cell.setCellStyle(borderStyle(workbook, true, false)); sheet.setColumnWidth(i, 500 * 10); i++; } } public static <T> void easyTemplateExport(HttpServletResponse response, Class<T> clazz) throws IOException { List<EasyCodeConfig> exportFields = getAnnoFields(clazz, false); ExcelWriter writer = ExcelUtil.getWriter(true); writer.renameSheet(0, "导入模板"); Workbook workbook = writer.getWorkbook(); Sheet sheet = workbook.getSheetAt(0); Row nexrow = sheet.createRow(1); nexrow.setHeight((short) 400); List<String> headers = exportFields.stream().map(EasyCodeConfig::title).collect(Collectors.toList()); setHeader(headers, workbook, sheet); int i = 0; for (EasyCodeConfig config : exportFields) { Cell cellnext = nexrow.createCell(i, CellType.STRING); cellnext.setCellValue(config.tip()); cellnext.setCellStyle(borderStyle(workbook, false, false)); sheet.setColumnWidth(i, 500 * 10); i++; } String fileName = URLEncoder.encode("导入模板" + ".xlsx", "UTF-8"); //设置响应头中文件的下载方式为附件方式，以及设置文件名 response.setHeader("Content-Disposition", "attachment; filename=" + fileName); writer.flush(response.getOutputStream()); } public static <T> void easyDataExport(List<T> datas, HttpServletResponse response, Class<T> clazz) throws IOException { List<EasyCodeConfig> exportFields = getAnnoFields(clazz, false); ExcelWriter writer = ExcelUtil.getWriter(true); writer.renameSheet(0, "导入模板"); Workbook workbook = writer.getWorkbook(); Sheet sheet = workbook.getSheetAt(0); List<String> headers = exportFields.stream().map(EasyCodeConfig::title).collect(Collectors.toList()); setHeader(headers, workbook, sheet); int rowNum = 1; for (Object record : datas) { Map<String, Object> map = BeanUtil.beanToMap(record); Row row = sheet.createRow(rowNum); int colNum = 0; for (EasyCodeConfig config : exportFields) { Object val = map.get(config.propName()); DataConverter converter = converters.get(config.type()); if (converter != null) { Cell cellnext = row.createCell(colNum, CellType.STRING); cellnext.setCellValue(converter.jdbc2Excel(val, config)); cellnext.setCellStyle(borderStyle(workbook, false, false)); } else { // 处理未知类型或转换器不存在的情况 throw new RuntimeException("未知类型或转换器不存在：" + config.type()); } sheet.setColumnWidth(colNum, 500 * 10); colNum++; } rowNum++; } String fileName = URLEncoder.encode("导出数据" + DateFormatUtils.format(new Date(), "HHmmss") + ".xlsx", "UTF-8"); //设置响应头中文件的下载方式为附件方式，以及设置文件名 response.setHeader("Content-Disposition", "attachment; filename=" + fileName); writer.flush(response.getOutputStream()); writer.close(); } private static <T> List<EasyCodeConfig> getAnnoFields(Class<T> clazz, boolean isImport) { Field[] declaredFields = clazz.getDeclaredFields(); return Arrays.stream(declaredFields).map(field -> { EasyCodeConfig annotation = field.getAnnotation(EasyCodeConfig.class); if (annotation != null && ((isImport && annotation.isImport()) || (!isImport && annotation.isExport()))) { return annotation; } return null; }).filter(Objects::nonNull).collect(Collectors.toList()); } public static <T> EasyCodeResult easyDataHandel(Sheet sheet, Class<T> clazz) { Map<String, String> errMaps = new HashMap<>(); Map<String, Integer> headerIndex = new HashMap<>(); EasyCodeResult result = new EasyCodeResult(); Row header = sheet.getRow(0); if (header == null) { throw new RuntimeException("标题行为空！"); } List<EasyCodeConfig> importFields = getAnnoFields(clazz, false); HashMap<String, EasyCodeConfig> filedCols = new HashMap<>(); for (EasyCodeConfig importField : importFields) { filedCols.put(importField.comment(), importField); } short lastCellNum = header.getLastCellNum(); int lastRowNum = sheet.getLastRowNum(); result.setRowsCount(lastRowNum); result.setColsCount(Integer.parseInt(lastCellNum + "")); if (lastRowNum <= 0) { throw new RuntimeException("导入文件数