javax.sql.rowset
Interface Predicate

public interface Predicate

The standard interface that provides the framework for all FilteredRowSet objects to describe their filters.

1.0 Background

2.0 Implementation Guidelines

A sample implementation would look something like this:

 
    public class Range implements Predicate {

       private Object lo[];
       private Object hi[];
       private int idx[];

       public Range(Object[] lo, Object[] hi, int[] idx) {
          this.lo = lo;
          this.hi = hi;
          this.idx = idx;
       }

      public boolean evaluate(RowSet rs) {
          CachedRowSet crs = (CachedRowSet)rs;
          boolean bool1,bool2;           
       
          // Check the present row determine if it lies
          // within the filtering criteria. 
      
          for (int i = 0; i < idx.length; i++) {
        
                if ((rs.getObject(idx[i]) >= lo[i]) && 
                  (rs.getObject(idx[i]) >= hi[i]) { 
                    bool1 = true; // within filter constraints
          } else {
            bool2 = true; // outside of filter constraints             
          } 
      }
      
      if (bool2) {
         return false;
      } else {
         return true;
      }
  }          
 
 

The example above implements a simple range predicate. Note, that implementations should but are not required to provider String and integer index based constructors to provide for JDBC RowSet Implementation applications that use both column identification conventions.

Method Summary
boolean	evaluate(Object value, int column)           This method is called by a FilteredRowSet object to check whether the value lies between the filtering criterion (or criteria if multiple constraints exist) set using the setFilter() method.
boolean	evaluate(Object value, String columnName)           This method is called by the FilteredRowSet object to check whether the value lies between the filtering criteria set using the setFilter method.
boolean	evaluate(RowSet rs)           This method is typically called a FilteredRowSet object internal methods (not public) that control the RowSet object's cursor moving from row to the next.

 

Method Detail

evaluate

boolean evaluate(RowSet rs)

This method is typically called a FilteredRowSet object internal methods (not public) that control the RowSet object's cursor moving from row to the next. In addition, if this internal method moves the cursor onto a row that has been deleted, the internal method will continue to ove the cursor until a valid row is found.

Returns:

true if there are more rows in the filter; false otherwise

evaluate

boolean evaluate(Object value,
                 int column)
                 throws SQLException

This method is called by a FilteredRowSet object to check whether the value lies between the filtering criterion (or criteria if multiple constraints exist) set using the setFilter() method.

The FilteredRowSet object will use this method internally while inserting new rows to a FilteredRowSet instance.

Parameters:

value - An Object value which needs to be checked, whether it can be part of this FilterRowSet object.

column - a int object that must match the SQL index of a column in this RowSet object. This must have been passed to Predicate as one of the columns for filtering while initializing a Predicate

Returns:

true ifrow value lies within the filter; false otherwise

Throws:

SQLException - if the column is not part of filtering criteria

evaluate

boolean evaluate(Object value,
                 String columnName)
                 throws SQLException

This method is called by the FilteredRowSet object to check whether the value lies between the filtering criteria set using the setFilter method.

The FilteredRowSet object will use this method internally while inserting new rows to a FilteredRowSet instance.

Parameters:

value - An Object value which needs to be checked, whether it can be part of this FilterRowSet.

columnName - a String object that must match the SQL name of a column in this RowSet, ignoring case. This must have been passed to Predicate as one of the columns for filtering while initializing a Predicate

Returns:

true if value lies within the filter; false otherwise

Throws:

SQLException - if the column is not part of filtering criteria