jeecg 导入、导出 excel

最新推荐文章于 2025-10-01 06:05:02 发布

原创

最新推荐文章于 2025-10-01 06:05:02 发布 · 6.2k 阅读

17 ·

CC 4.0 BY-SA版权

文章标签：

#excel #servlet #java

这段代码展示了JeecgBoot项目中QuarantineMemberController、IQuarantineMemberService和QuarantineMemberServiceImpl的实现，用于隔离人员信息的Excel导入和导出。导入功能解析Excel数据并进行业务处理，如身份证转换性别和生日，地址编码转省市区，异常处理等。导出功能根据查询条件生成Excel，包括数据转换和导出配置。

jeecg 导入、导出 excel

1.QuarantineMemberController

    /**
    * 导出excel
    *
    * @param request
    * @param quarantineMember
    */
    //@RequiresPermissions("org.jeecg.modules:quarantine_member:exportXls")
    @RequestMapping(value = "/exportXls")
    public ModelAndView exportXls(HttpServletRequest request, QuarantineMember quarantineMember) {
    
    
//        return super.exportXls(request, quarantineMember, QuarantineMember.class, "quarantine_member");
		return quarantineMemberService.exportingExcel(request, quarantineMember, QuarantineMember.class, "隔离人员");
    }

    /**
      * 通过excel导入数据
    *
    * @param request
    * @param response
    * @return
    */
    //@RequiresPermissions("quarantine_member:importExcel")
    @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
    public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
    
    
        return quarantineMemberService.importExcel(request, response);
    }

2.IQuarantineMemberService

package org.jeecg.modules.quarantine.service;

import org.jeecg.common.api.vo.Result;
import org.jeecg.modules.quarantine.entity.QuarantineMember;
import com.baomidou.mybatisplus.extension.service.IService;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * @Description: quarantine_member
 * @Author: jeecg-boot
 * @Date:   2022-11-03
 * @Version: V1.0
 */
public interface IQuarantineMemberService extends IService<QuarantineMember> {
    
    
  
    Result<?> importExcel(HttpServletRequest request, HttpServletResponse response);

    ModelAndView exportingExcel(HttpServletRequest request, QuarantineMember quarantineMember, Class<QuarantineMember> quarantineMemberClass, String quarantine_member);

}

3.QuarantineMemberServiceImpl

package org.jeecg.modules.quarantine.service.impl;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.apache.shiro.SecurityUtils;
import org.jeecg.common.api.vo.Result;
import org.jeecg.common.system.query.QueryGenerator;
import org.jeecg.common.system.vo.LoginUser;
import org.jeecg.common.util.AreaUtil;
import org.jeecg.common.util.oConvertUtils;
import org.jeecg.modules.quarantine.entity.QuarantineMember;
import org.jeecg.modules.quarantine.mapper.QuarantineMemberMapper;
import org.jeecg.modules.quarantine.service.IQuarantineMemberService;
import org.jeecgframework.poi.excel.ExcelImportUtil;
import org.jeecgframework.poi.excel.def.NormalExcelConstants;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.entity.ImportParams;
import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Service;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.*;

/**
 * @Description: quarantine_member
 * @Author: jeecg-boot
 * @Date:   2022-11-03
 * @Version: V1.0
 */
@Service
@Slf4j
public class QuarantineMemberServiceImpl extends ServiceImpl<QuarantineMemberMapper, QuarantineMember> implements IQuarantineMemberService {
    
    

    @Autowired
    private QuarantineMemberMapper quarantineMemberMapper;

    /**
     * 导入
     * @param request
     * @param response
     * @return
     */
    @Override
    public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
    
    
        MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
        Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
        JSONArray areaData = AreaUtil.getAreaData();
        for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
    
    
            // 获取上传文件对象
            MultipartFile file = entity.getValue();
            if(Objects.requireNonNull(file.getContentType()).indexOf("excel") > 0 || Objects.requireNonNull(file.getContentType()).indexOf("sheet") > 0){
    
    
                ImportParams params = new ImportParams();
                params.setTitleRows(1);
                params.setHeadRows(2);
                params.setNeedSave(true);
                try {
    
    
                    List<QuarantineMember> list = ExcelImportUtil.importExcel(file.getInputStream(), QuarantineMember.class, params);
                    //update-begin-author:taoyan date:20190528 for:批量插入数据
                    long start = System.currentTimeMillis();
                    for (int i = 0; i < list.size(); i++) {
    
    
                        QuarantineMember quarantineMember