示例#1
0
  public UserTO loginValidation(UserTO userTo) throws BaseAppException {
    boolean flag = false;
    String email = userTo.getEmailId();
    String password = userTo.getPassword1();
    Connection con;
    PreparedStatement psmt = null;
    ResultSet rs;
    String sql =
        "SELECT UserId, EmailId , Password ,FirstName , LastName , "
            + " RoleId FROM t_user"
            + " WHERE EmailId='"
            + email
            + "' AND Password ='******'"
            + " AND IsApproved=1";
    try {
      con = GetConnection.getSimpleConnection();
      psmt = con.prepareStatement(sql);
      rs = psmt.executeQuery();
      if (rs.next()) {
        flag = true;
        userTo.setEmailId(rs.getString("EmailId"));
        // userTo.setUsername(rs.getString("FirstName") + " " + rs.getString("LastName"));
        userTo.setRoleId(rs.getInt("RoleId"));
        userTo.setUserId(rs.getInt("UserId"));
        // updateUnsuccessfulAttempt(email)
      } else {
        userTo = null;
      }

    } catch (SQLException sqld) {
      throw new RuntimeException(sqld);
    } finally {
      try {
        if (null != psmt) {
          psmt.close();
        }
      } catch (Exception e) {
        throw new RuntimeException(e);
      }
    }

    return userTo;
  }
示例#2
0
 /**
  * populates details to SessionObj extracting the details from UserTO object
  *
  * @param userTo - UserTo Object holding the details of user
  * @return - Populated UserSessionInfo Object with user details
  */
 public static UserSessionInfo populateUserDetails_ToSession(UserTO userTo, String loginType) {
   // Smita - 10th Aug 10
   UserSessionInfo objUserInfo = new UserSessionInfo();
   objUserInfo.setLoginType(loginType);
   objUserInfo.setEmailId(userTo.getEmailId());
   objUserInfo.setFirstName(userTo.getFirstName());
   objUserInfo.setLastName(userTo.getLastName());
   objUserInfo.setDoneFullRegistration(userTo.isDoneFullRegistration());
   objUserInfo.setRegistrationDate(userTo.getRegistrationDate());
   objUserInfo.setRoleId(String.valueOf(userTo.getRoleId()));
   objUserInfo.setUserloginName(userTo.getUserloginID());
   objUserInfo.setUserId(userTo.getUserId());
   objUserInfo.setUserTo(userTo);
   return objUserInfo;
 }