/** * Creates a Patient object from a database query * * @param result The ResultSet from the database query * @return The Patient object */ private Patient createFromSearch(ResultSet result) { Patient p = new Patient(); try { p.setPatientID(result.getInt("patient_ID")); p.setFirstName(result.getString("firstname")); p.setLastName(result.getString("lastname")); p.setPreferredName(result.getString("preferredname")); // set gender String gender = result.getString("gender"); if ("M".equals(gender)) p.setGender("Male"); else if ("F".equals(gender)) p.setGender("Female"); else p.setGender("Other"); // set clinic String clinicCode = result.getString("clinic"); p.setClinic(clinicCode); p.setClinicName(Utils.getClinicName(clinicCode)); p.setVolunteer(result.getInt("volunteer")); p.setNotes(result.getString("notes")); p.setAvailability(result.getString("availability")); p.setAlerts(result.getString("alerts")); String myOscarVerfied = result.getString("myoscar_verified"); p.setMyoscarVerified(myOscarVerfied); // set myoscar authentication for display in client's detail page if ("1".equals(myOscarVerfied)) p.setMyOscarAuthentication("Authenticated"); else p.setMyOscarAuthentication("Not Authenticated"); p.setPartner(result.getInt("volunteer2")); // Set volunteer name and partner name setVolunteerDisplayName(p, "volunteer1"); setVolunteerDisplayName(p, "volunteer2"); } catch (SQLException e) { System.out.println("Error: Failed to create Patient object"); e.printStackTrace(); } return p; }