Excel导入导出 EasyExcel的使用- 导入组织人员

最新推荐文章于 2023-03-21 14:07:38 发布
最新推荐文章于 2023-03-21 14:07:38 发布
阅读量586 收藏
点赞数
分类专栏： java 文章标签： java 开发语言 后端 EasyExcel 部门人员导入 1024程序员节
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sinosoft12345/article/details/120894270
版权

模板

 表结构

HSGD_BASE_GROUP_CUSTOMER_IMPORT_RECORD

 HSGD_BASE_GROUP_CUSTOMER_IMPORT_COMPLETION

HSGD_BASE_GROUP_CUSTOMER_NOT_IMPORT_RECORD

代码

package com.zhgd.base.controller.api;

import com.zhgd.base.service.IZhgdSrBaseGroupCustomerImportService;
import com.zhgd.common.util.JsonUtil;
import com.zhgd.common.web.ResponseResult;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.List;

/**
 * 描述  掌柜组织改版：1-导入组织人员
 *
 * @author 
 * @version 1.0.0
 * @date 2021/10/11 16:07:20
 */
@RestController
@Api(tags = "Zhgd Sr Base Group Import Customer Controller")
@RequestMapping(value = "/api/srBaseGroupCustomerImport")
@Slf4j
public class ApiZhgdSrBaseGroupCustomerImportController {

    @Resource
    private IZhgdSrBaseGroupCustomerImportService iZhgdSrBaseGroupCustomerImportService;

    @ApiOperation(value = "掌柜组织改版导入组织人员接口", response = String.class, notes = "Import Base Group Customer")
    @PostMapping(value = "/11202/v1/importBaseGroupCustomer")
    public ResponseResult<List<String>> importBaseGroupCustomer(@RequestParam("importFile") MultipartFile importFile){
        String importFileName = importFile != null ? importFile.getOriginalFilename() : "--";
        log.info("[掌柜组织改版]导入部门组织人员，导入文件名：{}",importFileName);
        ResponseResult<List<String>> result = new ResponseResult<>();
        result.setData(iZhgdSrBaseGroupCustomerImportService.importBaseGroupCustomerProcess(importFile));
        log.info("[掌柜组织改版]导入部门组织人员，导入文件名：{}", JsonUtil.toJSONString(result));
        return result;
    }

//    @ApiOperation(value = "掌柜组织改版 初始化组织人员上下级关系接口", response = String.class, notes = "Initialize Base Group Customer Relation")
//    @PostMapping(value = "/11203/v1/initializeBaseGroupCustomerRelation")
//    public ResponseResult<Boolean> initializeBaseGroupCustomerRelation(HttpServletRequest request){
//        log.info("[掌柜组织改版]初始化组织人员上下级关系,开始...");
//        ResponseResult<Boolean> result = new ResponseResult<>();
//        result.setData(iZhgdSrBaseGroupCustomerImportService.initializeBaseGroupCustomerRelationProcess());
//        log.info("[掌柜组织改版]初始化组织人员上下级关系,响应结果：{}", JsonUtil.toJSONString(result));
//        return result;
//    }
}


package com.zhgd.base.service;

import com.zhgd.base.entity.HsgdBaseGroupCustomerImportRecord;
import org.springframework.web.multipart.MultipartFile;

import java.util.List;

public interface IZhgdSrBaseGroupCustomerImportService {

    void batchInsertAll(List<HsgdBaseGroupCustomerImportRecord> recordList);

    List<String> importBaseGroupCustomerProcess(MultipartFile importFile);

    Boolean initializeBaseGroupCustomerRelationProcess();

    void insert(HsgdBaseGroupCustomerImportRecord record);
}

package com.zhgd.base.service.impl;

import com.alibaba.excel.EasyExcel;
import com.github.pagehelper.PageHelper;
import com.zhgd.base.domain.model.ZhgdSrGroupCustomerImportModel;
import com.zhgd.base.domain.vo.HsgdBaseGroupCustomerSimpleVO;
import com.zhgd.base.domain.vo.HsgdBaseGroupLevelNameVO;
import com.zhgd.base.domain.vo.HsgdBaseGroupSimpleVO;
import com.zhgd.base.entity.*;
import com.zhgd.base.enums.HsgdBaseGroupLevelEnum;
import com.zhgd.base.listener.ZhgdSrBaseGroupCustomerImportExcelListener;
import com.zhgd.base.mapper.HsgdBaseGroupCustomerImportCompletionMapper;
import com.zhgd.base.mapper.HsgdBaseGroupCustomerImportRecordMapper;
import com.zhgd.base.mapper.HsgdBaseGroupCustomerMapper;
import com.zhgd.base.mapper.HsgdBaseGroupMapper;
import com.zhgd.base.service.*;
import com.zhgd.common.util.StringUtil;
import com.zhgd.common.util.UUIDUtils;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.collections.CollectionUtils;
import org.apache.commons.lang.ObjectUtils;
import org.apache.commons.lang.StringUtils;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;

import javax.annotation.Resource;
import java.util.*;
import java.util.function.Function;
import java.util.stream.Collectors;

@Service
@Slf4j
public class ZhgdSrBaseGroupCustomerImportServiceImpl implements IZhgdSrBaseGroupCustomerImportService {

    private final String SYSTEM_USER_NAME = "system";

    @Resource
    private HsgdBaseGroupCustomerImportRecordMapper hsgdBaseGroupCustomerImportRecordMapper;

    @Resource
    private HsgdBaseGroupCustomerImportCompletionMapper hsgdBaseGroupCustomerImportCompletionMapper;

    @Resource
    private IZhgdSrBaseGroupImportCustomerHandleService iZhgdSrBaseGroupImportCustomerHandleService;

    @Resource
    private HsgdBaseGroupCustomerMapper hsgdBaseGroupCustomerMapper;

    @Resource
    private HsgdBaseGroupMapper hsgdBaseGroupMapper;

    @Resource
    private IZhgdSrBaseGroupImportService iZhgdSrBaseGroupImportService;

    @Resource
    private IHsgdBaseGroupCustomerService iHsgdBaseGroupCustomerService;

    @Resource
    private IHsgdBaseGroupCustomerNotImportRecordService iHsgdBaseGroupCustomerNotImportRecordService;

    @Transactional(rollbackFor = Exception.class)
    @Override
    public void batchInsertAll(List<HsgdBaseGroupCustomerImportRecord> recordList) {
        hsgdBaseGroupCustomerImportRecordMapper.insertAll(recordList);
    }

    @Override
    public void insert(HsgdBaseGroupCustomerImportRecord record) {
        hsgdBaseGroupCustomerImportRecordMapper.insert(record);
    }

    @Override
    public List<String> importBaseGroupCustomerProcess(MultipartFile importFile) {
        List<String> importResultList = new ArrayList<>();
        try {
            String batchNo = UUIDUtils.getUUID();
            ZhgdSrBaseGroupCustomerImportExcelListener listener = new ZhgdSrBaseGroupCustomerImportExcelListener(iZhgdSrBaseGroupImportCustomerHandleService, batchNo);
            EasyExcel.read(importFile.getInputStream(), ZhgdSrGroupCustomerImportModel.class, listener).sheet(0).doRead();
            // 2、文件校验(待处理)
            // 3、组织数据
            int totalRecord =  this.organizeAndSaveBaseGroupCustomerCompletionData(batchNo);
            this.saveBaseGroupCustomerData(batchNo,totalRecord);
        } catch (Exception e) {
            log.info("导入异常", e);
            importResultList.add("导入异常 ：" + e.getMessage());
            return importResultList;
        }

        importResultList.add("执行完成,请检查是否全部导入成功！");
        return importResultList;
    }

    @Override
    public Boolean initializeBaseGroupCustomerRelationProcess() {
        return null;
    }

