Statement stmt = connection.createStatement();
try{
stmt.execute("select NAME, ZIP, SSN, AGE, SEX, MARITAL, RACE, TAXSTAT, DETAIL, HOUSEHOLDDETAIL, FATHERORIGIN, MOTHERORIGIN, BIRTHCOUNTRY, CITIZENSHIP from userrecord where ssn="+ssn);
ResultSet rs = stmt.getResultSet();
if( rs.next() ){
UserDTO user = new UserDTO();
user.setName(rs.getString(1).trim());
user.setZipCode(rs.getString(2));
user.setSsn(rs.getInt(3));
user.setAge(rs.getInt(4));
user.setSex(rs.getString(5));
user.setMarital(rs.getString(6));
user.setRace(rs.getString(7));
user.setTaxStatus(rs.getString(8));
user.setDetail(rs.getString(9));
user.setHouseholdDetail(rs.getString(10));
user.setFatherOrigin(rs.getString(11));
user.setMotherOrigin(rs.getString(12));
user.setBirthCountry(rs.getString(13));
user.setCitizenship(rs.getString(14));
return user;
} else {
return null;
}
}finally{