模板工具Jaspersoft Studio创建模板并普通打印、分组打印;Jaspersoft Studio的基本使用方法
整合springboot打印,工程结构:
打印效果图
这里如果要分组打印,选中当前project右键选择Create Group,选择要根据哪个列分组,然后将fields下字段拖动后设置title,通过创建Variables可以自定义展现一些统计数据和页码展示的功能;Basic Elements里面有饼状图,图片等等各种也可以视情况插入到页面中
相关代码:
package com.test.controller; import com.test.entity.User; import net.sf.jasperreports.engine.*; import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource; import org.springframework.core.io.ClassPathResource; import org.springframework.core.io.Resource; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RestController; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.FileInputStream; import java.io.IOException; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; @RestController public class JasperController { //模板工具:Jaspersoft Studio /** * 基于javaBean方式填充数据 * GetMapping注解已经默认封装了@RequestMapping(method = RequestMethod.GET) */ @GetMapping("/testJasper") public void createPdf(HttpServletRequest request, HttpServletResponse response) throws IOException { //1.引入jasper文件 Resource resource = new ClassPathResource("template/testReport.jasper"); FileInputStream fis = new FileInputStream(resource.getFile()); //2.创建JasperPrint,向jasper文件中填充数据 ServletOutputStream os = response.getOutputStream(); try { /** * fis: jasper 文件输入流 * parameters :向模板中输入的参数 * JasperDataSource:数据源(和数据库数据源不同) * 填充模板的数据来源(connection,javaBean,Map) * 填充空数据来源:JREmptyDataSource */ Map parameters = new HashMap<>(); parameters.put("printDate","2010-11-28"); //3.查询具体需要显示的数据集合 List<User> userList = getUserList(); //4.通过数据集合创建javaBean的数据源对象 JRBeanCollectionDataSource ds = new JRBeanCollectionDataSource(userList); //JasperPrint print = JasperFillManager.fillReport(fis, parameters,new JREmptyDataSource()); //有展示的表格数据就将new JREmptyDataSource()参数替换成javaBean的数据源对象 JasperPrint print = JasperFillManager.fillReport(fis, parameters,ds); //5.将JasperPrint以PDF的形式输出 JasperExportManager.exportReportToPdfStream(print,os); } catch (JRException e) { e.printStackTrace(); }finally { os.flush(); } } public List<User> getUserList() { ArrayList<User> users = new ArrayList<>(); for(int i=0;i<3;i++){ User user = new User(i+"","张三"+i,"10010"+i); users.add(user); } return users; } }
springboot启动类
package com.test; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; @SpringBootApplication(scanBasePackages = "com.test") public class JasperApplication { /** * 启动方法 */ public static void main(String[] args) { SpringApplication.run(JasperApplication.class,args); } }
javaBean
package com.test.entity; public class User { private String orderId; private String userName; private String phone; public User(String orderId, String userName, String phone) { this.orderId = orderId; this.userName = userName; this.phone = phone; } public String getOrderId() { return orderId; } public void setOrderId(String orderId) { this.orderId = orderId; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone; } }
springboot配置文件
server: port: 8080 #spring配置 spring: #1.应用配置 application: name: jasper #指定服务名(和项目名称一样) #2.数据库连接池 datasource: driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://localhost:3306/ihrm?useUnicode=true&characterEncoding=utf8 username: root password: root
解决中文乱码相关文件(这里只添加了华文宋体)
jasperreports_extension.properties
net.sf.jasperreports.extension.registry.factory.simple.font.families=net.sf.jasperreports.engine.fonts.SimpleFontExtensionsRegistryFactory
net.sf.jasperreports.extension.simple.font.families.lobstertwo=stsong/fonts.xml
fonts.xml
<?xml version="1.0" encoding="UTF-8"?> <fontFamilies> <!--<fontFamily name="Lobster Two">--> <!--<normal>lobstertwo/LobsterTwo-Regular.otf</normal>--> <!--<bold>lobstertwo/LobsterTwo-Bold.otf</bold>--> <!--<italic>lobstertwo/LobsterTwo-Italic.otf</italic>--> <!--<boldItalic>lobstertwo/LobsterTwo-BoldItalic.otf</boldItalic>--> <!--<pdfEncoding>Identity-H</pdfEncoding>--> <!--<pdfEmbedded>true</pdfEmbedded>--> <!--<!–--> <!--<exportFonts>--> <!--<export key="net.sf.jasperreports.html">'Lobster Two', 'Times New Roman', Times, serif</export>--> <!--</exportFonts>--> <!--–>--> <!--</fontFamily>--> <fontFamily name="华文宋体"> <normal>stsong/stsong.TTF</normal> <bold>stsong/stsong.TTF</bold> <italic>stsong/stsong.TTF</italic> <boldItalic>stsong/stsong.TTF</boldItalic> <pdfEncoding>Identity-H</pdfEncoding> <pdfEmbedded>true</pdfEmbedded> <exportFonts> <export key="net.sf.jasperreports.html">'华文宋体', Arial, Helvetica, sans-serif</export> <export key="net.sf.jasperreports.xhtml">'华文宋体', Arial, Helvetica, sans-serif</export> </exportFonts> <!-- <locales> <locale>en_US</locale> <locale>de_DE</locale> </locales> --> </fontFamily> </fontFamilies>
pom文件
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.*</groupId> <artifactId>jasper</artifactId> <version>1.0-SNAPSHOT</version> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.0.5.RELEASE</version> <relativePath/> </parent> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-thymeleaf</artifactId> </dependency> <dependency> <groupId>net.sf.jasperreports</groupId> <artifactId>jasperreports</artifactId> <version>6.5.0</version> </dependency> <dependency> <groupId>org.olap4j</groupId> <artifactId>olap4j</artifactId> <version>1.2.0</version> </dependency> <dependency> <groupId>com.lowagie</groupId> <artifactId>itext</artifactId> <version>2.1.7</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>4.0.1</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>4.0.1</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml-schemas</artifactId> <version>4.0.1</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> </dependencies> </project>
Jaspersoft Studio的基本使用