    private int organizeAndSaveBaseGroupCustomerCompletionData(String batchNo) {

        int importDataTotal = hsgdBaseGroupCustomerImportRecordMapper.countImportBaseGroupCustomerDataTotalByBatchNo(batchNo);
        
        if (importDataTotal > 0) {
            // 每页记录数
            int pageSize = 120, startPage = 1;
            // 总页数
            int totalPage = importDataTotal % pageSize == 0 ? (importDataTotal / pageSize) : (importDataTotal / pageSize + 1);

            for (int pageN = 0; pageN < totalPage; pageN++) {
                PageHelper.startPage(startPage + pageN, pageSize, false);
                List<HsgdBaseGroupCustomerImportRecord> list = hsgdBaseGroupCustomerImportRecordMapper.selectListByBatchNo(batchNo);

                if (CollectionUtils.isNotEmpty(list)) {
                    List<HsgdBaseGroupCustomerImportCompletion> completionList = new ArrayList<>();
                    HsgdBaseGroupCustomerImportCompletion completion;

                    for (int i = 0, listSize = list.size(); i < listSize; i++) {
                        HsgdBaseGroupCustomerImportRecord record = list.get(i);
                        completion = new HsgdBaseGroupCustomerImportCompletion();

                        if (StringUtils.isNotBlank(record.getLevelOneGroup())) {
                            completion.setGroupLevel(HsgdBaseGroupLevelEnum.ONE.getGroupLevel());
                        }

                        if (StringUtils.isNotBlank(record.getLevelTwoGroup())) {
                            completion.setGroupLevel(HsgdBaseGroupLevelEnum.TWO.getGroupLevel());
                        }

                        if (StringUtils.isNotBlank(record.getLevelThreeGroup())) {
                            completion.setGroupLevel(HsgdBaseGroupLevelEnum.THREE.getGroupLevel());
                        }

                        if (StringUtils.isNotBlank(record.getLevelFourGroup())) {
                            completion.setGroupLevel(HsgdBaseGroupLevelEnum.FOUR.getGroupLevel());
                        }

                        if (StringUtils.isNotBlank(record.getLevelFiveGroup())) {
                            completion.setGroupLevel(HsgdBaseGroupLevelEnum.FIVE.getGroupLevel());
                        }

                        if (StringUtils.isNotBlank(record.getLevelSixGroup())) {
                            completion.setGroupLevel(HsgdBaseGroupLevelEnum.SIX.getGroupLevel());
                        }

                        if (StringUtils.isNotBlank(record.getLevelSevenGroup())) {
                            completion.setGroupLevel(HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel());
                        }

                        if (StringUtils.isNotBlank(record.getLevelEightGroup())) {
                            completion.setGroupLevel(HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel());
                        }

                        BeanUtils.copyProperties(record, completion);
                        completionList.add(completion);
                    }

                    iZhgdSrBaseGroupImportCustomerHandleService.insertAllImportCompletion(completionList);
                }
            }
        }

        return importDataTotal;
    }


