| 12
 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