Automatically input data into Datasets

[puk284]

Hi,
I am using JFreechart in java to create a graph of some data that i have produced using a program i have written(in java). The problem that i have is that i have to manually input the data into the dataset to create the graph. Is it possible to generate the data that will go into the dataset without having to manually input the data? if yes can someone please explain to me how i might go about it? Thank you for your help.

[switchblade327]

You can definitely do that. I will provide you a simple sample code for that. Here it is:

/**
    * Create pie chart representing percentage of employees in each department
    * that has at least one employee.
    * 
    * @return Pie chart; null if no image created.
    */
   public JFreeChart createNumberEmpsPerDeptPieChart()
   {
      JFreeChart pieChart = null;

      final String QUERY_NUMBER_EMPLOYEES_PER_DEPARTMENT =
         "SELECT departments.department_name, count(*) AS num_employees " +
           "FROM departments, employees " +
          "WHERE employees.department_id = departments.department_id " +
       "GROUP BY departments.department_name";

      final String TITLE_EMPS_PER_DEPT = “Employees Per Department”;

      try
      {
         PieDataset pieDataset =
            new JDBCPieDataset( databaseAccess.getOracleDbConnection(),
                                QUERY_NUMBER_EMPLOYEES_PER_DEPARTMENT );

         pieChart =
            ChartFactory.createPieChart( TITLE_EMPS_PER_DEPT, // chart title
                                         pieDataset,
                                         true,      // legend displayed
                                         true,      // tooltips displayed
                                         false );   // no URLs

      }
      catch (SQLException sqlEx)    // checked exception
      {
         System.err.println("Error trying to acquire JDBCPieDataset.");
         System.err.println("Error Code: " + sqlEx.getErrorCode());
         System.err.println("SQLSTATE:   " + sqlEx.getSQLState());
         sqlEx.printStackTrace();
      }

      return pieChart;
   }

[Zecho]

Though I am not much into Java but in .net, I think it is not possible to make such thing that will automatically input data into your datasets. As it is, manually inputting of data is better for proper functioning.

[Pragmatic]

Yes, it is definitely possible. I think you would have tried the suggestion of switchblade327.