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); } }