package nkotb;

import java.util.Scanner;
import java.sql.*;


public class Bank {

    public static void main(String[] args) {

        String url = "jdbc:mysql://localhost:3306/nkotb";
        String user = "root";
        String password = "1337";
        Scanner userInput = new Scanner(System.in);

        System.out.println("Användarnamn:");
        String loginUsername = userInput.next();
        System.out.println("Lösenord:");
        String loginPassword = userInput.next();

        try {
            //1. Connection till mysql
            Connection Conn = DriverManager.getConnection(url, user, password);
            //2. Skapa ett statement
            Statement stmt = Conn.createStatement();
            //3. Kör sql-query
            ResultSet rs = stmt.executeQuery("SELECT * FROM employeeinfo");
            //4. Result set
            while (rs.next()){
                rs.getString("surname"))
            }

        }
        catch (Exception exc){
        exc.printStackTrace();
        }

        System.out.println("1. Ändra ränta.");
        System.out.println("2. Lägg till bankbiträde.");
        System.out.println("3. Visa översikt.");

        Scanner choice = new Scanner(System.in);
        System.out.println();
        int choiceEntry = choice.nextInt();

        switch (choiceEntry) {
            case 1:
                System.out.println("ändra ränta");
                break;
            case 2:
                System.out.println("lägg till bankbiträde");
                break;
            case 3:
                System.out.println("visa översikt");
                break;
            default:
                System.out.println("fel");
        }

    }

}