Java tutorial
/* * JasperReports - Free Java Reporting Library. * Copyright (C) 2001 - 2014 TIBCO Software Inc. All rights reserved. * http://www.jaspersoft.com * * Unless you have purchased a commercial license agreement from Jaspersoft, * the following license terms apply: * * This program is part of JasperReports. * * JasperReports is free software: you can redistribute it and/or modify * it under the terms of the GNU Lesser General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * JasperReports is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public License * along with JasperReports. If not, see <http://www.gnu.org/licenses/>. */ import java.io.File; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.JasperPrintManager; import net.sf.jasperreports.engine.export.JRCsvExporter; import net.sf.jasperreports.engine.export.JRRtfExporter; import net.sf.jasperreports.engine.export.JRXlsExporter; import net.sf.jasperreports.engine.export.oasis.JROdsExporter; import net.sf.jasperreports.engine.export.oasis.JROdtExporter; import net.sf.jasperreports.engine.export.ooxml.JRDocxExporter; import net.sf.jasperreports.engine.export.ooxml.JRPptxExporter; import net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter; import net.sf.jasperreports.engine.query.JRHibernateQueryExecuterFactory; import net.sf.jasperreports.engine.util.AbstractSampleApp; import net.sf.jasperreports.engine.util.JRLoader; import net.sf.jasperreports.export.SimpleExporterInput; import net.sf.jasperreports.export.SimpleHtmlExporterOutput; import net.sf.jasperreports.export.SimpleOdsReportConfiguration; import net.sf.jasperreports.export.SimpleOutputStreamExporterOutput; import net.sf.jasperreports.export.SimpleWriterExporterOutput; import net.sf.jasperreports.export.SimpleXlsReportConfiguration; import net.sf.jasperreports.export.SimpleXlsxReportConfiguration; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; /** * @author Teodor Danciu (teodord@users.sourceforge.net) * @version $Id: HibernateApp.java 7199 2014-08-27 13:58:10Z teodord $ */ public class HibernateApp extends AbstractSampleApp { /** * */ public static void main(String[] args) { main(new HibernateApp(), args); } /** * */ public void test() throws JRException { pdf(); xmlEmbed(); xml(); html(); rtf(); xls(); jxl(); csv(); odt(); ods(); docx(); xlsx(); pptx(); xhtml(); } /** * */ public void fill() throws JRException { Session session = createSession(); Transaction transaction = session.beginTransaction(); Map<String, Object> params = getParameters(session); File[] files = new File[] { new File("build/reports/AddressesReport.jasper"), new File("build/reports/HibernateQueryReport.jasper") }; for (int i = 0; i < files.length; i++) { File reportFile = files[i]; long start = System.currentTimeMillis(); JasperFillManager.fillReportToFile(reportFile.getAbsolutePath(), params); System.err .println("Report : " + reportFile + ". Filling time : " + (System.currentTimeMillis() - start)); } transaction.rollback(); session.close(); } /** * */ public void print() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { File reportFile = files[i]; long start = System.currentTimeMillis(); JasperPrintManager.printReport(reportFile.getAbsolutePath(), true); System.err.println( "Report : " + reportFile + ". Printing time : " + (System.currentTimeMillis() - start)); } } /** * */ public void pdf() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { File reportFile = files[i]; long start = System.currentTimeMillis(); JasperExportManager.exportReportToPdfFile(reportFile.getAbsolutePath()); System.err.println( "Report : " + reportFile + ". PDF creation time : " + (System.currentTimeMillis() - start)); } } /** * */ public void rtf() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { long start = System.currentTimeMillis(); File sourceFile = files[i]; JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile); File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".rtf"); JRRtfExporter exporter = new JRRtfExporter(); exporter.setExporterInput(new SimpleExporterInput(jasperPrint)); exporter.setExporterOutput(new SimpleWriterExporterOutput(destFile)); exporter.exportReport(); System.err.println( "Report : " + sourceFile + ". RTF creation time : " + (System.currentTimeMillis() - start)); } } /** * */ public void xml() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { File reportFile = files[i]; long start = System.currentTimeMillis(); JasperExportManager.exportReportToXmlFile(reportFile.getAbsolutePath(), false); System.err.println( "Report : " + reportFile + ". XML creation time : " + (System.currentTimeMillis() - start)); } } /** * */ public void xmlEmbed() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { File reportFile = files[i]; long start = System.currentTimeMillis(); JasperExportManager.exportReportToXmlFile(reportFile.getAbsolutePath(), true); System.err.println( "Report : " + reportFile + ". XML creation time : " + (System.currentTimeMillis() - start)); } } /** * */ public void html() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { File reportFile = files[i]; long start = System.currentTimeMillis(); JasperExportManager.exportReportToHtmlFile(reportFile.getAbsolutePath()); System.err.println( "Report : " + reportFile + ". HTML creation time : " + (System.currentTimeMillis() - start)); } } /** * */ public void xls() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { long start = System.currentTimeMillis(); File sourceFile = files[i]; JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile); File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls"); JRXlsExporter exporter = new JRXlsExporter(); exporter.setExporterInput(new SimpleExporterInput(jasperPrint)); exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(destFile)); SimpleXlsReportConfiguration configuration = new SimpleXlsReportConfiguration(); configuration.setOnePagePerSheet(true); exporter.setConfiguration(configuration); exporter.exportReport(); System.err.println( "Report : " + sourceFile + ". XLS creation time : " + (System.currentTimeMillis() - start)); } } /** * */ @SuppressWarnings("deprecation") public void jxl() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { long start = System.currentTimeMillis(); File sourceFile = files[i]; JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile); File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".jxl.xls"); net.sf.jasperreports.engine.export.JExcelApiExporter exporter = new net.sf.jasperreports.engine.export.JExcelApiExporter(); exporter.setExporterInput(new SimpleExporterInput(jasperPrint)); exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(destFile)); net.sf.jasperreports.export.SimpleJxlReportConfiguration configuration = new net.sf.jasperreports.export.SimpleJxlReportConfiguration(); configuration.setOnePagePerSheet(true); exporter.setConfiguration(configuration); exporter.exportReport(); System.err.println( "Report : " + sourceFile + ". XLS creation time : " + (System.currentTimeMillis() - start)); } } /** * */ public void csv() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { long start = System.currentTimeMillis(); File sourceFile = files[i]; JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile); File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".csv"); JRCsvExporter exporter = new JRCsvExporter(); exporter.setExporterInput(new SimpleExporterInput(jasperPrint)); exporter.setExporterOutput(new SimpleWriterExporterOutput(destFile)); exporter.exportReport(); System.err.println( "Report : " + sourceFile + ". CSV creation time : " + (System.currentTimeMillis() - start)); } } /** * */ public void odt() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { long start = System.currentTimeMillis(); File sourceFile = files[i]; JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile); File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".odt"); JROdtExporter exporter = new JROdtExporter(); exporter.setExporterInput(new SimpleExporterInput(jasperPrint)); exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(destFile)); exporter.exportReport(); System.err.println( "Report : " + sourceFile + ". ODT creation time : " + (System.currentTimeMillis() - start)); } } /** * */ public void ods() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { long start = System.currentTimeMillis(); File sourceFile = files[i]; JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile); File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".ods"); JROdsExporter exporter = new JROdsExporter(); exporter.setExporterInput(new SimpleExporterInput(jasperPrint)); exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(destFile)); SimpleOdsReportConfiguration configuration = new SimpleOdsReportConfiguration(); configuration.setOnePagePerSheet(true); exporter.setConfiguration(configuration); exporter.exportReport(); System.err.println( "Report : " + sourceFile + ". ODS creation time : " + (System.currentTimeMillis() - start)); } } /** * */ public void docx() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { long start = System.currentTimeMillis(); File sourceFile = files[i]; JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile); File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".docx"); JRDocxExporter exporter = new JRDocxExporter(); exporter.setExporterInput(new SimpleExporterInput(jasperPrint)); exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(destFile)); exporter.exportReport(); System.err.println( "Report : " + sourceFile + ". DOCX creation time : " + (System.currentTimeMillis() - start)); } } /** * */ public void xlsx() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { long start = System.currentTimeMillis(); File sourceFile = files[i]; JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile); File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xlsx"); JRXlsxExporter exporter = new JRXlsxExporter(); exporter.setExporterInput(new SimpleExporterInput(jasperPrint)); exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(destFile)); SimpleXlsxReportConfiguration configuration = new SimpleXlsxReportConfiguration(); configuration.setOnePagePerSheet(true); exporter.setConfiguration(configuration); exporter.exportReport(); System.err.println( "Report : " + sourceFile + ". XLSX creation time : " + (System.currentTimeMillis() - start)); } } /** * */ public void pptx() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { long start = System.currentTimeMillis(); File sourceFile = files[i]; JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile); File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".pptx"); JRPptxExporter exporter = new JRPptxExporter(); exporter.setExporterInput(new SimpleExporterInput(jasperPrint)); exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(destFile)); exporter.exportReport(); System.err.println( "Report : " + sourceFile + ". PPTX creation time : " + (System.currentTimeMillis() - start)); } } /** * */ @SuppressWarnings("deprecation") public void xhtml() throws JRException { File[] files = getFiles(new File("build/reports"), "jrprint"); for (int i = 0; i < files.length; i++) { long start = System.currentTimeMillis(); File sourceFile = files[i]; JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile); File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".x.html"); net.sf.jasperreports.engine.export.JRXhtmlExporter exporter = new net.sf.jasperreports.engine.export.JRXhtmlExporter(); exporter.setExporterInput(new SimpleExporterInput(jasperPrint)); exporter.setExporterOutput(new SimpleHtmlExporterOutput(destFile)); exporter.exportReport(); System.err.println( "Report : " + sourceFile + ". XHTML creation time : " + (System.currentTimeMillis() - start)); } } private static Map<String, Object> getParameters(Session session) { Map<String, Object> parameters = new HashMap<String, Object>(); parameters.put(JRHibernateQueryExecuterFactory.PARAMETER_HIBERNATE_SESSION, session); parameters.put("ReportTitle", "Address Report"); List<String> cityFilter = new ArrayList<String>(3); cityFilter.add("Boston"); cityFilter.add("Chicago"); cityFilter.add("Oslo"); parameters.put("CityFilter", cityFilter); parameters.put("OrderClause", "city"); return parameters; } private static Session createSession() { SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory(); return sessionFactory.openSession(); } }