1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
|
// Create and populate a CategoryDataset
DefaultCategoryDataset dataset = new DefaultCategoryDataset();
int nombre_pieces=0;
String reg="";
double mont_total;
while (rs.next()){
nombre_pieces=rs.getInt("nombre_pieces");
reg=rs.getString("reg");
mont_total=rs.getDouble("mont_total");
dataset.addValue(nombre_pieces, "Nombre de pieces", reg);
dataset.addValue(mont_total/1000, "Montant", reg);
}
// Create the chart object
CategoryAxis categoryAxis = new CategoryAxis("Directions Regionales");
ValueAxis valueAxis = new NumberAxis("");
BarRenderer3D renderer = new BarRenderer3D();
renderer.setBaseItemLabelsVisible(true);
renderer.setItemURLGenerator(new StandardCategoryURLGenerator("xy_chart.jsp","series","section"));
renderer.setToolTipGenerator(new StandardCategoryToolTipGenerator());
Plot plot = new CategoryPlot(dataset, categoryAxis, valueAxis, renderer);
JFreeChart chart = new JFreeChart("Depenses Publiques", JFreeChart.DEFAULT_TITLE_FONT, plot, true);
chart.setBackgroundPaint(Color.white);
ChartRenderingInfo info = new ChartRenderingInfo(new StandardEntityCollection());
String filename = ServletUtilities.saveChartAsPNG(chart, 500, 300, info, session);
String graphURL = request.getContextPath() + "/servlet/DisplayChart?filename=" + filename; |
Partager