项目数据导出成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);
}
业务层,持久层查询语句:
略…