javax.sql.rowset
Interface FilteredRowSet

All Superinterfaces:
CachedRowSet sample code for javax.sql.rowset.CachedRowSet definition code for javax.sql.rowset.CachedRowSet , Joinable sample code for javax.sql.rowset.Joinable definition code for javax.sql.rowset.Joinable , ResultSet sample code for java.sql.ResultSet definition code for java.sql.ResultSet , RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet , WebRowSet sample code for javax.sql.rowset.WebRowSet definition code for javax.sql.rowset.WebRowSet

public interface FilteredRowSet
extends WebRowSet sample code for javax.sql.rowset.WebRowSet definition code for javax.sql.rowset.WebRowSet

The standard interface that all standard implementations of FilteredRowSet must implement. The FilteredRowSetImpl class provides the reference implementation which may be extended if required. Alternatively, a vendor is free to implement its own version by implementing this interface.

1.0 Background

There are occasions when a RowSet object has a need to provide a degree of filtering to its contents. One possible solution is to provide a query language for all standard RowSet implementations; however, this is an impractical approach for lightweight components such as disconnected RowSet objects. The FilteredRowSet interface seeks to address this need without supplying a heavyweight query language along with the processing that such a query language would require.

A JDBC FilteredRowSet standard implementation implements the RowSet interfaces and extends the CachedRowSetTM class. The CachedRowSet class provides a set of protected cursor manipulation methods, which a FilteredRowSet implementation can override to supply filtering support.

2.0 Predicate Sharing

If a FilteredRowSet implementation is shared using the inherited createShared method in parent interfaces, the Predicate should be shared without modification by all FilteredRowSet instance clones.

3.0 Usage

By implementing a Predicate (see example in Predicate class JavaDoc), a FilteredRowSet could then be used as described below.

     FilteredRowSet frs = new FilteredRowSetImpl();
     frs.populate(rs);
 
     Range name = new Range("Alpha", "Bravo", "columnName");
     frs.setFilter(name);
 
     frs.next() // only names from "Alpha" to "Bravo" will be returned
 
In the example above, we initialize a Range object which implements the Predicate interface. This object expresses the following constraints: All rows outputted or modified from this FilteredRowSet object must fall between the values 'Alpha' and 'Bravo' both values inclusive, in the column 'columnName'. If a filter is applied to a FilteredRowSet object that contains no data that falls within the range of the filter, no rows are returned.

This framework allows multiple classes implementing predicates to be used in combination to achieved the required filtering result with out the need for query language processing.

4.0 Updating a FilteredRowSet Object

The predicate set on a FilteredRowSet object applies a criterion on all rows in a RowSet object to manage a subset of rows in a RowSet object. This criterion governs the subset of rows that are visible and also defines which rows can be modified, deleted or inserted.

Therefore, the predicate set on a FilteredRowSet object must be considered as bi-directional and the set criterion as the gating mechanism for all views and updates to the FilteredRowSet object. Any attempt to update the FilteredRowSet that violates the criterion will result in a SQLException object being thrown.

The FilteredRowSet range criterion can be modified by applying a new Predicate object to the FilteredRowSet instance at any time. This is possible if no additional references to the FilteredRowSet object are detected. A new filter has has an immediate effect on criterion enforcement within the FilteredRowSet object, and all subsequent views and updates will be subject to similar enforcement.

5.0 Behavior of Rows Outside the Filter

Rows that fall outside of the filter set on a FilteredRowSet object cannot be modified until the filter is removed or a new filter is applied.

Furthermore, only rows that fall within the bounds of a filter will be synchronized with the data source.


Field Summary
 
Fields inherited from interface javax.sql.rowset.WebRowSet sample code for javax.sql.rowset.WebRowSet definition code for javax.sql.rowset.WebRowSet
PUBLIC_XML_SCHEMA sample code for javax.sql.rowset.WebRowSet.PUBLIC_XML_SCHEMA definition code for javax.sql.rowset.WebRowSet.PUBLIC_XML_SCHEMA , SCHEMA_SYSTEM_ID sample code for javax.sql.rowset.WebRowSet.SCHEMA_SYSTEM_ID definition code for javax.sql.rowset.WebRowSet.SCHEMA_SYSTEM_ID
 
Fields inherited from interface javax.sql.rowset.CachedRowSet sample code for javax.sql.rowset.CachedRowSet definition code for javax.sql.rowset.CachedRowSet
COMMIT_ON_ACCEPT_CHANGES sample code for javax.sql.rowset.CachedRowSet.COMMIT_ON_ACCEPT_CHANGES definition code for javax.sql.rowset.CachedRowSet.COMMIT_ON_ACCEPT_CHANGES
 
Fields inherited from interface java.sql.ResultSet sample code for java.sql.ResultSet definition code for java.sql.ResultSet
CLOSE_CURSORS_AT_COMMIT sample code for java.sql.ResultSet.CLOSE_CURSORS_AT_COMMIT definition code for java.sql.ResultSet.CLOSE_CURSORS_AT_COMMIT , CONCUR_READ_ONLY sample code for java.sql.ResultSet.CONCUR_READ_ONLY definition code for java.sql.ResultSet.CONCUR_READ_ONLY , CONCUR_UPDATABLE sample code for java.sql.ResultSet.CONCUR_UPDATABLE definition code for java.sql.ResultSet.CONCUR_UPDATABLE , FETCH_FORWARD sample code for java.sql.ResultSet.FETCH_FORWARD definition code for java.sql.ResultSet.FETCH_FORWARD , FETCH_REVERSE sample code for java.sql.ResultSet.FETCH_REVERSE definition code for java.sql.ResultSet.FETCH_REVERSE , FETCH_UNKNOWN sample code for java.sql.ResultSet.FETCH_UNKNOWN definition code for java.sql.ResultSet.FETCH_UNKNOWN , HOLD_CURSORS_OVER_COMMIT sample code for java.sql.ResultSet.HOLD_CURSORS_OVER_COMMIT definition code for java.sql.ResultSet.HOLD_CURSORS_OVER_COMMIT , TYPE_FORWARD_ONLY sample code for java.sql.ResultSet.TYPE_FORWARD_ONLY definition code for java.sql.ResultSet.TYPE_FORWARD_ONLY , TYPE_SCROLL_INSENSITIVE sample code for java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE definition code for java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE , TYPE_SCROLL_SENSITIVE sample code for java.sql.ResultSet.TYPE_SCROLL_SENSITIVE definition code for java.sql.ResultSet.TYPE_SCROLL_SENSITIVE
 
