Method Summary |
|
public void | addOrderByFirstName(boolean direction_flag) Add firstName to the ORDER BY clause. |
public void | addOrderByFirstName() Add firstName to the ORDER BY clause. |
public void | addOrderByLastName(boolean direction_flag) Add lastName to the ORDER BY clause. |
public void | addOrderByLastName() Add lastName to the ORDER BY clause. |
public void | addOrderByPhoneNumber(boolean direction_flag) Add phoneNumber to the ORDER BY clause. |
public void | addOrderByPhoneNumber() Add phoneNumber to the ORDER BY clause. |
public void | closeParen() Place a closing parenthesis in the WHERE clause. |
public boolean | containsWildcards(String dbSearchValue) |
public String | convertUserSearchValue(String userSearchValue) |
public ResultSet | executeQuery(DBConnection conn) Method to query objects from the database.
The following call in runQuery()
dbQuery.query( this );
causes the dbQuery object to invoke
executeQuery()
Parameters: conn - Handle to database connection. |
public QueryResult | getCachedResults(QueryResult result) Return QueryResult with read DOs or DataStructs from caches. |
public int | getCount() |
public PersonDO[] | getDOArray() Return array of DOs constructed from ResultSet returned by query. |
public int | getDatabaseLimit() |
public boolean | getDatabaseLimitExceeded() Get the database limit exceeded flag of the query. |
public boolean | getLoadData() Return true if Query is prepared for select t1.* statement. |
public String | getLogicalDatabase() |
public int | getMaxRows() Return limit of rows (DOs) returned. |
public PersonDO | getNextDO() Return successive DOs from array built from ResultSet returned by query. |
public QueryBuilder | getQueryBuilder() Returns the QueryBuilder that this PersonQuery
uses to construct and execute database queries.
PersonQuery.setQueryXXX methods use
the QueryBuilder to
append SQL expressions to the "WHERE" clause to be executed.
The QueryBuilder.addEndClause method. can be used to
append freeform SQL expressions to the WHERE clause,
e.g. |
public int | getReadSkip() |
public boolean | getUnique() |
public boolean | getUserStringAppendWildcard() Get user string append wildcard. |
public String | getUserStringSingleWildcard() Get user string single wildcard. |
public String | getUserStringSingleWildcardEscape() Get user string single wildcard escape. |
public boolean | getUserStringTrim() Get user string trim. |
public String | getUserStringWildcard() Get user string wildcard. |
public String | getUserStringWildcardEscape() Get user string wildcard escape. |
public int | get_FetchSize() |
public int | get_QueryTimeout() |
public void | hitDatabase() Set that all queries go to database, not to cache. |
public boolean | isOrderRelevant() Returns attribute orderRelevant. |
public Object | next(ResultSet rs) WARNING! This method is disabled. |
public void | openParen() Place an open parenthesis in the WHERE clause. |
public void | or() Insert an OR between WHERE clauses. |
public void | requireUniqueInstance() Set "unique instance" assertion bit. |
public void | reset() Reset the query parameters. |
public int | selectCount() |
public void | setDBMatchFirstName(String x) |
public void | setDBMatchLastName(String x) |
public void | setDBMatchPhoneNumber(String x) |
public void | setDatabaseLimit(int newLimit) |
public void | setLoadData(boolean newValue) Set loadData parameter. |
public void | setLogicalDatabase(String dbName) |
public void | setMaxRows(int maxRows) Limit the number of rows (DOs) returned. |
public void | setOrderRelevant(boolean newOrderRelevant) Sets attribute orderRelevant. |
public void | setQueryFirstName(String x, String cmp_op) Set the firstName to query, with a QueryBuilder comparison operator.
Parameters: x - The firstName of the person to query. Parameters: cmp_op - QueryBuilder comparison operator to use. exception: DataObjectException - If a database access error occurs. exception: QueryException - If comparison operator is inappropriate(e.g. |
public void | setQueryFirstName(String x) Set the firstName to query, with a QueryBuilder comparison operator.
Parameters: x - The firstName of the person to query. exception: DataObjectException - If a database access error occurs. exception: QueryException - If comparison operator is inappropriate(e.g. |
public void | setQueryHandle(String handle) Set the object handle to query. |
public void | setQueryLastName(String x, String cmp_op) Set the lastName to query, with a QueryBuilder comparison operator.
Parameters: x - The lastName of the person to query. Parameters: cmp_op - QueryBuilder comparison operator to use. exception: DataObjectException - If a database access error occurs. exception: QueryException - If comparison operator is inappropriate(e.g. |
public void | setQueryLastName(String x) Set the lastName to query, with a QueryBuilder comparison operator.
Parameters: x - The lastName of the person to query. exception: DataObjectException - If a database access error occurs. exception: QueryException - If comparison operator is inappropriate(e.g. |
public void | setQueryOId(ObjectId oid) Set the OID to query. |
public void | setQueryPhoneNumber(String x, String cmp_op) Set the phoneNumber to query, with a QueryBuilder comparison operator.
Parameters: x - The phoneNumber of the person to query. Parameters: cmp_op - QueryBuilder comparison operator to use. exception: DataObjectException - If a database access error occurs. exception: QueryException - If comparison operator is inappropriate(e.g. |
public void | setQueryPhoneNumber(String x) Set the phoneNumber to query, with a QueryBuilder comparison operator.
Parameters: x - The phoneNumber of the person to query. exception: DataObjectException - If a database access error occurs. exception: QueryException - If comparison operator is inappropriate(e.g. |
public void | setReadSkip(int newReadSkip) |
protected void | setRefs(HashMap queryRefs) |
public void | setUnique(boolean newUnique) |
public void | setUserMatchFirstName(String x) |
public void | setUserMatchLastName(String x) |
public void | setUserMatchPhoneNumber(String x) |
public void | setUserStringAppendWildcard(boolean userStringAppendWildcard) Set user string append wildcard. |
public void | setUserStringSingleWildcard(String newUserStringSingleWildcard) Set user string single wildcard. |
public void | setUserStringSingleWildcardEscape(String newUserStringSingleWildcardEscape) Set user string single wildcard escape. |
public void | setUserStringTrim(boolean userStringTrim) Set user string trim. |
public void | setUserStringWildcard(String newUserStringWildcard) Set user string wildcard. |
public void | setUserStringWildcardEscape(String newUserStringWildcardEscape) Set user string wildcard escape. |
public void | set_FetchSize(int iCurrentFetchSizeIn) |
public void | set_QueryTimeout(int iQueryTimeoutIn) |