package datenbanken2;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.sql.*;

import oracle.jdbc.pool.OracleDataSource;

public class connect {

	public static void main(String[] args) {
		BufferedReader in = new BufferedReader(new InputStreamReader(System.in));

		// Variable für die Switchcase
		int a;
		//int b;


		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");

			// connection mit der DB
			Connection con = DriverManager.getConnection("jdbc:oracle:thin:@schelling.nt.fh-koeln.de:1521:xe",
					"dbprak22", "dbprak22");

			// Anweisung für die SwitchCase
			System.out.println("(1) Ausgabe aller Rohstoffe");
			System.out.println("(2) Ausgabe aller Produkt:");
			a = Integer.parseInt(in.readLine());
			switch (a) {

			case 1:
				System.out.println("Ausgabe aller Rohstoffe");
				// create a statement
				Statement st = con.createStatement();
				ResultSet mySt = st.executeQuery("select * from Rohstoff");

				// ausgabe des Rohstoff + Nr + Bez + Menge + Preis
				while (mySt.next()) {
					System.out.println(mySt.getString("ROHNR") + " " + mySt.getString("ROHBEZ") + " "
							+ mySt.getString("RMGE") + " " + mySt.getString("PREISME"));
				}
				break;
			case 2:
				System.out.println("Ausgabe aller Produkte:");
				// create Statement
				Statement prod = con.createStatement();
				// Statement ausführen - executeQuery
				ResultSet myProd = prod.executeQuery("select * from Produkt");
				// same wie bei Rohstoff
				while (myProd.next()) {
					System.out.println(myProd.getString("PRODUKTNR") + " " + myProd.getString("PRODNAM") + " "
							+ myProd.getString("PREIS") + " " + myProd.getString("PRODGR"));
				}
				break;
			//case 4:
				//Statement prod = con.createStatement();

			}
		}

		catch (Exception e) {
			System.out.println(e);
		}
	}
}