a03 - Verbindung zur DB

package DBa03;

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 DBa03.StatementsSQL;

public class DB_Verbindung {

	final static String URL = "jdbc:oracle:thin:@localhost:1521:oracle";
	final static String DBNAME = "nicole";
	final static String USER = "zimmermann";
	final static String PASSWORD = "nicki24";
	final static String DRIVER = "com.oracle.jdbc.Driver";

	public static void main(String[] args) {

		System.out.println("Frage 8");
		Frage8();
		System.out.println("\n" + "Frage 9:");
		Frage9();
		System.out.println("\n" + "Frage 10:");
		Frage10();
	}

	// Aufruf der Werte der SQL - Statements für Frage 8
	public static HashMap<Integer,Integer> Frage8() {
		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;
		}
	}

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

			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(StatementsSQL.stmF9());
			HashMap<String, Integer> dbValues = new HashMap<String, Integer>();
			while (rs.next()) {
				int query_Anzahl = rs.getInt("Query_Anzahl");
				String datum = rs.getString("Datum");
				dbValues.put(datum, query_Anzahl);

				System.out.println(datum + " | " + query_Anzahl + "| ");
			}
			return dbValues;

		} catch (SQLException err) {
			System.out.println(err.getMessage());
			return null;
		}
	}

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

			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(StatementsSQL.stmF10());
			HashMap<Integer, Integer> dbValues = new HashMap<Integer, Integer>();
			while (rs.next()) {
				int SN_Querys = rs.getInt("SN_Querys");
				int G_Querys = rs.getInt("G_Querys");
				dbValues.put(SN_Querys, G_Querys);

				System.out.println(SN_Querys + " | " + G_Querys + "| ");
			}
			return dbValues;

		} catch (SQLException err) {
			System.out.println(err.getMessage());
			return null;
		}
	}
}