Method Summary
 Predicate sample code for javax.sql.rowset.Predicate definition code for javax.sql.rowset.Predicate getFilter sample code for javax.sql.rowset.FilteredRowSet.getFilter() definition code for javax.sql.rowset.FilteredRowSet.getFilter() ()
          Retrieves the active filter for this FilteredRowSet object.
 void setFilter sample code for javax.sql.rowset.FilteredRowSet.setFilter(javax.sql.rowset.Predicate) definition code for javax.sql.rowset.FilteredRowSet.setFilter(javax.sql.rowset.Predicate) (Predicate sample code for javax.sql.rowset.Predicate definition code for javax.sql.rowset.Predicate  p)
          Applies the given Predicate object to this FilteredRowSet object.
 
Methods inherited from interface javax.sql.rowset.WebRowSet sample code for javax.sql.rowset.WebRowSet definition code for javax.sql.rowset.WebRowSet
readXml sample code for javax.sql.rowset.WebRowSet.readXml(java.io.InputStream) definition code for javax.sql.rowset.WebRowSet.readXml(java.io.InputStream) , readXml sample code for javax.sql.rowset.WebRowSet.readXml(java.io.Reader) definition code for javax.sql.rowset.WebRowSet.readXml(java.io.Reader) , writeXml sample code for javax.sql.rowset.WebRowSet.writeXml(java.io.OutputStream) definition code for javax.sql.rowset.WebRowSet.writeXml(java.io.OutputStream) , writeXml sample code for javax.sql.rowset.WebRowSet.writeXml(java.sql.ResultSet, java.io.OutputStream) definition code for javax.sql.rowset.WebRowSet.writeXml(java.sql.ResultSet, java.io.OutputStream) , writeXml sample code for javax.sql.rowset.WebRowSet.writeXml(java.sql.ResultSet, java.io.Writer) definition code for javax.sql.rowset.WebRowSet.writeXml(java.sql.ResultSet, java.io.Writer) , writeXml sample code for javax.sql.rowset.WebRowSet.writeXml(java.io.Writer) definition code for javax.sql.rowset.WebRowSet.writeXml(java.io.Writer)
 
Methods inherited from interface javax.sql.rowset.CachedRowSet sample code for javax.sql.rowset.CachedRowSet definition code for javax.sql.rowset.CachedRowSet
acceptChanges sample code for javax.sql.rowset.CachedRowSet.acceptChanges() definition code for javax.sql.rowset.CachedRowSet.acceptChanges() , acceptChanges sample code for javax.sql.rowset.CachedRowSet.acceptChanges(java.sql.Connection) definition code for javax.sql.rowset.CachedRowSet.acceptChanges(java.sql.Connection) , columnUpdated sample code for javax.sql.rowset.CachedRowSet.columnUpdated(int) definition code for javax.sql.rowset.CachedRowSet.columnUpdated(int) , columnUpdated sample code for javax.sql.rowset.CachedRowSet.columnUpdated(java.lang.String) definition code for javax.sql.rowset.CachedRowSet.columnUpdated(java.lang.String) , commit sample code for javax.sql.rowset.CachedRowSet.commit() definition code for javax.sql.rowset.CachedRowSet.commit() , createCopy sample code for javax.sql.rowset.CachedRowSet.createCopy() definition code for javax.sql.rowset.CachedRowSet.createCopy() , createCopyNoConstraints sample code for javax.sql.rowset.CachedRowSet.createCopyNoConstraints() definition code for javax.sql.rowset.CachedRowSet.createCopyNoConstraints() , createCopySchema sample code for javax.sql.rowset.CachedRowSet.createCopySchema() definition code for javax.sql.rowset.CachedRowSet.createCopySchema() , createShared sample code for javax.sql.rowset.CachedRowSet.createShared() definition code for javax.sql.rowset.CachedRowSet.createShared() , execute sample code for javax.sql.rowset.CachedRowSet.execute(java.sql.Connection) definition code for javax.sql.rowset.CachedRowSet.execute(java.sql.Connection) , getKeyColumns sample code for javax.sql.rowset.CachedRowSet.getKeyColumns() definition code for javax.sql.rowset.CachedRowSet.getKeyColumns() , getOriginal sample code for javax.sql.rowset.CachedRowSet.getOriginal() definition code for javax.sql.rowset.CachedRowSet.getOriginal() , getOriginalRow sample code for javax.sql.rowset.CachedRowSet.getOriginalRow() definition code for javax.sql.rowset.CachedRowSet.getOriginalRow() , getPageSize sample code for javax.sql.rowset.CachedRowSet.getPageSize() definition code for javax.sql.rowset.CachedRowSet.getPageSize() , getRowSetWarnings sample code for javax.sql.rowset.CachedRowSet.getRowSetWarnings() definition code for javax.sql.rowset.CachedRowSet.getRowSetWarnings() , getShowDeleted sample code for javax.sql.rowset.CachedRowSet.getShowDeleted() definition code for javax.sql.rowset.CachedRowSet.getShowDeleted() , getSyncProvider sample code for javax.sql.rowset.CachedRowSet.getSyncProvider() definition code for javax.sql.rowset.CachedRowSet.getSyncProvider() , getTableName sample code for javax.sql.rowset.CachedRowSet.getTableName() definition code for javax.sql.rowset.CachedRowSet.getTableName() , nextPage sample code for javax.sql.rowset.CachedRowSet.nextPage() definition code for javax.sql.rowset.CachedRowSet.nextPage() , populate sample code for javax.sql.rowset.CachedRowSet.populate(java.sql.ResultSet) definition code for javax.sql.rowset.CachedRowSet.populate(java.sql.ResultSet) , populate sample code for javax.sql.rowset.CachedRowSet.populate(java.sql.ResultSet, int) definition code for javax.sql.rowset.CachedRowSet.populate(java.sql.ResultSet, int) , previousPage sample code for javax.sql.rowset.CachedRowSet.previousPage() definition code for javax.sql.rowset.CachedRowSet.previousPage() , release sample code for javax.sql.rowset.CachedRowSet.release() definition code for javax.sql.rowset.CachedRowSet.release() , restoreOriginal sample code for javax.sql.rowset.CachedRowSet.restoreOriginal() definition code for javax.sql.rowset.CachedRowSet.restoreOriginal() , rollback sample code for javax.sql.rowset.CachedRowSet.rollback() definition code for javax.sql.rowset.CachedRowSet.rollback() , rollback sample code for javax.sql.rowset.CachedRowSet.rollback(java.sql.Savepoint) definition code for javax.sql.rowset.CachedRowSet.rollback(java.sql.Savepoint) , rowSetPopulated sample code for javax.sql.rowset.CachedRowSet.rowSetPopulated(javax.sql.RowSetEvent, int) definition code for javax.sql.rowset.CachedRowSet.rowSetPopulated(javax.sql.RowSetEvent, int) , setKeyColumns sample code for javax.sql.rowset.CachedRowSet.setKeyColumns(int[]) definition code for javax.sql.rowset.CachedRowSet.setKeyColumns(int[]) , setMetaData sample code for javax.sql.rowset.CachedRowSet.setMetaData(javax.sql.RowSetMetaData) definition code for javax.sql.rowset.CachedRowSet.setMetaData(javax.sql.RowSetMetaData) , setOriginalRow sample code for javax.sql.rowset.CachedRowSet.setOriginalRow() definition code for javax.sql.rowset.CachedRowSet.setOriginalRow() , setPageSize sample code for javax.sql.rowset.CachedRowSet.setPageSize(int) definition code for javax.sql.rowset.CachedRowSet.setPageSize(int) , setShowDeleted sample code for javax.sql.rowset.CachedRowSet.setShowDeleted(boolean) definition code for javax.sql.rowset.CachedRowSet.setShowDeleted(boolean) , setSyncProvider sample code for javax.sql.rowset.CachedRowSet.setSyncProvider(java.lang.String) definition code for javax.sql.rowset.CachedRowSet.setSyncProvider(java.lang.String) , setTableName sample code for javax.sql.rowset.CachedRowSet.setTableName(java.lang.String) definition code for javax.sql.rowset.CachedRowSet.setTableName(java.lang.String) , size sample code for javax.sql.rowset.CachedRowSet.size() definition code for javax.sql.rowset.CachedRowSet.size() , toCollection sample code for javax.sql.rowset.CachedRowSet.toCollection() definition code for javax.sql.rowset.CachedRowSet.toCollection() , toCollection sample code for javax.sql.rowset.CachedRowSet.toCollection(int) definition code for javax.sql.rowset.CachedRowSet.toCollection(int) , toCollection sample code for javax.sql.rowset.CachedRowSet.toCollection(java.lang.String) definition code for javax.sql.rowset.CachedRowSet.toCollection(java.lang.String) , undoDelete sample code for javax.sql.rowset.CachedRowSet.undoDelete() definition code for javax.sql.rowset.CachedRowSet.undoDelete() , undoInsert sample code for javax.sql.rowset.CachedRowSet.undoInsert() definition code for javax.sql.rowset.CachedRowSet.undoInsert() , undoUpdate sample code for javax.sql.rowset.CachedRowSet.undoUpdate() definition code for javax.sql.rowset.CachedRowSet.undoUpdate()
 
Methods inherited from interface javax.sql.RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet
addRowSetListener sample code for javax.sql.RowSet.addRowSetListener(javax.sql.RowSetListener) definition code for javax.sql.RowSet.addRowSetListener(javax.sql.RowSetListener) , clearParameters sample code for javax.sql.RowSet.clearParameters() definition code for javax.sql.RowSet.clearParameters() , execute sample code for javax.sql.RowSet.execute() definition code for javax.sql.RowSet.execute() , getCommand sample code for javax.sql.RowSet.getCommand() definition code for javax.sql.RowSet.getCommand() , getDataSourceName sample code for javax.sql.RowSet.getDataSourceName() definition code for javax.sql.RowSet.getDataSourceName() , getEscapeProcessing sample code for javax.sql.RowSet.getEscapeProcessing() definition code for javax.sql.RowSet.getEscapeProcessing() , getMaxFieldSize sample code for javax.sql.RowSet.getMaxFieldSize() definition code for javax.sql.RowSet.getMaxFieldSize() , getMaxRows sample code for javax.sql.RowSet.getMaxRows() definition code for javax.sql.RowSet.getMaxRows() , getPassword sample code for javax.sql.RowSet.getPassword() definition code for javax.sql.RowSet.getPassword() , getQueryTimeout sample code for javax.sql.RowSet.getQueryTimeout() definition code for javax.sql.RowSet.getQueryTimeout() , getTransactionIsolation sample code for javax.sql.RowSet.getTransactionIsolation() definition code for javax.sql.RowSet.getTransactionIsolation() , getTypeMap sample code for javax.sql.RowSet.getTypeMap() definition code for javax.sql.RowSet.getTypeMap() , getUrl sample code for javax.sql.RowSet.getUrl() definition code for javax.sql.RowSet.getUrl() , getUsername sample code for javax.sql.RowSet.getUsername() definition code for javax.sql.RowSet.getUsername() , isReadOnly sample code for javax.sql.RowSet.isReadOnly() definition code for javax.sql.RowSet.isReadOnly() , removeRowSetListener sample code for javax.sql.RowSet.removeRowSetListener(javax.sql.RowSetListener) definition code for javax.sql.RowSet.removeRowSetListener(javax.sql.RowSetListener) , setArray sample code for javax.sql.RowSet.setArray(int, java.sql.Array) definition code for javax.sql.RowSet.setArray(int, java.sql.Array) , setAsciiStream sample code for javax.sql.RowSet.setAsciiStream(int, java.io.InputStream, int) definition code for javax.sql.RowSet.setAsciiStream(int, java.io.InputStream, int) , setBigDecimal sample code for javax.sql.RowSet.setBigDecimal(int, java.math.BigDecimal) definition code for javax.sql.RowSet.setBigDecimal(int, java.math.BigDecimal) , setBinaryStream sample code for javax.sql.RowSet.setBinaryStream(int, java.io.InputStream, int) definition code for javax.sql.RowSet.setBinaryStream(int, java.io.InputStream, int) , setBlob sample code for javax.sql.RowSet.setBlob(int, java.sql.Blob) definition code for javax.sql.RowSet.setBlob(int, java.sql.Blob) , setBoolean sample code for javax.sql.RowSet.setBoolean(int, boolean) definition code for javax.sql.RowSet.setBoolean(int, boolean) , setByte sample code for javax.sql.RowSet.setByte(int, byte) definition code for javax.sql.RowSet.setByte(int, byte) , setBytes sample code for javax.sql.RowSet.setBytes(int, byte[]) definition code for javax.sql.RowSet.setBytes(int, byte[]) , setCharacterStream sample code for javax.sql.RowSet.setCharacterStream(int, java.io.Reader, int) definition code for javax.sql.RowSet.setCharacterStream(int, java.io.Reader, int) , setClob sample code for javax.sql.RowSet.setClob(int, java.sql.Clob) definition code for javax.sql.RowSet.setClob(int, java.sql.Clob) , setCommand sample code for javax.sql.RowSet.setCommand(java.lang.String) definition code for javax.sql.RowSet.setCommand(java.lang.String) , setConcurrency sample code for javax.sql.RowSet.setConcurrency(int) definition code for javax.sql.RowSet.setConcurrency(int) , setDataSourceName sample code for javax.sql.RowSet.setDataSourceName(java.lang.String) definition code for javax.sql.RowSet.setDataSourceName(java.lang.String) , setDate sample code for javax.sql.RowSet.setDate(int, java.sql.Date) definition code for javax.sql.RowSet.setDate(int, java.sql.Date) , setDate sample code for javax.sql.RowSet.setDate(int, java.sql.Date, java.util.Calendar) definition code for javax.sql.RowSet.setDate(int, java.sql.Date, java.util.Calendar) , setDouble sample code for javax.sql.RowSet.setDouble(int, double) definition code for javax.sql.RowSet.setDouble(int, double) , setEscapeProcessing sample code for javax.sql.RowSet.setEscapeProcessing(boolean) definition code for javax.sql.RowSet.setEscapeProcessing(boolean) , setFloat sample code for javax.sql.RowSet.setFloat(int, float) definition code for javax.sql.RowSet.setFloat(int, float) , setInt sample code for javax.sql.RowSet.setInt(int, int) definition code for javax.sql.RowSet.setInt(int, int) , setLong sample code for javax.sql.RowSet.setLong(int, long) definition code for javax.sql.RowSet.setLong(int, long) , setMaxFieldSize sample code for javax.sql.RowSet.setMaxFieldSize(int) definition code for javax.sql.RowSet.setMaxFieldSize(int) , setMaxRows sample code for javax.sql.RowSet.setMaxRows(int) definition code for javax.sql.RowSet.setMaxRows(int) , setNull sample code for javax.sql.RowSet.setNull(int, int) definition code for javax.sql.RowSet.setNull(int, int) , setNull sample code for javax.sql.RowSet.setNull(int, int, java.lang.String) definition code for javax.sql.RowSet.setNull(int, int, java.lang.String) , setObject sample code for javax.sql.RowSet.setObject(int, java.lang.Object) definition code for javax.sql.RowSet.setObject(int, java.lang.Object) , setObject sample code for javax.sql.RowSet.setObject(int, java.lang.Object, int) definition code for javax.sql.RowSet.setObject(int, java.lang.Object, int) , setObject sample code for javax.sql.RowSet.setObject(int, java.lang.Object, int, int) definition code for javax.sql.RowSet.setObject(int, java.lang.Object, int, int) , setPassword sample code for javax.sql.RowSet.setPassword(java.lang.String) definition code for javax.sql.RowSet.setPassword(java.lang.String) , setQueryTimeout sample code for javax.sql.RowSet.setQueryTimeout(int) definition code for javax.sql.RowSet.setQueryTimeout(int) , setReadOnly sample code for javax.sql.RowSet.setReadOnly(boolean) definition code for javax.sql.RowSet.setReadOnly(boolean) , setRef sample code for javax.sql.RowSet.setRef(int, java.sql.Ref) definition code for javax.sql.RowSet.setRef(int, java.sql.Ref) , setShort sample code for javax.sql.RowSet.setShort(int, short) definition code for javax.sql.RowSet.setShort(int, short) , setString sample code for javax.sql.RowSet.setString(int, java.lang.String) definition code for javax.sql.RowSet.setString(int, java.lang.String) , setTime sample code for javax.sql.RowSet.setTime(int, java.sql.Time) definition code for javax.sql.RowSet.setTime(int, java.sql.Time) , setTime sample code for javax.sql.RowSet.setTime(int, java.sql.Time, java.util.Calendar) definition code for javax.sql.RowSet.setTime(int, java.sql.Time, java.util.Calendar) , setTimestamp sample code for javax.sql.RowSet.setTimestamp(int, java.sql.Timestamp) definition code for javax.sql.RowSet.setTimestamp(int, java.sql.Timestamp) , setTimestamp sample code for javax.sql.RowSet.setTimestamp(int, java.sql.Timestamp, java.util.Calendar) definition code for javax.sql.RowSet.setTimestamp(int, java.sql.Timestamp, java.util.Calendar) , setTransactionIsolation sample code for javax.sql.RowSet.setTransactionIsolation(int) definition code for javax.sql.RowSet.setTransactionIsolation(int) , setType sample code for javax.sql.RowSet.setType(int) definition code for javax.sql.RowSet.setType(int) , setTypeMap sample code for javax.sql.RowSet.setTypeMap(java.util.Map) definition code for javax.sql.RowSet.setTypeMap(java.util.Map) , setUrl sample code for javax.sql.RowSet.setUrl(java.lang.String) definition code for javax.sql.RowSet.setUrl(java.lang.String) , setUsername sample code for javax.sql.RowSet.setUsername(java.lang.String) definition code for javax.sql.RowSet.setUsername(java.lang.String)
 
