JasperReport導出報表

我們已經看到在前面的章節中,如何打印和查看的JasperReport生成的文檔。在這裏,我們將看到如何在其他格式,如PDF,HTML和XLS轉換或導出這些報告。 Facade類net.sf.jasperreports.engine.JasperExportManager提供實現這一功能。導出方式轉變JasperPrint對象(.jrprint文件)導入到不同的格式。

下面的代碼(JasperReportExport.java)演示了JasperReport文檔的導出過程。該JasperExportManager提供的方法將報表導出成PDF,HTML和XML。導出到使用的類net.sf.jasperreports.engine.export.JRXlsExporter的XLS格式。此代碼生成以下三個文件:

  • sample_report.pdf

  • sample_report.htmll

  • sample_report.xls

導出爲其他格式

讓我們來寫一個報表模板。在JRXML文件的內容 (C: oolsjasperreports-5.0.1 estjasper_report_template.jrxml) 如下:

<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports
http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="jasper_report_template" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <![CDATA[]]> <field name="country" class="java.lang.String"> <![CDATA[country]]> <field name="name" class="java.lang.String"> <![CDATA[name]]> <band height="23"> <reportElement mode="Opaque" x="0" y="3" width="535" height="15" backcolor="#70A9A9" /> <bottomPen lineWidth="1.0" lineColor="#CCCCCC" /> <![CDATA[]]> <reportElement x="414" y="3" width="121" height="15" /> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true" /> <![CDATA[Country]]> <reportElement x="0" y="3" width="136" height="15" /> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true" /> <![CDATA[Name]]> <band height="16"> <reportElement mode="Opaque" x="0" y="0" width="535" height="14" backcolor="#E5ECF9" /> <bottomPen lineWidth="0.25" lineColor="#CCCCCC" /> <![CDATA[]]> <reportElement x="414" y="0" width="121" height="15" /> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="9" /> <textFieldExpression class="java.lang.String"> <![CDATA[$F{country}]]> <reportElement x="0" y="0" width="136" height="15" /> <textElement textAlignment="Center" verticalAlignment="Middle" /> <textFieldExpression class="java.lang.String"> <![CDATA[$F{name}]]>

接着,POJO文件 C: oolsjasperreports-5.0.1 estsrccomyiibaiDataBean.java 的內容如下:

package com.yiibai; public class DataBean { private String name; private String country; public String getName() { return name; } public void setName(String name) { this.name = name; } public String getCountry() { return country; } public void setCountry(String country) { this.country = country; } }

文件 C: oolsjasperreports-5.0.1 estsrccomyiibaiDataBeanList.java 的內容如下:

package com.yiibai; import java.util.ArrayList; public class DataBeanList { public ArrayList<DataBean> getDataBeanList() { ArrayList<DataBean> dataBeanList = new ArrayList<DataBean>(); dataBeanList.add(produce("Manisha", "India")); dataBeanList.add(produce("Dennis Ritchie", "USA")); dataBeanList.add(produce("V.Anand", "India")); dataBeanList.add(produce("Shrinath", "California")); return dataBeanList; } /**
* This method returns a DataBean object,
* with name and country set in it.
*/ private DataBean produce(String name, String country) { DataBean dataBean = new DataBean(); dataBean.setName(name); dataBean.setCountry(country); return dataBean; } }

寫一個主類文件JasperReportFill.java,它從類(DataBeanList)獲取java bean集合,並將其傳遞到Jasper 報表引擎,填補了報表模板。把它保存到目錄 C: oolsjasperreports-5.0.1 estsrccomyiibai.

package com.yiibai; import java.util.ArrayList; import java.util.HashMap; import java.util.Map; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JRExporterParameter; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource; import net.sf.jasperreports.engine.export.JRXlsExporter; public class JasperReportFill { @SuppressWarnings("unchecked") public static void main(String[] args) { String sourceFileName = "c://tools/jasperreports-5.0.1/" + "test/jasper_report_template.jasper"; String printFileName = null; DataBeanList DataBeanList = new DataBeanList(); ArrayList

dataList
=

DataBeanList
.
getDataBeanList
();

JRBeanCollectionDataSource
beanColDataSource
=

new

JRBeanCollectionDataSource
(
dataList
);

Map
parameters
=

new

HashMap
();

try

{
printFileName
=

JasperFillManager
.
fillReportToFile
(
sourceFileName
,
parameters
,
beanColDataSource
);

if

(
printFileName
!=

null
)

{

/** * 1- export to PDF */

JasperExportManager
.
exportReportToPdfFile
(
printFileName
,

"C://sample_report.pdf"
);

/** * 2- export to HTML */

JasperExportManager
.
exportReportToHtmlFile
(
printFileName
,

"C://sample_report.htmll"
);

/** * 3- export to Excel sheet */

JRXlsExporter
exporter
=

new

JRXlsExporter
();
exporter
.
setParameter
(
JRExporterParameter
.
INPUT_FILE_NAME
,
printFileName
);
exporter
.
setParameter
(
JRExporterParameter
.
OUTPUT_FILE_NAME
,

"C://sample_report.xls"
);
exporter
.
exportReport
();

}

}

catch

(
JRException
e
)

{
e
.
printStackTrace
();

}

}

}

在這裏,我們已經包括了邏輯Jasper 打印文件導出到PDF,HTML和XLS格式。

生成報表

讓我們用我們的常規Ant構建過程編譯和執行上述文件。 build.xml文件如下圖所示:

<project name="JasperReportTest" default="executereport" basedir="."> <import file="baseBuild.xml"/> <target name="executereport" depends="compile,compilereportdesing,run"> <echo message="Im here"/> <target name="compilereportdesing" description="Compiles the JXML file and
produces the .jasper file."> <taskdef name="jrc" classname="net.sf.jasperreports.ant.JRAntCompileTask"> <classpath refid="classpath" /> <jrc destdir="."> <fileset dir="."> <include name="*.jrxml" /> <classpath refid="classpath" />

進入命令提示符,然後轉到目錄C: oolsjasperreports-5.0.1 est,其中build.xml已放置。最後執行的命令 ant -Dmain-class=com.yiibai.JasperReportFill. 輸出如下所示:

C: oolsjasperreports-5.0.1 est>ant -Dmain-class=com.yiibai.JasperReportFill
Buildfile: C: oolsjasperreports-5.0.1 estuild.xml

clean-sample:
[delete] Deleting directory C: oolsjasperreports-5.0.1 estclasses
[delete] Deleting: C: oolsjasperreports-5.0.1 estjasper_report_template.jasper
[delete] Deleting: C: oolsjasperreports-5.0.1 estjasper_report_template.jrprint

compile:
[mkdir] Created dir: C: oolsjasperreports-5.0.1 estclasses
[javac] C: oolsjasperreports-5.0.1 estaseBuild.xml:28:
warning: 'includeantruntime' was not set, defaulting t
[javac] Compiling 4 source files to C: oolsjasperreports-5.0.1 estclasses

compilereportdesing:
[jrc] Compiling 1 report design files.
[jrc] log4j:WARN No appenders could be found for logger
(net.sf.jasperreports.engine.xml.JRXmlDigesterFactory).
[jrc] log4j:WARN Please initialize the log4j system properly.
[jrc] log4j:WARN See http://logging.apache.org/log4j/1.2/faq.htmll#noconfig for more info.
[jrc] File : C: oolsjasperreports-5.0.1 estjasper_report_template.jrxml ... OK.

run:
[echo] Runnin class : com.yiibai.JasperReportFill
[java] log4j:WARN No appenders could be found for logger
(net.sf.jasperreports.extensions.ExtensionsEnvironment).
[java] log4j:WARN Please initialize the log4j system properly.

executereport:
[echo] Im here

BUILD SUCCESSFUL
Total time: 32 seconds

正如上面執行的結果,會發現三個文件sample_report.pdf,sample_report.htmll,sample_report.xls已生成在 C: 目錄.