zagdoudi
|
Bonjour,
je fait une base de donnée avec mysql
j'ai une table opération(nom,date_debut,date_fin)
je fait un diagramme de gantt avec java pour voir les différents taches à réaliser
j'utilise jfreechart et ca marche bien
mon probleme de réaliser un diagramme à partir d'une requete mysql
le requete est select * from opération;
le code est le suivant
package gpao;
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;
public class GanttDemo1 extends ApplicationFrame {
public GanttDemo1(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(800, 800));
setContentPane(chartPanel);
}
public static IntervalCategoryDataset createDataset() {
final TaskSeries s1 = new TaskSeries("Prévu");
s1.add(new Task("argent-kilani",
new SimpleTimePeriod(date(1, Calendar.JUNE, 2010, 8),
date(1, Calendar.JUNE, 2010, 9))));
s1.add(new Task("argent-besma",
new SimpleTimePeriod(date(1, Calendar.JUNE, 2010, 8),
date(1, Calendar.JUNE, 2010, 9))));
s1.add(new Task("marron-khaled",
new SimpleTimePeriod(date(1, Calendar.JUNE, 2010, 8),
date(1, Calendar.JUNE, 2010, 9))));
s1.add(new Task("vernis-slah",
new SimpleTimePeriod(date(1, Calendar.JUNE, 2010, 8),
date(1, Calendar.JUNE, 2010, 10))));
s1.add(new Task("controle visuel-saber",
new SimpleTimePeriod(date(1, Calendar.JUNE, 2010, 10),
date(1, Calendar.JUNE, 2010, 12))));
s1.add(new Task("carbone",
new SimpleTimePeriod(date(1, Calendar.JUNE, 2010, 8),
date(1, Calendar.JUNE, 2010, 13))));
s1.add(new Task("test-electrique",
new SimpleTimePeriod(date(1, Calendar.JUNE, 2010, 10),
date(1, Calendar.JUNE, 2010, 12))));
s1.add(new Task("decoupe-jamel",
new SimpleTimePeriod(date(1, Calendar.JUNE, 2010, 9),
date(1, Calendar.JUNE, 2010, 11))));
s1.add(new Task("sodure",
new SimpleTimePeriod(date(1, Calendar.JUNE, 2010, 13),
date(1, Calendar.JUNE, 2010, 14))));
s1.add(new Task("montage diode led-maher",
new SimpleTimePeriod(date(1, Calendar.JUNE, 2010, 12),
date(1, Calendar.JUNE, 2010, 15))));
s1.add(new Task("sertisage-hana",
new SimpleTimePeriod(date(1, Calendar.JUNE, 2010, 12),
date(1, Calendar.JUNE, 2010, 13))));
s1.add(new Task("test de fonctionnement-rihem",
new SimpleTimePeriod(date(1, Calendar.JUNE, 2010, 12),
date(1, Calendar.JUNE, 2010,14))));
s1.add(new Task("test de qualité-imen",
new SimpleTimePeriod(date(1, Calendar.JUNE, 2010, 14),
date(1, Calendar.JUNE, 2010, 16))));
final TaskSeries s2 = new TaskSeries("Actual");
s2.add(new Task("assemblage",
new SimpleTimePeriod(date(1, Calendar.JUNE, 2010, 20),
date(1, Calendar.JUNE, 2010, 22))));
final TaskSeriesCollection collection = new TaskSeriesCollection();
collection.add(s1);
collection.add(s2);
return collection;
}
private static Date date(final int day, final int month, final int year,final int hourofday) {
final Calendar calendar = Calendar.getInstance();
calendar.set(year, month, day, hourofday, month);
final Date result = calendar.getTime();
return result;
}
private JFreeChart createChart(final IntervalCategoryDataset dataset) {
final JFreeChart chart = ChartFactory.createGanttChart(
" diagramme de Gantt", // chart title
"opération-opérateur", // domain axis label
"Date", // range axis label
dataset, // data
true, // include legend
true, // tooltips
true // urls
);
// chart.getCategoryPlot().getDomainAxis().setMaxCategoryLabelWidthRatio(10.0f);
return chart;
}
public static void main(final String[] args) {
final GanttDemo1 demo = new GanttDemo1("diagramme de Gantt");
demo.pack();
RefineryUtilities.centerFrameOnScreen(demo);
demo.setVisible(true);
}
}
merci tout le monde
|