|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
com.ibm.etill.ldbcardcassette.LdbCardCassetteQuery.AccountQuery
An account query object automatically selects information from the cassette dependent account table using the same criteria that was used to select information from the framework account table. It is responsible for building the correct SQL statement, performing the query, and collecting the results. Furthermore, it is responsible for combining the information from each cassette account extension with the information already gathered for the framework account.
A query object trades simplicity for efficiency. The simplest technique for acquiring cassette dependent information for each account would be to perform a SQL Select statement for each framework account passed to the cassette query object. Instead, this query object performs a single SQL Select statement, joining the cassette dependent account table with the framework account table using the same criteria used to select the framework accounts passed to the cassette query object.
Inner Class Summary | |
class |
LdbCardCassetteQuery.AccountQuery.AccountInfo
An account information object contains the information gathered from one row of the cassette dependent account table. |
Field Summary | |
private java.util.Hashtable |
objAccounts
This query attribute is a collection of all the information selected from the cassette dependent account table. |
Constructor Summary | |
LdbCardCassetteQuery.AccountQuery(com.ibm.etill.framework.xdm.AccountQueryRequest argRequest)
This constructor is use by the cassette query object when it is asked to service an AccountQuery request. |
Method Summary | |
void |
combine(java.util.Vector argFrameworkObjects)
This method is used by the cassette query object to combine cassette dependent account information with framework account information. |
protected java.lang.String |
fromClause()
This method is used by this object to construct the From clause for the SQL Select statement to be performed. |
protected int |
processQueryResults(java.sql.ResultSet argResultSet)
This method is used by this class to process the results of the SQL Select statement. |
protected java.lang.String |
selectStatement()
This method is used by this object to select the appropriate columns for the query. |
protected java.lang.String |
tableName()
This method is used by this object to identify the name of the table to be used in the query. |
java.lang.String |
whereCondition()
This method is used by this object to construct the Where clause for the SQL Select statement to be performed. |
Field Detail |
private java.util.Hashtable objAccounts
Constructor Detail |
public LdbCardCassetteQuery.AccountQuery(com.ibm.etill.framework.xdm.AccountQueryRequest argRequest) throws com.ibm.etill.framework.payapi.ETillAbortOperation
argRequest
- - the AccountQuery request.Method Detail |
protected java.lang.String selectStatement()
For this cassette, all columns are selected.
protected java.lang.String tableName()
For this cassette, the table name is the name of a cassette dependent view that can be found in the database.
protected java.lang.String fromClause()
For this cassette, the method returns the account view selected by this object's tableName() method.
public java.lang.String whereCondition()
For this cassette, the account view selected by this object's tableName() method is designed to use the same Where clause specified in the original request to select the framework account objects.
protected int processQueryResults(java.sql.ResultSet argResultSet) throws com.ibm.etill.framework.payapi.ETillAbortOperation
argResultSet
- - The result set produced when the
manufactured SQL Select statement was performed.public void combine(java.util.Vector argFrameworkObjects)
argFrameworkObjects
- - a collection of framework
account objects previously selected by the framework while
processing the merchant's query request.
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |