import java.sql.*;
import java.io.*;
import org.jfree.data.category.DefaultCategoryDataset;
import org.jfree.chart.ChartFactory;
import org.jfree.chart.plot.PlotOrientation;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.ChartUtilities;

public class nummer2 {

        public static void main(String[] args) throws Exception{

                //SQL-query ohne abschließendes ';'
                String sqlquery =
                        "select to_char(aoldata.querydata.querytime,'DD.MM') as Tag,"
                        + " count(to_char(aoldata.querydata.querytime,'DD.MM')) as Anzahl"
                        + " from aoldata.querydata where aoldata.querydata.query like '%flood%'"
                        + " group by to_char(aoldata.querydata.querytime,'DD.MM')"
                        + " having count(to_char(aoldata.querydata.querytime,'DD.MM')) > 75"
                        + " order by Anzahl DESC";

                Class.forName ("oracle.jdbc.OracleDriver");
                Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:oracle", "dein_db_user", "dein_db_pw");
                DefaultCategoryDataset my_bar_chart_dataset = new DefaultCategoryDataset();
                Statement stmt = conn.createStatement();
                try {
                        ResultSet query_set = stmt.executeQuery(sqlquery);
                        while (query_set.next()) {
                                String date = query_set.getString("Tag");
                                int anzahl = query_set.getInt("Anzahl");
                                my_bar_chart_dataset.addValue(anzahl,"Anzahl",date);
                                }
                JFreeChart BarChartObject=ChartFactory.createBarChart("Die meisten Fluten Maerz-Mai","Datum","Anzahl Fluten",my_bar_chart_dataset,PlotOrientation.VERTICAL,true,true,false);
                query_set.close();
                stmt.close();
                conn.close();
                int width=1920; // bildbreite
                int height=1080; // bildhöhe
                File BarChart=new File("nummer2.png");
                ChartUtilities.saveChartAsPNG(BarChart,BarChartObject,width,height);
                }
                 catch (Exception i)
                 {
            System.out.println(i);
                 }

        }
}