gantt charts

Hi Friend,

Take 3 fields in your database table, task,date1,date2 whose data types are varchar, date and date respectively.

Now try the following code:

import java.awt.Color;
import java.util.Date;
import java.util.Calendar;
import org.jfree.ui.ApplicationFrame;
import org.jfree.ui.RefineryUtilities;
import org.jfree.chart.ChartFactory;
import org.jfree.chart.*;
import org.jfree.chart.JFreeChart;
import org.jfree.data.category.IntervalCategoryDataset;
import org.jfree.data.gantt.Task;
import org.jfree.data.gantt.TaskSeries;
import org.jfree.data.gantt.TaskSeriesCollection;
import org.jfree.data.time.SimpleTimePeriod;
import java.sql.*;

public class GanttChartExample {

public static void main( String[] args) {
JFreeChart chart=null ;
TaskSeries schedule1 = new TaskSeries("Scheduled Tasks");
TaskSeries schedule2 = new TaskSeries("Actual Done");
Connection con = null;
String url = "jdbc:mysql://192.168.10.112:3306/";;
String db = "mysql";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db, user, pass);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM chart");
while (rs.next()) {
schedule1.add(new Task(rs.getString(1), new SimpleTimePeriod((rs.getDate(2)),(rs.getDate(3)))));

schedule2.add(new Task(rs.getString(1), new SimpleTimePeriod((rs.getDate(2)), (rs.getDate(2)))));
TaskSeriesCollection collection = new TaskSeriesCollection();
collection.add(schedule1);
collection.add(schedule2);
IntervalCategoryDataset dataset= collection;

chart = ChartFactory.createGanttChart(
"Gantt Chart Example",
"Task",
"Date",
dataset,
true,
true,
false
);
}
}
catch(Exception e){
System.out.println(e.getMessage());
}
chart.setBackgroundPaint(new Color(0xff,0xff,0xcc));
ChartFrame frame=new ChartFrame("Gantt Chart",chart);
frame.setVisible(true);
frame.setSize(400,350);
}
}
Thanks