jasper的一个小例子

package com.sterning; import java.io.File; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; 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.JRExporter; import net.sf.jasperreports.engine.JRExporterParameter; import net.sf.jasperreports.engine.JasperCompileManager; 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; import net.sf.jasperreports.view.JasperViewer; import org.apache.struts2.ServletActionContext; import com.opensymphony.xwork2.ActionSupport; public class JasperAction extends ActionSupport { //private static final long serialVersionUID = 1L; //private List<PeopleBean> myList; public String execute() throws Exception { System.out.println("main.......1111111"); Connection conn = null; try { //DB Connection Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:ORCL", "db31", "embed" ); String curDir = System.getProperty("user.dir"); String dir = curDir+"\\src\\jasper\\"; String reportId = "Procedures"; System.out.println("main.......222222"); JasperCompileManager.compileReportToFile(dir+reportId + ".jrxml",dir+reportId + ".jasper"); JasperReport jasperReport = (JasperReport) JRLoader.loadObject(dir+reportId + ".jasper"); System.out.println("main.......333333"); Map map = new HashMap(); map.put("Facility", "Technology"); JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, map, conn); System.out.println("main.......444444"); exportReport(dir+reportId ,"xls",jasperPrint); JasperViewer jrview = new JasperViewer(jasperPrint,false); jrview.setVisible(true); conn.close(); System.out.println("main.......555555"); } catch (Exception e) { if(conn != null){ try { conn.close(); } catch (SQLException e1) {} } e.printStackTrace(); } return SUCCESS; } /** * @throws JRException */ private static void exportReport(String fileName, String format,JasperPrint print) throws JRException { System.out.println("main.......666666"); JRExporter exporter = null; if (format.equalsIgnoreCase("pdf")) { System.out.println("main.......777777"); exporter = new net.sf.jasperreports.engine.export.JRPdfExporter(); fileName = fileName+".pdf"; } else if (format.equalsIgnoreCase("csv")) { exporter = new net.sf.jasperreports.engine.export.JRCsvExporter(); fileName = fileName+".csv"; } else if (format.equalsIgnoreCase("html")) { exporter = new net.sf.jasperreports.engine.export.JRHtmlExporter(); fileName = fileName+".html"; } else if (format.equalsIgnoreCase("xls") || format.equalsIgnoreCase("xls2")) { if (format.equalsIgnoreCase("xls")) { exporter = new net.sf.jasperreports.engine.export.JRXlsExporter(); } else { exporter = new net.sf.jasperreports.engine.export.JExcelApiExporter(); } fileName = fileName+".xls"; } else if (format.equalsIgnoreCase("odt")) { exporter = new net.sf.jasperreports.engine.export.oasis.JROdtExporter(); fileName = fileName+".odt"; } if (exporter != null) { exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,fileName); exporter.setParameter(JRExporterParameter.JASPER_PRINT,print); exporter.exportReport(); } } }