package nkotb;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;

public class Login {

    String url = "jdbc:mysql://localhost:3306/nkotb";
    String user = "root";
    String password = "";
    Scanner userInput = new Scanner(System.in);
    PreparedStatement stmt = null;
    ResultSet rs = null;
    Connection conn = null;

    public void Login() {

        System.out.println("Name:");
        String loginUsername = userInput.next();
        System.out.println("Password:");
        String loginPassword = userInput.next();

        try {
            //1. Connection till mysql
            conn = DriverManager.getConnection(url, user, password);
            //2. Skapa ett statement med scannervaribaler.
            stmt = conn.prepareStatement("SELECT * FROM customers WHERE Name ='" + loginUsername + "' AND Password='" + loginPassword + "' ; ");
            //3. Kör sql-query
            rs = stmt.executeQuery();

            while (rs.next()) {
                String dbName = rs.getString("Name");
                String dbSurname = rs.getString("Surname");

                System.out.println("Welcome " + dbName + " " + dbSurname + "");
            }
        } catch (SQLException exc) {
            System.out.println(exc.getMessage());
        }
    }
}