Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- con = DriverManager.getConnection(url+dbName,userName,password);
- System.out.println("Connected to the database");
- Statement st = con.createStatement();
- ResultSet rt = st.executeQuery("SELECT username, accessLevel, AES_DECRYPT(`userPassword`, 'enigma') AS password FROM accounts WHERE username=('"+userNameE+"')");
- while(rt.next()){
- userNameCheck = rt.getString("username");
- accessLevel = rt.getInt("accessLevel");
- passwordCheck = rt.getString("password");
- if (userNameCheck.equals(userNameE) && passwordCheck.equals(jPasswordField1.getPassword().toString())){
- System.out.println("Disconnected from database");
- this.dispose();
- if(accessLevel == 1){
- mu.setVisible(true);
- mu.jButton1.setEnabled(false);
- mu.jButton2.setEnabled(false);
- loginFail = false;
- con.close();}
- if(accessLevel == 2){
- mu.setVisible(true);
- mu.jButton5.setEnabled(false);
- loginFail = false;
- con.close();
- }
- }
- }
Add Comment
Please, Sign In to add comment