Java VUE 使用文件流实现下载功能

喜欢ヅ旅行 2021-09-30 04:50 487阅读 0赞

## 1、后端：controller控制器 ##

/**
         * 导出 --->资产信息
         * @return
         * @throws IOException
         * @throws DbException
         */
        @RequestMapping(value = "/getExcel2",method = RequestMethod.GET)
        @ResponseBody
        public byte[] aa(HttpServletResponse response){
            byte[] bytes = null;
            try {
                String bmid = "0000000091";
                String bmmc = "服务部";
                List<String> addStatisticalTypeList = new ArrayList<>();
                List<String> reduceStatisticalTypeList = new ArrayList<>();
                List<String> standardList = new ArrayList<>();
               
                response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
                String fileName = URLEncoder.encode("fss.xlsx","utf-8");
                response.setHeader("Content-Disposition","attachment; fileName=\""+fileName+"\"");
                bytes = dcbService.getExcel(bmid,bmmc,standardList,addStatisticalTypeList,reduceStatisticalTypeList);
    
            } catch (IOException e) {
                e.printStackTrace();
            } catch (DbException e) {
                e.printStackTrace();
            }finally {
                return bytes;
            }
        }

## 2、前端： ##

## 3、浏览器访问： [http://localhost:8001/][http_localhost_8001] ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzE1NDk0_size_16_color_FFFFFF_t_70][]

[http_localhost_8001]: http://localhost:8001/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzE1NDk0_size_16_color_FFFFFF_t_70]: /images/20210725/3914a54a1f734bfb818c785998652d3f.png