PDF帐票工具：JasperReports+iReport

PDF帐票工具：JasperReports+iReport

分类： JAVA POI/JXL/PDF 2011-11-29 16:27 435人阅读 评论(0) 收藏 举报

在做PDF帐票的时候，我们用的最多的open source工具应该就是JasperReports+iReport了。

iReport is the free, open source report designer for JasperReports. Create very sophisticated layouts containing charts, images, subreports, crosstabs and much more. Access your data through JDBC, TableModels, JavaBeans, XML, Hibernate, CSV, and custom sources. Then publish your reports as PDF, RTF, XML, XLS, CSV, HTML, XHTML, text, DOCX, or OpenOffice.

JasperReports is the world's most popular open source reporting engine. It is entirely written in Java and it is able to use data coming from any kind of data source and produce pixel-perfect documents that can be viewed, printed or exported in a variety of document formats including HTML, PDF, Excel, OpenOffice and Word.

功能可以说是非常强大。

iReport 用来设计PDF模板，在java中通JasperReports来从DB取得数据并输出PDF帐票。

执行环境根据需要如下配置：

	JasperReports Requirements
	This table contains all the libraries that JasperReports may require, depending on the functionality required by JasperReports's parent application. JRE Java Runtime Environment 5.0 or higher Commons Jakarta Commons BeanUtils Component (version 1.8.0 or later) http://jakarta.apache.org/commons/beanutils/ Jakarta Commons Collections Component (version 2.1.1 or later) http://jakarta.apache.org/commons/collections/ Jakarta Commons Javaflow (Sandbox version) http://jakarta.apache.org/commons/sandbox/javaflow/ Jakarta Commons Logging Component (version 1.0.4 or later) http://jakarta.apache.org/commons/logging/ JRXML JAXP 1.1 XML Parser Jakarta Commons Digester Component (version 1.7 or later) http://jakarta.apache.org/commons/digester/ One of the following for report compilation, depending on the report compiler used: Eclipse JDT Java Compiler (recommended) http://www.eclipse.org/jdt/ JDK 5.0 or higher Jikes Compiler http://jikes.sourceforge.net Groovy (version 1.5.5 or later) http://groovy.codehaus.org BeanShell (version 2.0 beta 4 or later) http://www.beanshell.org JDBC JDBC 2.0 Driver PDF iText - Free Java-PDF library by Bruno Lowagie and Paulo Soares (version 2.1.7 or later)http://www.lowagie.com/iText/ XLS Jakarta POI (version 3.6 or later) http://jakarta.apache.org/poi/ JExcelApi (version 2.6.10 or later) http://jexcelapi.sourceforge.net/ Charts JFreeChart (1.0.12 or later) http://www.jfree.org/jfreechart/ JCommon (1.0.15 or later) - required by JFreeChart http://www.jfree.org/jcommon/ Batik SVG Toolkit (1.7 or later) - required when rendering charts as SVG http://xmlgraphics.apache.org/batik/

java取数据并输出PDF和Excel的代码片段：

[java] view plain copy

1. Connection con = null;  
2.        try    {  
3.            // jrxml path  
4.            File jrxmlFile = new File("C:/reporttest/report.jrxml");  
5.            if(jrxmlFile.exists()){  
6.                // Compile jrxml   
7.                JasperReport jasperReport = JasperCompileManager.compileReport(jrxmlFile.getAbsolutePath());  
8.                // Set parameter  
9.                HashMap<String, Object> params = new HashMap<String, Object>();  
10.                params.put("KEY_ID", 10);  
11.                ....  
12.                // Access DB   
13.                Class.forName("org.postgresql.Driver");  
14.                con = DriverManager.getConnection("jdbc:postgresql://localhost:5432/PDFTestDD", "postgres","postgres");  
15.                // Write DB  
16.                JasperPrint print = JasperFillManager.fillReport(jasperReport, params, con);  
17.                // Set file name  
18.                File pdf = new File("c:/report.pdf");  
19.                // Output pdf  
20.                JasperExportManager.exportReportToPdfFile(print, pdf.getAbsolutePath());  
21.   
22.                // Output XLS  
23.                File xls = new File("c:/reportXls.xls");  
24.                OutputStream output = new FileOutputStream(xls);  
25.                JRXlsExporter exporterXLS = new JRXlsExporter();  
26.                exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, print);  
27.                exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, output);  
28.                exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);  
29.                exporterXLS.exportReport();  
30.            }else{  
31.                System.out.println("jrxml is not exsit");  
32.            }  
33.        } catch (Exception e) {  
34.            e.printStackTrace();  
35.        } finally {  
36.            if(con != null){  
37.                try {  
38.                    con.close();  
39.                } catch (SQLException e) {  
40.                    e.printStackTrace();  
41.                }  
42.            }  
43.        }