栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

vue+java 导入excel(多条数据合并和导入主子表)

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

vue+java 导入excel(多条数据合并和导入主子表)

Vue相关:
1,



  
    
    
      将文件拖到此处,或
      点击上传
    
    
      
      是否更新已经存在的用户数据
      下载模板
    
    提示:仅允许导入“xls”或“xlsx”格式文件!
  
  
    
      
    
  


  
    确 定
    取 消
  

2,

return {
//导入相关的值–start
// upload_ownerId: null,
upload_url: null,
upload: {
orderType: null,
// 是否显示弹出层(用户导入)
open: false,
// 弹出层标题(用户导入)
title: ‘’,
// 是否禁用上传
isUploading: false,
// 是否更新已经存在的用户数据
updateSupport: 0,
// 设置上传的请求头部
headers: {
Authorization: 'Bearer ’ + getToken()
},
// 上传的地址
url: process.env.VUE_APP_BASE_API + ‘/aaa/bbb/ccc/’
},
//—end

3,

// 导入操作
handleImport() {
this.upload.title = this.td(‘订单导入’)
this.upload.open = true
},
// 下载模板操作
importTemplate() {
window.open(‘/excel_model/xxx导入模板.xlsx’, ‘_blank’)

},
// 文件上传中处理
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, this.td('导入结果'), {
    dangerouslyUseHTMLString: true
  })
  this.getList()
},
// 提交上传文件
submitFileForm() {
  this.$refs.upload.submit()
}

重点在后端:

1,这一步主要是把excel内容转化成java实体类对应的内容,关键在OrderImport
@PostMapping(“/xxx/{orderType}”) public AjaxResult
importTmsOrder(MultipartFile file,@PathVariable String orderType,
boolean updateSupport) throws Exception {

System.err.println(orderType);
ExcelUtil util = new ExcelUtil(OrderImport.class);
List orderImportList = util.importExcel(file.getInputStream());

2,实体类样式

@Data public class OrderImport implements Serializable {
private static final long serialVersionUID = 1L;

@Excel(name = "名字")//这个name值和excel导入的字段名要一致
private String xxxx;

3,

@Transactional
@Override
public String importTmsOrder(List orderImportList, String orderType, boolean updateSupport) {
    if (StringUtils.isNull(orderImportList) || orderImportList.size() == 0) {
        throw new ServiceException("导入数据不能为空!");
    }
    int successNum = 0;
    int failureNum = 0;
    int failureSameNum = 0;
    StringBuilder successMsg = new StringBuilder();
    StringBuilder failureMsg = new StringBuilder();
    StringBuilder failureSameMsg = new StringBuilder();

    //先分类--1
    Set setList = new HashSet<>();
    for (OrderImport orderImport : orderImportList) {
        String expressNumber = orderImport.getExpressNumber();
        if (expressNumber != null && !"".equals(expressNumber)) {
            setList.add(expressNumber);
        }
    }
    //归类--2
    Map> map = new HashMap<>();
    for (String expressNumberSet : setList) {
        List orderImports = new ArrayList();
        for (OrderImport orderImport : orderImportList) {
            String expressNumber = orderImport.getExpressNumber();
            if (expressNumber != null && !"".equals(expressNumber) && expressNumberSet.equals(expressNumber)) {
                orderImports.add(orderImport);
            }
        }
        map.put(expressNumberSet, orderImports);
    }
    //可以进行分类处理了--3
    for (Map.Entry> entry : map.entrySet()) {
        String expressNumber = entry.getKey();
        List value = entry.getValue();
        TmsOrder tmsOrder = new TmsOrder();//抽取第一条作为主表数据
        tmsOrder.setAddressee(value.get(0).getContactMsg());//收件人
        tmsOrder.setAreaId(value.get(0).getDistrict());//街道/分区/小区
        tmsOrder.setOrderType(orderType);//可以动态填写
        tmsOrder.setDataSource(1l);
        TmsOrder countExpressIdm = tmsOrderMapper.getCountExpressIdm(expressNumber);
        int i=0;
        if (countExpressIdm!=null){
            tmsOrder.setOrderId(countExpressIdm.getOrderId());
            i=tmsOrderMapper.updateTmsOrder(tmsOrder);
            tmsOrderMapper.deleteTmsOrderPackByOrderId(countExpressIdm.getOrderId());
        }else {
            i=tmsOrderMapper.insertTmsOrder(tmsOrder);
        }
        if (i>0){
            for (int j=0;j" + successNum + "、Express_number: " + value.get(j).getExpressNumber() + " 导入成功");
                }catch (Exception e) {
                    failureNum++;
                    String msg = "
" + failureNum + "、Express_number: " + value.get(j).getExpressNumber() + " 导入失败:"; failureMsg.append(msg + e.getMessage()); log.error(msg, e); } } } } if (failureNum > 0) { failureMsg.insert(0, "很抱歉,导入失败!共 " + failureNum + " 条数据不正确,错误如下:"); throw new ServiceException(failureMsg.toString()); } else if (failureSameNum > 0) { failureSameMsg.insert(0, "恭喜您,数据导入成功,共" + successNum + " 条"); return failureSameMsg.toString(); } else { successMsg.insert(0, "恭喜您,数据已全部导入成功!共 " + successNum + " 条"); return successMsg.toString(); } }

`

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/946944.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号