Advertisement
Guest User

Untitled

a guest
Apr 14th, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.77 KB | None | 0 0
  1. public boolean query(username, password) throws SQLException {
  2.     String dbName;
  3.     String password;
  4.     stmt = dbConnection().prepareStatement("SELECT * FROM customers WHERE Name ='" + username + "' AND Password='" + password + "' ; ");
  5.     while (rs.next()) {
  6.         dbName = rs.getString("Name");
  7.         dbPassword = rs.getString("Password");
  8.      }
  9.      if(dbName.equals(username)&& dbPassword.equals(password)){
  10.         return true;
  11.      }
  12.      else {
  13.         return false;
  14.      }
  15. }
  16.  
  17. ------------------------------------------------------
  18.  
  19. User user = new User();
  20. DbHandler db = new DbHandler();
  21. user.setName("Johnny");
  22. user.setPassword("pölpungsprut");
  23.  
  24. if (db.query(user.getName(), user.getPassword())) {
  25.     System.out.println("Welcome!");
  26. }
  27. else {
  28.     System.out.println("sod off, wanker.");
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement