public Deafness mapRow(ResultSet rs, int rowNum) throws SQLException {
      Deafness deafness = new Deafness();

      deafness.setId(rs.getLong(ID_FIELD_NAME));
      deafness.setRadarNo(rs.getLong(RADAR_NO_FIELD_NAME));
      deafness.setEvidenceOfDeafness(
          Deafness.EvidenceOfDeafness.getEvidenceOfDeafness(
              rs.getInt(EVIDENCE_OF_DEAFNESS_FIELD_NAME)));
      deafness.setDateProblemFirstNoticed(rs.getDate(DATE_PROBLEM_FIRST_NOTICED_FIELD_NAME));
      deafness.setDateStartedUsingHearingAid(rs.getDate(DATE_STARTED_USING_HEARING_AID_FIELD_NAME));

      return deafness;
    }