package Menu;


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


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+ "'";

       da.executeQuery(SQL);



                // Check Username and Password
        while (rs.next()) {
            databaseBrugernavn = rs.getString("users_name");
            databaseAdgangskode = rs.getString("users_password");
        }

        if (name.equals(databaseBrugernavn) && password.equals(databaseAdgangskode)) {
            System.out.println("Successful Login!\n----");
        } else {
            System.out.println("Incorrect Password\n----");
        }


    }








}