Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class MySQLConnection{
- private static Connection con = null;
- private static String dbHost = "localhost"; // Hostname
- private static String dbPort = "3306"; // Port -- Standard: 3306
- private static String dbName = "db_ausbildung"; // Datenbankname
- private static String dbUser = "root"; // Datenbankuser
- private static String dbPass = ""; // Datenbankpasswort
- private MySQLConnection(){
- try {
- Class.forName("com.mysql.jdbc.Driver"); // Datenbanktreiber für JDBC Schnittstellen laden.
- // Verbindung zur JDBC-Datenbank herstellen.
- con = DriverManager.getConnection("jdbc:mysql://"+dbHost+":"+ dbPort+"/"+dbName+"?"+"user="+dbUser+"&"+"password="+dbPass);
- } catch (ClassNotFoundException e) {
- System.out.println("Treiber nicht gefunden");
- } catch (SQLException e) {
- System.out.println("Verbindung nicht moglich");
- System.out.println("SQLException: " + e.getMessage());
- System.out.println("SQLState: " + e.getSQLState());
- System.out.println("VendorError: " + e.getErrorCode());
- }
- }
- private static Connection getInstance(){
- if(con == null)
- new MySQLConnection();
- return con;
- }
- //Gebe Tabelle in die Konsole aus
- public static void printNameList(){
- con = getInstance();
- if(con != null){
- // Abfrage-Statement erzeugen.
- Statement query;
- try {
- query = con.createStatement();
- // Tabelle anzeigen
- String sql =
- "SELECT ID, KW, Fach, Stunden FROM tbl_ausbildung";
- ResultSet result = query.executeQuery(sql);
- double infost24 = 0;
- double mmst24 = 0;
- double infost25 = 0;
- double mmst25 = 0;
- // Ergebnisstabelle durchforsten
- while (result.next()) {
- String id = result.getString("ID");
- String kw = result.getString("KW");
- String fach = result.getString("Fach");
- String stunden = result.getString("Stunden");
- String info = id + ", " + kw + ", " + fach + ", " + stunden;
- if(kw.equals("24"))
- {
- if(fach.equals("Informatik"))
- {
- Double istunden = Double.parseDouble(stunden);
- infost24 = infost24 + istunden;
- }
- else
- {
- Double istunden = Double.parseDouble(stunden);
- mmst24 = mmst24 + istunden;
- }
- }
- else
- {
- if(fach.equals("Informatik"))
- {
- Double istunden = Double.parseDouble(stunden);
- infost25 = infost25 + istunden;
- }
- else
- {
- Double istunden = Double.parseDouble(stunden);
- mmst25 = mmst25 + istunden;
- }
- }
- System.out.println(info);
- }
- raumauslastung(infost24, infost25, mmst24, mmst25);
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
- private static void raumauslastung(Double IStunde1, Double IStunde2, Double IStunde3, Double IStunde4)
- {
- System.out.println("Stundenauslatung Informatik der 24KW (in %): " + IStunde1/40*100);
- System.out.println("Stundenauslatung Multimedia der 24KW (in %): " + IStunde3/40*100);
- System.out.println("Stundenauslatung Informatik der 25KW (in %): " + IStunde2/40*100);
- System.out.println("Stundenauslatung Multimedia der 25KW (in %): " + IStunde4/40*100);}
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement