ruoyi增加导入导出

1.导入按钮、带导入模板以及存在是否更新

①在合适的位置增加导入按钮

 <el-col :span="1.5">
            <el-button
              type="info"
              plain
              icon="el-icon-upload2"
              size="mini"
              @click="handleImport"
              v-hasPermi="['system:user: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" slot="tip">
          <el-checkbox v-model="upload.updateSupport" />是否更新已经存在的用户数据
          <el-link type="info" style="font-size:12px" @click="importTemplate">下载模板</el-link>
        </div>
        <div class="el-upload__tip" style="color:red" slot="tip">提示：仅允许导入“xls”或“xlsx”格式文件！</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>

③设置upload参数

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

④导入动作设置

    /** 导入按钮操作 */
    handleImport() {
      this.upload.title = "用户导入";
      this.upload.open = true;
    },
    /** 下载模板操作 */
    importTemplate() {
      importTemplate().then(response => {
        this.download(response.msg);
      });
    },
    // 文件上传中处理
    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(response.msg, "导入结果", { dangerouslyUseHTMLString: true });
      this.getList();
    },
    // 提交上传文件
    submitFileForm() {
      this.$refs.upload.submit();
    }

⑤api js中配置importTemplate

// 下载用户导入模板
export function importTemplate() {
  return request({
    url: '/system/user/importTemplate',
    method: 'get'
  })
}

⑥后台代码对应编写

首先bean中需要导入导出的字段需要写@Exce注解

然后对应写导出导入模板以及导入按钮具体逻辑

    @Log(title = "品牌", businessType = BusinessType.IMPORT)
    @PreAuthorize("@ss.hasPermi('system:brand:import')")
    @PostMapping("/importData")
    public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception
    {
        ExcelUtil<BdBrand> util = new ExcelUtil<BdBrand>(BdBrand.class);
        List<BdBrand> brandList = util.importExcel(file.getInputStream());
        String message = bdBrandService.importBrand(brandList, updateSupport);
        return AjaxResult.success(message);
    }

    @GetMapping("/importTemplate")
    public AjaxResult importTemplate()
    {
        ExcelUtil<BdBrand> util = new ExcelUtil<BdBrand>(BdBrand.class);
        return util.importTemplateExcel("品牌数据");
    }

/**
     * 导入excel
     * @param brandList  数据
     * @param isUpdateSupport 重复是否更新标志
     * @return 结果
     */
	@Override
	public String importBrand(List<BdBrand> brandList, Boolean isUpdateSupport) {
		 if (StringUtils.isNull(brandList) || brandList.size() == 0)
	        {
	            throw new CustomException("导入数据不能为空！");
	        }
	        int successNum = 0;
	        int failureNum = 0;
	        StringBuilder successMsg = new StringBuilder();
	        StringBuilder failureMsg = new StringBuilder();
	        for (BdBrand brand : brandList)
	        {
	            try
	            {
	                // 验证是否存在这个品牌
	                int b = bdBrandMapper.checkBrandNameExist(brand.getBrandName());
	                if (b==0)
	                {
	                	brand.setCreateBy(SecurityUtils.getUsername());
	                	brand.setCreateTime(DateUtils.getNowDate());
	                    this.insertBdBrand(brand);
	                    successNum++;
	                    successMsg.append("<br/>" + successNum + "、品牌 " + brand.getBrandName() + " 导入成功");
	                }
	                else if (isUpdateSupport)
	                {
	                	brand.setUpdateBy(SecurityUtils.getUsername());
	                	brand.setUpdateTime(DateUtils.getNowDate());
	                    this.updateBdBrand(brand);
	                    successNum++;
	                    successMsg.append("<br/>" + successNum + "、品牌 " + brand.getBrandName() + " 更新成功");
	                }
	                else
	                {
	                    failureNum++;
	                    failureMsg.append("<br/>" + failureNum + "、品牌  " + brand.getBrandName() + " 已存在");
	                }
	            }
	            catch (Exception e)
	            {
	                failureNum++;
	                String msg = "<br/>" + failureNum + "、品牌 " + brand.getBrandName() + " 导入失败：";
	                failureMsg.append(msg + e.getMessage());
	                log.error(msg, e);
	            }
	        }
	        if (failureNum > 0)
	        {
	            failureMsg.insert(0, "很抱歉，导入失败！共 " + failureNum + " 条数据格式不正确，错误如下：");
	            throw new CustomException(failureMsg.toString());
	        }
	        else
	        {
	            successMsg.insert(0, "恭喜您，数据已全部导入成功！共 " + successNum + " 条，数据如下：");
	        }
	        return successMsg.toString();
	}

2、导出模板

①设置按钮

      <el-col :span="1.5">
        <el-button
          type="warning"
          plain
          icon="el-icon-download"
          size="mini"
		  :loading="exportLoading"
          @click="handleExport"
          v-hasPermi="['system:brand:export']"
        >导出</el-button>
      </el-col>
      

②导出按钮提示等设置

   /** 导出按钮操作 */
    handleExport() {
      const queryParams = this.queryParams;
      this.$confirm('是否确认导出所有品牌数据项?', "警告", {
          confirmButtonText: "确定",
          cancelButtonText: "取消",
          type: "warning"
        }).then(() => {
          this.exportLoading = true;
          return exportBrand(queryParams);
        }).then(response => {
          this.download(response.msg);
          this.exportLoading = false;
        }).catch(() => {});
    }

③api js中配置

// 导出品牌
export function exportBrand(query) {
  return request({
    url: '/system/brand/export',
    method: 'get',
    params: query
  })

④导出后台代码

    /**
     * 导出品牌列表
     */
    @PreAuthorize("@ss.hasPermi('system:brand:export')")
    @Log(title = "品牌", businessType = BusinessType.EXPORT)
    @GetMapping("/export")
    public AjaxResult export(BdBrand bdBrand)
    {
        List<BdBrand> list = bdBrandService.selectBdBrandList(bdBrand);
        ExcelUtil<BdBrand> util = new ExcelUtil<BdBrand>(BdBrand.class);
        return util.exportExcel(list, "品牌数据");
    }

3.导出导入相关包引入

import { listBrand, getBrand, delBrand, addBrand, updateBrand, exportBrand, importTemplate } from "@/api/system/brand";
import { getToken } from "@/utils/auth";

4.sql将两按钮导入导出插入sys_menu表，达到权限管理的效果

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('品牌导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'system:brand:export',       '#', 'admin', sysdate(), '', null, '');