Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void main(String[] args) {
- //Anropar Loginklassen
- Login loginObj = new Login();
- Scanner input = new Scanner(System.in);
- String username, pass;
- do{
- sysout("eter username");
- username = input.nextLine();
- sysout("enter passwsord");
- pass = input.nextLine();
- }while(!loginObj.Login(username, pass));
- System.out.println("1. Overview.");
- System.out.println("2. Transfer money.");
- int mainMenu = input.nextInt();
- if (mainMenu == 1) {
- Accounts overviewObject = new Accounts();
- overviewObject.Accounts();
- }
- if (mainMenu == 2) {
- Transfer transfObj = new Transfer();
- transfObj.OwnTransfer();
- }
- }
- ____________________________________________________________________________
- String url = "jdbc:mysql://localhost:3306/nkotb";
- String user = "root";
- String password = "1337";
- Scanner userInput = new Scanner(System.in);
- PreparedStatement stmt = null;
- ResultSet rs = null;
- Connection conn = null;
- public boolean Login(String username, String pass) {
- 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 ='" + username + "' AND Password='" + pass + "' ; ");
- //3. Kör sql-query
- rs = stmt.executeQuery();
- if (rs != null) {
- return true;
- }
- else {
- return false;
- }
- } catch (SQLException exc) {
- System.out.println("pölpungsprut.");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement