oracle.apps.fnd.applcore.dt.common.model
Class JdbcLovDataProviderImpl

java.lang.Object
  oracle.apps.fnd.applcore.dt.common.model.AbstractLovDataProviderImpl
      oracle.apps.fnd.applcore.dt.common.model.JdbcLovDataProviderImpl

All Implemented Interfaces:

LovDataProvider

Direct Known Subclasses:

DependentJdbcLovDataProviderImpl

public class JdbcLovDataProviderImpl
extends AbstractLovDataProviderImpl

JDBC Implementation of LOV (List of Values) Data Provider.

Author:

Michael Luetchford <michael.luetchford@oracle.com>

Field Summary

Fields inherited from class oracle.apps.fnd.applcore.dt.common.model.AbstractLovDataProviderImpl

_columns

Constructor Summary

JdbcLovDataProviderImpl(java.lang.String query, java.util.List<LovDataProviderColumn> columnNames, java.sql.Connection connection)
Constructor to provide sufficient context for this provider to retrieve the values required for this LOV.

Method Summary

void	applyCriteria(java.util.Map<LovDataProviderColumn,java.lang.Object> criteria) Retrieve the data from the query using the supplied criteria.
void	close() Close the result set for this query.
java.util.List	getData() Retrieve the current data row.
boolean	next() Check whether another data row exists.

Methods inherited from class oracle.apps.fnd.applcore.dt.common.model.AbstractLovDataProviderImpl

getColumnCount, getColumnNames, getColumns, getHiddenColumnIndexes

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

JdbcLovDataProviderImpl

public JdbcLovDataProviderImpl(java.lang.String query,
                               java.util.List<LovDataProviderColumn> columnNames,
                               java.sql.Connection connection)
                        throws java.lang.ClassNotFoundException,
                               java.sql.SQLException

Constructor to provide sufficient context for this provider to retrieve the values required for this LOV.

Parameters:

query - The SQL query that should be executed including bind parameters for criteria items.

columnNames - The names that should be displayed for the SQL query columns - null means the column should not be displayed.

connection - The JDBC Database connection.

Throws:

java.lang.ClassNotFoundException - Query prepartion exception.

java.sql.SQLException - Query prepartion exception.

Method Detail

applyCriteria

public void applyCriteria(java.util.Map<LovDataProviderColumn,java.lang.Object> criteria)

Retrieve the data from the query using the supplied criteria.

Parameters:

criteria - The bind variables that should be applied to the query.

getData

public java.util.List getData()

Retrieve the current data row.

Returns:

the current data row.

next

public boolean next()

Check whether another data row exists.

Returns:

true if another data row exists.

close

public void close()

Close the result set for this query.