/** * @param user * @param rst * @throws SQLException */ public DataModel loadUserVO(UserData user, ResultSet rst) throws TMException, SQLException { if (!rst.next()) { return null; } if (user == null) { user = new UserData(); } try { user.setId(rst.getLong(ID)); } catch (FixedValueException e) { // TODO Auto-generated catch block logger.error(e.getMessage(), e); } user.setUserName(rst.getString(USER_NAME)); user.setPassword(rst.getString(PASSWORD)); user.setFirstName(rst.getString(FIRST_NAME)); user.setMiddleName(rst.getString(MIDDLE_NAME)); user.setLastName(rst.getString(LAST_NAME)); user.setUserName(rst.getString(EMAIL_ID)); user.setDob(rst.getString(DOB)); user.setSex(rst.getInt(SEX)); user.setAddressId(rst.getLong(ADDRESS_ID)); user.setMaritalStatus(rst.getString(MARITAL_STATUS)); user.setNationality(rst.getString(NATIONALITY)); user.setImage(rst.getObject(IMAGE)); user.setActive(rst.getBoolean(IS_ACTIVE)); user.setActivationKey(rst.getString(ACTIVATION_KEY)); return user; }