local.Statistics.MostSellCars.java Source code

Introduction

Here is the source code for local.Statistics.MostSellCars.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package local.Statistics;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import local.DAO.Graficas_DAO;
import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartFrame;
import org.jfree.chart.JFreeChart;
import org.jfree.data.general.DefaultPieDataset;

/**
 *
 * @author Gustavo Hernandez
 */
public class MostSellCars {

    /**
     * @param args the command line arguments
     */
    public static void carrosMasVendidos() {
        Graficas_DAO gr = new Graficas_DAO();
        //obtencion de datos
        ResultSet rs = gr.getgraficaautomas();

        try {
            String nameAuto;
            int quantitySales;
            Object[] fila = new Object[3];
            DefaultPieDataset data = new DefaultPieDataset();
            while (rs.next()) {

                nameAuto = rs.getString(3);
                quantitySales = rs.getInt(1);
                data.setValue(nameAuto, quantitySales);
            }
            JFreeChart chart = ChartFactory.createPieChart("GRAFICAS AUTOS MAS VENDIDOS", data, true, true, false);
            ChartFrame frame = new ChartFrame("Autos mas vendidos", chart);
            frame.pack();
            frame.setVisible(true);

            rs.close();
            gr.close();
        } catch (SQLException ex) {
            Logger.getLogger(MostSellCars.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
}