Java+Vue从服务器上下载文件

最新推荐文章于 2024-05-06 08:50:16 发布

沐某人

最新推荐文章于 2024-05-06 08:50:16 发布

阅读量304

点赞数

分类专栏： Java Vue 文章标签： java vue.js 服务器

本文链接：https://blog.csdn.net/weixin_44405420/article/details/132498803

版权

Java 同时被 2 个专栏收录

16 篇文章 0 订阅

订阅专栏

Vue

10 篇文章 0 订阅

订阅专栏

 <el-button type="text" size="mini" icon="el-icon-bottom" @click="downloadFile(scope.row.id)">下载</el-button>

    /** 下载 **/
    async downloadFile(id) {
      this.loading = true
      const res = await cfmmcReportApi.downloadFile({
        cfmmcReportId: id
      })
      if (res.code === 200) {
        if (res.data.zbdcExcel !== null) {
          const el = document.createElement('a')
          el.setAttribute('href', 'data:xlsx;base64,' + res.data.zbdcExcel)
          el.setAttribute('download', 'a.xls')
          document.body.append(el)
          el.click()
        }
        if (res.data.zrdsExcel !== null) {
          const el = document.createElement('a')
          el.setAttribute('href', 'data:xlsx;base64,' + res.data.zrdsExcel)
          el.setAttribute('download', 'b.xls')
          document.body.append(el)
          el.click()
        }
        this.$message.success(res.msg)
        this.loading = false
      } else {
        this.$message.error(res.msg)
        this.loading = false
      }
    }

	@PostMapping({"/downloadFile"})
	public AjaxResult<DownloadReportVo> downloadFile(@RequestBody DownloadDto dto){
		Assert.notNull(dto.getCfmmcReportId(),"结算单id不能为空！");
		return trsCfmmcReportService.downloadFile(dto.getCfmmcReportId());
	}

	@Override
	public AjaxResult<DownloadReportVo> downloadFile(Long cfmmcReportId) {
		//查询结算单地址
		LambdaQueryWrapper<CfmmcReportModel> queryWrapper = new LambdaQueryWrapper<>();
		queryWrapper.eq(BaseModel::getId,cfmmcReportId);
		CfmmcReportModel cfmmcReportModel = cfmmcReportMapper.selectOne(queryWrapper);
		
		String base64String = null;
		//在服务器上获取地址
     	Path path = Paths.get(cfmmcReportModel.getReportUrl());
        String absolutePath = path.toAbsolutePath().toString();
        try (FileInputStream fileInputStream = new FileInputStream(absolutePath);
             Workbook workbook = new HSSFWorkbook(fileInputStream);
             ByteArrayOutputStream outputStream = new ByteArrayOutputStream()) {
             workbook.write(outputStream);
            byte[] excelBytes = outputStream.toByteArray();
            // 将 Excel 字节流转换为 Base64 字符串
            base64String = Base64.getEncoder().encodeToString(excelBytes);
            return AjaxResult.success("Excel下载完成", base64String);
        } catch (IOException e) {
            e.printStackTrace();
            return AjaxResult.error("Excel下载失败", null);
        }
	
		DownloadReportVo vo = new DownloadReportVo();
		if ("a".equals(cfmmcReportModel.getReportType())) {
			vo.setZbdcExcel(base64String);
		}else if ("b".equals(cfmmcReportModel.getReportType())) {
			vo.setZrdsExcel(base64String);
		}
		return AjaxResult.success("下载成功！",vo);
	}