Example usage for org.jfree.data.category DefaultCategoryDataset addValue

List of usage examples for org.jfree.data.category DefaultCategoryDataset addValue

Introduction

In this page you can find the example usage for org.jfree.data.category DefaultCategoryDataset addValue.

Prototype

public void addValue(double value, Comparable rowKey, Comparable columnKey) 

Source Link

Document

Adds a value to the table.

Usage

From source file:tp1.G_AdminStats.java

private void formWindowGainedFocus(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowGainedFocus
    // TODO add your handling code here:
    Map<String, Integer> att = new HashMap<String, Integer>();
    DefaultTableModel model = (DefaultTableModel) tab3.getModel();
    model.setRowCount(0);/*from  w  w w.  j a  va 2 s. co m*/
    try {
        Class.forName("java.sql.DriverManager");
        Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/projectbuy",
                "root", "null");
        Statement stmt = (Statement) con.createStatement();
        String query = "SELECT usr, count(DISTINCT Datee) FROM attendence GROUP BY usr;";
        ResultSet rs = stmt.executeQuery(query);
        while (rs.next()) {
            String a = rs.getString(1);
            String b = rs.getString(2);
            model.addRow(new Object[] { a, b });
            att.put(a, Integer.parseInt(b));
        }
    } catch (Exception e) {
        JOptionPane.showMessageDialog(this, e.getMessage());
    }

    DefaultCategoryDataset dataset = new DefaultCategoryDataset();
    for (Map.Entry<String, Integer> entry : att.entrySet()) {
        dataset.addValue(entry.getValue(), "series1", entry.getKey());
    }

    JFreeChart chart = ChartFactory.createBarChart("Attendence", "Admin Name", "Days Present", dataset,
            PlotOrientation.VERTICAL, false, true, false);
    try {
        BufferedImage chartImage = chart.createBufferedImage(800, 300, null);
        labelGraph.setIcon(new javax.swing.ImageIcon(chartImage));
    } catch (Exception e) {
        System.out.println(e.getMessage());
    }
}

From source file:co.udea.edu.proyectointegrador.gr11.parqueaderoapp.domain.stadistics.graphics.implement.Grafica.java

private DefaultCategoryDataset createDataForVehicleType(List<TipoVehiculoEstadistica> tipoVehiculos) {
    DefaultCategoryDataset dataset = new DefaultCategoryDataset();
    for (TipoVehiculoEstadistica tipoVehiculo : tipoVehiculos) {
        dataset.addValue(tipoVehiculo.getNumeroDeIngresos(), UNIQUE_SERIE_TO_VEHICLE,
                tipoVehiculo.getTipoVehiculo().getTipoVehiculoDescripcion());
    }/*from  w  w  w. j  a  v a  2s.  co  m*/
    return dataset;
}

From source file:de.fub.maps.project.plugins.tasks.eval.OverviewChart.java

private void handle(String name, RoadNetworkProcess roadNetworkProcess) {
    if (roadNetworkProcess != null && roadNetworkProcess.getResult() != null) {
        RoadNetwork roadNetwork = roadNetworkProcess.getResult();

        CategoryDataset dataSet = barchart1.getPlot().getDataset(0);
        if (dataSet instanceof DefaultCategoryDataset) {
            DefaultCategoryDataset categoryDataset = (DefaultCategoryDataset) dataSet;
            categoryDataset.addValue(roadNetwork.getTotalRoadLength(), name,
                    Statistics.PROP_NAME_TOTAL_ROAD_LENGTH);
            categoryDataset.addValue(roadNetwork.getAverageRoadLength(), name,
                    Statistics.PROP_NAME_AVERAGE_ROAD_LENGTH);
            categoryDataset.addValue(null, name, Statistics.PROP_NAME_TOTAL_NUMBER_OF_ROADS);

            categoryDataset.addValue(null, name, Statistics.PROP_NAME_TOTAL_NUMBER_OF_INTERSECTIONS);
        }//from   w  ww . j  a  va 2s  .  c  o m

        dataSet = barchart1.getPlot().getDataset(1);
        if (dataSet instanceof DefaultCategoryDataset) {
            DefaultCategoryDataset categoryDataset = (DefaultCategoryDataset) dataSet;
            categoryDataset.addValue(null, name, Statistics.PROP_NAME_TOTAL_ROAD_LENGTH);
            categoryDataset.addValue(null, name, Statistics.PROP_NAME_AVERAGE_ROAD_LENGTH);
            categoryDataset.addValue(roadNetwork.getRoadCount(), name,
                    Statistics.PROP_NAME_TOTAL_NUMBER_OF_ROADS);

            categoryDataset.addValue(roadNetwork.getIntersectionCount(), name,
                    Statistics.PROP_NAME_TOTAL_NUMBER_OF_INTERSECTIONS);
        }
    }
}

From source file:org.jfree.data.category.SlidingCategoryDatasetTest.java

/**
 * Confirm that cloning works./* w w w .j a v  a  2 s  .c om*/
 */
@Test
public void testCloning() throws CloneNotSupportedException {
    DefaultCategoryDataset u1 = new DefaultCategoryDataset();
    u1.addValue(1.0, "R1", "C1");
    u1.addValue(2.0, "R1", "C2");
    SlidingCategoryDataset d1 = new SlidingCategoryDataset(u1, 0, 5);
    SlidingCategoryDataset d2;
    d2 = (SlidingCategoryDataset) d1.clone();
    assertTrue(d1 != d2);
    assertTrue(d1.getClass() == d2.getClass());
    assertTrue(d1.equals(d2));

    // basic check for independence
    u1.addValue(3.0, "R1", "C3");
    assertFalse(d1.equals(d2));
    DefaultCategoryDataset u2 = (DefaultCategoryDataset) d2.getUnderlyingDataset();
    u2.addValue(3.0, "R1", "C3");
    assertTrue(d1.equals(d2));
}

From source file:com.sami.chart.util.LineChartDemo1.java

/**
 * Creates a sample dataset.//from  w ww.ja va 2 s.  co  m
 * 
 * @return The dataset.
 */
private CategoryDataset createDataset() {

    // row keys...
    final String series1 = "First";
    final String series2 = "Second";
    final String series3 = "Third";

    // column keys...
    final String type1 = "Type 1";
    final String type2 = "Type 2";
    final String type3 = "Type 3";
    final String type4 = "Type 4";
    final String type5 = "Type 5";
    final String type6 = "Type 6";
    final String type7 = "Type 7";
    final String type8 = "Type 8";

    // create the dataset...
    final DefaultCategoryDataset dataset = new DefaultCategoryDataset();

    dataset.addValue(1.0, series1, type1);
    dataset.addValue(4.0, series1, type2);
    dataset.addValue(3.0, series1, type3);
    dataset.addValue(5.0, series1, type4);
    dataset.addValue(5.0, series1, type5);
    dataset.addValue(7.0, series1, type6);
    dataset.addValue(7.0, series1, type7);
    dataset.addValue(8.0, series1, type8);

    dataset.addValue(5.0, series2, type1);
    dataset.addValue(7.0, series2, type2);
    dataset.addValue(6.0, series2, type3);
    dataset.addValue(8.0, series2, type4);
    dataset.addValue(4.0, series2, type5);
    dataset.addValue(4.0, series2, type6);
    dataset.addValue(2.0, series2, type7);
    dataset.addValue(1.0, series2, type8);

    dataset.addValue(4.0, series3, type1);
    dataset.addValue(3.0, series3, type2);
    dataset.addValue(2.0, series3, type3);
    dataset.addValue(3.0, series3, type4);
    dataset.addValue(6.0, series3, type5);
    dataset.addValue(3.0, series3, type6);
    dataset.addValue(4.0, series3, type7);
    dataset.addValue(3.0, series3, type8);

    return dataset;

}

From source file:org.jfree.data.category.junit.CategoryToPieDatasetTest.java

/**
 * Some checks for the getValue() method.
 *//*from   w w w .  j a va  2s  .  c o m*/
public void testGetValue() {
    DefaultCategoryDataset underlying = new DefaultCategoryDataset();
    underlying.addValue(1.1, "R1", "C1");
    underlying.addValue(2.2, "R1", "C2");
    CategoryToPieDataset d1 = new CategoryToPieDataset(underlying, TableOrder.BY_ROW, 0);
    assertEquals(d1.getValue("C1"), new Double(1.1));
    assertEquals(d1.getValue("C2"), new Double(2.2));

    // check negative index throws exception
    try {
        /* Number n = */ d1.getValue(-1);
        fail("Expected IndexOutOfBoundsException.");
    } catch (IndexOutOfBoundsException e) {
        // this is expected
    }

    // check index == getItemCount() throws exception
    try {
        /* Number n = */ d1.getValue(d1.getItemCount());
        fail("Expected IndexOutOfBoundsException.");
    } catch (IndexOutOfBoundsException e) {
        // this is expected
    }

    // test null source
    CategoryToPieDataset p1 = new CategoryToPieDataset(null, TableOrder.BY_COLUMN, 0);
    try {
        /* Number n = */ p1.getValue(0);
        fail("Expected IndexOutOfBoundsException.");
    } catch (IndexOutOfBoundsException e) {
        // this is expected
    }
}

