用JFreeChart在jsp页面画甘特图

最新推荐文章于 2020-12-27 11:29:28 发布

jinseshanguang

最新推荐文章于 2020-12-27 11:29:28 发布

阅读量383

点赞数

分类专栏：学习笔记文章标签： JSP jfreechart CSS SQL Cache

学习笔记专栏收录该内容

15 篇文章 0 订阅

订阅专栏

最近由于项目需要，需要在网页中生成甘特图，在网上浏览资料之后，最后通过JFreeChart实现了在jsp页面画甘特图。

在此就与大家分享一下我的收获。

首先把重要的代码粘出来供大家参考，项目源码和数据库信息表，以及参考的资料和一些资料的网址我就打包放在下面，大家可以下载后学习参考。

ProgressControl.java//完成从数据库读数据，生成甘特图

package com.angrybirds.DAO;

import java.io.IOException;
import java.io.PrintWriter;
//import java.util.Date;
import java.sql.*;
import java.util.ArrayList;
import java.util.ListIterator;

import javax.servlet.http.HttpSession;

import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartRenderingInfo;
import org.jfree.chart.ChartUtilities;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.entity.StandardEntityCollection;
import org.jfree.chart.servlet.ServletUtilities;
import org.jfree.data.gantt.Task;
import org.jfree.data.gantt.TaskSeries;
import org.jfree.data.gantt.TaskSeriesCollection;

public class ProgressControl {
	
