private OfficeVisitBean loadFullOfficeVist(ResultSet rs, long visitID)
      throws SQLException, DBException {
    OfficeVisitBean ov = new OfficeVisitBean(visitID);
    ov.setVisitDateStr(
        new SimpleDateFormat("MM/dd/yyyy").format(new Date(rs.getDate("VisitDate").getTime())));
    ov.setHcpID(rs.getLong("HCPID"));
    ov.setNotes(rs.getString("notes"));
    ov.setPatientID(rs.getLong("PatientID"));
    ov.setHospitalID(rs.getString("HospitalID"));
    ov.setDiagnoses(getDiagnoses(visitID));
    ov.setPrescriptions(getPrescriptions(visitID));
    ov.setProcedures(getProcedures(visitID));

    return ov;
  }
 public void testUpdateNewOfficeVisit() {
   try {
     OfficeVisitBean ov = new OfficeVisitBean();
     long newOVID = ovDAO.add(ov);
     ov = new OfficeVisitBean(newOVID);
     ov.setNotes("some notes");
     ov.setVisitDateStr("07/07/2007");
     ov.setPatientID(65);
     ov.setHcpID(5);
     ov.setHospitalID("9191919191");
     ovDAO.update(ov);
     ov = ovDAO.getOfficeVisit(newOVID);
     assertEquals("some notes", ov.getNotes());
     assertEquals("07/07/2007", new SimpleDateFormat("MM/dd/yyyy").format(ov.getVisitDate()));
     assertEquals(65, ov.getPatientID());
     assertEquals(5, ov.getHcpID());
     assertEquals("9191919191", ov.getHospitalID());
   } catch (Exception e) {
     e.printStackTrace();
   }
 }