基于若依系统的导入功能

前端：
<template>
//按钮
     <el-col :span="1.5">
        <el-button type="info" plain icon="el-icon-upload2" size="mini" @click="handleImport"
          v-hasPermi="['shopLicense:shopLicense:import']">导入</el-button>
      </el-col>


    <!-- 商店导入对话框 -->
    <el-dialog :title="upload.title" :visible.sync="upload.open" width="400px" append-to-body>
      <el-upload ref="upload" :limit="1" accept=".xlsx, .xls" :headers="upload.headers"
        :action="upload.url + '?updateSupport=' + upload.updateSupport" :disabled="upload.isUploading"
        :on-progress="handleFileUploadProgress" :on-success="handleFileSuccess" :auto-upload="false" drag>
        <i class="el-icon-upload"></i>
        <div class="el-upload__text">将文件拖到此处，或<em>点击上传</em></div>
        <div class="el-upload__tip text-center" slot="tip">
          <div class="el-upload__tip" slot="tip">
            <el-checkbox v-model="upload.updateSupport" /> 是否更新已经存在的商店数据
          </div>
          <span>仅允许导入xls、xlsx格式文件。</span>
          <el-link type="primary" :underline="false" style="font-size:12px;vertical-align: baseline;"
            @click="importTemplate">下载模板</el-link>
        </div>
      </el-upload>
      <div slot="footer" class="dialog-footer">
        <el-button type="primary" @click="submitFileForm">确 定</el-button>
        <el-button @click="upload.open = false">取 消</el-button>
      </div>
    </el-dialog>

</template>

<script>
import { getToken } from "@/utils/auth";
export default {
  data() {
    return {
      // 商店导入参数
      upload: {
        // 是否显示弹出层（商店导入）
        open: false,
        // 弹出层标题（商店导入）
        title: "",
        // 是否禁用上传
        isUploading: false,
        // 是否更新已经存在的商店数据
        updateSupport: 0,
        // 设置上传的请求头部
        headers: { Authorization: "Bearer " + getToken() },
        // 上传的地址
        url: process.env.VUE_APP_BASE_API + "/shopLicense/importData"
      },
    };
  },
  created() {

  },
  methods: {
    /** 导入按钮操作 */
    handleImport() {
      this.upload.title = "商店导入";
      this.upload.open = true;
    },
    /** 下载模板操作 */
    importTemplate() {
      this.download('shopLicense/importTemplate', {
      }, `shopLicense_template_${new Date().getTime()}.xlsx`)
    },

  // 文件上传中处理
  handleFileUploadProgress(event, file, fileList) {
    this.upload.isUploading = true;
  },
  // 文件上传成功处理
  handleFileSuccess(response, file, fileList) {
    this.upload.open = false;
    this.upload.isUploading = false;
    this.$refs.upload.clearFiles();
    this.$alert("<div style='overflow: auto;overflow-x: hidden;max-height: 70vh;padding: 10px 20px 0;'>" + response.msg + "</div>", "导入结果", { dangerouslyUseHTMLString: true });
    this.getList();
  },
  // 提交上传文件
  submitFileForm() {
    this.$refs.upload.submit();
  }
},
};

</script>

后端：
domain:
需加注释，例@Excel(name = "审核状态",readConverterExp = "0=待审核,1=审核通过,2=审核不通过")
service:
public String importShop(List<EcommerceShops> shopList, Boolean isUpdateSupport, String operName);
impl:
@Override
public String importShop(List<EcommerceShops> shopList, Boolean isUpdateSupport, String operName)
{
    if (StringUtils.isNull(shopList) || shopList.size() == 0)
    {
        throw new ServiceException("导入商店数据不能为空！");
    }
    int successNum = 0;
    int failureNum = 0;
    StringBuilder successMsg = new StringBuilder();
    StringBuilder failureMsg = new StringBuilder();
    for (EcommerceShops ecommerceShops : shopList)
    {
        try
        {
            // 验证是否存在这个用户,若无selectEcommerceShopsByShopName方法，需自己写。
            EcommerceShops u = ecommerceShopsMapper.selectEcommerceShopsByShopName(ecommerceShops.getShopName());
            if (StringUtils.isNull(u))
            {
                BeanValidators.validateWithException(validator, ecommerceShops);
                ecommerceShops.setCreateBy(operName);
                this.insertEcommerceShops(ecommerceShops);
                successNum++;
                successMsg.append("<br/>" + successNum + "、账号 " + ecommerceShops.getShopName() + " 导入成功");
            }
            else if (isUpdateSupport)
            {
                BeanValidators.validateWithException(validator, ecommerceShops);
                ecommerceShops.setUpdateBy(operName);
                ecommerceShopsMapper.updateEcommerceShops(ecommerceShops);
                successNum++;
                successMsg.append("<br/>" + successNum + "、账号 " + ecommerceShops.getShopName() + " 更新成功");
            }
            else
            {
                failureNum++;
                failureMsg.append("<br/>" + failureNum + "、账号 " + ecommerceShops.getShopName() + " 已存在");
            }
        }
        catch (Exception e)
        {
            failureNum++;
            String msg = "<br/>" + failureNum + "、账号 " + ecommerceShops.getShopName() + " 导入失败：";
            failureMsg.append(msg + e.getMessage());
            log.error(msg, e);
        }
    }
    if (failureNum > 0)
    {
        failureMsg.insert(0, "很抱歉，导入失败！共 " + failureNum + " 条数据格式不正确，错误如下：");
        throw new ServiceException(failureMsg.toString());
    }
    else
    {
        successMsg.insert(0, "恭喜您，数据已全部导入成功！共 " + successNum + " 条，数据如下：");
    }
    return successMsg.toString();
}

controller:
@Log(title = "商店导入", businessType = BusinessType.IMPORT) // todo
@PostMapping("/importData")
public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception
{
    ExcelUtil<EcommerceShops> util = new ExcelUtil<>(EcommerceShops.class); // todo
    List<EcommerceShops> shopsList = util.importExcel(file.getInputStream()); // todo
    String operName = getUsername();
    String message = ecommerceShopsService.importShop(shopsList, updateSupport, operName); // todo
    return AjaxResult.success(message);
}

@PostMapping("/importTemplate")
public void importTemplate(HttpServletResponse response)
{
    ExcelUtil<EcommerceShops> util = new ExcelUtil<>(EcommerceShops.class); // todo
    util.importTemplateExcel(response, "商店导入");
}

参考文章:若依导入功能，导入数据详细教程（保姆级教程）-CSDN博客

若依代码生成自带导入功能_若依代码生成导入功能-CSDN博客