    private void saveBaseGroupCustomerData(String batchNo, int totalRecord) {
        if(totalRecord > 0) {
            int pageSize = 120, startPage = 1;
            int totalPage = totalRecord % pageSize == 0 ? (totalRecord / pageSize) : (totalRecord / pageSize + 1);
            Date nowDate = new Date();
            Long parentId;
            String oneMapKey, twoMapKey, threeMapKey, fourMapKey, fiveMapKey, sixMapKey, sevenMapKey, eightMapKey;
            HsgdBaseGroupSimpleVO groupSimpleVo = null;
            Map<String, HsgdBaseGroupSimpleVO> groupOneLevelMap = new HashMap<>();
            Map<String, HsgdBaseGroupSimpleVO> groupTwoLevelMap = new HashMap<>();
            Map<String, HsgdBaseGroupSimpleVO> groupThreeLevelMap = new HashMap<>();
            Map<String, HsgdBaseGroupSimpleVO> groupFourLevelMap = new HashMap<>();
            Map<String, HsgdBaseGroupSimpleVO> groupFiveLevelMap = new HashMap<>();
            Map<String, HsgdBaseGroupSimpleVO> groupSixLevelMap = new HashMap<>();
            Map<String, HsgdBaseGroupSimpleVO> groupSevenLevelMap = new HashMap<>();
            Map<String, HsgdBaseGroupSimpleVO> groupEightLevelMap = new HashMap<>();

            for (int pageN = 0; pageN < totalPage; pageN++) {
                PageHelper.startPage(startPage + pageN, pageSize, false);
                List<HsgdBaseGroupCustomerImportCompletion> completionPageList  = hsgdBaseGroupCustomerImportCompletionMapper.selectListByBatchNo(batchNo);
                if(CollectionUtils.isNotEmpty(completionPageList)){

                    List<Long> customerIdList = completionPageList.stream().map(HsgdBaseGroupCustomerImportCompletion::getCustomerId).collect(Collectors.toList());
                    List<HsgdBaseGroupCustomerSimpleVO>  customerSiList = hsgdBaseGroupCustomerImportCompletionMapper.querySrCustomerInfoByIds(customerIdList);
                    List<HsgdBaseGroupCustomerSimpleVO>  customerDealerList = hsgdBaseGroupCustomerImportCompletionMapper.queryDealerCustomerInfoByIds(customerIdList);
                    Map<Long,HsgdBaseGroupCustomerSimpleVO> customerSiMap = new HashMap<>();
                    if (CollectionUtils.isNotEmpty(customerSiList)) {
                        Map<Long, HsgdBaseGroupCustomerSimpleVO> srCustomerSiMap = customerSiList.stream().collect(Collectors.toMap(HsgdBaseGroupCustomerSimpleVO::getCustomerId, Function.identity(), (key1, key2) -> key2));
                        customerSiMap.putAll(srCustomerSiMap);
                    }
                    if (CollectionUtils.isNotEmpty(customerDealerList)) {
                        Map<Long, HsgdBaseGroupCustomerSimpleVO> dealerCustomerSiMap = customerDealerList.stream().collect(Collectors.toMap(HsgdBaseGroupCustomerSimpleVO::getCustomerId, Function.identity(), (key1, key2) -> key2));
                        customerSiMap.putAll(dealerCustomerSiMap);
                    }

                    List<HsgdBaseGroupCustomer> groupCustomerList = new ArrayList<>();
                    HsgdBaseGroupCustomer baseGroupCustomer;
                    List<HsgdBaseGroupCustomerNotImportRecord>  errorRecordList = new ArrayList<>();
                    HsgdBaseGroupCustomerNotImportRecord notImportRecord;

                    Map<Long,HsgdBaseGroupCustomerImportCompletion> completionMap = completionPageList.stream().collect(Collectors.toMap(HsgdBaseGroupCustomerImportCompletion::getId,Function.identity(),(key1,key2)->key2));

                    for (HsgdBaseGroupCustomerImportCompletion completionVO : completionPageList){
                        HsgdBaseGroupCustomerSimpleVO customerVo = customerSiMap.get(completionVO.getCustomerId());
                        Long importId = completionVO.getId();

                        if(customerSiMap.containsKey(completionVO.getCustomerId())){

                            if (HsgdBaseGroupLevelEnum.ONE.getGroupLevel().equals(completionVO.getGroupLevel())) {
                                oneMapKey = completionVO.getLevelOneGroup();
                                if (groupOneLevelMap.get(oneMapKey) == null) {
                                    this.queryOneLevelGroup(oneMapKey, groupOneLevelMap, completionVO);
                                }

                                if (groupOneLevelMap.get(oneMapKey) != null) {
                                    groupSimpleVo = groupOneLevelMap.get(oneMapKey);
                                    baseGroupCustomer = this.createHsgdBaseGroupCutomerData(groupSimpleVo, customerVo, nowDate,importId);
                                    groupCustomerList.add(baseGroupCustomer);
                                } else {
                                    notImportRecord = new HsgdBaseGroupCustomerNotImportRecord();
                                    BeanUtils.copyProperties(completionVO, notImportRecord);
                                    errorRecordList.add(notImportRecord);
                                }
                            }
                            else if (HsgdBaseGroupLevelEnum.TWO.getGroupLevel().equals(completionVO.getGroupLevel())) {
                                oneMapKey = completionVO.getLevelOneGroup();
                                twoMapKey = completionVO.getLevelTwoGroup();

                                if(groupOneLevelMap.get(oneMapKey) == null){
                                    this.queryOneLevelGroup(oneMapKey, groupOneLevelMap, completionVO);
                                }

                                if(groupOneLevelMap.get(oneMapKey) != null  &&  groupTwoLevelMap.get(twoMapKey) == null){
                                    this.queryTwoLevelGroup(twoMapKey, groupTwoLevelMap, completionVO);
                                }

                                if(groupOneLevelMap.get(oneMapKey) != null  &&  groupTwoLevelMap.get(twoMapKey) != null){
                                    groupSimpleVo = groupTwoLevelMap.get(twoMapKey);
                                    baseGroupCustomer =  this.createHsgdBaseGroupCutomerData(groupSimpleVo,customerVo,nowDate,importId);
                                    groupCustomerList.add(baseGroupCustomer);
                                }else{
                                    notImportRecord = new HsgdBaseGroupCustomerNotImportRecord();
                                    BeanUtils.copyProperties(completionVO, notImportRecord);
                                    errorRecordList.add(notImportRecord);
                                }
                            }
                            else if (HsgdBaseGroupLevelEnum.THREE.getGroupLevel().equals(completionVO.getGroupLevel())) {
                                oneMapKey = completionVO.getLevelOneGroup();
                                twoMapKey = completionVO.getLevelTwoGroup();
                                threeMapKey = completionVO.getLevelThreeGroup();

                                if(groupOneLevelMap.get(oneMapKey) == null){
                                    this.queryOneLevelGroup(oneMapKey, groupOneLevelMap, completionVO);
                                }

                                if(groupOneLevelMap.get(oneMapKey) != null  &&  groupTwoLevelMap.get(twoMapKey) == null){
                                    this.queryTwoLevelGroup(twoMapKey, groupTwoLevelMap, completionVO);
                                }

                                if(groupTwoLevelMap.get(twoMapKey) != null && groupThreeLevelMap.get(threeMapKey) == null){
                                    this.queryThreeLevelGroup(threeMapKey, groupThreeLevelMap, completionVO);
                                }

                                if(groupOneLevelMap.get(oneMapKey) != null  &&  groupTwoLevelMap.get(twoMapKey) != null && groupThreeLevelMap.get(threeMapKey) != null){
                                    groupSimpleVo = groupThreeLevelMap.get(threeMapKey);
                                    baseGroupCustomer =  this.createHsgdBaseGroupCutomerData(groupSimpleVo,customerVo,nowDate,importId);
                                    groupCustomerList.add(baseGroupCustomer);
                                }else{
                                    notImportRecord = new HsgdBaseGroupCustomerNotImportRecord();
                                    BeanUtils.copyProperties(completionVO, notImportRecord);
                                    errorRecordList.add(notImportRecord);
                                }
                            }
                            else if (HsgdBaseGroupLevelEnum.FOUR.getGroupLevel().equals(completionVO.getGroupLevel())) {
                                oneMapKey = completionVO.getLevelOneGroup();
                                twoMapKey = completionVO.getLevelTwoGroup();
                                threeMapKey = completionVO.getLevelThreeGroup();
                                fourMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup();

                                if(groupOneLevelMap.get(oneMapKey) == null){
                                    this.queryOneLevelGroup(oneMapKey, groupOneLevelMap, completionVO);
                                }

                                if(groupOneLevelMap.get(oneMapKey) != null  &&  groupTwoLevelMap.get(twoMapKey) == null){
                                    this.queryTwoLevelGroup(twoMapKey, groupTwoLevelMap, completionVO);
                                }

                                if(groupTwoLevelMap.get(twoMapKey) != null && groupThreeLevelMap.get(threeMapKey) == null){
                                    this.queryThreeLevelGroup(threeMapKey, groupThreeLevelMap, completionVO);
                                }

                                if(groupThreeLevelMap.get(threeMapKey) != null && groupFourLevelMap.get(fourMapKey) == null){
                                    parentId = groupThreeLevelMap.get(threeMapKey).getGroupId();
                                    this.queryFourLevelGroup(fourMapKey, groupFourLevelMap, completionVO,parentId);
                                }

                                if(groupOneLevelMap.get(oneMapKey) != null  && groupTwoLevelMap.get(twoMapKey) != null
                                        && groupThreeLevelMap.get(threeMapKey) != null && groupFourLevelMap.get(fourMapKey) != null){
                                    groupSimpleVo = groupFourLevelMap.get(fourMapKey);
                                    baseGroupCustomer =  this.createHsgdBaseGroupCutomerData(groupSimpleVo,customerVo,nowDate,importId);
                                    groupCustomerList.add(baseGroupCustomer);
                                }else{
                                    notImportRecord = new HsgdBaseGroupCustomerNotImportRecord();
                                    BeanUtils.copyProperties(completionVO, notImportRecord);
                                    errorRecordList.add(notImportRecord);
                                }
                            }
                            else if (HsgdBaseGroupLevelEnum.FIVE.getGroupLevel().equals(completionVO.getGroupLevel())) {
                                oneMapKey = completionVO.getLevelOneGroup();
                                twoMapKey = completionVO.getLevelTwoGroup();
                                threeMapKey = completionVO.getLevelThreeGroup();
                                fourMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup();
                                fiveMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup();

                                if(groupOneLevelMap.get(oneMapKey) == null){
                                    this.queryOneLevelGroup(oneMapKey, groupOneLevelMap, completionVO);
                                }

                                if(groupOneLevelMap.get(oneMapKey) != null  &&  groupTwoLevelMap.get(twoMapKey) == null){
                                    this.queryTwoLevelGroup(twoMapKey, groupTwoLevelMap, completionVO);
                                }

                                if(groupTwoLevelMap.get(twoMapKey) != null && groupThreeLevelMap.get(threeMapKey) == null){
                                    this.queryThreeLevelGroup(threeMapKey, groupThreeLevelMap, completionVO);
                                }

                                if(groupThreeLevelMap.get(threeMapKey) != null && groupFourLevelMap.get(fourMapKey) == null){
                                    parentId = groupThreeLevelMap.get(threeMapKey).getGroupId();
                                    this.queryFourLevelGroup(fourMapKey, groupFourLevelMap, completionVO,parentId);
                                }

                                if(groupFourLevelMap.get(fourMapKey) != null && groupFiveLevelMap.get(fiveMapKey) == null){
                                    parentId = groupFourLevelMap.get(fourMapKey).getGroupId();
                                    this.queryFiveLevelGroup(fiveMapKey, groupFiveLevelMap, completionVO,parentId);
                                }

                                if (groupOneLevelMap.get(oneMapKey) != null  && groupTwoLevelMap.get(twoMapKey) != null && groupThreeLevelMap.get(threeMapKey) != null &&
                                        groupFourLevelMap.get(fourMapKey) != null && groupFiveLevelMap.get(fiveMapKey) != null) {
                                    groupSimpleVo  = groupFiveLevelMap.get(fiveMapKey);
                                    baseGroupCustomer = this.createHsgdBaseGroupCutomerData(groupSimpleVo, customerVo, nowDate,importId);
                                    groupCustomerList.add(baseGroupCustomer);
                                }else{
                                    notImportRecord = new HsgdBaseGroupCustomerNotImportRecord();
                                    BeanUtils.copyProperties(completionVO, notImportRecord);
                                    errorRecordList.add(notImportRecord);
                                }
                            }
                            else if (HsgdBaseGroupLevelEnum.SIX.getGroupLevel().equals(completionVO.getGroupLevel())) {

                                oneMapKey = completionVO.getLevelOneGroup();
                                twoMapKey = completionVO.getLevelTwoGroup();
                                threeMapKey = completionVO.getLevelThreeGroup();
                                fourMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup();
                                fiveMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup();
                                sixMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup()
                                        + "-" + completionVO.getLevelSixGroup();

                                if(groupOneLevelMap.get(oneMapKey) == null){
                                    this.queryOneLevelGroup(oneMapKey, groupOneLevelMap, completionVO);
                                }

                                if(groupOneLevelMap.get(oneMapKey) != null  &&  groupTwoLevelMap.get(twoMapKey) == null){
                                    this.queryTwoLevelGroup(twoMapKey, groupTwoLevelMap, completionVO);
                                }

                                if(groupTwoLevelMap.get(twoMapKey) != null && groupThreeLevelMap.get(threeMapKey) == null){
                                    this.queryThreeLevelGroup(threeMapKey, groupThreeLevelMap, completionVO);
                                }

                                if(groupThreeLevelMap.get(threeMapKey) != null && groupFourLevelMap.get(fourMapKey) == null){
                                    parentId = groupThreeLevelMap.get(threeMapKey).getGroupId();
                                    this.queryFourLevelGroup(fourMapKey, groupFourLevelMap, completionVO,parentId);
                                }

                                if(groupFourLevelMap.get(fourMapKey) != null && groupFiveLevelMap.get(fiveMapKey) == null){
                                    parentId = groupFourLevelMap.get(fourMapKey).getGroupId();
                                    this.queryFiveLevelGroup(fiveMapKey, groupFiveLevelMap, completionVO,parentId);
                                }

                                if(groupFiveLevelMap.get(fiveMapKey) != null && groupSixLevelMap.get(sixMapKey) == null){
                                    parentId = groupFiveLevelMap.get(fiveMapKey).getGroupId();
                                    this.querySixLevelGroup(sixMapKey, groupSixLevelMap, completionVO,parentId);
                                }

                                if(groupOneLevelMap.get(oneMapKey) != null  && groupTwoLevelMap.get(twoMapKey) != null && groupThreeLevelMap.get(threeMapKey) != null &&
                                        groupFourLevelMap.get(fourMapKey) != null && groupFiveLevelMap.get(fiveMapKey) != null && groupSixLevelMap.get(sixMapKey) != null ){
                                    groupSimpleVo  = groupSixLevelMap.get(sixMapKey);
                                    baseGroupCustomer =  this.createHsgdBaseGroupCutomerData(groupSimpleVo,customerVo,nowDate,importId);
                                    groupCustomerList.add(baseGroupCustomer);
                                }else{
                                    notImportRecord = new HsgdBaseGroupCustomerNotImportRecord();
                                    BeanUtils.copyProperties(completionVO, notImportRecord);
                                    errorRecordList.add(notImportRecord);
                                }
                            }
                            else if (HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel().equals(completionVO.getGroupLevel())) {
                                oneMapKey = completionVO.getLevelOneGroup();
                                twoMapKey = completionVO.getLevelTwoGroup();
                                threeMapKey = completionVO.getLevelThreeGroup();
                                fourMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup();
                                fiveMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup();
                                sixMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup()
                                        + "-" + completionVO.getLevelSixGroup();
                                sevenMapKey =  completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup()
                                        + "-" + completionVO.getLevelSixGroup() + "-" + completionVO.getLevelSevenGroup();

                                if(groupOneLevelMap.get(oneMapKey) == null){
                                    this.queryOneLevelGroup(oneMapKey, groupOneLevelMap, completionVO);
                                }

                                if(groupOneLevelMap.get(oneMapKey) != null  &&  groupTwoLevelMap.get(twoMapKey) == null){
                                    this.queryTwoLevelGroup(twoMapKey, groupTwoLevelMap, completionVO);
                                }

                                if(groupTwoLevelMap.get(twoMapKey) != null && groupThreeLevelMap.get(threeMapKey) == null){
                                    this.queryThreeLevelGroup(threeMapKey, groupThreeLevelMap, completionVO);
                                }

                                if(groupThreeLevelMap.get(threeMapKey) != null && groupFourLevelMap.get(fourMapKey) == null){
                                    parentId = groupThreeLevelMap.get(threeMapKey).getGroupId();
                                    this.queryFourLevelGroup(fourMapKey, groupFourLevelMap, completionVO,parentId);
                                }

                                if(groupFourLevelMap.get(fourMapKey) != null && groupFiveLevelMap.get(fiveMapKey) == null){
                                    parentId = groupFourLevelMap.get(fourMapKey).getGroupId();
                                    this.queryFiveLevelGroup(fiveMapKey, groupFiveLevelMap, completionVO,parentId);
                                }

                                if(groupFiveLevelMap.get(fiveMapKey) != null && groupSixLevelMap.get(sixMapKey) == null){
                                    parentId = groupFiveLevelMap.get(fiveMapKey).getGroupId();
                                    this.querySixLevelGroup(sixMapKey, groupSixLevelMap, completionVO,parentId);
                                }

                                if(groupSixLevelMap.get(sixMapKey) != null && groupSevenLevelMap.get(sevenMapKey) == null){
                                    parentId = groupSixLevelMap.get(sixMapKey) .getGroupId();
                                    this.querySevenLevelGroup(sevenMapKey, groupSevenLevelMap, completionVO,parentId);
                                }

                                if(groupOneLevelMap.get(oneMapKey) != null  && groupTwoLevelMap.get(twoMapKey) != null && groupThreeLevelMap.get(threeMapKey) != null &&
                                        groupFourLevelMap.get(fourMapKey) != null && groupFiveLevelMap.get(fiveMapKey) != null && groupSixLevelMap.get(sixMapKey) != null
                                        &&  groupSevenLevelMap.get(sevenMapKey) != null){
                                    groupSimpleVo  = groupSevenLevelMap.get(sevenMapKey);
                                    baseGroupCustomer =  this.createHsgdBaseGroupCutomerData(groupSimpleVo,customerVo,nowDate,importId);
                                    groupCustomerList.add(baseGroupCustomer);
                                }else{
                                    notImportRecord = new HsgdBaseGroupCustomerNotImportRecord();
                                    BeanUtils.copyProperties(completionVO, notImportRecord);
                                    errorRecordList.add(notImportRecord);
                                }
                            }
                            else if (HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel().equals(completionVO.getGroupLevel())) {
                                oneMapKey = completionVO.getLevelOneGroup();
                                twoMapKey = completionVO.getLevelTwoGroup();
                                threeMapKey = completionVO.getLevelThreeGroup();
                                fourMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup();
                                fiveMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup();
                                sixMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup()
                                        + "-" + completionVO.getLevelSixGroup();
                                sevenMapKey =  completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup()
                                        + "-" + completionVO.getLevelSixGroup() + "-" + completionVO.getLevelSevenGroup();
                                eightMapKey =   completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup()
                                        + "-" + completionVO.getLevelSixGroup() + "-" + completionVO.getLevelSevenGroup() + "-" + completionVO.getLevelEightGroup();

                                if(groupOneLevelMap.get(oneMapKey) == null){
                                    this.queryOneLevelGroup(oneMapKey, groupOneLevelMap, completionVO);
                                }

                                if(groupOneLevelMap.get(oneMapKey) != null  &&  groupTwoLevelMap.get(twoMapKey) == null){
                                    this.queryTwoLevelGroup(twoMapKey, groupTwoLevelMap, completionVO);
                                }

                                if(groupTwoLevelMap.get(twoMapKey) != null && groupThreeLevelMap.get(threeMapKey) == null){
                                    this.queryThreeLevelGroup(threeMapKey, groupThreeLevelMap, completionVO);
                                }

                                if(groupThreeLevelMap.get(threeMapKey) != null && groupFourLevelMap.get(fourMapKey) == null){
                                    parentId = groupThreeLevelMap.get(threeMapKey).getGroupId();
                                    this.queryFourLevelGroup(fourMapKey, groupFourLevelMap, completionVO,parentId);
                                }

                                if(groupFourLevelMap.get(fourMapKey) != null && groupFiveLevelMap.get(fiveMapKey) == null){
                                    parentId = groupFourLevelMap.get(fourMapKey).getGroupId();
                                    this.queryFiveLevelGroup(fiveMapKey, groupFiveLevelMap, completionVO,parentId);
                                }

                                if(groupFiveLevelMap.get(fiveMapKey) != null && groupSixLevelMap.get(sixMapKey) == null){
                                    parentId = groupFiveLevelMap.get(fiveMapKey).getGroupId();
                                    this.querySixLevelGroup(sixMapKey, groupSixLevelMap, completionVO,parentId);
                                }

                                if(groupSixLevelMap.get(sixMapKey) != null && groupSevenLevelMap.get(sevenMapKey) == null){
                                    parentId = groupSixLevelMap.get(sixMapKey) .getGroupId();
                                    this.querySevenLevelGroup(sevenMapKey, groupSevenLevelMap, completionVO,parentId);
                                }

                                if( groupSevenLevelMap.get(sevenMapKey) != null && groupEightLevelMap.get(eightMapKey) == null){
                                    parentId = groupSevenLevelMap.get(sevenMapKey).getGroupId();
                                    this.queryEightLevelGroup(eightMapKey, groupEightLevelMap, completionVO,parentId);
                                }

                                if(groupOneLevelMap.get(oneMapKey) != null  && groupTwoLevelMap.get(twoMapKey) != null && groupThreeLevelMap.get(threeMapKey) != null &&
                                        groupFourLevelMap.get(fourMapKey) != null && groupFiveLevelMap.get(fiveMapKey) != null && groupSixLevelMap.get(sixMapKey) != null
                                        &&  groupSevenLevelMap.get(sevenMapKey) != null && groupEightLevelMap.get(eightMapKey) != null){
                                    groupSimpleVo  = groupEightLevelMap.get(eightMapKey);
                                    baseGroupCustomer =  this.createHsgdBaseGroupCutomerData(groupSimpleVo,customerVo,nowDate,importId);
                                    groupCustomerList.add(baseGroupCustomer);
                                }else{
                                    notImportRecord = new HsgdBaseGroupCustomerNotImportRecord();
                                    BeanUtils.copyProperties(completionVO, notImportRecord);
                                    errorRecordList.add(notImportRecord);
                                }
                            }
                        }else{
                            notImportRecord = new HsgdBaseGroupCustomerNotImportRecord();
                            BeanUtils.copyProperties(completionVO, notImportRecord);
                            errorRecordList.add(notImportRecord);
                        }
                    }

                    if(CollectionUtils.isNotEmpty(groupCustomerList)){
                        List<Long> customerIds =  groupCustomerList.stream().map(HsgdBaseGroupCustomer::getCustomerId).collect(Collectors.toList());
                        List<HsgdBaseGroupCustomer> groupCustomerIdList = iHsgdBaseGroupCustomerService.selectListByCustomerId(customerIds);
                        List<String> existsList = groupCustomerIdList.stream().map(e -> e.getCustomerId() + "-" + e.getGroupId()  ).collect(Collectors.toList());
                        List<HsgdBaseGroupCustomer> needInsertGroupCustomerList = new ArrayList<>();
                        for (HsgdBaseGroupCustomer  customer : groupCustomerList){
                            if(!existsList.contains(customer.getCustomerId() + "-" + customer.getGroupId())){
                                needInsertGroupCustomerList.add(customer);
                            }else{
                                HsgdBaseGroupCustomerImportCompletion   comRecord =  completionMap.get(customer.getImportId());
                                notImportRecord = new HsgdBaseGroupCustomerNotImportRecord();
                                BeanUtils.copyProperties(comRecord, notImportRecord);
                                errorRecordList.add(notImportRecord);
                            }
                        }
                        if(CollectionUtils.isNotEmpty(needInsertGroupCustomerList)){
                            iHsgdBaseGroupCustomerService.saveBatch(needInsertGroupCustomerList);
                        }
                    }

                    if(CollectionUtils.isNotEmpty(errorRecordList)){
                        iHsgdBaseGroupCustomerNotImportRecordService.saveBatch(errorRecordList);
                    }
                }
            }
        }
    }

