重庆分公司,新征程启航
为企业提供网站建设、域名注册、服务器等服务
小编给大家分享一下如何通过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+"/"; %>AngryBirds
You are here:Home
- 1
- 2
- 3
<% String missionId = "1"; String filename = ProgressControl.createPlanGanttChart(missionId,"AllProject",session,new PrintWriter(out)); String graphURL = request.getContextPath() + "/servlet/DisplayChart?filename=" + filename; %> " width="500" height="300" border="0" usemap="#<%=filename %>">HOME | ABOUT US | GALLERY | FAQ | SERVICES | CONTACT
Copyright 2009 Your Website | CSS Template by AngryBirds
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+"/"; %>AngryBirds
You are here:Home
- 1
- 2
- 3
<% String missionId = "1"; String filename = ProgressControl.createRealGanttChart(missionId,"AllProject",session,new PrintWriter(out)); String graphURL = request.getContextPath() + "/servlet/DisplayChart?filename=" + filename; %> " width="500" height="300" border="0" usemap="#<%=filename %>">HOME | ABOUT US | GALLERY | FAQ | SERVICES | CONTACT
Copyright 2009 Your Website | CSS Template by AngryBirds
此图为效果图:(由于我用的是DB2所以时间显示有点问题,如果要想甘特图有更好的显示效果可以参考API文档中相关类和方法
地址:http://www.jfree.org/jfreechart/api/javadoc/index.html)
看完了这篇文章,相信你对“如何通过JFreeChart实现在jsp页面画甘特图”有了一定的了解,如果想了解更多相关知识,欢迎关注创新互联行业资讯频道,感谢各位的阅读!