- package test.report;
- import java.math.BigDecimal;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.util.HashMap;
- import net.sf.jasperreports.engine.JRException;
- import net.sf.jasperreports.engine.JRResultSetDataSource;
- import net.sf.jasperreports.engine.JasperCompileManager;
- import net.sf.jasperreports.engine.JasperExportManager;
- import net.sf.jasperreports.engine.JasperFillManager;
- import net.sf.jasperreports.engine.JasperPrint;
- import net.sf.jasperreports.engine.JasperReport;
- import net.sf.jasperreports.engine.util.JRLoader;
- public class GenerateReport {
- public static void main(String[] args) {
- try {
- sql4Report();
- } catch (JRException e) {
- e.printStackTrace();
- } catch (SQLException e) {
- e.printStackTrace();
- } finally {
- System.out.print( "finish" );
- }
- }
- public static void parameter4Report ()
- throws SQLException, JRException {
- //report parameter
- HashMap<String, Object> parameter =
- new HashMap<String, Object>();
- parameter.put( "master_location_id", new BigDecimal(22) );
- Connection con = getConnection();
- JasperReport jasperReport =
- JasperCompileManager.compileReport("reports/Location.jrxml");
- JasperPrint jasperPrint =
- JasperFillManager.fillReport( jasperReport, parameter, con );
- JasperExportManager.exportReportToPdfFile(
- jasperPrint, "reports/location_parameter4Report.pdf");
- }
- public static void sql4Report () throws SQLException, JRException {
- //create the ResultSet
- Connection con = getConnection();
- PreparedStatement statement =
- con.prepareStatement(
- "select * from loc_location "
- + "where location_type_cd = 'ROOM' "
- + "order by location_type_cd"
- );
- ResultSet resultSet = statement.executeQuery();
- JRResultSetDataSource result =
- new JRResultSetDataSource( resultSet );
- JasperReport jasperReport =
- JasperCompileManager.compileReport("reports/Location.jrxml");
- JasperPrint jasperPrint =
- JasperFillManager.fillReport(
- jasperReport, new HashMap(), result
- );
- JasperExportManager.exportReportToPdfFile(
- jasperPrint, "reports/location_sql4Report.pdf"
- );
- }
- public static void jasper4Report ()
- throws SQLException, JRException {
- //create the ResultSet
- Connection con = getConnection();
- PreparedStatement statement =
- con.prepareStatement(
- "select * from loc_location "
- + "where location_type_cd = 'ROOM' "
- + "order by location_type_cd"
- );
- ResultSet resultSet = statement.executeQuery();
- JRResultSetDataSource result =
- new JRResultSetDataSource( resultSet );
- //modify
- JasperReport jasperReport =
- (JasperReport) JRLoader.loadObject(
- "reports/Location.jasper"
- );
- JasperPrint jasperPrint =
- JasperFillManager.fillReport(
- jasperReport, new HashMap(), result
- );
- JasperExportManager.exportReportToPdfFile(
- jasperPrint, "reports/location_jasper4Report.pdf"
- );
- }
- public static void xls4Report () throws SQLException, JRException {
- // create the ResultSet
- Connection con = getConnection();
- PreparedStatement statement =
- con.prepareStatement(
- "select * from loc_location "
- + "where location_type_cd = 'ROOM' "
- + "order by location_type_cd"
- );
- ResultSet resultSet = statement.executeQuery();
- JRResultSetDataSource result =
- new JRResultSetDataSource( resultSet );
- // create JasperReport from .jasper
- JasperReport jasperReport =
- (JasperReport) JRLoader.loadObject("reports/Location.jasper");
- JasperPrint jasperPrint =
- JasperFillManager.fillReport( jasperReport, new HashMap(), result );
- // JasperExportManager.exportReportToPdfFile( jasperPrint, "reports/location_xls4Report.xls");
- JRXlsExporter xlsExporter = new JRXlsExporter();
- xlsExporter.setParameter( JRExporterParameter.JASPER_PRINT, jasperPrint );
- xlsExporter.setParameter( JRExporterParameter.OUTPUT_FILE, new File("reports/location_xls4Report.xls") );
- xlsExporter.exportReport();
- }
- private static Connection getConnection () throws SQLException {
- DriverManager.registerDriver(
- new oracle.jdbc.driver.OracleDriver()
- );
- return DriverManager.getConnection( url, user, pw );
- }
- private static String url = "jdbc:oracle:thin:@localhost:1521:db";
- private static String user = "report";
- private static String pw = "report";
- }
- package test.report;
- import java.math.BigDecimal;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.util.HashMap;
- import net.sf.jasperreports.engine.JRException;
- import net.sf.jasperreports.engine.JRResultSetDataSource;
- import net.sf.jasperreports.engine.JasperCompileManager;
- import net.sf.jasperreports.engine.JasperExportManager;
- import net.sf.jasperreports.engine.JasperFillManager;
- import net.sf.jasperreports.engine.JasperPrint;
- import net.sf.jasperreports.engine.<span class="hilite1"><span style="background-color: #ffff00;">JasperReport</span></span>;
- import net.sf.jasperreports.engine.util.JRLoader;
- public class GenerateReport {
- public static void main(String[] args) {
- try {
- sql4Report();
- } catch (JRException e) {
- e.printStackTrace();
- } catch (SQLException e) {
- e.printStackTrace();
- } finally {
- System.out.print( "finish" );
- }
- }
- public static void parameter4Report ()
- throws SQLException, JRException {
- //report parameter
- HashMap<String, Object> parameter =
- new HashMap<String, Object>();
- parameter.put( "master_location_id", new BigDecimal(22) );
- Connection con = getConnection();
- <span class="hilite1"><span style="background-color: #ffff00;">JasperReport</span></span> <span class="hilite1"><span style="background-color: #ffff00;">jasperReport</span></span> =
- JasperCompileManager.compileReport("reports/Location.jrxml");
- JasperPrint jasperPrint =
- JasperFillManager.fillReport( <span class="hilite1"><span style="background-color: #ffff00;">jasperReport</span></span>, parameter, con );
- JasperExportManager.exportReportToPdfFile(
- jasperPrint, "reports/location_parameter4Report.pdf");
- }
- public static void sql4Report () throws SQLException, JRException {
- //create the ResultSet
- Connection con = getConnection();
- PreparedStatement statement =
- con.prepareStatement(
- "select * from loc_location "
- + "where location_type_cd = 'ROOM' "
- + "order by location_type_cd"
- );
- ResultSet resultSet = statement.executeQuery();
- JRResultSetDataSource result =
- new JRResultSetDataSource( resultSet );
- <span class="hilite1"><span style="background-color: #ffff00;">JasperReport</span></span> <span class="hilite1"><span style="background-color: #ffff00;">jasperReport</span></span> =
- JasperCompileManager.compileReport("reports/Location.jrxml");
- JasperPrint jasperPrint =
- JasperFillManager.fillReport(
- <span class="hilite1"><span style="background-color: #ffff00;">jasperReport</span></span>, new HashMap(), result
- );
- JasperExportManager.exportReportToPdfFile(
- jasperPrint, "reports/location_sql4Report.pdf"
- );
- }
- public static void jasper4Report ()
- throws SQLException, JRException {
- //create the ResultSet
- Connection con = getConnection();
- PreparedStatement statement =
- con.prepareStatement(
- "select * from loc_location "
- + "where location_type_cd = 'ROOM' "
- + "order by location_type_cd"
- );
- ResultSet resultSet = statement.executeQuery();
- JRResultSetDataSource result =
- new JRResultSetDataSource( resultSet );
- //modify
- <span class="hilite1"><span style="background-color: #ffff00;">JasperReport</span></span> <span class="hilite1"><span style="background-color: #ffff00;">jasperReport</span></span> =
- (<span class="hilite1"><span style="background-color: #ffff00;">JasperReport</span></span>) JRLoader.loadObject(
- "reports/Location.jasper"
- );
- JasperPrint jasperPrint =
- JasperFillManager.fillReport(
- <span class="hilite1"><span style="background-color: #ffff00;">jasperReport</span></span>, new HashMap(), result
- );
- JasperExportManager.exportReportToPdfFile(
- jasperPrint, "reports/location_jasper4Report.pdf"
- );
- }
- public static void xls4Report () throws SQLException, JRException {
- // create the ResultSet
- Connection con = getConnection();
- PreparedStatement statement =
- con.prepareStatement(
- "select * from loc_location "
- + "where location_type_cd = 'ROOM' "
- + "order by location_type_cd"
- );
- ResultSet resultSet = statement.executeQuery();
- JRResultSetDataSource result =
- new JRResultSetDataSource( resultSet );
- // create <span class="hilite1"><span style="background-color: #ffff00;">JasperReport</span></span> from .jasper
- <span class="hilite1"><span style="background-color: #ffff00;">JasperReport</span></span> <span class="hilite1"><span style="background-color: #ffff00;">jasperReport</span></span> =
- (<span class="hilite1"><span style="background-color: #ffff00;">JasperReport</span></span>) JRLoader.loadObject("reports/Location.jasper");
- JasperPrint jasperPrint =
- JasperFillManager.fillReport( <span class="hilite1"><span style="background-color: #ffff00;">jasperReport</span></span>, new HashMap(), result );
- // JasperExportManager.exportReportToPdfFile( jasperPrint, "reports/location_xls4Report.xls");
- JRXlsExporter xlsExporter = new JRXlsExporter();
- xlsExporter.setParameter( JRExporterParameter.JASPER_PRINT, jasperPrint );
- xlsExporter.setParameter( JRExporterParameter.OUTPUT_FILE, new File("reports/location_xls4Report.xls") );
- xlsExporter.exportReport();
- }
- private static Connection getConnection () throws SQLException {
- DriverManager.registerDriver(
- new oracle.jdbc.driver.OracleDriver()
- );
- return DriverManager.getConnection( url, user, pw );
- }
- private static String url = "jdbc:oracle:thin:@localhost:1521:db";
- private static String user = "report";
- private static String pw = "report";
- }
需要的包:
jasperreports-3.1.2.jar
jasperreports-3.1.2-applet.jar
jasperreports-3.1.2-javaflow.jar
commons-collections.jar
commons-digester.jar
commons-logging-1.0.4.jar
commons-logging-api.jar
commons-beanutils.jar
itext-1.3.1.jar
classes12.jar
poi-3.0.1.jar
poi-contrib-3.0.1-FINAL-20070705.jar
poi-scratchpad-3.0.1-FINAL-20070705.jar
文件结构:
+test
++report
+++GenerateReport.java
+reports
++Location.jrxml
++Location.jasper
数据表要和Location.jrmal或Location.jasper(即report的设计一致就行了
相关推荐
JasperReport实例导入可用
自己写的ssh整合jasperreport实例,没有用struts集成jasperreport的插件,自己封装的导出类,可以导出各种格式,读的是jasperreport的xml文件,不是编译过的文件,可以进行自定义报表开发
一个完整的Jasperreport实例,能够详细的导出excel表格和pdf,html。利用poi项目!
自己制作报表的测试源码和所有相关学习资料,对应所有jar包,jasperReport版本。
jasperReport详细教程及例子
本资源为本人博文的源码,关于jasperreport5.6+javaServletWeb开发的项目,项目比较简单,关于report的数据传递方法都进行代码框架搭建,读者可以根据自己的需要进行下载修改,有问题欢迎随时交流。
Jreport—jasperreport的一个实例demo
windows下teach1.jasper考到c盘根目录,linux下改变一下路径。
看看代码你就知道报表开发有多简单。由于jar包太多,所以没有附带,你可以安装ireport3.0.0后,ireport安装目录下的lib文件下的jar包就是本实例的jar包,但是struts的包需要你自己加入。
实例中通过利用自定义javabean数据源实现报表实例,其中有代码和文档,还有项目中所需要的jar包,不需要重新下载jasper获取jar包
基于Jasperreport动态单元格合并模板,支持多层分组排序,支持多分组动态合并单元格,附件中有两组以及大于两组的模板实例。
ireport jasperreports 项目实例,导入myeclipse下,运行在tomcat上即可 导出pdf,doc,xls,html格式的文档,自己整理可用的,不忽悠你,算是比较完整的 不仅在servlet中导出,而且整合了struts2导出,非常实用,当然...
详细介绍了如何利用ireport+jasperreport柱状图例子,并附有代码,参照实例,手把手教你用该解决方案作柱状图。
iReport 报表、子报表、主从报表、合计、实例解析1. 开发使用步骤(iReport4.1)... 2 4.1. JasperReport 和iReport的介绍... 2 4.1.1. JasperReport 简介... 3 4.1.2. iReport 简介... 3 4.1.2.1. iReport几个重要...
ireport+jasperreport 例子
ireport+jasperreport 子报表实现行合并实例
jasperreport DEMO WabApp在ECLIPSE下运行通过。 其中有个小BUG,主要是SCRIPT脚本语言类文件错误,现已修正,再有就是类库文件的添加,均以补全。
此书是收费的,也是现在最新版、最完整的Jasperreport学习资料,像现在网站上的一些入门、实例、应用等都是本书所包含在内的(当然只是知识点一样,例子或源码并不是绝对的)。由于此书前段时间在网上提供下载导致...
关于jasperreport和jsp的报表实例,将静态的数据源改为从数据库中去,由于jar较大,所以不予上传,如有需要请私下联系!