Java VCUserTO.setEmailAddress Examples

Example #1

File: VCUserDAO.java Project: hnalagandla/votingcentral

  private void fillVCUserTO(ResultSet rs, VCUserTO vto) throws SQLException {

    vto.setUserId(rs.getLong("USER_ID"));

    String value = "";

    value = rs.getString("FIRST_NAME");
    if (value != null) {
      vto.setFirstName(value);
    }

    value = rs.getString("LAST_NAME");
    if (value != null) {
      vto.setLastName(value);
    }

    value = rs.getString("MIDDLE_INITIAL");
    if (value != null) {
      vto.setMiddleInitial(value);
    }

    value = rs.getString("MIDDLE_NAME");
    if (value != null) {
      vto.setMiddleName(value);
    }

    int dob = rs.getInt("DOB");
    vto.setBirthDay(Integer.toString(dob));

    int mob = rs.getInt("MOB");
    vto.setBirthMonth(Integer.toString(mob));

    int yob = rs.getInt("YOB");
    vto.setBirthYear(Integer.toString(yob));

    value = rs.getString("GENDER");
    if (value != null) {
      vto.setGender(value);
    }

    value = rs.getString("EMAIL_ADDRESS");
    if (value != null) {
      vto.setEmailAddress(value);
    }

    value = rs.getString("USER_NAME");
    if (value != null) {
      vto.setUserName(value);
    }

    value = rs.getString("DISPLAY_USER_NAME");
    if (value != null) {
      vto.setDisplayUserName(value);
    }

    value = rs.getString("MAILING_ADDRESS1");
    if (value != null) {
      vto.setMailingAddress1(value);
    }

    value = rs.getString("MAILING_ADDRESS2");
    if (value != null) {
      vto.setMailingAddress2(value);
    }

    value = rs.getString("CITY");
    if (value != null) {
      vto.setCity(value);
    }

    int cid = rs.getInt("STATE");
    if (value != null) {
      vto.setStateId(cid);
    }

    value = rs.getString("ZIP_CODE1");
    if (value != null) {
      vto.setZipCode1(value);
    }

    value = rs.getString("ZIP_CODE2");
    if (value != null) {
      vto.setZipCode2(value);
    }

    value = rs.getString("PHONE_COUNTRY_CODE");
    if (value != null) {
      vto.setPhoneCountryCode(value);
    }

    value = rs.getString("PHONE_AREA_CODE");
    if (value != null) {
      vto.setPhoneAreaCode(value);
    }

    value = rs.getString("PHONE_NUM_1");
    if (value != null) {
      vto.setPhoneNum1(value);
    }

    value = rs.getString("PHONE_NUM_2");
    if (value != null) {
      vto.setPhoneNum2(value);
    }

    int c = rs.getInt("COUNTRY");
    vto.setCountryId(c);

    value = rs.getString("ACCOUNT_STATUS");
    if (value != null) {
      vto.setAccountStatus(value);
    }

    Timestamp d = rs.getTimestamp("CREATE_TIMESTAMP");
    if (d != null) {
      vto.setCreateTimestamp(d);
    }

    d = rs.getTimestamp("MODIFY_TIMESTAMP");

    if (d != null) {
      vto.setModifyTimestamp(d);
    }
  }