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

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

ft0905

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

阅读量663

点赞数

文章标签：报表 web parameters report object hashmap

本文链接：https://blog.csdn.net/ft0905/article/details/1651696

版权

参考如下：
<%@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