若依系统的数据导入功能设置

一、后端

@Autowired
    private TokenService tokenService;
    
      @PostMapping("/importData")
    public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception
    {
        ExcelUtil<Questions> util = new ExcelUtil<Questions>(Questions.class);
        List<Questions> questionsList = util.importExcel(file.getInputStream());
        String operName = getUsername();
        String message = questionsService.importQuestions(questionsList, updateSupport, operName);
        return AjaxResult.success(message);
    }

    @PostMapping("/importTemplate")
    public void importTemplate(HttpServletResponse response) {
        ExcelUtil<Questions> util = new ExcelUtil<Questions>(Questions.class);
        util.importTemplateExcel(response, "题库数据");
    }

实现类中的

import com.ruoyi.common.exception.ServiceException;
 /**
     * 导入公交站牌信息
     * @param busStopList
     * @param isUpdateSupport
     * @param operName
     * @return
     */
    @Override
    public String importUser(List<BusStop> busStopList, boolean isUpdateSupport, String operName) {
        if (StringUtils.isNull(busStopList) || busStopList.size() == 0)
        {
            throw new ServiceException("导入公交站牌数据不能为空！");
        }
        int successNum = 0;
        int failureNum = 0;
        StringBuilder successMsg = new StringBuilder();
        StringBuilder failureMsg = new StringBuilder();

        for (BusStop busStop : busStopList)
        {
            try
            {
                // 验证是否存在这个公交站牌
                SysUser u = busStopMapper.selectBusStopByWfcId(busStop.getWfcId());
                if (StringUtils.isNull(u))
                {
                    busStop.setCreateBy(operName);
                    this.insertBusStop(busStop);
                    successNum++;
                    successMsg.append("<br/>" + successNum + "、站牌 " + busStop.getWfcId() + " 导入成功");
                }
                else if (isUpdateSupport)
                {
                    busStop.setUpdateBy(operName);
                    this.updateBusStop(busStop);
                    successNum++;
                    successMsg.append("<br/>" + successNum + "、站牌 " + busStop.getWfcId() + " 更新成功");
                }
                else
                {
                    failureNum++;
                    failureMsg.append("<br/>" + failureNum + "、站牌 " + busStop.getWfcId() + " 已存在");
                }
            }
            catch (Exception e)
            {
                failureNum++;
                String msg = "<br/>" + failureNum + "、站牌 " + busStop.getWfcId() + " 导入失败：";
                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();
    }

二、前端
data return中

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

methods中放置

/** 导入按钮操作 */
    handleImport() {
      this.upload.title = "题库导入";
      this.upload.open = true;
    },
    /** 下载模板操作 */
    importTemplate() {
      this.download('/questions/questions/importTemplate', {
      }, `question_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();
    },

temple中放置

     <!-- 用户导入对话框 -->
    <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>

el-row中放置

  <el-col :span="1.5">
        <el-button
          type="info"
          icon="el-icon-upload2"
          size="mini"
          @click="handleImport"
          v-hasPermi="['busStop:busStop:import']"
        >导入</el-button>
      </el-col>