EasyExcel 并发读取文件字段并进行校验，数据写入到新文件，批量插入数据到数据库

package com.oydsoft.wagelevelsurvey.entity; import com.alibaba.excel.annotation.ExcelIgnore; import com.alibaba.excel.annotation.ExcelProperty; import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.annotations.TableField; import com.baomidou.mybatisplus.annotations.TableId; import com.baomidou.mybatisplus.annotations.TableName; import com.baomidou.mybatisplus.enums.IdType; import com.oydsoft.wagelevelsurvey.common.ImportModel; import com.oydsoft.wagelevelsurvey.common.annotation.ExcelVerify; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; import java.util.Date; @TableName("WAGE_LEVEL_SURVEY.A01") @Data @AllArgsConstructor @NoArgsConstructor public class A01 implements ImportModel { @TableId(value = "A01_ID",type = IdType.UUID) @ExcelIgnore private String id; @TableField(value = "B01_ID") @ExcelIgnore private String b01Id; @TableField(value = "B0120") @ExcelVerify(name = "单位所在政区", value ="areaCode",index = 0) @ExcelProperty(value = "单位所在政区",index = 0) private String areaCode; @TableField(value = "B0121") @ExcelVerify(name = "单位所在政区", value ="area",index = 1) @ExcelProperty(value = "单位所在政区",index = 1) private String area; @TableField(value = "B0101") @ExcelVerify(name = "单位全称", value ="deptName",index = 2,notNull = true) @ExcelProperty(value = "单位全称",index = 2) private String deptName; @TableField(value = "Z0001") @ExcelVerify(name = "序号", value ="persenId",index = 3) @ExcelProperty(value = "序号",index = 3) private String persenId; @TableField(value = "A0101") @ExcelVerify(name = "姓名", value ="name",index = 4) @ExcelProperty(value = "姓名",index = 4) private String name; @TableField(value = "A0107") @ExcelVerify(name = "性别", value ="name",index = 5) @ExcelProperty(value = "性别",index = 5) private String sex; @TableField(value = "A0111") @ExcelVerify(name = "出生年月", value ="brithDay",index = 6) @ExcelProperty(value = "出生年月",index = 6) private String brithDay; @TableField(value = "A6103") @ExcelVerify(name = "学历", value ="inputYear",index = 7) @ExcelProperty(value = "学历",index = 7) private String inputYear; @TableField(value = "A0141") @ExcelVerify(name = "参加工作日期", value ="workDate",index = 8) @ExcelProperty(value = "参加工作日期",index = 8) private String workDate; @TableField(value = "A4195") @ExcelVerify(name = "领导职务", value ="leaderWork",index = 9) @ExcelProperty(value = "领导职务",index = 9) private String leaderWork; @TableField(value = "A4191") @ExcelVerify(name = "职级", value ="rank",index = 10) @ExcelProperty(value = "职级",index = 10) private String rank; @TableField(value = "A7811") @ExcelVerify(name = "基本工资", value ="basePay",index = 11) @ExcelProperty(value = "基本工资",index = 11) private Integer basePay; @TableField(value = "A7821") @ExcelVerify(name = "国家统一规定的津贴补贴", value ="ruleSubsidy",index = 12) @ExcelProperty(value = "国家统一规定的津贴补贴",index = 12) private Integer ruleSubsidy; @TableField(value = "A7822") @ExcelVerify(name = "规范津贴补贴", value ="standardSubsidy",index = 13) @ExcelProperty(value = "规范津贴补贴",index = 13) private Integer standardSubsidy; @TableField(value = "A7823") @ExcelVerify(name = "改革性补贴", value ="reformSubsidy",index = 14) @ExcelProperty(value = "改革性补贴",index = 14) private Integer reformSubsidy; @TableField(value = "A7825") @ExcelVerify(name = "年终一次性奖金", value ="yearSubsidy",index = 15) @ExcelProperty(value = "年终一次性奖金",index =15) private Integer yearSubsidy; @TableField(value = "A7826") @ExcelVerify(name = "立功受奖一次性奖金", value ="awardsSubsidy",index = 16) @ExcelProperty(value = "立功受奖一次性奖金",index = 16) private Integer awardsSubsidy; @TableField(value = "A7824") @ExcelVerify(name = "奖励性补贴", value ="rewardSubsidy",index = 17) @ExcelProperty(value = "奖励性补贴",index = 17) private Integer rewardSubsidy; @TableField(value = "A7827") @ExcelVerify(name = "其他", value ="other",index = 18) @ExcelProperty(value = "其他",index = 18) private Integer others; @TableField(value = "A7828") @ExcelVerify(name = "年工资总额", value ="yearsPaySum",index = 19) @ExcelProperty(value = "年工资总额",index = 19) private Integer yearsPaySum; @TableField(value = "Z0091") @ExcelVerify(name = "备注", value ="back",index = 20) @ExcelProperty(value = "备注",index = 20) private String back; @TableField(value = "Z0011") @ExcelIgnore private Integer rowStatus; @TableField(value = "Z0016") @ExcelIgnore private Integer appStatus; @ExcelIgnore @TableField(value = "Z0018") private Date createDate; @TableField(value = "Z0019") @ExcelIgnore private String createBy; @TableField(value = "Z0020") @ExcelIgnore private Date updateDate; @TableField(value = "Z0021") @ExcelIgnore private String updateBy; @TableField(exist = false) @ExcelProperty(value = "基础检查结果",index = 21) private String check; @TableField(exist = false) @ExcelProperty(value = "前置表检查结果",index = 22) private String otherCheck; @TableField(exist = false) @ExcelIgnore private String entityName="B01"; @Override public Class getModelClass() { Class aClass = this.getClass(); return aClass; } @Override public String toString() { return JSON.toJSONString(this); } @Override public String getEntityName() { return "A01"; } }