Officebar.java 文件源码

@SuppressWarnings({ "unchecked", "rawtypes" })
private ObservableList<XYChart.Series<String, Double>> getChartData() {
       double aValue = 0;
       ObservableList<XYChart.Series<String, Double>> answer = FXCollections.observableArrayList();
       Series<String, Double> aSeries = new Series<String, Double>();
       aSeries.setName("dates");

       String qcount= "SELECT date, COUNT(date) FROM  officeentry GROUP BY date";
    DBConnect.connect();
    try 
    {
        ResultSet rec = DBConnect.stmt.executeQuery(qcount);
        while(rec.next())
        {
            String date = rec.getString("date");
            int count= rec.getInt("COUNT(date)");
            aSeries.getData().add(new XYChart.Data(date, count));
            aValue = aValue + Math.random() - .5;
        }

    } catch (SQLException e) 
    {
        ErrorMessage.display("SQL Error", e.getMessage()+"\n error");
        e.printStackTrace();
    }

       answer.addAll(aSeries);
       return answer;
   }