package Menu;


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

import Menu.DataAccess;


public class Login {


    DataAccess da = new DataAccess();


    public void login() {


        Scanner sc = new Scanner(System.in);

        String databaseBrugernavn = "";
        String databaseAdgangskode = "";

        // Check brugernavn og adgangskode
        System.out.print("Enter username: ");
        String name = sc.next();
        System.out.print("Enter Password: ");
        String password = sc.next();

        // Create SQL Query
        String SQL = "SELECT * FROM brugerlogin WHERE brugernavn='" + name + "' AND adgangskode='" + password + "'";


        Object[][] x;
        try {
            x = da.executeQuery(SQL);
            System.out.println("======================================");

            for (Object[] o : x){

                for (Object d : o){
                    System.out.print(d.toString()+"\t");
                    System.out.println("======================================");
                    if (name.equals(d)) { //&& password.equals(o)) {
                        System.out.println("Successful Login!\n----");




                    }
                }
                System.out.println();
            }
            System.out.println("======================================");System.out.println("======================================");
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }


                // Check Username and Password
//      while (.next()) {
//          databaseBrugernavn = rs.getString("brugernavn");
//          databaseAdgangskode = rs.getString("adgangskode");
//      }
//
//      if (name.equals(databaseBrugernavn) && password.equals(databaseAdgangskode)) {
//          System.out.println("Successful Login!\n----");
//      } else {
//          System.out.println("Incorrect Password\n----");
//      }


    }




}