《报表及报表设计.ppt

iReport报表设计 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. iReport报表设计 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. iReport报表设计 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. JasperReport+iReport+JSP //得到数据源 Connection conn= DriverManager.getConnection(jdbc:mysql://localhost:3306/library?characterEncoding=GBK, root, root); //确定报表文件(*.jasper)的路径 File reportFile = new File(application.getRealPath(/report1.jasper)); //下面这行代码告诉我们一个Jasper Report在JAVA程序中是一个对象 JasperReport jasperReport = (JasperReport)JRLoader.loadObject(reportFile.getPath()); Map parameters = new HashMap(); //用“名值对”的方式来传递报表参数 parameters.put(type, Disk); //下面这行代码告诉我们下一步是要填充(fill)报表 JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters,conn); //运行报表的最一步则是要导出(exort)报表到一个输出流 JRHtmlExporter exporter = new JRHtmlExporter(); session.setAttribute(ImageServlet.DEFAULT_JASPER_PRINT_SESSION_ATTRIBUTE, jasperPrint); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_WRITER, out); exporter.setParameter(JRHtmlExporterParameter.IMAGES_URI, servlets/image?image=); //导出报表 exporter.exportReport(); //导出Excel报表 JRXlsExporter exlExporter=new JRXlsExporter(); response.setContentType(application/vnd.ms-excel); ServletOutputStream output = response.getOutputStream(); exlExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exlExportersetParameter(JRExporterParameter.OUTPUT_STREAM,output); exlExporter.exportReport(); Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. JasperReport-webapp Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. JasperReport-webapp 各种导出格式： PDF