Methods inherited from interface java.sql.ResultSet sample code for java.sql.ResultSet definition code for java.sql.ResultSet
absolute sample code for java.sql.ResultSet.absolute(int) definition code for java.sql.ResultSet.absolute(int) , afterLast sample code for java.sql.ResultSet.afterLast() definition code for java.sql.ResultSet.afterLast() , beforeFirst sample code for java.sql.ResultSet.beforeFirst() definition code for java.sql.ResultSet.beforeFirst() , cancelRowUpdates sample code for java.sql.ResultSet.cancelRowUpdates() definition code for java.sql.ResultSet.cancelRowUpdates() , clearWarnings sample code for java.sql.ResultSet.clearWarnings() definition code for java.sql.ResultSet.clearWarnings() , close sample code for java.sql.ResultSet.close() definition code for java.sql.ResultSet.close() , deleteRow sample code for java.sql.ResultSet.deleteRow() definition code for java.sql.ResultSet.deleteRow() , findColumn sample code for java.sql.ResultSet.findColumn(java.lang.String) definition code for java.sql.ResultSet.findColumn(java.lang.String) , first sample code for java.sql.ResultSet.first() definition code for java.sql.ResultSet.first() , getArray sample code for java.sql.ResultSet.getArray(int) definition code for java.sql.ResultSet.getArray(int) , getArray sample code for java.sql.ResultSet.getArray(java.lang.String) definition code for java.sql.ResultSet.getArray(java.lang.String) , getAsciiStream sample code for java.sql.ResultSet.getAsciiStream(int) definition code for java.sql.ResultSet.getAsciiStream(int) , getAsciiStream sample code for java.sql.ResultSet.getAsciiStream(java.lang.String) definition code for java.sql.ResultSet.getAsciiStream(java.lang.String) , getBigDecimal sample code for java.sql.ResultSet.getBigDecimal(int) definition code for java.sql.ResultSet.getBigDecimal(int) , getBigDecimal sample code for java.sql.ResultSet.getBigDecimal(int, int) definition code for java.sql.ResultSet.getBigDecimal(int, int) , getBigDecimal sample code for java.sql.ResultSet.getBigDecimal(java.lang.String) definition code for java.sql.ResultSet.getBigDecimal(java.lang.String) , getBigDecimal sample code for java.sql.ResultSet.getBigDecimal(java.lang.String, int) definition code for java.sql.ResultSet.getBigDecimal(java.lang.String, int) , getBinaryStream sample code for java.sql.ResultSet.getBinaryStream(int) definition code for java.sql.ResultSet.getBinaryStream(int) , getBinaryStream sample code for java.sql.ResultSet.getBinaryStream(java.lang.String) definition code for java.sql.ResultSet.getBinaryStream(java.lang.String) , getBlob sample code for java.sql.ResultSet.getBlob(int) definition code for java.sql.ResultSet.getBlob(int) , getBlob sample code for java.sql.ResultSet.getBlob(java.lang.String) definition code for java.sql.ResultSet.getBlob(java.lang.String) , getBoolean sample code for java.sql.ResultSet.getBoolean(int) definition code for java.sql.ResultSet.getBoolean(int) , getBoolean sample code for java.sql.ResultSet.getBoolean(java.lang.String) definition code for java.sql.ResultSet.getBoolean(java.lang.String) , getByte sample code for java.sql.ResultSet.getByte(int) definition code for java.sql.ResultSet.getByte(int) , getByte sample code for java.sql.ResultSet.getByte(java.lang.String) definition code for java.sql.ResultSet.getByte(java.lang.String) , getBytes sample code for java.sql.ResultSet.getBytes(int) definition code for java.sql.ResultSet.getBytes(int) , getBytes sample code for java.sql.ResultSet.getBytes(java.lang.String) definition code for java.sql.ResultSet.getBytes(java.lang.String) , getCharacterStream sample code for java.sql.ResultSet.getCharacterStream(int) definition code for java.sql.ResultSet.getCharacterStream(int) , getCharacterStream sample code for java.sql.ResultSet.getCharacterStream(java.lang.String) definition code for java.sql.ResultSet.getCharacterStream(java.lang.String) , getClob sample code for java.sql.ResultSet.getClob(int) definition code for java.sql.ResultSet.getClob(int) , getClob sample code for java.sql.ResultSet.getClob(java.lang.String) definition code for java.sql.ResultSet.getClob(java.lang.String) , getConcurrency sample code for java.sql.ResultSet.getConcurrency() definition code for java.sql.ResultSet.getConcurrency() , getCursorName sample code for java.sql.ResultSet.getCursorName() definition code for java.sql.ResultSet.getCursorName() , getDate sample code for java.sql.ResultSet.getDate(int) definition code for java.sql.ResultSet.getDate(int) , getDate sample code for java.sql.ResultSet.getDate(int, java.util.Calendar) definition code for java.sql.ResultSet.getDate(int, java.util.Calendar) , getDate sample code for java.sql.ResultSet.getDate(java.lang.String) definition code for java.sql.ResultSet.getDate(java.lang.String) , getDate sample code for java.sql.ResultSet.getDate(java.lang.String, java.util.Calendar) definition code for java.sql.ResultSet.getDate(java.lang.String, java.util.Calendar) , getDouble sample code for java.sql.ResultSet.getDouble(int) definition code for java.sql.ResultSet.getDouble(int) , getDouble sample code for java.sql.ResultSet.getDouble(java.lang.String) definition code for java.sql.ResultSet.getDouble(java.lang.String) , getFetchDirection sample code for java.sql.ResultSet.getFetchDirection() definition code for java.sql.ResultSet.getFetchDirection() , getFetchSize sample code for java.sql.ResultSet.getFetchSize() definition code for java.sql.ResultSet.getFetchSize() , getFloat sample code for java.sql.ResultSet.getFloat(int) definition code for java.sql.ResultSet.getFloat(int) , getFloat sample code for java.sql.ResultSet.getFloat(java.lang.String) definition code for java.sql.ResultSet.getFloat(java.lang.String) , getInt sample code for java.sql.ResultSet.getInt(int) definition code for java.sql.ResultSet.getInt(int) , getInt sample code for java.sql.ResultSet.getInt(java.lang.String) definition code for java.sql.ResultSet.getInt(java.lang.String) , getLong sample code for java.sql.ResultSet.getLong(int) definition code for java.sql.ResultSet.getLong(int) , getLong sample code for java.sql.ResultSet.getLong(java.lang.String) definition code for java.sql.ResultSet.getLong(java.lang.String) , getMetaData sample code for java.sql.ResultSet.getMetaData() definition code for java.sql.ResultSet.getMetaData() , getObject sample code for java.sql.ResultSet.getObject(int) definition code for java.sql.ResultSet.getObject(int) , getObject sample code for java.sql.ResultSet.getObject(int, java.util.Map) definition code for java.sql.ResultSet.getObject(int, java.util.Map) , getObject sample code for java.sql.ResultSet.getObject(java.lang.String) definition code for java.sql.ResultSet.getObject(java.lang.String) , getObject sample code for java.sql.ResultSet.getObject(java.lang.String, java.util.Map) definition code for java.sql.ResultSet.getObject(java.lang.String, java.util.Map) , getRef sample code for java.sql.ResultSet.getRef(int) definition code for java.sql.ResultSet.getRef(int) , getRef sample code for java.sql.ResultSet.getRef(java.lang.String) definition code for java.sql.ResultSet.getRef(java.lang.String) , getRow sample code for java.sql.ResultSet.getRow() definition code for java.sql.ResultSet.getRow() , getShort sample code for java.sql.ResultSet.getShort(int) definition code for java.sql.ResultSet.getShort(int) , getShort sample code for java.sql.ResultSet.getShort(java.lang.String) definition code for java.sql.ResultSet.getShort(java.lang.String) , getStatement sample code for java.sql.ResultSet.getStatement() definition code for java.sql.ResultSet.getStatement() , getString sample code for java.sql.ResultSet.getString(int) definition code for java.sql.ResultSet.getString(int) , getString sample code for java.sql.ResultSet.getString(java.lang.String) definition code for java.sql.ResultSet.getString(java.lang.String) , getTime sample code for java.sql.ResultSet.getTime(int) definition code for java.sql.ResultSet.getTime(int) , getTime sample code for java.sql.ResultSet.getTime(int, java.util.Calendar) definition code for java.sql.ResultSet.getTime(int, java.util.Calendar) , getTime sample code for java.sql.ResultSet.getTime(java.lang.String) definition code for java.sql.ResultSet.getTime(java.lang.String) , getTime sample code for java.sql.ResultSet.getTime(java.lang.String, java.util.Calendar) definition code for java.sql.ResultSet.getTime(java.lang.String, java.util.Calendar) , getTimestamp sample code for java.sql.ResultSet.getTimestamp(int) definition code for java.sql.ResultSet.getTimestamp(int) , getTimestamp sample code for java.sql.ResultSet.getTimestamp(int, java.util.Calendar) definition code for java.sql.ResultSet.getTimestamp(int, java.util.Calendar) , getTimestamp sample code for java.sql.ResultSet.getTimestamp(java.lang.String) definition code for java.sql.ResultSet.getTimestamp(java.lang.String) , getTimestamp sample code for java.sql.ResultSet.getTimestamp(java.lang.String, java.util.Calendar) definition code for java.sql.ResultSet.getTimestamp(java.lang.String, java.util.Calendar) , getType sample code for java.sql.ResultSet.getType() definition code for java.sql.ResultSet.getType() , getUnicodeStream sample code for java.sql.ResultSet.getUnicodeStream(int) definition code for java.sql.ResultSet.getUnicodeStream(int) , getUnicodeStream sample code for java.sql.ResultSet.getUnicodeStream(java.lang.String) definition code for java.sql.ResultSet.getUnicodeStream(java.lang.String) , getURL sample code for java.sql.ResultSet.getURL(int) definition code for java.sql.ResultSet.getURL(int) , getURL sample code for java.sql.ResultSet.getURL(java.lang.String) definition code for java.sql.ResultSet.getURL(java.lang.String) , getWarnings sample code for java.sql.ResultSet.getWarnings() definition code for java.sql.ResultSet.getWarnings() , insertRow sample code for java.sql.ResultSet.insertRow() definition code for java.sql.ResultSet.insertRow() , isAfterLast sample code for java.sql.ResultSet.isAfterLast() definition code for java.sql.ResultSet.isAfterLast() , isBeforeFirst sample code for java.sql.ResultSet.isBeforeFirst() definition code for java.sql.ResultSet.isBeforeFirst() , isFirst sample code for java.sql.ResultSet.isFirst() definition code for java.sql.ResultSet.isFirst() , isLast sample code for java.sql.ResultSet.isLast() definition code for java.sql.ResultSet.isLast() , last sample code for java.sql.ResultSet.last() definition code for java.sql.ResultSet.last() , moveToCurrentRow sample code for java.sql.ResultSet.moveToCurrentRow() definition code for java.sql.ResultSet.moveToCurrentRow() , moveToInsertRow sample code for java.sql.ResultSet.moveToInsertRow() definition code for java.sql.ResultSet.moveToInsertRow() , next sample code for java.sql.ResultSet.next() definition code for java.sql.ResultSet.next() , previous sample code for java.sql.ResultSet.previous() definition code for java.sql.ResultSet.previous() , refreshRow sample code for java.sql.ResultSet.refreshRow() definition code for java.sql.ResultSet.refreshRow() , relative sample code for java.sql.ResultSet.relative(int) definition code for java.sql.ResultSet.relative(int) , rowDeleted sample code for java.sql.ResultSet.rowDeleted() definition code for java.sql.ResultSet.rowDeleted() , rowInserted sample code for java.sql.ResultSet.rowInserted() definition code for java.sql.ResultSet.rowInserted() , rowUpdated sample code for java.sql.ResultSet.rowUpdated() definition code for java.sql.ResultSet.rowUpdated() , setFetchDirection sample code for java.sql.ResultSet.setFetchDirection(int) definition code for java.sql.ResultSet.setFetchDirection(int) , setFetchSize sample code for java.sql.ResultSet.setFetchSize(int) definition code for java.sql.ResultSet.setFetchSize(int) , updateArray sample code for java.sql.ResultSet.updateArray(int, java.sql.Array) definition code for java.sql.ResultSet.updateArray(int, java.sql.Array) , updateArray sample code for java.sql.ResultSet.updateArray(java.lang.String, java.sql.Array) definition code for java.sql.ResultSet.updateArray(java.lang.String, java.sql.Array) , updateAsciiStream sample code for java.sql.ResultSet.updateAsciiStream(int, java.io.InputStream, int) definition code for java.sql.ResultSet.updateAsciiStream(int, java.io.InputStream, int) , updateAsciiStream sample code for java.sql.ResultSet.updateAsciiStream(java.lang.String, java.io.InputStream, int) definition code for java.sql.ResultSet.updateAsciiStream(java.lang.String, java.io.InputStream, int) , updateBigDecimal sample code for java.sql.ResultSet.updateBigDecimal(int, java.math.BigDecimal) definition code for java.sql.ResultSet.updateBigDecimal(int, java.math.BigDecimal) , updateBigDecimal sample code for java.sql.ResultSet.updateBigDecimal(java.lang.String, java.math.BigDecimal) definition code for java.sql.ResultSet.updateBigDecimal(java.lang.String, java.math.BigDecimal) , updateBinaryStream sample code for java.sql.ResultSet.updateBinaryStream(int, java.io.InputStream, int) definition code for java.sql.ResultSet.updateBinaryStream(int, java.io.InputStream, int) , updateBinaryStream sample code for java.sql.ResultSet.updateBinaryStream(java.lang.String, java.io.InputStream, int) definition code for java.sql.ResultSet.updateBinaryStream(java.lang.String, java.io.InputStream, int) , updateBlob sample code for java.sql.ResultSet.updateBlob(int, java.sql.Blob) definition code for java.sql.ResultSet.updateBlob(int, java.sql.Blob) , updateBlob sample code for java.sql.ResultSet.updateBlob(java.lang.String, java.sql.Blob) definition code for java.sql.ResultSet.updateBlob(java.lang.String, java.sql.Blob) , updateBoolean sample code for java.sql.ResultSet.updateBoolean(int, boolean) definition code for java.sql.ResultSet.updateBoolean(int, boolean) , updateBoolean sample code for java.sql.ResultSet.updateBoolean(java.lang.String, boolean) definition code for java.sql.ResultSet.updateBoolean(java.lang.String, boolean) , updateByte sample code for java.sql.ResultSet.updateByte(int, byte) definition code for java.sql.ResultSet.updateByte(int, byte) , updateByte sample code for java.sql.ResultSet.updateByte(java.lang.String, byte) definition code for java.sql.ResultSet.updateByte(java.lang.String, byte) , updateBytes sample code for java.sql.ResultSet.updateBytes(int, byte[]) definition code for java.sql.ResultSet.updateBytes(int, byte[]) , updateBytes sample code for java.sql.ResultSet.updateBytes(java.lang.String, byte[]) definition code for java.sql.ResultSet.updateBytes(java.lang.String, byte[]) , updateCharacterStream sample code for java.sql.ResultSet.updateCharacterStream(int, java.io.Reader, int) definition code for java.sql.ResultSet.updateCharacterStream(int, java.io.Reader, int) , updateCharacterStream sample code for java.sql.ResultSet.updateCharacterStream(java.lang.String, java.io.Reader, int) definition code for java.sql.ResultSet.updateCharacterStream(java.lang.String, java.io.Reader, int) , updateClob sample code for java.sql.ResultSet.updateClob(int, java.sql.Clob) definition code for java.sql.ResultSet.updateClob(int, java.sql.Clob) , updateClob sample code for java.sql.ResultSet.updateClob(java.lang.String, java.sql.Clob) definition code for java.sql.ResultSet.updateClob(java.lang.String, java.sql.Clob) , updateDate sample code for java.sql.ResultSet.updateDate(int, java.sql.Date) definition code for java.sql.ResultSet.updateDate(int, java.sql.Date) , updateDate sample code for java.sql.ResultSet.updateDate(java.lang.String, java.sql.Date) definition code for java.sql.ResultSet.updateDate(java.lang.String, java.sql.Date) , updateDouble sample code for java.sql.ResultSet.updateDouble(int, double) definition code for java.sql.ResultSet.updateDouble(int, double) , updateDouble sample code for java.sql.ResultSet.updateDouble(java.lang.String, double) definition code for java.sql.ResultSet.updateDouble(java.lang.String, double) , updateFloat sample code for java.sql.ResultSet.updateFloat(int, float) definition code for java.sql.ResultSet.updateFloat(int, float) , updateFloat sample code for java.sql.ResultSet.updateFloat(java.lang.String, float) definition code for java.sql.ResultSet.updateFloat(java.lang.String, float) , updateInt sample code for java.sql.ResultSet.updateInt(int, int) definition code for java.sql.ResultSet.updateInt(int, int) , updateInt sample code for java.sql.ResultSet.updateInt(java.lang.String, int) definition code for java.sql.ResultSet.updateInt(java.lang.String, int) , updateLong sample code for java.sql.ResultSet.updateLong(int, long) definition code for java.sql.ResultSet.updateLong(int, long) , updateLong sample code for java.sql.ResultSet.updateLong(java.lang.String, long) definition code for java.sql.ResultSet.updateLong(java.lang.String, long) , updateNull sample code for java.sql.ResultSet.updateNull(int) definition code for java.sql.ResultSet.updateNull(int) , updateNull sample code for java.sql.ResultSet.updateNull(java.lang.String) definition code for java.sql.ResultSet.updateNull(java.lang.String) , updateObject sample code for java.sql.ResultSet.updateObject(int, java.lang.Object) definition code for java.sql.ResultSet.updateObject(int, java.lang.Object) , updateObject sample code for java.sql.ResultSet.updateObject(int, java.lang.Object, int) definition code for java.sql.ResultSet.updateObject(int, java.lang.Object, int) , updateObject sample code for java.sql.ResultSet.updateObject(java.lang.String, java.lang.Object) definition code for java.sql.ResultSet.updateObject(java.lang.String, java.lang.Object) , updateObject sample code for java.sql.ResultSet.updateObject(java.lang.String, java.lang.Object, int) definition code for java.sql.ResultSet.updateObject(java.lang.String, java.lang.Object, int) , updateRef sample code for java.sql.ResultSet.updateRef(int, java.sql.Ref) definition code for java.sql.ResultSet.updateRef(int, java.sql.Ref) , updateRef sample code for java.sql.ResultSet.updateRef(java.lang.String, java.sql.Ref) definition code for java.sql.ResultSet.updateRef(java.lang.String, java.sql.Ref) , updateRow sample code for java.sql.ResultSet.updateRow() definition code for java.sql.ResultSet.updateRow() , updateShort sample code for java.sql.ResultSet.updateShort(int, short) definition code for java.sql.ResultSet.updateShort(int, short) , updateShort sample code for java.sql.ResultSet.updateShort(java.lang.String, short) definition code for java.sql.ResultSet.updateShort(java.lang.String, short) , updateString sample code for java.sql.ResultSet.updateString(int, java.lang.String) definition code for java.sql.ResultSet.updateString(int, java.lang.String) , updateString sample code for java.sql.ResultSet.updateString(java.lang.String, java.lang.String) definition code for java.sql.ResultSet.updateString(java.lang.String, java.lang.String) , updateTime sample code for java.sql.ResultSet.updateTime(int, java.sql.Time) definition code for java.sql.ResultSet.updateTime(int, java.sql.Time) , updateTime sample code for java.sql.ResultSet.updateTime(java.lang.String, java.sql.Time) definition code for java.sql.ResultSet.updateTime(java.lang.String, java.sql.Time) , updateTimestamp sample code for java.sql.ResultSet.updateTimestamp(int, java.sql.Timestamp) definition code for java.sql.ResultSet.updateTimestamp(int, java.sql.Timestamp) , updateTimestamp sample code for java.sql.ResultSet.updateTimestamp(java.lang.String, java.sql.Timestamp) definition code for java.sql.ResultSet.updateTimestamp(java.lang.String, java.sql.Timestamp) , wasNull sample code for java.sql.ResultSet.wasNull() definition code for java.sql.ResultSet.wasNull()
 
