oracle.dacf.dataset
Interface SearchableRowsetAccess

All Superinterfaces:

javax.infobus.RowsetAccess, javax.infobus.ScrollableRowsetAccess

All Known Implementing Classes:

oracle.dacf.dataset.RowsetAccessImpl

public interface SearchableRowsetAccess

extends javax.infobus.ScrollableRowsetAccess

This interface is an extension of javax.infobus.ScrollableRowsetAccess that allows searching of the retrieved rows.

Version:

SDK

Method Summary

int	findRangeIndexOf(java.lang.String[] colNames, java.lang.Object[] values) Searches for a row, like the findRow method above.
boolean	findRow(java.lang.String[] colNames, java.lang.Object[] values) Finds a the first row within the result set that contains values in columns.

Methods inherited from interface javax.infobus.ScrollableRowsetAccess

absolute, first, getBufferSize, getRow, getRowCount, last, newCursor, previous, relative, setBufferSize

Methods inherited from interface javax.infobus.RowsetAccess

canDelete, canInsert, canUpdate, canUpdate, canUpdate, deleteRow, flush, getColumnCount, getColumnDatatypeName, getColumnDatatypeNumber, getColumnItem, getColumnItem, getColumnName, getDb, getHighWaterMark, hasMoreRows, lockRow, newRow, next, setColumnValue, setColumnValue

Method Detail

findRow

public boolean findRow(java.lang.String[] colNames,
                       java.lang.Object[] values)
                throws javax.infobus.ColumnNotFoundException,
                       javax.infobus.DuplicateColumnException,
                       java.sql.SQLException

Finds a the first row within the result set that contains values in columns.

There must be a one-to-one correspondence between the colNames and values arrays. The columns listed in colNames must be the primary keys used to produce the result set. The value values[n] will be used as the search value for colNames[n]. Individual null entries are allowed in values and will be mapped to the SQL null value.

Parameters:

colNames - The name of the columns to search within

values - The values to use for the comparison

Returns:

true if a row was found that matches the search criteria

Throws:

javax.infobus.ColumnNotFoundException, - javax.infobus.DuplicateColumnException, java.sql.SQLException;

javax.infobus.ColumnNotFoundException

javax.infobus.DuplicateColumnException

java.sql.SQLException

findRangeIndexOf

public int findRangeIndexOf(java.lang.String[] colNames,
                            java.lang.Object[] values)
                     throws javax.infobus.ColumnNotFoundException,
                            javax.infobus.DuplicateColumnException,
                            java.sql.SQLException

Searches for a row, like the findRow method above. If a row is found it returns the index of the row relative to the Range index of the RowSet. If there is no row is found matching the column values -1 is returned

Parameters:

colNames - The name of the columns to search within

values - The values to use for the comparison

Returns:

true if a row was found that matches the search criteria

Throws:

javax.infobus.ColumnNotFoundException, - javax.infobus.DuplicateColumnException, java.sql.SQLException;

javax.infobus.ColumnNotFoundException

javax.infobus.DuplicateColumnException

java.sql.SQLException

See Also:

RowSetIterator