    private HsgdBaseGroupCustomer createHsgdBaseGroupCutomerData(HsgdBaseGroupSimpleVO oneSimpleVo, HsgdBaseGroupCustomerSimpleVO customerVo, Date nowDate,Long importCustomerComId) {
        HsgdBaseGroupCustomer hsgdBaseGroupCustomer = new HsgdBaseGroupCustomer();
        hsgdBaseGroupCustomer.setGroupId(oneSimpleVo.getGroupId());
        hsgdBaseGroupCustomer.setType(customerVo.getCustomerType());
        hsgdBaseGroupCustomer.setBusType(Integer.parseInt(customerVo.getBusType()));
        hsgdBaseGroupCustomer.setCustomerId(customerVo.getCustomerId());
        hsgdBaseGroupCustomer.setPoiCode(customerVo.getPoiCode());
        hsgdBaseGroupCustomer.setStatus(1);
        hsgdBaseGroupCustomer.setCreated(nowDate);
        hsgdBaseGroupCustomer.setCreatedBy(SYSTEM_USER_NAME);
        hsgdBaseGroupCustomer.setCreatedById(-1L);
        hsgdBaseGroupCustomer.setUpdated(nowDate);
        hsgdBaseGroupCustomer.setUpdatedBy(SYSTEM_USER_NAME);
        hsgdBaseGroupCustomer.setUpdatedById(-1L);
        hsgdBaseGroupCustomer.setImportId(importCustomerComId);
        return hsgdBaseGroupCustomer;
    }


