Advertisement
Guest User

Untitled

a guest
Mar 16th, 2016
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.78 KB | None | 0 0
  1.  
  2. public static void main(String[] args) {
  3.  
  4. //Anropar Loginklassen
  5. Login loginObj = new Login();
  6. Scanner input = new Scanner(System.in);
  7. String username, pass;
  8. do{
  9. sysout("eter username");
  10. username = input.nextLine();
  11. sysout("enter passwsord");
  12. pass = input.nextLine();
  13. }while(!loginObj.Login(username, pass));
  14.  
  15. System.out.println("1. Overview.");
  16. System.out.println("2. Transfer money.");
  17.  
  18.  
  19. int mainMenu = input.nextInt();
  20.  
  21. if (mainMenu == 1) {
  22. Accounts overviewObject = new Accounts();
  23. overviewObject.Accounts();
  24. }
  25.  
  26. if (mainMenu == 2) {
  27. Transfer transfObj = new Transfer();
  28. transfObj.OwnTransfer();
  29. }
  30. }
  31.  
  32. ____________________________________________________________________________
  33. String url = "jdbc:mysql://localhost:3306/nkotb";
  34. String user = "root";
  35. String password = "1337";
  36. Scanner userInput = new Scanner(System.in);
  37. PreparedStatement stmt = null;
  38. ResultSet rs = null;
  39. Connection conn = null;
  40.  
  41. public boolean Login(String username, String pass) {
  42.  
  43. try {
  44. //1. Connection till mysql
  45. conn = DriverManager.getConnection(url, user, password);
  46. //2. Skapa ett statement med scannervaribaler.
  47. stmt = conn.prepareStatement("SELECT * FROM customers WHERE Name ='" + username + "' AND Password='" + pass + "' ; ");
  48. //3. Kör sql-query
  49. rs = stmt.executeQuery();
  50.  
  51. if (rs != null) {
  52. return true;
  53. }
  54. else {
  55. return false;
  56. }
  57.  
  58. } catch (SQLException exc) {
  59. System.out.println("pölpungsprut.");
  60. }
  61. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement