While Loop in Gantt Chart values

[Eric Tan]

the problem is in the "createDataset" method whereby i want to do a while loop where i can check the data inside the database that i just inserted. after that i want to pass in all the data that is needed to generate the Gantt Chart. can anyone help me on this?
thanks

package ericTest;
 
import java.io.BufferedReader;
import java.io.DataInputStream;
import java.io.File;
import java.io.FileReader;
import java.io.IOException;
import java.text.ParseException;
import java.util.StringTokenizer;
 
import java.util.ArrayList;
import java.util.Iterator;
 
import java.util.Calendar;
import java.util.Date;
 

import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartPanel;
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 org.jfree.ui.ApplicationFrame;
import org.jfree.ui.RefineryUtilities;
 
import com.db4o.Db4o;
import com.db4o.ObjectContainer;
import com.db4o.ObjectSet;
 
public class GanttDemo3 extends ApplicationFrame {

   public GanttDemo3(final String title) {
 
        super(title);
 
        final IntervalCategoryDataset dataset = createDataset();
        final JFreeChart chart = createChart(dataset);
 
        // add the chart to a panel...
        final ChartPanel chartPanel = new ChartPanel(chart);
        chartPanel.setPreferredSize(new java.awt.Dimension(500, 270));
        setContentPane(chartPanel);
   }
       
    public final static String filename = "C:\\KLGCC Mock Up.yap";
    
    private static ObjectContainer db;
    
    private static String day;
    private static String month;
    private static String year;
    private static String task;
    
    private static String startDate;
    private static String endDate;
    
    private static String startDay;
    private static String startMonth;
    private static String startYear;
    
    public static int startDay1;
    public static int startMonth1;
    public static int startYear1;
    
    public static String endDay;
    public static String endMonth;
    public static String endYear;
    
    public static int endDay1;
    public static int endMonth1;
    public static int endYear1;
        
    DataInputStream dis = null;
    String fileRecord = null;
        
    public void storeData() throws IOException{
    new File(filename).delete();
    db = Db4o.openFile(filename);
    
    File f = new File("C:\\KLGCC Mock Up.txt");
    FileReader fis = new FileReader(f);
    BufferedReader bis = new BufferedReader(fis);
    
    while((fileRecord = bis.readLine()) != null){
    
    StringTokenizer st = new StringTokenizer(fileRecord,",");
    
    task = st.nextToken();
    startDate = st.nextToken();
    endDate = st.nextToken();
    
    System.out.println(task+ " - " +startDate+ " - " +endDate);
    
    Country c = new Country(task, startDate, endDate);
    db.set(c);
    }
    db.close();
    }
    
    public void storeStartDate() throws ParseException{
    
    db = Db4o.openFile(filename);
    Country c = new Country();
    ObjectSet result = db.get(c);
    
    while(result.hasNext()){
    Country obj = (Country)result.next();
    String sDate = obj.getStartDate();
    
    StringTokenizer str = new StringTokenizer(sDate, "/");
    
    startMonth = str.nextToken();
    startDay = str.nextToken();
    startYear = str.nextToken();
    System.out.println(startYear);
        
    int startMonth1 = Integer.parseInt(startMonth);
    int startDay1 = Integer.parseInt(startDay);
    int startYear1 = Integer.parseInt(startYear);
    
    //startMonth1 = startMonth1 + 1;
    
    ArrayList<Integer> startDay2 = new ArrayList<Integer>();
    startDay2.add(startDay1);
    
    ArrayList<Integer> startMonth2 = new ArrayList<Integer>();
    startMonth2.add(startMonth1);
    
    ArrayList<Integer> startYear2 = new ArrayList<Integer>();
    startYear2.add(startYear1);
    
    System.out.println("Heloo" +startDay2+ "/" +startMonth2+ "/" +startYear2);
    
    
    }
    db.close();
    }
    
    
    public void storeEndDate() throws ParseException{
    
    db = Db4o.openFile(filename);
    Country c = new Country();
    ObjectSet result = db.get(c);
    
    while(result.hasNext()){
    Country obj = (Country)result.next();
    String sEndDate = obj.getEndDate();
    
    StringTokenizer str1 = new StringTokenizer(sEndDate, "/");
    
    endMonth = str1.nextToken();
    endDay = str1.nextToken();
    endYear = str1.nextToken();
        
    int endMonth1 = Integer.parseInt(endMonth);
    int endDay1 = Integer.parseInt(endDay);
    int endYear1 = Integer.parseInt(endYear);
    
    ArrayList<Integer> endDay2 = new ArrayList<Integer>();
    endDay2.add(startDay1);
    
    ArrayList<Integer> endMonth2 = new ArrayList<Integer>();
    endMonth2.add(endMonth1);
    
    ArrayList<Integer> endYear2 = new ArrayList<Integer>();
    endYear2.add(endYear1);
    
    System.out.println("END" +endDay2+ "/" +endMonth2+ "/" +endYear2);
    }
    db.close();
}
    
    public static IntervalCategoryDataset createDataset() {
    
    final TaskSeries s1 = new TaskSeries("Scheduled");
    //Country chart = new Country();
    
    ArrayList ar = new Arraylist;
    Iterator it = ar.iterator();
    while it.hasNext();{
    
    
    s1.add(new Task("abc",
               new SimpleTimePeriod(date(startDay1, startMonth1, startYear1),
                                    date(endDay1, endMonth1, endYear1))));
        
    }
                final TaskSeriesCollection collection = new TaskSeriesCollection();
        collection.add(s1);
    
        return collection;
    }
    
 
    /**
     * Utility method for creating <code>Date</code> objects.
     *
     * @param day  the date.
     * @param month  the month.
     * @param year  the year.
     *
     * @return a date.
     */
    
    private static Date date(final int day, final int month, final int year) {
 
        final Calendar calendar = Calendar.getInstance();
        calendar.set(year, month, day);
        final Date result = calendar.getTime();
        return result;
 
    }
        
    /**
     * Creates a chart.
     * 
     * @param dataset  the dataset.
     * 
     * @return The chart.
     */
    
    private JFreeChart createChart(final IntervalCategoryDataset dataset) {
        final JFreeChart chart = ChartFactory.createGanttChart(
            "Gantt Chart Demo",  // chart title
            "Task",              // domain axis label
            "Date",              // range axis label
            dataset,             // data
            true,                // include legend
            true,                // tooltips
            false                // urls
        );    
//        chart.getCategoryPlot().getDomainAxis().setMaxCategoryLabelWidthRatio(10.0f);
        return chart;    
    }
    
   
    public static void main(final String[] args) throws IOException, ParseException 
    {
 
        final GanttDemo3 demo = new GanttDemo3("Gantt Chart Demo 1");
        demo.storeData();
        demo.storeStartDate();
        demo.storeEndDate();
        demo.pack();
        RefineryUtilities.centerFrameOnScreen(demo);
        demo.setVisible(true);
 
    }
 
}