报表和报表设计.ppt

iReport报表设计 iReport报表设计 iReport报表设计 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(); JasperReport-webapp JasperReport-webapp 各种导出格式： PDF, HTML, XLS, RTF, ODT, CSV, TXT and XML … JasperReport-webapp PDF导出： JOR（简表）－使用手册 JOR（简表）－设计器 JOR（简表）－设计器 JOR（简表）－web示例 JOR（简表）－web示例 jQuery Sheet-电子表格组件 jQuery.sheet gives you all sorts of possibilities when it comes to giving your web application a spreadsheet style interface with MS Excel style calculations. jQuery.sheet manages the sheet creation, viewing, and editing processes. It can even be used like a datagrid, without calculations. For a complete list of all the MS Excel style functions that jQuery.sheet supports, take a look at the Demo, which is the documentation. Fe