private void loginActionPerformed( java.awt.event.ActionEvent evt) { // GEN-FIRST:event_loginActionPerformed // TODO add your handling code here: String K = Encrypt.cryptWithMD5(Password.getText()); String sql = "Select * From user_login Where Username =? and Password=?"; try { conn = DbConnectionManager.getInstance(); pst = conn.getInstance().prepareStatement(sql); pst.setString(1, user_name.getText()); /*--------------------------------------------------------*/ pst.setString(2, K); // this should be corrected to K // System.out.println(Password.getText()); String username = user_name.getText(); UserDataAccessManager userda = new UserDataAccessManager(); String getusertype = userda.getType(username); String userType = getusertype; System.out.println(userType); String pass = K; try { rs = pst.executeQuery(); // System.out.println(rs); } catch (MySQLSyntaxErrorException e) { System.out.println("Mu horek methanata adala na.."); } if (rs.next()) { System.out.println("loksda"); userid = rs.getInt("User_id"); System.out.println("user ID " + userid); System.out.println("user Type " + userType); if (userType.compareTo("Doctor") == 0) { close(); DoctorJFrame doc = new DoctorJFrame(); doc.setDoctorId(userid); doc.addmodeltime(); doc.setLocationRelativeTo(null); doc.setVisible(true); doc.setExtendedState(doc.getExtendedState() | doc.MAXIMIZED_BOTH); // } else if (userType.compareTo("FrontDesk") == 0) { System.out.println("awa"); close(); FrontDeskJFrame FD = new FrontDeskJFrame(); FD.setLocationRelativeTo(null); FD.setVisible(true); FD.setExtendedState(FD.getExtendedState() | FD.MAXIMIZED_BOTH); } else if (userType.compareTo("Attendant") == 0) { close(); AttendentsJFrame FD = new AttendentsJFrame(); FD.setLocationRelativeTo(null); FD.setVisible(true); FD.setSize(1024, 800); FD.setExtendedState(FD.getExtendedState() | FD.MAXIMIZED_BOTH); } } else { System.out.println("Check query"); JOptionPane.showMessageDialog(new JDialog(), "Username or Password is wrong"); } } catch (SQLException | NumberFormatException e) { JOptionPane.showMessageDialog(null, e); } } // GEN-LAST:event_loginActionPerformed