	public static String createPlanGanttChart(String missionId,String missionName,HttpSession session,PrintWriter pw){
		
		String fileName = null;
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		String sql = null;
		String sql2 = null;
		
		ArrayList nameList = new ArrayList();
		ArrayList startList = new ArrayList();
		ArrayList endList = new ArrayList();
		
		conn = DB.getConnection();
		stmt = DB.getStatement(conn);
		
		
		
		sql = "select * from SQLJ.Pro_control"; // where Task_id = '" + missionId + "'";
		
		//System.out.println(sql);
		
		rs = DB.getResultSet(stmt, sql);
		
		try {
			while(rs.next()){
				
				nameList.add(rs.getString("Task_name"));
				startList.add(rs.getDate("Plan_starttime"));
				endList.add(rs.getDate("Plan_endtime"));				
							}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		ListIterator iterN = nameList.listIterator();
		ListIterator iterS = startList.listIterator();
		ListIterator iterE = endList.listIterator();
		
		TaskSeriesCollection tsc = new TaskSeriesCollection();
		TaskSeries tsPlan = new TaskSeries("Plan");
			
		while(iterN.hasNext()){
			
			String submissionName = (String)iterN.next();
			java.util.Date sDate = (java.util.Date)iterS.next();
			java.util.Date eDate = (java.util.Date)iterE.next();
			
						
			if(sDate.before(eDate)){
			
			Task task = new Task(submissionName,sDate,eDate);
			tsPlan.add(task);
					
			}
			else{}
			
						
			
		}
					
			tsc.add(tsPlan);//tsc.add(tsPlan);
				
			JFreeChart chart = ChartFactory.createGanttChart(missionName + "GanttProject", "Project", "Time", tsc, true, true, true);
			
			ChartRenderingInfo info = new ChartRenderingInfo(new StandardEntityCollection());
			
	
				try {
					fileName = ServletUtilities.saveChartAsPNG(chart, 500, 80+65*nameList.size(), info,session);
				} catch (IOException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
		
			
		
				try {
					ChartUtilities.writeImageMap(pw, fileName, info,true);
				} catch (IOException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
		
			
		
				try {
					rs.close();
					stmt.close();
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}		
				
		
			
			pw.flush();

		//System.out.println(fileName);
	
		return fileName;
	

	}
	
	public static String createRealGanttChart(String missionId,String missionName,HttpSession session,PrintWriter pw){
		
		String fileName = null;
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		String sql = null;
		String sql2 = null;
		
		ArrayList nameList = new ArrayList();
		ArrayList startList = new ArrayList();
		ArrayList endList = new ArrayList();
		
		conn = DB.getConnection();
		stmt = DB.getStatement(conn);
		
		
		
		sql = "select * from SQLJ.Pro_control"; // where Task_id = '" + missionId + "'";
		
		//System.out.println(sql);
		
		rs = DB.getResultSet(stmt, sql);
		
		try {
			while(rs.next()){
				
				nameList.add(rs.getString("Task_name"));
								startList.add(rs.getDate("Reality_starttime"));
				endList.add(rs.getDate("Reality_endtime"));
				
							}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		//rs = null;
		//System.out.println("over:1");
			ListIterator iterN = nameList.listIterator();
		ListIterator iterS = startList.listIterator();
		ListIterator iterE = endList.listIterator();
		
		TaskSeriesCollection tsc = new TaskSeriesCollection();
		//TaskSeries tsPlan = new TaskSeries("Plan");
		TaskSeries tsReal = new TaskSeries("Real");
		
		while(iterN.hasNext()){
			
			String submissionName = (String)iterN.next();
			java.util.Date sDate = (java.util.Date)iterS.next();
			java.util.Date eDate = (java.util.Date)iterE.next();
						
			if(sDate.before(eDate)){
			
			Task task = new Task(submissionName,sDate,eDate);
			tsReal.add(task);
					
			}
			else{}
			
			
					
						
			
		}
		
			
			tsc.add(tsReal);//tsc.add(tsPlan);
						
			JFreeChart chart = ChartFactory.createGanttChart(missionName + "GanttProject", "Project", "Time", tsc, true, true, true);
			
			ChartRenderingInfo info = new ChartRenderingInfo(new StandardEntityCollection());
			
	
				try {
					fileName = ServletUtilities.saveChartAsPNG(chart, 500, 80+65*nameList.size(), info,session);
				} catch (IOException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
		
			
		
				try {
					ChartUtilities.writeImageMap(pw, fileName, info,true);
				} catch (IOException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
		
			
		
				try {
					rs.close();
					stmt.close();
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}		
				
		
			
			pw.flush();

		//System.out.println(fileName);
	
		return fileName;
	

	}
}

我把计划任务和实际任务分开画的甘特图，所以有两个甘特图的jsp页面

PlanGantt.jsp

<%@ page language="java" import="java.util.*,java.io.*" %>
<%@ page import="com.angrybirds.DAO.ProgressControl"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>


    

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="zh-CN">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>AngryBirds</title>
<link href="css.css" rel="stylesheet" type="text/css" />
	<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">
</head>
<body>
<div class="size">
  <div class="header">
    <div class="header01">
      <div class="logo"> <img src="image/img_15.bmp" alt="" /> </div>
    </div>
    <div class="cmainimg"> <img alt="" src="image/img_73.jpg" /> </div>
    <div class="mnav"> <img class="mnimgl" src="image/img_37.jpg" alt="" /> <img class="mnimgr" src="image/img_50.jpg" alt="" />
      <div class="mnm">
        <ul>
        
        </ul>
      </div>
    </div>
  </div>
  <div class="content">
    <div class="submenu" style="left: 0px; top: 0px"> <img class="snimgl" src="image/img_96.jpg" alt="" /> <img class="snimgr" src="image/img_107.jpg" alt="" />
      <div class="subtext"> You are here:Home </div>
      <div class="subimag" style="width: 41px; height: 51px">
        <ul>
          <li>1</li>
          <li>2</li>
          <li>3</li>
        </ul>
      </div>
    </div>
    <div class="mcontent">
       <!--***************************************************************************×ó/-->

      <!--***************************************************************************ÓÒ/-->
      <div align="center"  class="mcmid3">
 <% 
    	String missionId = "1";
    	String filename = ProgressControl.createPlanGanttChart(missionId,"AllProject",session,new PrintWriter(out));
    	String graphURL = request.getContextPath() + "/servlet/DisplayChart?filename=" + filename;
    %>
    
    <img src="<%=graphURL %>" width="500" height="300" border="0" usemap="#<%=filename %>">
      </div>
      <!--***************************************************************************/-->
    </div>
  </div>
  <div class="footer"> <img class="mnimgl" src="image/img_275.jpg" alt="" /> <img class="mnimgr" src="image/img_291.jpg" alt="" /> <a href="http://www.88web.org/">HOME</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="http://www.88web.org/">ABOUT US</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="http://www.88web.org/">GALLERY</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="http://www.88web.org/">FAQ</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="http://www.88web.org/">SERVICES</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="http://www.88web.org/">CONTACT</a> <br/>
    <font color="#333333">Copyright 2009 Your Website | <a style="color: #333333" href="http://www.88web.org/css-templates/">CSS Template</a> by <a style="color: #333333" href="http://www.88web.org/">AngryBirds</a></font></div>
</div>
</body>
</html>

RealGantt.jsp

<%@ page language="java" import="java.util.*,java.io.*" pageEncoding="GBK"%>
<%@ page import="com.angrybirds.DAO.ProgressControl"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="zh-CN">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>AngryBirds</title>
<link href="css.css" rel="stylesheet" type="text/css" />
	<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">
</head>
<body>
<div class="size">
  <div class="header">
    <div class="header01">
      <div class="logo"> <img src="image/img_15.bmp" alt="" /> </div>
    </div>
    <div class="cmainimg"> <img alt="" src="image/img_73.jpg" /> </div>
    <div class="mnav"> <img class="mnimgl" src="image/img_37.jpg" alt="" /> <img class="mnimgr" src="image/img_50.jpg" alt="" />
      <div class="mnm">
        <ul>
          
        </ul>
      </div>
    </div>
  </div>
  <div class="content">
    <div class="submenu" style="left: 0px; top: 0px"> <img class="snimgl" src="image/img_96.jpg" alt="" /> <img class="snimgr" src="image/img_107.jpg" alt="" />
      <div class="subtext"> You are here:Home </div>
      <div class="subimag" style="width: 41px; height: 51px">
        <ul>
          <li>1</li>
          <li>2</li>
          <li>3</li>
        </ul>
      </div>
    </div>
    <div class="mcontent">
       <!--***************************************************************************左/-->

   
      <!--***************************************************************************右/-->
      <div align="center" class="mcmid3">
    <% 
    	String missionId = "1";
    	String filename = ProgressControl.createRealGanttChart(missionId,"AllProject",session,new PrintWriter(out));
    	String graphURL = request.getContextPath() + "/servlet/DisplayChart?filename=" + filename;
    %>
    
    <img src="<%=graphURL %>" width="500" height="300" border="0" usemap="#<%=filename %>">
      </div>
      <!--***************************************************************************/-->
    </div>
  </div>
  <div class="footer"> <img class="mnimgl" src="image/img_275.jpg" alt="" /> <img class="mnimgr" src="image/img_291.jpg" alt="" /> <a href="http://www.88web.org/">HOME</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="http://www.88web.org/">ABOUT US</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="http://www.88web.org/">GALLERY</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="http://www.88web.org/">FAQ</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="http://www.88web.org/">SERVICES</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="http://www.88web.org/">CONTACT</a> <br/>
    <font color="#333333">Copyright 2009 Your Website | <a style="color: #333333" href="http://www.88web.org/css-templates/">CSS Template</a> by <a style="color: #333333" href="http://www.88web.org/">AngryBirds</a></font></div>
</div>
</body>
</html>

此图为效果图：（由于我用的是DB2所以时间显示有点问题，如果要想甘特图有更好的显示效果可以参考API文档中相关类和方法

地址：http://www.jfree.org/jfreechart/api/javadoc/index.html）

jinseshanguang

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
用JFreeChart在jsp页面画甘特图

最近由于项目需要，需要在网页中生成甘特图，在网上浏览资料之后，最后通过JFreeChart实现了在jsp页面画甘特图。在此就与大家分享一下我的收获。首先把重要的代码粘出来供大家参考，项目源码和数据库信息表，以及参考的资料和一些资料的网址我就打包放在下面，大家可以下载后学习参考。 ProgressControl.java//完成从数据库读数据，生成...
复制链接

扫一扫

专栏目录