Ireport+jfreechart+Jasperreport开发图表

更新时间：2022-09-09 22:12:39

http://wenku.baidu.com/view/78e0ed74a417866fb84a8eca.html

1.Ireport生成图表

下载Ireport3.74

1、文件-新建

Ireport+jfreechart+Jasperreport开发图表

2、选择Blank A4 、—》 lannch Report Wizard

3、设定报表名称，生成完报表的存放位置，选择下一步

Ireport+jfreechart+Jasperreport开发图表

4、新建数据源new

Ireport+jfreechart+Jasperreport开发图表

5、选择Database JDBC connection

Ireport+jfreechart+Jasperreport开发图表

注: 将以下红色框内容按情况填写正确。

Ireport+jfreechart+Jasperreport开发图表

注：由于ireport只提供了mysql的dirver，如用oracle数据库需先将驱动jar包导入ireport。

导入方式：工具->选项->CLASSPATH把相关jar包导入。

6、输入SQL语句 SQL是报表要查询的数据下一步。

注：这块没有给SQL传入参数，传参方法请参考报表生成PPT。

Ireport+jfreechart+Jasperreport开发图表

7、把相应查询出来报表要用到的File添加进去，下一步->完成。

Ireport+jfreechart+Jasperreport开发图表

8、以下band只留Summary Band，其他band鼠标右键Delete Band并且在Summary Band中添加报表。

Ireport+jfreechart+Jasperreport开发图表

注：在Detail1中添加报表容易产生重复报表。

9、将chart直接拖入 Summary Band区域，选择报表下一步。

Ireport+jfreechart+Jasperreport开发图表

10、添加需要统计的数据组到第一个对话框，对应组的值放入第二个对话框。选择相应的Field。

Ireport+jfreechart+Jasperreport开发图表

注：如没出来定义报表的时候选择的字段需要点击报表Edit Query把相应的sql对应的字read到Fields里面。

11、增加类别

Ireport+jfreechart+Jasperreport开发图表

12、增加柱图显示数量

Ireport+jfreechart+Jasperreport开发图表

13、OK图表生成了。Preview查看下效果吧。后续编译生成.jasper文件放入工程中。

2.关于撰取

Ireport+jfreechart+Jasperreport开发图表

注：其中HyperLink target与HyperLinkType都是需要设置参数，HyperLink Referece Expression

是撰取的url附带参数可以实现分类撰取。

3.Jasper导出代码部分

需要配置一个servlet在web.xml

<servlet-name>ImageServlet</servlet-name>

<servlet-class>net.sf.jasperreports.j2ee.servlets.ImageServlet</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>ImageServlet</servlet-name>

<url-pattern>/image</url-pattern>

</servlet-mapping>

我们工程需要加入jcommon-1.0.16.jar如需要导出样式加入jasperreports-chart-themes-3.7.4.jar。

代码：

1、公共调用的工具类负责生成并导出图表：

2、对应的Action(撰取)

2.1、被撰取action

3、展示的JSP

3、图表的实例生成文件

4、撰取图表

Action：

[java] view plain copy

package com.xin.struts2;
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts2.ServletActionContext;
import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Result;
import com.opensymphony.xwork2.ActionSupport;
@Action(value = "jasperTest",results={@Result(name="jasper",location="/jasperTest.jsp")})
public class JasperTestAction extends ActionSupport{
private StringBuffer vpnbuffer = null;
public StringBuffer getVpnbuffer() {
return vpnbuffer;
}
public void setVpnbuffer(StringBuffer vpnbuffer) {
this.vpnbuffer = vpnbuffer;
}
private static final String URL = "xxxxxxxxxxxxxxxxxxx";
public String getHtml(){
Connection conn = getConn();
HttpServletRequest request = ServletActionContext.getRequest();
Map<String,String> parameters = new HashMap<String,String>();
parameters.put("title", "xxxxxxx");
parameters.put("title2", "xxxxxx");
vpnbuffer = new StringBuffer();
File reportFile = new File(ServletActionContext.getServletContext().getRealPath(
File.separator + "report" + File.separator + "report1.jasper"));
try {
ChartReportUtil.genAndExpChart(vpnbuffer, conn, request, reportFile, parameters);
} catch (Exception e) {
e.printStackTrace();
}
System.out.println("sbuffer"+vpnbuffer);
return "jasper";
}
private static Connection getConn(){
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(URL,"xxxxx","xxxxxx");
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void main(String[] args) {
System.out.println(new Date().toGMTString());
}
}

util:

[java] view plain copy

package com.xin.struts2;
import java.io.File;
import java.sql.Connection;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.HashMap;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRExporterParameter;
import net.sf.jasperreports.engine.JRRuntimeException;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.export.JRHtmlExporter;
import net.sf.jasperreports.engine.export.JRHtmlExporterParameter;
import net.sf.jasperreports.engine.util.JRLoader;
import net.sf.jasperreports.j2ee.servlets.ImageServlet;
/**
* 图表工具类
* @author xxxxx
*
*/
@SuppressWarnings("unchecked")
public class ChartReportUtil {
//报表图片生成路径
private static final String REPORT_IMG_DIR = "compReportImg";
/**
* 生成并导出图形报表
* @param buffer output HTML
* @param conn DB connection used for query
* @param request
* @param reportFile report JASPER file
* @param parameters Used for the parameters of the query
* @throws JRException
*/
public static void genAndExpChart(StringBuffer sbuffer,Connection conn,HttpServletRequest request
,File reportFile,Map<String,String> parameters) throws Exception{
try {
if(!reportFile.exists()){ //Check file exists
throw new JRRuntimeException("jasper file is not found!");
}
if(null == sbuffer){ //Check StringBuffer init
throw new RuntimeException("StringBuffer is not init");
}
JRHtmlExporter exporter = new JRHtmlExporter();
JasperReport jasperReport = (JasperReport) JRLoader.loadObject(reportFile.getPath());
JasperPrint jasperPrint = null;
jasperPrint = JasperFillManager.fillReport(jasperReport,parameters, conn);
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_STRING_BUFFER,sbuffer);
exporter.setParameter(JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN,Boolean.FALSE);
exporter.setParameter(JRHtmlExporterParameter.HTML_HEADER, "");
exporter.setParameter(JRHtmlExporterParameter.BETWEEN_PAGES_HTML, "");
request.getSession().setAttribute(ImageServlet.DEFAULT_JASPER_PRINT_SESSION_ATTRIBUTE, jasperPrint);
String imgServDirUrl = REPORT_IMG_DIR + File.separator + getFileNameNoEx(reportFile.getName());//构造报表存放子目录，以期解决一次请求返回多个图形报表重叠现象
File imgRealDir= new File(request.getRealPath(File.separator) + imgServDirUrl);
if(!imgRealDir.exists()) {
imgRealDir.mkdirs();
}
//重设JRHtmlExporterParameter.IMAGES_URI
exporter.setParameter(JRHtmlExporterParameter.IMAGES_URI, request.getContextPath() +"/"+imgServDirUrl+ "/");
exporter.setParameter(JRHtmlExporterParameter.IMAGES_DIR, imgRealDir);
exporter.setParameter(JRHtmlExporterParameter.IS_OUTPUT_IMAGES_TO_DIR, Boolean.TRUE);
exporter.setParameter(JRHtmlExporterParameter.HTML_FOOTER, "");
exporter.exportReport();
}finally{
if(conn!=null){
conn.close();
}
}
}

JSP:

[html] view plain copy

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'login.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<form action="jasperTest!getHtml.action" method="post">
<input type="submit" value="生成图表">
</form>
<table border="0" cellpadding="0" cellspacing="0" align="left">
<tr>
<td align="center" colspan=2>
<font size="3">${vpnbuffer}</font>
</td>
</tr>
</tr>
</c:if>
</table>
</body>
</html>

WEB.XML

[html] view plain copy

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<display-name>Struts2Project</display-name>
<filter>
<filter-name>struts2</filter-name>
<filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>*.action</url-pattern>
</filter-mapping>
<span style="color:#ff0000;"> </span> <servlet>
<servlet-name>ImageServlet</servlet-name>
<servlet-class>net.sf.jasperreports.j2ee.servlets.ImageServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>ImageServlet</servlet-name>
<url-pattern>/image</url-pattern>
</servlet-mapping>
</web-app>

4.效果图

Ireport+jfreechart+Jasperreport开发图表

5.生成的HTML

<tr>

</tr>

</tr>

</map>

</td>

</tr>

</map>

</td>

</tr>

</tr>

</table>

上一篇 : ：angelc0de原创burpsuite系列培训教程（下载）下一篇 : 宁皓网bootstrap

Ireport+jfreechart+Jasperreport开发图表

http://wenku.baidu.com/view/78e0ed74a417866fb84a8eca.html

1.Ireport生成图表

2.关于撰取

3.Jasper导出代码部分

4.效果图

5.生成的HTML

相关阅读

推荐文章