【SpringBoot】+【Vue】 数据的批量导入和导出

导出

 总结了三种导出数据为表格的情况，直接上代码！！ 

整体导出

 后端接口： 

//    批量导出数据
    @GetMapping("/export")
    public void exportDate(HttpServletResponse response) throws IOException {
        ExcelWriter writer= ExcelUtil.getWriter(true);
//        全部导出
        Iterable<Hero> list=heroService.list();

        writer.write(list,true);

//        设置响应格式
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");
        String filename= URLEncoder.encode("信息表","UTF-8");
        response.setHeader("Content-Disposition","attachment;filename="+filename+".xlsx");
        
        ServletOutputStream outputStream= response.getOutputStream();
        writer.flush(outputStream,true);
        outputStream.flush();
        outputStream.close();
    }

前端使用：

 //批量导出
    expertDate () {
        window.open('http://localhost:8080/hero/export?token=' + this.user.token)
    }

按查询结果导出 

后端：

 @GetMapping("/export")
    public void exportDate(@RequestParam(required = false) String heroname,