项目数据导出成PDF文件

项目数据导出成PDF文件

模板准备:

数据格式模板如:abc.xlsx

页面处理:

绑定事件:

<el-button @click="exportPDF">导出Excel</el-button>运营数据统计

发送请求：

不能用ajax,因为接受的是文件输出流,ajax接受的是json

methods:{exportPDF(){        
window.location.href = '/report/exportBusinessReport4PDF.do';
}}

后端代码实现:

1.查询出数据

2.获取并编译模板

3.填充数据

4.使用输出流进行表格下载

    @RequestMapping("/exportBusinessReport4PDF")
    public void exportBusinessReport4PDF(HttpServletRequest request,HttpServletResponse response) throws Exception {
        //1.获取数据
        Map<String, Object> result = reportService.getBusinessReportData();
        List<Map> hotSetmeal = (List<Map>)result.get("hotSetmeal");
        //2.获取模板文件路径
        String jrmxlPath=request.getSession().getServletContext().getRealPath("/template")+File.separator
                + "health_business3.jrxml";
        String jasperPath=request.getSession().getServletContext().getRealPath("/template")+File.separator
                + "health_business3.jasper";
        // 编译模板
        JasperCompileManager.compileReportToFile(jrmxlPath,jasperPath);
        // 3.填充数据
        JasperPrint jasperPrint = JasperFillManager.fillReport(jasperPath, result, new JRBeanCollectionDataSource(hotSetmeal));
        //4.设置响应信息
        ServletOutputStream out = response.getOutputStream();
        response.setContentType("application/pdf");
        response.setHeader("content-disposition","attachment;filename=report.pdf");
        // 输出文件
        JasperExportManager.exportReportToPdfStream(jasperPrint,out);
    }

业务层,持久层查询语句:

略…