Methods inherited from interface javax.sql.rowset.Joinable sample code for javax.sql.rowset.Joinable definition code for javax.sql.rowset.Joinable
getMatchColumnIndexes sample code for javax.sql.rowset.Joinable.getMatchColumnIndexes() definition code for javax.sql.rowset.Joinable.getMatchColumnIndexes() , getMatchColumnNames sample code for javax.sql.rowset.Joinable.getMatchColumnNames() definition code for javax.sql.rowset.Joinable.getMatchColumnNames() , setMatchColumn sample code for javax.sql.rowset.Joinable.setMatchColumn(int) definition code for javax.sql.rowset.Joinable.setMatchColumn(int) , setMatchColumn sample code for javax.sql.rowset.Joinable.setMatchColumn(int[]) definition code for javax.sql.rowset.Joinable.setMatchColumn(int[]) , setMatchColumn sample code for javax.sql.rowset.Joinable.setMatchColumn(java.lang.String) definition code for javax.sql.rowset.Joinable.setMatchColumn(java.lang.String) , setMatchColumn sample code for javax.sql.rowset.Joinable.setMatchColumn(java.lang.String[]) definition code for javax.sql.rowset.Joinable.setMatchColumn(java.lang.String[]) , unsetMatchColumn sample code for javax.sql.rowset.Joinable.unsetMatchColumn(int) definition code for javax.sql.rowset.Joinable.unsetMatchColumn(int) , unsetMatchColumn sample code for javax.sql.rowset.Joinable.unsetMatchColumn(int[]) definition code for javax.sql.rowset.Joinable.unsetMatchColumn(int[]) , unsetMatchColumn sample code for javax.sql.rowset.Joinable.unsetMatchColumn(java.lang.String) definition code for javax.sql.rowset.Joinable.unsetMatchColumn(java.lang.String) , unsetMatchColumn sample code for javax.sql.rowset.Joinable.unsetMatchColumn(java.lang.String[]) definition code for javax.sql.rowset.Joinable.unsetMatchColumn(java.lang.String[])
 

