SpringBoot+layui项目整合JasperReport报表生成PDF并下载
一、JasperReport是什么?
JasperReport是一个强大、灵活的报表生成工具,能够展示丰富的页面内容,并将之转换成PDF,HTML,或者XML格式。该库完全由Java写成,可以用于在各种Java应用程序,包括J2EE,Web应用程序中生成动态内容。
二、生成步骤
1.前端部分
var confirmPay = function (obj) {
var link = document.createElement('a');
link.href = 'sincardtempfee/query/export?prtseq='+obj.prtseq+'&agentcode='+obj.agentcode+';
link.click();
};
2.后端部分
2.1引入依赖
代码如下:
<!-- jasperreports begin -->
<dependency>
<groupId>net.sf.jasperreports</groupId>
<artifactId>jasperreports</artifactId>
<version>6.12.2</version>
<exclusions>
<exclusion>
<groupId>com.lowagie</groupId>
<artifactId>itext</artifactId>
</exclusion>
<exclusion>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
</exclusion>
<exclusion>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
</exclusion>
<exclusion>
<artifactId>commons-beanutils</artifactId>
<groupId>commons-beanutils</groupId>
</exclusion>
<exclusion>
<artifactId>commons-collections</artifactId>
<groupId>commons-collections</groupId>
</exclusion>
<exclusion>
<artifactId>commons-logging</artifactId>
<groupId>commons-logging</groupId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>com.lowagie</groupId>
<artifactId>itext</artifactId>
<version>2.1.7</version>
</dependency>
<dependency>
<groupId>org.codehaus.groovy</groupId>
<artifactId>groovy-all</artifactId>
<version>2.4.11</version>
</dependency>
<dependency>
<groupId>net.sf.jasperreports</groupId>
<artifactId>fonts</artifactId>
<version>1</version>
<scope>system</scope>
<systemPath>${project.basedir}/src/main/resources/fonts.jar</systemPath>
</dependency>
<dependency>
<groupId>net.sf.jasperreports</groupId>
<artifactId>wmsyou</artifactId>
<version>1</version>
<scope>system</scope>
<systemPath>${project.basedir}/src/main/resources/wmsyou.jar</systemPath>
</dependency>
<dependency>
<groupId>org.springblade.wms</groupId>
<artifactId>taobao-sdk-java-auto</artifactId>
<version>1</version>
<scope>system</scope>
<systemPath>${project.basedir}/src/main/resources/taobao-sdk-java-auto_1608103519290-20211110.jar</systemPath>
</dependency>
<dependency>
<groupId>com.itextpdf</groupId>
<artifactId>itext-pdfa</artifactId>
<version>5.5.0</version>
</dependency>
<!-- jasperreports end -->
2.2Controller层
@GetMapping(value = "/export", produces = "application/json")
@ResponseBody
public void export(HttpServletResponse response, SinCardTempFeeQueryVO sinCardTempFeeQueryVO) {
log.info("收据打印开始startPrint()");
response.setHeader("content-disposition","attachment;fileName="+"ReceiptPrinter.pdf");
sinCardTempFee.receiptPrinter(response,sinCardTempFeeQueryVO);
}
2.3Service层
package com.lotso.web.module.KDFinfeeSure.service.impl;
import com.lotso.web.module.KDFinfeeSure.service.SinCardTempFeeService;
import com.lotso.web.module.KDFinfeeSure.vo.SinCardTempFeeQueryVO;
import lombok.SneakyThrows;
import lombok.extern.slf4j.Slf4j;
import net.sf.jasperreports.engine.JREmptyDataSource;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.export.JRPdfExporter;
import net.sf.jasperreports.export.SimpleExporterInput;
import net.sf.jasperreports.export.SimpleOutputStreamExporterOutput;
import org.apache.commons.collections.CollectionUtils;
import org.springframework.stereotype.Service;
import javax.servlet.http.HttpServletResponse;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@Service
@Slf4j
public class SinCardTempFeeImpl implements SinCardTempFeeService {
@SneakyThrows
public void receiptPrinter(HttpServletResponse response,SinCardTempFeeQueryVO asinCardTempFeeQueryVO) {
log.info("start print!");
String jrxmlPath = Thread.currentThread().getContextClassLoader().getResource("templates/pdf/KDDLR_Receipt_Printer.jrxml").getPath();
log.info("收据打印模板路径jrxmlPath:"+jrxmlPath);
String jasperPath = Thread.currentThread().getContextClassLoader().getResource("templates/pdf/KDDLR_Receipt_Printer.jasper").getPath();
log.info("收据打印模板路径jasperPath:"+jasperPath);
JasperCompileManager.compileReportToFile(jrxmlPath);
// 构造数据
Map paramters = new HashMap();
paramters.put("prtseq",asinCardTempFeeQueryVO.getPrtseq());
paramters.put("agentcode",asinCardTempFeeQueryVO.getAgentcode());
paramters.put("agentname",asinCardTempFeeQueryVO.getAgentname());
paramters.put("kdstartno",asinCardTempFeeQueryVO.getKdstartno());
paramters.put("kdendno",asinCardTempFeeQueryVO.getKdendno());
paramters.put("oldprtseq",asinCardTempFeeQueryVO.getOldprtseq());
paramters.put("reqcom",asinCardTempFeeQueryVO.getReqcom());
String logoPath = Thread.currentThread().getContextClassLoader().getResource("static/global/img/DWRSLOG.png").getPath();
log.info("模板log路径"+logoPath);
paramters.put("logo",logoPath);
//打印列表
List<JasperPrint> reportlist = new ArrayList();
//填充数据---使用JavaBean数据源方式填充
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperPath,paramters,new JREmptyDataSource());
reportlist.add(jasperPrint);
//打印
export(response, reportlist);
}
//打印
public void export (HttpServletResponse response, List<JasperPrint> reportlist){
log.info("准备输出pdf流,数量:{}", reportlist == null ? 0 : reportlist.size());
//输出pdf文件
response.setContentType("application/pdf");
JRPdfExporter exporter = new JRPdfExporter();
if (CollectionUtils.isEmpty(reportlist)) {
return;
}
try {
exporter.setExporterInput(SimpleExporterInput.getInstance(reportlist));
exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(response.getOutputStream()));
exporter.exportReport();
} catch (Exception e) {
log.error("异常:{",e.getMessage()+e.getCause()+"}");
log.info("打印输出流失败");
}
}
}
3.模板部分
采用TIBCO Jasperreport Studio绘制模板
开始绘制模板
将绘制好的模板引入至项目中,放在项目resources下