Oracle Seeker, Oracle探索者

  private RowIterator findRowIteratorByViewCriteria(ViewObject viewObject,
                                                    ViewCriteria viewCriteria) {
    RowIterator rowIterator =
      viewObject.findByViewCriteria(viewCriteria, -1, ViewObject.QUERY_MODE_SCAN_DATABASE_TABLES);
    if (rowIterator.first() != null) {
      return rowIterator;
    } else {
      return null;
    }
  }
 
  public Row findEmployeeByEmailCriteria(String email) {
    ViewObjectImpl employeesViewImpl = this.getEmployeesView1();
    ViewCriteria viewCriteria = employeesViewImpl.createViewCriteria();
    ViewCriteriaRow viewCriteriaRow = viewCriteria.createViewCriteriaRow();
    viewCriteriaRow.setAttribute("Email", "=" + email);
    viewCriteria.add(viewCriteriaRow);
    employeesViewImpl.applyViewCriteria(viewCriteria);
    RowIterator rowIterator =
      this.findRowIteratorByViewCriteria(employeesViewImpl, viewCriteria);
    Row row = null;
    while (rowIterator.hasNext()) {
      System.out.println("rowIterator hasNext");
      row = rowIterator.next();
    }
    if ((rowIterator.getAllRowsInRange()).length != 0) {
      System.out.println(rowIterator.first().getAttribute("EmployeeId"));
    }
    return row;
  }