如何通过JFreeChart实现在jsp页面画甘特图

本文讲解"怎么通过JFreeChart实现在jsp页面画甘特图",希望能够解决您遇到的有关问题,下面我们来看这篇 "怎么通过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">        <!--***************************************************************************&times;&oacute;/-->        <!--***************************************************************************&Oacute;&Ograve;/-->       <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)

如何通过JFreeChart实现在jsp页面画甘特图

关于 "怎么通过JFreeChart实现在jsp页面画甘特图" 就介绍到这。希望大家多多支持编程宝库

如何使用JFreeChart实现折线图:本文讲解"怎么使用JFreeChart实现折线图",希望能够解决您遇到的有关问题,下面我们来看这篇 "怎么使用JFreeChart实现折线图" 文章。折线图,大可分为两种,(1)X轴值类型为Strin ...