From source file:org.jfree.data.category.junit.CategoryToPieDatasetTest.java

/**
 * Some checks for the getKey(int) method.
 *///from www  .j a  va  2  s. c om
public void testGetKey() {
    DefaultCategoryDataset underlying = new DefaultCategoryDataset();
    underlying.addValue(1.1, "R1", "C1");
    underlying.addValue(2.2, "R1", "C2");
    CategoryToPieDataset d1 = new CategoryToPieDataset(underlying, TableOrder.BY_ROW, 0);
    assertEquals(d1.getKey(0), "C1");
    assertEquals(d1.getKey(1), "C2");

    // check negative index throws exception
    try {
        /* Number n = */ d1.getKey(-1);
        fail("Expected IndexOutOfBoundsException.");
    } catch (IndexOutOfBoundsException e) {
        // this is expected
    }

    // check index == getItemCount() throws exception
    try {
        /* Number n = */ d1.getKey(d1.getItemCount());
        fail("Expected IndexOutOfBoundsException.");
    } catch (IndexOutOfBoundsException e) {
        // this is expected
    }

    // test null source
    CategoryToPieDataset p1 = new CategoryToPieDataset(null, TableOrder.BY_COLUMN, 0);
    try {
        /* Number n = */ p1.getKey(0);
        fail("Expected IndexOutOfBoundsException.");
    } catch (IndexOutOfBoundsException e) {
        // this is expected
    }
}

From source file:org.jfree.data.category.SlidingCategoryDatasetTest.java

/**
 * Some checks for the getColumnIndex() method.
 *//*from  w  ww.jav a  2 s  .com*/
@Test
public void testGetColumnIndex() {
    DefaultCategoryDataset underlying = new DefaultCategoryDataset();
    underlying.addValue(1.0, "R1", "C1");
    underlying.addValue(2.0, "R1", "C2");
    underlying.addValue(3.0, "R1", "C3");
    underlying.addValue(4.0, "R1", "C4");
    SlidingCategoryDataset dataset = new SlidingCategoryDataset(underlying, 1, 2);
    assertEquals(-1, dataset.getColumnIndex("C1"));
    assertEquals(0, dataset.getColumnIndex("C2"));
    assertEquals(1, dataset.getColumnIndex("C3"));
    assertEquals(-1, dataset.getColumnIndex("C4"));
}

From source file:org.jfree.data.category.SlidingCategoryDatasetTest.java

/**
 * Some checks for the getRowIndex() method.
 *//*from  w w w . j a v  a  2 s.  c om*/
@Test
public void testGetRowIndex() {
    DefaultCategoryDataset underlying = new DefaultCategoryDataset();
    underlying.addValue(1.0, "R1", "C1");
    underlying.addValue(2.0, "R2", "C1");
    underlying.addValue(3.0, "R3", "C1");
    underlying.addValue(4.0, "R4", "C1");
    SlidingCategoryDataset dataset = new SlidingCategoryDataset(underlying, 1, 2);
    assertEquals(0, dataset.getRowIndex("R1"));
    assertEquals(1, dataset.getRowIndex("R2"));
    assertEquals(2, dataset.getRowIndex("R3"));
    assertEquals(3, dataset.getRowIndex("R4"));
}

From source file:pdfboxtest.HistandVolChart.java

public File chart(String ticker, int numberOfYears) throws Exception {
    BufferedReader reader = null;
    String splitBy = ",";
    String line;//from w w w. j  ava  2s  .c  om
    double stockPrice;
    File file = new File(
            "C:\\Users\\Matthew\\Documents\\NetBeansProjects\\TradingData\\ticker\\" + ticker + ".data");
    reader = new BufferedReader(new FileReader(file));

    DefaultCategoryDataset stockDataSet = new DefaultCategoryDataset();
    while (reader.readLine() != null) {
        line = reader.readLine();
        String[] stockData = line.split(splitBy);
        stockPrice = Double.parseDouble(stockData[0]);
        stockDataSet.addValue(stockPrice, ticker, line);
    }

    JFreeChart chartObject = ChartFactory.createLineChart(null, null, null, stockDataSet,
            PlotOrientation.VERTICAL, false, false, false);
    int width = 300;
    int height = 200;
    File chart = new File("C:\\Users\\Matthew\\Documents\\NetBeansProjects\\PDFBoxTest\\" + ticker + ".jpg");
    ChartUtilities.saveChartAsJPEG(chart, chartObject, width, height);
    return chart;
}