Guest User

Untitled

a guest
Jan 23rd, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.26 KB | None | 0 0
  1. try {
  2. con = DriverManager.getConnection(url+dbName,userName,password);
  3. System.out.println("Connected to the database");
  4. Statement st = con.createStatement();
  5. ResultSet rt = st.executeQuery("SELECT username, accessLevel, AES_DECRYPT(`userPassword`, 'enigma') AS password FROM accounts WHERE username=('"+userNameE+"')");
  6. while(rt.next()){
  7. userNameCheck = rt.getString("username");
  8. accessLevel = rt.getInt("accessLevel");
  9. passwordCheck = rt.getString("password");
  10.  
  11. if (userNameCheck.equals(userNameE) && passwordCheck.equals(jPasswordField1.getPassword().toString())){
  12. System.out.println("Disconnected from database");
  13. this.dispose();
  14.  
  15. if(accessLevel == 1){
  16. mu.setVisible(true);
  17. mu.jButton1.setEnabled(false);
  18. mu.jButton2.setEnabled(false);
  19. loginFail = false;
  20. con.close();}
  21. if(accessLevel == 2){
  22. mu.setVisible(true);
  23. mu.jButton5.setEnabled(false);
  24. loginFail = false;
  25. con.close();
  26. }
  27. }
  28. }
Add Comment
Please, Sign In to add comment