java ireport jasperreport 配套使用(一)

 

 

 

从2010年11月份进入项目组，一直在使用2种报表生成工具：SSRS和ireport.

 

ireport描述:此处略去若干字...(自己百度之,Google之)

 

项目使用的是ireport3.7.4,及配套一些开源工具框架.

这个系列文章是建立在你有ireport使用经验和Java ee的基础上的.

例如：

1,理解parameters/feilds/variables.

2,理解各个band的作用.

3,如何ireport中使用JDBC datasource.

4,常用Elements使用及properties的设置.

 

ireport3.7.4下载地址

http://sourceforge.net/projects/ireport/files/iReport/

下载iReport-3.7.4-windows-installer.exe

 

1,安装过程为傻瓜式.

2,启动ireport

3,新建report

File->new->report->open this template->输入report name(ireport_HelloWorld)/location:D:/bi/jasper report->OK.

4,测试ireport.

打开window->palette,

找到static text控件,拖拽2个到Title band区域,向控件内写入任何文字(建议英文).

如下图:

 

因为我们要使用Java生成报表,所以要修改report  2个properties.

report language:Java,

when no data:all sections,no detail

步骤如下:

1,点击report 灰色区域

2,window->properties 此时会弹出properties面板,将2个选项改为上述值.

 

点击preview 按钮查看.

 

到这里一个report就建好了.

 

如何使用Java将report生成PDF格式的报表呢?

那么不得不提jasperreport.

至于jasperreport作用,简介 请百度之,Google之.

 

 

使用Java将report生成PDF将用到一些jar包:

jasperreport-3.7.4.jar

commons-logging-1.1.jar

commons-collections-3.1.jar

commons-beanutils-1.7.0.jar

commons-digester-1.7.jar

xml-apis-1.0.b2.jar

iText.jar

ojdbc6.jar

iTextAsian.jar

 

其中前7个为必须.

ojdbc6.jar为oracle jdbc jar,因为report可能会用到数据库连接.当然,如果你不是使用oracle数据库,那么你只需换成相应jar包.

iTextAsian.jar  如果你的report里出现中文,那么此jar包也必须.

 

相关jar包下载我已上传至优快云资源

下载地址：http://download.youkuaiyun.com/source/3164957

 

将全部jar包加入到classpath中.

 

将D:/bi/jasper report 目录下ireport_HelloWorld.jrxml和ireport_HelloWorld.jasper两个文件拷贝到

包com.jasper.report中.

ireport_HelloWorld.jrxml是ireport编辑文件

ireport_HelloWorld.jasper是jrxml文件编译生成的文件,

java生成报表就是用.jasper文件的.

 

新建一个Servlet(IreportHelloWorld.java)用来生成pdf.

package com.jasper; import java.io.IOException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.jasper.connection.JDBCUtils; public class IreportHelloWorld extends HttpServlet { private static final long serialVersionUID = 1L; public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Map<String, String> paramMap = new HashMap<String, String>(); Connection conn = JDBCUtils.getInstance().getConnection(); ReportGenerator generator = new ReportGenerator(); generator.PDFGenerator(response, "ireport_HelloWorld.jasper", paramMap, conn); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doGet(request, response); } } 

 

 

在Servlet中引用到ReportGenerator,这个类为生成报表的工具类,只有一个方法PDFGenerator方法.

 

 

package com.jasper; import java.io.IOException; import java.io.InputStream; import java.sql.Connection; import java.util.Map; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletResponse; import net.sf.jasperreports.engine.JRDataSource; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JRExporterParameter; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.export.JRPdfExporter; import net.sf.jasperreports.engine.util.JRLoader; import com.jasper.connection.JDBCUtils; public class ReportGenerator { public static final String REPORT_FOLDER_PATH = "com/jasper/report/"; public void PDFGenerator(HttpServletResponse response,String jasperFileName, Map<String, String> paramMap,JRDataSource dataSource) { InputStream reportFile = this.getClass().getClassLoader().getResourceAsStream(REPORT_FOLDER_PATH + jasperFileName); JasperPrint jasperPrint = null; try { JasperReport jasperReport = (JasperReport) JRLoader.loadObject(reportFile); jasperPrint = JasperFillManager.fillReport(jasperReport, paramMap, dataSource); } catch (JRException e) { e.printStackTrace(); } if (jasperPrint != null) { response.setContentType("application/pdf"); ServletOutputStream outputStream = null; try { outputStream = response.getOutputStream(); } catch (IOException e1) { e1.printStackTrace(); } // 使用JRPdfExproter导出器导出pdf JRPdfExporter exporter = new JRPdfExporter(); // 设置JasperPrintList exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM,outputStream); try { exporter.exportReport(); } catch (JRException e) { e.printStackTrace(); } finally { JDBCUtils.closeConnection(); try { outputStream.close(); } catch (IOException e) { e.printStackTrace(); } } } } public void PDFGenerator(HttpServletResponse response, String jasperFileName, Map<String, String> paramMap, Connection conn) { InputStream reportFile = this.getClass().getClassLoader().getResourceAsStream(REPORT_FOLDER_PATH + jasperFileName); JasperPrint jasperPrint = null; try { JasperReport jasperReport = (JasperReport) JRLoader.loadObject(reportFile); jasperPrint = JasperFillManager.fillReport(jasperReport, paramMap,conn); } catch (JRException e) { e.printStackTrace(); } if (jasperPrint != null) { response.setContentType("application/pdf"); ServletOutputStream outputStream = null; try { outputStream = response.getOutputStream(); } catch (IOException e1) { e1.printStackTrace(); } // 使用JRPdfExproter导出器导出pdf JRPdfExporter exporter = new JRPdfExporter(); // 设置JasperPrintList exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM,outputStream); try { exporter.exportReport(); } catch (JRException e) { e.printStackTrace(); } finally { JDBCUtils.closeConnection(); try { outputStream.close(); } catch (IOException e) { e.printStackTrace(); } } } } }

 

修改web.xml

   <servlet> <servlet-name>IreportHelloWorld</servlet-name> <servlet-class>com.jasper.IreportHelloWorld</servlet-class> </servlet> <servlet-mapping> <servlet-name>IreportHelloWorld</servlet-name> <url-pattern>/IreportHelloWorld</url-pattern> </servlet-mapping> 

 

修改jsp页面,加入下面链接

<a href="IreportHelloWorld" mce_href="IreportHelloWorld">IreportHelloWorld </a><br/> 

 

 

将项目重新发布到server.

在地址栏打开页面,点击链接,生成pdf.如下图.