    private HsgdBaseGroupSimpleVO queryOneLevelGroup(String oneMapKey, Map<String, HsgdBaseGroupSimpleVO> groupOneLevelMap, HsgdBaseGroupCustomerImportCompletion completionVO) {
        HsgdBaseGroupSimpleVO oneSimpleVo = iZhgdSrBaseGroupImportService.getGroupSimpleByGroupNameAndLevel(completionVO.getLevelOneGroup(), HsgdBaseGroupLevelEnum.ONE.getGroupLevel());
        if (oneSimpleVo != null) {
            groupOneLevelMap.put(oneMapKey, oneSimpleVo);
        }
        return oneSimpleVo;
    }


    private HsgdBaseGroupSimpleVO queryTwoLevelGroup(String twoMapKey, Map<String, HsgdBaseGroupSimpleVO> groupTwoLevelMap, HsgdBaseGroupCustomerImportCompletion completionVO) {
        HsgdBaseGroupSimpleVO twoSimpleVo = iZhgdSrBaseGroupImportService.getGroupSimpleByGroupNameAndLevel(completionVO.getLevelTwoGroup(), HsgdBaseGroupLevelEnum.TWO.getGroupLevel());
        if (twoSimpleVo != null) {
            groupTwoLevelMap.put(twoMapKey, twoSimpleVo);
        }
        return twoSimpleVo;
    }

    private HsgdBaseGroupSimpleVO queryThreeLevelGroup(String threeMapKey, Map<String, HsgdBaseGroupSimpleVO> groupThreeLevelMap, HsgdBaseGroupCustomerImportCompletion completionVO) {
        HsgdBaseGroupSimpleVO threeSimpleVo = iZhgdSrBaseGroupImportService.getGroupSimpleByGroupNameAndLevel(completionVO.getLevelThreeGroup(), HsgdBaseGroupLevelEnum.THREE.getGroupLevel());
        if (threeSimpleVo != null) {
            groupThreeLevelMap.put(threeMapKey, threeSimpleVo);
        }
        return threeSimpleVo;
    }


    private HsgdBaseGroupSimpleVO queryFourLevelGroup(String fourMapKey, Map<String, HsgdBaseGroupSimpleVO> groupFourLevelMap, HsgdBaseGroupCustomerImportCompletion completionVO, Long parentId) {
        HsgdBaseGroupSimpleVO fourSimpleVo = iZhgdSrBaseGroupImportService.getGroupSimpleByGroupNameAndLevelAndParentId(completionVO.getLevelFourGroup(), HsgdBaseGroupLevelEnum.FOUR.getGroupLevel(), parentId);
        if (fourSimpleVo != null) {
            groupFourLevelMap.put(fourMapKey, fourSimpleVo);
        }
        return fourSimpleVo;
    }

    private HsgdBaseGroupSimpleVO queryFiveLevelGroup(String fiveMapKey, Map<String, HsgdBaseGroupSimpleVO> groupFiveLevelMap, HsgdBaseGroupCustomerImportCompletion completionVO, Long parentId) {
        HsgdBaseGroupSimpleVO  fiveSimpleVo = iZhgdSrBaseGroupImportService.getGroupSimpleByGroupNameAndLevelAndParentId(completionVO.getLevelFiveGroup(), HsgdBaseGroupLevelEnum.FIVE.getGroupLevel(), parentId);
        if (fiveSimpleVo != null) {
            groupFiveLevelMap.put(fiveMapKey, fiveSimpleVo);
        }
        return fiveSimpleVo;
    }

    private HsgdBaseGroupSimpleVO querySixLevelGroup(String sixMapKey, Map<String, HsgdBaseGroupSimpleVO> groupSixLevelMap, HsgdBaseGroupCustomerImportCompletion completionVO, Long parentId) {
        HsgdBaseGroupSimpleVO  sixSimpleVo = iZhgdSrBaseGroupImportService.getGroupSimpleByGroupNameAndLevelAndParentId(completionVO.getLevelSixGroup(),HsgdBaseGroupLevelEnum.SIX.getGroupLevel(), parentId);
        if(sixSimpleVo != null){
            groupSixLevelMap.put(sixMapKey,sixSimpleVo);
        }

        return sixSimpleVo;
    }


    private HsgdBaseGroupSimpleVO querySevenLevelGroup(String sevenMapKey, Map<String, HsgdBaseGroupSimpleVO> groupSevenLevelMap, HsgdBaseGroupCustomerImportCompletion completionVO, Long parentId) {
        HsgdBaseGroupSimpleVO sevenSimpleVo = iZhgdSrBaseGroupImportService.getGroupSimpleByGroupNameAndLevelAndParentId(completionVO.getLevelSevenGroup(), HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel(),parentId);
        if (sevenSimpleVo != null) {
            groupSevenLevelMap.put(sevenMapKey, sevenSimpleVo);
        }
        return sevenSimpleVo;
    }


    private HsgdBaseGroupSimpleVO queryEightLevelGroup(String eightMapKey, Map<String, HsgdBaseGroupSimpleVO> groupEightLevelMap, HsgdBaseGroupCustomerImportCompletion completionVO, Long parentId) {
        HsgdBaseGroupSimpleVO eightSimpleVo = iZhgdSrBaseGroupImportService.getGroupSimpleByGroupNameAndLevelAndParentId(completionVO.getLevelEightGroup(), HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel(), parentId);
        if (eightSimpleVo != null) {
            groupEightLevelMap.put(eightMapKey, eightSimpleVo);
        }
        return eightSimpleVo;
    }


}

package com.zhgd.base.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zhgd.base.entity.HsgdBaseGroupCustomerImportRecord;
import com.zhgd.base.entity.HsgdBaseGroupImportRecord;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @desc 组织部门人员导入记录 Mapper
 *
 * @author 
 * @version 1.0
 * @date 2021-10-12 10:15:35
 */
@Repository
public interface HsgdBaseGroupCustomerImportRecordMapper extends BaseMapper<HsgdBaseGroupCustomerImportRecord> {

    /**
     * 组织部门人员导入记录 批量插入数据集
     * @param param
     * @return Boolean
     */
    Boolean insertAll(@Param("paramList") List<HsgdBaseGroupCustomerImportRecord> param);

    int countImportBaseGroupCustomerDataTotalByBatchNo(String batchNo);

    List<HsgdBaseGroupCustomerImportRecord> selectListByBatchNo(String batchNo);
}

HsgdBaseGroupCustomerImportRecordMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zhgd.base.mapper.HsgdBaseGroupCustomerImportRecordMapper">
    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.zhgd.base.entity.HsgdBaseGroupCustomerImportRecord">
        <id column="ID" property="id" jdbcType="BIGINT"/>
        <result column="LEVEL_ONE_GROUP" property="levelOneGroup" jdbcType="VARCHAR"/>
        <result column="LEVEL_TWO_GROUP" property="levelTwoGroup" jdbcType="VARCHAR"/>
        <result column="LEVEL_THREE_GROUP" property="levelThreeGroup" jdbcType="VARCHAR"/>
        <result column="LEVEL_FOUR_GROUP" property="levelFourGroup" jdbcType="VARCHAR"/>
        <result column="LEVEL_FIVE_GROUP" property="levelFiveGroup" jdbcType="VARCHAR"/>
        <result column="LEVEL_SIX_GROUP" property="levelSixGroup" jdbcType="VARCHAR"/>
        <result column="LEVEL_SEVEN_GROUP" property="levelSevenGroup" jdbcType="VARCHAR"/>
        <result column="LEVEL_EIGHT_GROUP" property="levelEightGroup" jdbcType="VARCHAR"/>
        <result column="CUSTOMER_ID" property="customerId" jdbcType="BIGINT"/>
        <result column="POI_CODE" property="poiCode" jdbcType="BIGINT"/>
        <result column="CREATED" property="created" jdbcType="TIMESTAMP"/>
        <result column="CREATED_BY" property="createdBy" jdbcType="VARCHAR"/>
        <result column="UPDATED" property="updated" jdbcType="TIMESTAMP"/>
        <result column="UPDATED_BY" property="updatedBy" jdbcType="VARCHAR"/>
        <result column="BATCH_NO" property="batchNo" jdbcType="VARCHAR"/>
    </resultMap>
    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        ID, LEVEL_ONE_GROUP, LEVEL_TWO_GROUP, LEVEL_THREE_GROUP, LEVEL_FOUR_GROUP, LEVEL_FIVE_GROUP, LEVEL_SIX_GROUP, LEVEL_SEVEN_GROUP, LEVEL_EIGHT_GROUP, CUSTOMER_ID, POI_CODE, CREATED, CREATED_BY, UPDATED, UPDATED_BY, BATCH_NO
    </sql>
    <insert id="insertAll" parameterType="com.zhgd.base.entity.HsgdBaseGroupCustomerImportRecord" >
        insert into HSGD_BASE_GROUP_CUSTOMER_IMPORT_RECORD
        <trim prefix="(" suffix=")" suffixOverrides="," >
            LEVEL_ONE_GROUP,
            LEVEL_TWO_GROUP,
            LEVEL_THREE_GROUP,
            LEVEL_FOUR_GROUP,
            LEVEL_FIVE_GROUP,
            LEVEL_SIX_GROUP,
            LEVEL_SEVEN_GROUP,
            LEVEL_EIGHT_GROUP,
            CUSTOMER_ID,
            POI_CODE,
            CREATED,
            CREATED_BY,
            UPDATED,
            UPDATED_BY,
            BATCH_NO,
        </trim>
        VALUES
        <foreach collection="paramList" separator="," item="param" index="index">
            <trim prefix="(" suffix=")" suffixOverrides="," >
                #{param.levelOneGroup, jdbcType=VARCHAR},
                #{param.levelTwoGroup, jdbcType=VARCHAR},
                #{param.levelThreeGroup, jdbcType=VARCHAR},
                #{param.levelFourGroup, jdbcType=VARCHAR},
                #{param.levelFiveGroup, jdbcType=VARCHAR},
                #{param.levelSixGroup, jdbcType=VARCHAR},
                #{param.levelSevenGroup, jdbcType=VARCHAR},
                #{param.levelEightGroup, jdbcType=VARCHAR},
                #{param.customerId, jdbcType=BIGINT},
                #{param.poiCode, jdbcType=BIGINT},
                #{param.created, jdbcType=TIMESTAMP},
                #{param.createdBy, jdbcType=VARCHAR},
                #{param.updated, jdbcType=TIMESTAMP},
                #{param.updatedBy, jdbcType=VARCHAR},
                #{param.batchNo, jdbcType=VARCHAR},
            </trim>
        </foreach>
    </insert>

    <select id="countImportBaseGroupCustomerDataTotalByBatchNo" resultType="java.lang.Integer">
         SELECT COUNT(1) FROM HSGD_BASE_GROUP_CUSTOMER_IMPORT_RECORD WITH(NOLOCK) WHERE BATCH_NO = #{batchNo}
    </select>

    <select id="selectListByBatchNo" resultType="com.zhgd.base.entity.HsgdBaseGroupCustomerImportRecord">
        SELECT
        <include refid="Base_Column_List"/>
        FROM HSGD_BASE_GROUP_CUSTOMER_IMPORT_RECORD WITH(NOLOCK)
        WHERE BATCH_NO = #{batchNo}
        ORDER BY LEVEL_ONE_GROUP,LEVEL_TWO_GROUP,LEVEL_THREE_GROUP,LEVEL_FOUR_GROUP,LEVEL_FIVE_GROUP,LEVEL_SIX_GROUP,LEVEL_SEVEN_GROUP,LEVEL_EIGHT_GROUP
    </select>
</mapper>
package com.zhgd.base.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zhgd.base.domain.vo.HsgdBaseGroupCustomerSimpleVO;
import com.zhgd.base.entity.HsgdBaseGroupCustomerImportCompletion;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @desc 组织部门人员导入记录补全表 Mapper
 *
 * @author 
 * @version 1.0
 * @date 2021-10-13 14:29:30
 */
@Repository
public interface HsgdBaseGroupCustomerImportCompletionMapper extends BaseMapper<HsgdBaseGroupCustomerImportCompletion> {

    /**
     * 组织部门人员导入记录补全表 批量插入数据集
     * @param param
     * @return Boolean
     */
    Boolean insertAll(@Param("paramList") List<HsgdBaseGroupCustomerImportCompletion> param);

    List<HsgdBaseGroupCustomerImportCompletion> selectListByBatchNo(String batchNo);

    List<HsgdBaseGroupCustomerSimpleVO> querySrCustomerInfoByIds(@Param("list")  List<Long> customerIdList);

    List<HsgdBaseGroupCustomerSimpleVO> queryDealerCustomerInfoByIds(List<Long> customerIdList);
}

HsgdBaseGroupCustomerImportCompletionMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zhgd.base.mapper.HsgdBaseGroupCustomerImportCompletionMapper">
    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.zhgd.base.entity.HsgdBaseGroupCustomerImportCompletion">
        <id column="ID" property="id" jdbcType="BIGINT"/>
        <result column="LEVEL_ONE_GROUP" property="levelOneGroup" jdbcType="VARCHAR"/>
        <result column="LEVEL_TWO_GROUP" property="levelTwoGroup" jdbcType="VARCHAR"/>
        <result column="LEVEL_THREE_GROUP" property="levelThreeGroup" jdbcType="VARCHAR"/>
        <result column="LEVEL_FOUR_GROUP" property="levelFourGroup" jdbcType="VARCHAR"/>
        <result column="LEVEL_FIVE_GROUP" property="levelFiveGroup" jdbcType="VARCHAR"/>
        <result column="LEVEL_SIX_GROUP" property="levelSixGroup" jdbcType="VARCHAR"/>
        <result column="LEVEL_SEVEN_GROUP" property="levelSevenGroup" jdbcType="VARCHAR"/>
        <result column="LEVEL_EIGHT_GROUP" property="levelEightGroup" jdbcType="VARCHAR"/>
        <result column="CUSTOMER_ID" property="customerId" jdbcType="BIGINT"/>
        <result column="POI_CODE" property="poiCode" jdbcType="BIGINT"/>
        <result column="CREATED" property="created" jdbcType="TIMESTAMP"/>
        <result column="CREATED_BY" property="createdBy" jdbcType="VARCHAR"/>
        <result column="UPDATED" property="updated" jdbcType="TIMESTAMP"/>
        <result column="UPDATED_BY" property="updatedBy" jdbcType="VARCHAR"/>
        <result column="BATCH_NO" property="batchNo" jdbcType="VARCHAR"/>
        <result column="GROUP_LEVEL" property="groupLevel" jdbcType="INTEGER"/>
    </resultMap>
    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        ID, LEVEL_ONE_GROUP, LEVEL_TWO_GROUP, LEVEL_THREE_GROUP, LEVEL_FOUR_GROUP, LEVEL_FIVE_GROUP, LEVEL_SIX_GROUP, LEVEL_SEVEN_GROUP, LEVEL_EIGHT_GROUP, CUSTOMER_ID, POI_CODE, CREATED, CREATED_BY, UPDATED, UPDATED_BY, BATCH_NO,GROUP_LEVEL
    </sql>
    <insert id="insertAll" parameterType="com.zhgd.base.entity.HsgdBaseGroupCustomerImportCompletion" >
        insert into HSGD_BASE_GROUP_CUSTOMER_IMPORT_COMPLETION
        <trim prefix="(" suffix=")" suffixOverrides="," >
            LEVEL_ONE_GROUP,
            LEVEL_TWO_GROUP,
            LEVEL_THREE_GROUP,
            LEVEL_FOUR_GROUP,
            LEVEL_FIVE_GROUP,
            LEVEL_SIX_GROUP,
            LEVEL_SEVEN_GROUP,
            LEVEL_EIGHT_GROUP,
            CUSTOMER_ID,
            POI_CODE,
            CREATED,
            CREATED_BY,
            UPDATED,
            UPDATED_BY,
            BATCH_NO,
            GROUP_LEVEL,
        </trim>
        VALUES
        <foreach collection="paramList" separator="," item="param" index="index">
            <trim prefix="(" suffix=")" suffixOverrides="," >
                #{param.levelOneGroup, jdbcType=VARCHAR},
                #{param.levelTwoGroup, jdbcType=VARCHAR},
                #{param.levelThreeGroup, jdbcType=VARCHAR},
                #{param.levelFourGroup, jdbcType=VARCHAR},
                #{param.levelFiveGroup, jdbcType=VARCHAR},
                #{param.levelSixGroup, jdbcType=VARCHAR},
                #{param.levelSevenGroup, jdbcType=VARCHAR},
                #{param.levelEightGroup, jdbcType=VARCHAR},
                #{param.customerId, jdbcType=BIGINT},
                #{param.poiCode, jdbcType=BIGINT},
                #{param.created, jdbcType=TIMESTAMP},
                #{param.createdBy, jdbcType=VARCHAR},
                #{param.updated, jdbcType=TIMESTAMP},
                #{param.updatedBy, jdbcType=VARCHAR},
                #{param.batchNo, jdbcType=VARCHAR},
                #{param.groupLevel, jdbcType=INTEGER},
            </trim>
        </foreach>
    </insert>

    <select id="selectListByBatchNo" resultType="com.zhgd.base.entity.HsgdBaseGroupCustomerImportCompletion">
        SELECT
        <include refid="Base_Column_List"/>
        FROM HSGD_BASE_GROUP_CUSTOMER_IMPORT_COMPLETION WITH(NOLOCK)
        WHERE BATCH_NO = #{batchNo}
        ORDER BY LEVEL_ONE_GROUP,LEVEL_TWO_GROUP,LEVEL_THREE_GROUP,LEVEL_FOUR_GROUP,LEVEL_FIVE_GROUP,LEVEL_SIX_GROUP,LEVEL_SEVEN_GROUP,LEVEL_EIGHT_GROUP
    </select>

    <select id="querySrCustomerInfoByIds" resultType="com.zhgd.base.domain.vo.HsgdBaseGroupCustomerSimpleVO">
        SELECT
            businessInfo.CUSTOMER_ID AS customerId,
            1 AS customerType,
            businessInfo.BUS_TYPE AS busType,
            wsCustomer.ORG_ID AS poiCode
            FROM CRM_BUSINESS_INFO businessInfo WITH(NOLOCK)
            LEFT JOIN CRM_WS_CUSTOMER wsCustomer  WITH(NOLOCK)  ON  businessInfo.CUSTOMER_ID = wsCustomer.CUSTOMER_ID
            WHERE
                businessInfo.BUS_STATUS = 1
            AND wsCustomer.CUST_STATUS = 1
            AND businessInfo.CUSTOMER_ID IN
            <foreach collection="list" item="custoemrId" separator="," open="(" close=")">
                #{custoemrId}
            </foreach>
    </select>

    <select id="queryDealerCustomerInfoByIds"
            resultType="com.zhgd.base.domain.vo.HsgdBaseGroupCustomerSimpleVO">
            SELECT
            wsCustomer.CUSTOMER_ID AS customerId,
            2 AS customerType,
            CASE WHEN poiInfo.POI_TYPE = 'saler'
            THEN 1
            WHEN poiInfo.POI_TYPE = 'dealer' AND  poiInfo.DEALER_SOURCE_TYPE = '经销商'
            THEN 3
            WHEN poiInfo.POI_TYPE = 'dealer' AND  poiInfo.DEALER_SOURCE_TYPE = '镇村通伙伴'
            THEN 2
            END
            AS busType,
            wsCustomer.ORG_ID AS poiCode
            FROM CRM_WS_CUSTOMER wsCustomer  WITH(NOLOCK)
            LEFT JOIN CRM_POI_INFO poiInfo WITH(NOLOCK)  ON  poiInfo.POI_CODE = wsCustomer.ORG_ID
            WHERE
                poiInfo.STATUS = 1
            AND wsCustomer.CUST_STATUS = 1
            AND wsCustomer.CUSTOMER_ID IN
            <foreach collection="list" item="custoemrId" separator="," open="(" close=")">
                #{custoemrId}
            </foreach>
            AND poiInfo.POI_TYPE IN ('dealer','saler')
    </select>

