示例#1
0
  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