borland Packages  Class Hierarchy  sql.dataset Package  Index 

QueryProvider component

java.lang.Object
   +----borland.jbcl.dataset.Provider
           +----borland.sql.dataset.JdbcProvider
                   +----borland.sql.dataset.QueryProvider

About the QueryProvider component

Constructors  Properties  Methods  

Implements LoadCancel, ConnectionUpdateListener, Task, Serializable, EventListener

The QueryProvider component is used to provide data to a DataSet by running a query through JDBC. This component is also a place holder for static methods for executing statements with parameters (see executeStatement()).


QueryProvider constructors

QueryProvider properties

*Read-only properties **Write-only properties

Properties implemented in this class

Properties implemented in borland.sql.dataset.JdbcProvider

Properties implemented in java.lang.Object

QueryProvider methods

Methods implemented in this class

Methods implemented in borland.jbcl.dataset.Provider

Methods implemented in borland.sql.dataset.JdbcProvider

Methods implemented in java.lang.Object


QueryProvider constructors

QueryProvider()

  public QueryProvider()
Creates a QueryProvider object.

QueryProvider properties

query

 public final QueryDescriptor getQuery()
 public final void setQuery(borland.sql.dataset.QueryDescriptor queryDescriptor)
The QueryDescriptor object that contains query properties.

QueryProvider methods

checkMasterLink(borland.jbcl.dataset.MasterLinkDescriptor)

  public void checkMasterLink(borland.jbcl.dataset.MasterLinkDescriptor masterLink)
Called by the StorageDataSet to allow the provider to validate the masterLink property. When the MasterLinkDescriptor.fetchAsNeeded property is enabled (true), the QueryProvider uses this method to check if there is a WHERE clause in the query. If no WHERE clause is specified, the QueryProvider throws a DataSetException.

Overrides: borland.jbcl.dataset.Provider.checkMasterLink(borland.jbcl.dataset.MasterLinkDescriptor)

executeStatement(borland.sql.dataset.Database, java.lang.String, borland.jbcl.dataset.ReadWriteRow)

  public static final int executeStatement(borland.sql.dataset.Database database, java.lang.String statement, borland.jbcl.dataset.ReadWriteRow parameters)
Executes the statement with the specified parameters:

Parameters:

database
The Database object associated with the query.
statement
The query statement to execute.
parameters
The ReadWriteRow implementation that stores values for the query parameters.

executeStatement(borland.sql.dataset.Database, java.lang.String, borland.jbcl.dataset.ReadWriteRow[])

  public static final int executeStatement(borland.sql.dataset.Database database, java.lang.String statement, borland.jbcl.dataset.ReadWriteRow[] parameters)
Executes the statement with the specified parameters:

Parameters:

database
The Database object associated with the query.
statement
The query statement to execute.
parameters
An array of ReadWriteRow objects that store values for the query parameters. You must name the access to the parameters using the format:
:1.PARM_NAME

getQueryString(borland.jbcl.dataset.StorageDataSet)

  public final String getQueryString(borland.jbcl.dataset.StorageDataSet sds)