package DB03;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;
import java.sql.ResultSet;
import DB03.StatmentsSQL;



public class DB_Connection {

	final static String URL = "jbc:oracle:thin:@localhost:1521:oracle";
	final static String DBNAME = "gummiente";
	final static String USER = "KOTMAN";
	final static String PASSWORD = "*********";
	final static String DRIVER = "com.oracle.jdbc.Driver";

	public static void main(String[]args){

		System.out.println("Frage 1");
        Question();
        System.out.println("\n" + "Frage 2:");
        Question2();
        System.out.println("\n" + "Frage 3:");
        Question3();
        System.out.println("\n" + "Frage 4:");
        Question4();
        System.out.println("\n" + "Frage 5:");
        Question5();
        System.out.println("\n" + "Frage 6:");
        Question6();
        System.out.println("\n" + "Frage 7:");
        Question7();
        System.out.println("\n" + "Frage 8:");
        Question8();
        System.out.println("\n" + "Frage 9:");
        Question9();
        System.out.println("\n" + "Frage 10:");
        Question10();

	}//Main-Methode

	public static HashMap<Integer,Integer> Question8(){
		try {
            Connection con = DriverManager.getConnection(URL, USER, PASSWORD);

            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(StatementsSQL.stmF8());
            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;
        }
	}//Methode HashMap Question8

}//Class DB-Connection