package application;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.HashMap;
import application.SQL_Statements;


public class DBconnectFrage6 {
      final String DBNAME = "test";
      final String URL = "jdbc:oracle:thin:@localhost:1521:oracle";
      final String USER = "NOERENBERG";
      final String PASSWORD = "0soll.5w1k1";
      final String DRIVER = "com.oracle.jdbc.Driver";


      public static void main(String[] args) {

          System.out.println("Frage 6");
          Frage6();
          System.out.println("\n" + "Frage 6:");
          Frage6();
      }


          // Aufruf der Werte der SQL - Statements für Frage 6
          public static HashMap<Integer,Integer> Frage6() {
              try {
                  Connection con = DriverManager.getConnection(URL, USER, PASSWORD);

                  Statement stmt = con.createStatement();
                  ResultSet rs = stmt.executeQuery(SQL_Statements.stmF6());
                  int i = 0;
                  //Key = id , Value = ANZ
                  HashMap<Integer, Integer> dbValues = new HashMap<Integer, Integer>();
                  while (rs.next() && i < 11) {
                      int Anonid = rs.getInt("anonid");
                      int ANZ = rs.getInt("ANZ");
                      dbValues.put(Anonid, ANZ);

                      System.out.println(Anonid + " | " + ANZ + "| ");
                      i++;
                  }
                  return dbValues;
              } catch (SQLException err) {
                  System.out.println(err.getMessage());
                  return null;
              }
   }
}