</mapper>
package com.zhgd.base.service;

import com.zhgd.base.domain.model.ZhgdSrGroupCustomerImportModel;
import com.zhgd.base.entity.HsgdBaseGroupCustomerImportCompletion;


import java.util.List;

public interface IZhgdSrBaseGroupImportCustomerHandleService {

    void saveSrBaseGroupCustomerImportDataList(List<ZhgdSrGroupCustomerImportModel> dataList);

    void saveSrBaseGroupCustomerImportData(ZhgdSrGroupCustomerImportModel data);

    void insertAllImportCompletion(List<HsgdBaseGroupCustomerImportCompletion> completionList);
}

package com.zhgd.base.service.impl;

import com.zhgd.base.domain.model.ZhgdSrGroupCustomerImportModel;
import com.zhgd.base.entity.HsgdBaseGroupCustomerImportCompletion;
import com.zhgd.base.entity.HsgdBaseGroupCustomerImportRecord;
import com.zhgd.base.entity.HsgdBaseGroupImportRecord;
import com.zhgd.base.mapper.HsgdBaseGroupCustomerImportCompletionMapper;
import com.zhgd.base.service.IZhgdSrBaseGroupCustomerImportService;
import com.zhgd.base.service.IZhgdSrBaseGroupImportCustomerHandleService;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.collections.CollectionUtils;
import org.apache.commons.lang.StringUtils;
import org.apache.commons.lang.math.NumberUtils;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

@Service
@Slf4j
public class ZhgdSrBaseGroupImportCustomerHandleServiceImpl implements IZhgdSrBaseGroupImportCustomerHandleService {

    @Resource
    private IZhgdSrBaseGroupCustomerImportService iZhgdSrBaseGroupCustomerImportService;

    @Resource
    private HsgdBaseGroupCustomerImportCompletionMapper hsgdBaseGroupCustomerImportCompletionMapper;

    @Override
    public void saveSrBaseGroupCustomerImportDataList(List<ZhgdSrGroupCustomerImportModel> dataList) {
        Date nowDate = new Date();
        final String userName = "system";
        if(CollectionUtils.isNotEmpty(dataList)){
            List<HsgdBaseGroupCustomerImportRecord> recordList = new ArrayList();
            HsgdBaseGroupCustomerImportRecord record = null;
            for (int i=0,len = dataList.size();i< len;i++){
                ZhgdSrGroupCustomerImportModel importModel = dataList.get(i);
                record = new HsgdBaseGroupCustomerImportRecord();
                BeanUtils.copyProperties(importModel,record);
                record.setCreated(nowDate);
                record.setCreatedBy(userName);
                record.setUpdated(nowDate);
                record.setUpdatedBy(userName);
                if(StringUtils.isNotBlank(importModel.getCustomerID()) && NumberUtils.isNumber(importModel.getCustomerID())){
                    record.setCustomerId(Long.parseLong(importModel.getCustomerID()));
                }
                if(StringUtils.isNotBlank(importModel.getPoiCode()) && NumberUtils.isNumber(importModel.getPoiCode())){
                    record.setPoiCode(Long.parseLong(importModel.getPoiCode()));
                }
                recordList.add(record);
            };
            iZhgdSrBaseGroupCustomerImportService.batchInsertAll(recordList);
        }
    }

    @Override
    public void saveSrBaseGroupCustomerImportData(ZhgdSrGroupCustomerImportModel data) {
        Date nowDate = new Date();
        final String userName = "system";
        if(data != null){
            HsgdBaseGroupCustomerImportRecord record = new HsgdBaseGroupCustomerImportRecord();
            BeanUtils.copyProperties(data,record);
            record.setCreated(nowDate);
            record.setCreatedBy(userName);
            record.setUpdated(nowDate);
            record.setUpdatedBy(userName);
            if(StringUtils.isNotBlank(data.getCustomerID()) && NumberUtils.isNumber(data.getCustomerID())){
                record.setCustomerId(Long.parseLong(data.getCustomerID()));
            }
            if(StringUtils.isNotBlank(data.getPoiCode()) && NumberUtils.isNumber(data.getPoiCode())){
                record.setPoiCode(Long.parseLong(data.getPoiCode()));
            }

            iZhgdSrBaseGroupCustomerImportService.insert(record);
        }
    }

    @Override
    @Transactional
    public void insertAllImportCompletion(List<HsgdBaseGroupCustomerImportCompletion> completionList) {
        hsgdBaseGroupCustomerImportCompletionMapper.insertAll(completionList);
    }


}

package com.zhgd.base.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.zhgd.base.entity.HsgdBaseGroupCustomer;

import java.util.List;

/**
 * @desc 部门关联用户表 服务
 *
 * @author 
 * @version 1.0
 * @date 2021-10-14 16:55:50
 */
public interface IHsgdBaseGroupCustomerService extends IService<HsgdBaseGroupCustomer> {

    /**
     * 部门关联用户表 批量新增重写
     * @param param model集合
     * @return Boolean
     */
    Boolean saveBatch(List<HsgdBaseGroupCustomer> param);

    long countExistsGroupCustomer(Long customerId, Long groupId);

    void insert(HsgdBaseGroupCustomer customer);

    List<HsgdBaseGroupCustomer> selectListByCustomerId(List<Long> customerIds);
}

