JFreeChart最佳实践：甘特图-51CTO.COM

最近由于项目需要，需要在网页中生成甘特图，在网上浏览资料之后，***通过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）

原文链接：http://769672133.iteye.com/blog/1015897

【编辑推荐】