Method Detail

setFilter sample code for javax.sql.rowset.FilteredRowSet.setFilter(javax.sql.rowset.Predicate) definition code for javax.sql.rowset.FilteredRowSet.setFilter(javax.sql.rowset.Predicate)

void setFilter(Predicate sample code for javax.sql.rowset.Predicate definition code for javax.sql.rowset.Predicate  p)
               throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException 
Applies the given Predicate object to this FilteredRowSet object. The filter applies controls both to inbound and outbound views, constraining which rows are visible and which rows can be manipulated.

A new Predicate object may be set at any time. This has the effect of changing constraints on the RowSet object's data. In addition, modifying the filter at runtime presents issues whereby multiple components may be operating on one FilteredRowSet object. Application developers must take responsibility for managing multiple handles to FilteredRowSet objects when their underling Predicate objects change.

Parameters:
p - a Predicate object defining the filter for this FilteredRowSet object. Setting a null value will clear the predicate, allowing all rows to become visible.
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if an error occurs when setting the Predicate object

getFilter sample code for javax.sql.rowset.FilteredRowSet.getFilter() definition code for javax.sql.rowset.FilteredRowSet.getFilter()

Predicate sample code for javax.sql.rowset.Predicate definition code for javax.sql.rowset.Predicate  getFilter()
Retrieves the active filter for this FilteredRowSet object.

Returns:
p the Predicate for this FilteredRowSet object; null if no filter has been set.