Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package Menu;
- import java.util.Scanner;
- import java.sql.*;
- import Menu.DataAccess;
- public class Login {
- //Loader dataAccess klasse
- DataAccess da = new DataAccess();
- //Scanner klasse initeres
- Scanner sc = new Scanner(System.in);
- //Metode login
- public void login() {
- // Check brugernavn og adgangskode og position
- System.out.print("Enter your 4 digit userpin: ");
- String number = 20 + sc.next();
- System.out.print("Enter Password: ");
- String password = sc.next();
- // Create SQL Query
- String SQL = "SELECT * FROM brugerlogin WHERE brugernummer ='" + number + "' OR adgangskode COLLATE utf8_bin ='" + password + "'";
- Object[][] x;
- try {
- x = da.executeQuery(SQL);
- if(x != null) {
- System.out.println("======================================");
- for (Object[] o : x)
- {
- if(number.equals(o[0]) && password.equals(o[1])) {
- System.out.println("Login Succes");
- }
- else
- {
- System.out.println("Login failed");
- }
- //Check permission
- }
- }
- else {
- System.out.println("Dine informationer er forkerte");
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement