package database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DatabaseHandler {
    Connection con;
    public DatabaseHandler()
    {
        try {
            try {
                Class.forName("com.mysql.jdbc.Driver").newInstance();
            } catch (InstantiationException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (IllegalAccessException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            String url = "jdbc:mysql://mysql.stud.ntnu.no/byhring_restaura";
            String user = "byhring_restaura";
            String pw = "passwd";
            System.out.println("jeg kommer hit!");
            con = DriverManager.getConnection(url,user,pw);
            System.out.println("jeg kommer ikke hit!");
            System.out.println("Tilkoblingen fungerte.");
        } catch (SQLException ex) {
            System.out.println("Tilkobling feilet: "+ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("Feilet under driverlasting: "+ex.getMessage());
        } finally {
            try {
                if (con !=  null) con.close();
            } catch (SQLException ex) {
                System.out.println("Epic fail: "+ex.getMessage());
            }
        }
    }
    public String hentKundeNavnMedNr(int kundeNr)
    {
        String navn = "";
        try {
            Statement st = con.createStatement();
            st.executeQuery("SELECT * FROM Kunde WHERE nr = " + kundeNr);
            ResultSet rs = st.executeQuery("SELECT * FROM Kunde WHERE nr = " + kundeNr);
            rs.next();
            navn = rs.getString("fornavn") + rs.getString("etternavn");
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        return navn;
    }
}