package com.zhgd.base.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.zhgd.base.entity.HsgdBaseGroupCustomer;
import com.zhgd.base.mapper.HsgdBaseGroupCustomerMapper;
import com.zhgd.base.service.IHsgdBaseGroupCustomerService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

/**
 * @desc 部门关联用户表 服务实现
 *
 * @author 
 * @version 1.0
 * @date 2021-10-14 16:55:50
 */
@Service
@Slf4j
public class HsgdBaseGroupCustomerServiceImpl extends ServiceImpl<HsgdBaseGroupCustomerMapper, HsgdBaseGroupCustomer> implements IHsgdBaseGroupCustomerService {

    /**
     * 部门关联用户表 批量新增重写
     * @param param model集合
     * @return Boolean
     */
    @Transactional(rollbackFor = Exception.class)
    @Override
    public Boolean saveBatch(List<HsgdBaseGroupCustomer> param) {
        return this.getBaseMapper().insertAll(param);
    }

    @Override
    public long countExistsGroupCustomer(Long customerId, Long groupId) {
        QueryWrapper<HsgdBaseGroupCustomer> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("CUSTOMER_ID",customerId);
        queryWrapper.eq("GROUP_ID",groupId);
        queryWrapper.eq("STATUS",1);
        long count =  this.getBaseMapper().selectCount(queryWrapper);
        return count;
    }

    @Override
    public void insert(HsgdBaseGroupCustomer customer) {
        this.getBaseMapper().insert(customer);
    }

    @Override
    public List<HsgdBaseGroupCustomer> selectListByCustomerId(List<Long> customerIds) {
        QueryWrapper<HsgdBaseGroupCustomer> queryWrapper = new QueryWrapper<>();
        queryWrapper.in("CUSTOMER_ID",customerIds);
        queryWrapper.eq("STATUS",1);
        return  this.getBaseMapper().selectList(queryWrapper);
    }

}

 导入之后

HSGD_BASE_GROUP_CUSTOMER_IMPORT_RECORD

HSGD_BASE_GROUP_CUSTOMER_IMPORT_COMPLETION

 HSGD_BASE_GROUP_CUSTOMER_NOT_IMPORT_RECORD

门主冬七
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
阿里EasyExcel导出案例
01-19
阿里EasyExcel导出案例
easyexcel+validation excel导入导出下载
01-19
使用EasyExcel进行Excel导入导出，主要涉及以下几个步骤： 1. **定义实体类**：首先，我们需要创建一个Java实体类，该类的属性对应Excel文件中的列，通过注解可以设置对应的Excel列名和格式。 2. **编写监听器**：...
EasyExcel导入一级分类二级分类
奈&何.
03-21 344
5，监听器listener。4，service层。
Java读取Excel模板并动态添加数据
丹丹的后花园
08-06 7379
在项目开发中，会经常遇到报表的需求；遇到报表后，不可避免的会与Excel打交道。那么面对复杂的表头或者其他要求要怎么处理？我们可以通过模板文件来进行解决！
excel表格不够怎么添加_Excel表格制作员工名单，遇到员工姓名生僻字不会读怎么办？...
weixin_39929253的博客
11-15 238
还在上学的时候，上课期间，最怕老师点名，起来回答问题，不过又想老师点名，因为有些同学的名字确实很奇葩，名字出现生僻字，而恰好老师又不懂这个字怎么读，所以当老师念名字的时候，我们都期待老师念错，这样大家就会哄堂大笑，这些虽然都已经成为回忆了，现在毕业工作了，我们同样会遇到这样的事情了，领导念同事名字的时候，如果遇到生僻字也容易读错，这会让领导很难堪，作为优秀员工，当然要为领导分忧，如果把员...
使用EasyExcel实现Excel的导入导出
热门推荐
Java学习博客
11-01 1万+
在真实的开发者场景中，经常会使用excel作为数据的载体，进行数据导入和导出的操作，使用excel的导入和导出有很多种解决方案，本篇记录一下EasyExcel的使用。EasyExcel是一个excel导入导出的解决方案，非常好用。
SpringBoot整合EasyExcel+MyBatis-Plus实现Excel批量导入和导出
最新发布
05-03
本文将详细介绍如何使用SpringBoot框架结合EasyExcel和MyBatis-Plus来实现Excel的批量导入和导出，从而提高数据处理效率。 首先，SpringBoot是一个轻量级的Java开发框架，它简化了Spring应用的初始搭建以及开发过程...
EasyExcel导入excel和导出excel的demo
02-07
通过这个"EasyExcel导入导出demo"，开发者可以快速了解如何在SpringBoot项目中实现Excel的导入与导出功能，同时也可以根据实际需求进行扩展，例如添加更复杂的数据验证、支持动态生成Excel模板等。
Easyexcel-批量导入模板-Sheet页内有多个标题行.xlsx
08-08
1.导入多个Sheet页且每个Sheet页有多个标题行; 2.代码详细介绍可参考： <a href="https://blog.csdn.net/CSDN_TANXD/article/details/119517948">https://blog.csdn.net/CSDN_TANXD/article/details/119517948</a>
easyexcel-阿里导入导出工具类
03-12
easyexcel 阿里导入导出工具类
Gbase 8s Group by 功能介绍
因为吃过天津一家超好吃的八珍豆腐从而改名为八珍豆腐的博客
04-21 834
Group by语法的含义是根据（by）一定的规则将一个数据集的数据进行分组（group）。它的作用是通过一定的规则将数据划分成若干的区域，然后针对划分的各个区域进行数据处理。 如下一个表t1及表内数据： fruit place price apple CHA $1.10 apple USA $2.10 ...
EasyExcel导入、导出合并单元格excel文件
搬砖农民工的博客
09-26 1881
原文地址：https://blog.csdn.net/weixin_42195311/article/details/110441885 <!--版本最好大于2.2.6，版本太低会导致没有extra方法--> <dependency> <groupId>com.alibaba</groupId> <artifactId>easyexcel</artifactId> <version>2.2.6<
Java-easy Excel监听器
UID_UUID的博客
12-01 936
返回成功失败条数，原因 @Data public class ImportExcelListener extends AnalysisEventListener<AnnualBudgetExport> { private final Logger log = LoggerFactory.getLogger(AnnualBudgetExport.class); @Autowired BudgetIssuedRepository budgetIssuedRepositor
使用easyexcel导出\入excel
weixin_56320090的博客
07-26 2700
使用easyexcle导出excel
GBase产品学习-hash分布表
lingzi113的博客
04-26 861
hash分布表中的被选为distributed by列字段，不能被update更新，语法会报错。
Hbase RegionServerGroup配置重启后失效问题排查
u013332124的专栏
02-07 2905
文章目录一、问题描述二、问题定位三、解决方案四、网上相关patch 使用Hbase 版本：2.1.1 一、问题描述 RegionServer group是2.x后引入的隔离机制，可以用于业务的隔离。我们通过hbase shell的相关命令配置完group后，group信息如下： 后面滚动重启所有RegionServer，发现原先配置到gid_group_test的两台RS跑到default组了，同时gid_group_test组出现了两台Dead server： 通过hbase shell的list_r
【Java】导出excel表格用EasyExcel，简单方便一步操作！
May女子の博客
03-31 1799
一、需求简介 做各种后台时，总会遇到表格导出为excel的功能，那么对于我这样的Java小白，当然是喜欢操作简单、性能还好的方法啦！ 我们项目使用的是阿里的EasyExcel，下面我就来介绍一下，快速上手使用EasyExcel包~ 二、官方链接 JAVA解析Excel工具EasyExcel： https://github.com/alibaba/easyexcel 三、快速上手使用 （一）引入依赖...
使用easyExcel导出excel数据案例
qq_40974235的博客
10-15 1482
easyExcel简介： Java领域解析、生成Excel比较有名的框架有Apache poi、jxl等。但他们都存在一个严重的问题就是非常的耗内存。如果你的系统并发量不大的话可能还行，但是一旦并发上来后一定会OOM或者JVM频繁的full gc。 easyExcel是阿里巴巴开源的一个excel处理框架，以使用简单、节省内存著称。 easyExcel采用一行一行的解析模式，并将一行的解析结果以观察者的模式通知处理 easyExcel能大大减少占用内存的主要原因是在解析Excel时没有将文件数据一次性全部加
es6和node.js导出导入的区别
qq_46472106的博客
10-18 359
es6导出导入 // 导入 import Login from './view/Login.vue' // 导入vue的组件 import './css/login.css' // 导入普通静态资源文件 // 导出 // *** 注意： export default 只能导出一个对象 *** // （1）vue项目开始，导出一个单文件组件 export default { data(){ 　　 return{ msg: '这是单文件组件的数据
Java EasyExcel：高效Excel导入导出与操作实战
Java开发中，Excel操作是数据处理的重要环节，尤其是对于数据的导入导出以及与后端数据交互。...通过本文提供的详细步骤和实例，Java开发者可以快速掌握如何使用EasyExcel进行Excel的高效导入导出和文件上传下载操作。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

门主冬七

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值