使用Jasperreport作为报表控件开发Web 报表应用后续

最新推荐文章于 2014-01-25 14:04:48 发布

原创最新推荐文章于 2014-01-25 14:04:48 发布 · 715 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#报表 #web #parameters #report #object #hashmap

本文介绍如何使用JasperReports生成报表，包括设置报表参数、连接数据库、填充报表及导出为HTML格式等关键步骤。

参考如下：
<%@page contentType="text/html;charset=gbk"%>
<%@ page import="net.sf.jasperreports.engine.*" %>
<%@ page import="net.sf.jasperreports.engine.util.*" %>
<%@ page import="net.sf.jasperreports.engine.export.*" %>
<%@ page import="java.util.*,java.io.*,java.sql.*" %>

<%
String jasperFileName = "emp" ;
File jasperFile = new File(application.getRealPath("//report//emp.jasper"));

Map parameters = new HashMap();
System.out.println("::::::::::::::::DS OK1:"+jasperFile.getPath());
parameters.put("dd","LYD1");

Connection con = null;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/photo","root","root");
}catch(Exception e){
System.out.println("::::::::::::::::DS fail");
}

JasperReport jasperReport = (JasperReport) JRLoader.loadObject(jasperFile.getPath());

JasperPrint jasperPrint =
JasperFillManager.fillReport(
jasperReport,
parameters,
con
);

JRHtmlExporter exporter = new JRHtmlExporter();

//exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
//exporter.setParameter(JRExporterParameter.OUTPUT_WRITER, out);
Map imagesMap = new HashMap();
session.setAttribute("IMAGES_MAP", imagesMap);

exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_WRITER, out);
exporter.setParameter(JRHtmlExporterParameter.IMAGES_MAP, imagesMap);
exporter.setParameter(JRHtmlExporterParameter.IMAGES_URI, "image.jsp?image=");

exporter.exportReport();

%>

JasperFillManager类 fillreport 方法

fillReport

public static JasperPrint fillReport(java.io.InputStream inputStream,
                                     java.util.Map parameters,
                                     java.sql.Connection connection)
                              throws JRException

Fills the compiled report design loaded from the supplied input stream and returns the generated report object.

Parameters:

inputStream - input stream to read the compiled report design object from

parameters - report parameters map

connection - JDBC connection object to use for executing the report internal SQL query

Returns:

generated report object

Throws:

JRException

fillReport

public static JasperPrint fillReport(java.io.InputStream inputStream,
                                     java.util.Map parameters)
                              throws JRException

Fills the compiled report design loaded from the supplied input stream and returns the generated report object.

Parameters:

inputStream - input stream to read the compiled report design object from

parameters - report parameters map

Returns:

generated report object

Throws:

JRException

fillReport

public static JasperPrint fillReport(JasperReport jasperReport,
                                     java.util.Map parameters,
                                     java.sql.Connection connection)
                              throws JRException

Fills the compiled report design supplied as the first parameter and returns the generated report object.

Parameters:

jasperReport - compiled report design object to use for filling

parameters - report parameters map

connection - JDBC connection object to use for executing the report internal SQL query

Returns:

generated report object

Throws:

JRException

fillReport

public static JasperPrint fillReport(JasperReport jasperReport,
                                     java.util.Map parameters)
                              throws JRException

Fills the compiled report design supplied as the first parameter and returns the generated report object.

Parameters:

jasperReport - compiled report design object to use for filling

parameters - report parameters map

Returns:

generated report object

Throws:

JRException