|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use Criteria | |
---|---|
org.apache.torque.util | Misc. |
Uses of Criteria in org.apache.torque.util |
---|
Methods in org.apache.torque.util that return Criteria | |
---|---|
Criteria |
Criteria.add(Criteria.Criterion c)
This method adds a prepared Criterion object to the Criteria. |
Criteria |
Criteria.add(String column,
boolean value)
Convenience method to add a boolean to Criteria. |
Criteria |
Criteria.add(String column,
boolean value,
SqlEnum comparison)
Convenience method to add a boolean to Criteria. |
Criteria |
Criteria.add(String column,
double value)
Convenience method to add a double to Criteria. |
Criteria |
Criteria.add(String column,
double value,
SqlEnum comparison)
Convenience method to add a double to Criteria. |
Criteria |
Criteria.add(String column,
float value)
Convenience method to add a float to Criteria. |
Criteria |
Criteria.add(String column,
float value,
SqlEnum comparison)
Convenience method to add a float to Criteria. |
Criteria |
Criteria.add(String column,
int value)
Convenience method to add an int to Criteria. |
Criteria |
Criteria.add(String column,
int value,
SqlEnum comparison)
Convenience method to add an int to Criteria. |
Criteria |
Criteria.add(String column,
long value)
Convenience method to add a long to Criteria. |
Criteria |
Criteria.add(String column,
long value,
SqlEnum comparison)
Convenience method to add a long to Criteria. |
Criteria |
Criteria.add(String column,
Object value)
This method adds a new criterion to the list of criterias. |
Criteria |
Criteria.add(String column,
Object value,
SqlEnum comparison)
This method adds a new criterion to the list of criterias. |
Criteria |
Criteria.add(String table,
String column,
Object value)
This method adds a new criterion to the list of criterias. |
Criteria |
Criteria.add(String table,
String column,
Object value,
SqlEnum comparison)
This method adds a new criterion to the list of criterias. |
Criteria |
Criteria.addAscendingOrderByColumn(String name)
Add order by column name, explicitly specifying ascending. |
Criteria |
Criteria.addAsColumn(String name,
String clause)
Add an AS clause to the select columns. |
Criteria |
Criteria.addDate(String column,
int year,
int month,
int date)
Convenience method to add a Date object specified by year, month, and date into the Criteria. |
Criteria |
Criteria.addDate(String column,
int year,
int month,
int date,
SqlEnum comparison)
Convenience method to add a Date object specified by year, month, and date into the Criteria. |
Criteria |
Criteria.addDescendingOrderByColumn(String name)
Add order by column name, explicitly specifying descending. |
Criteria |
Criteria.addGroupByColumn(String groupBy)
Add group by column name. |
Criteria |
Criteria.addHaving(Criteria.Criterion having)
This method adds a prepared Criterion object to the Criteria as a having clause. |
Criteria |
Criteria.addIn(String column,
int[] values)
Adds an 'IN' clause with the criteria supplied as an int array. |
Criteria |
Criteria.addIn(String column,
List values)
Adds an 'IN' clause with the criteria supplied as a List. |
Criteria |
Criteria.addIn(String column,
Object[] values)
Adds an 'IN' clause with the criteria supplied as an Object array. |
Criteria |
Criteria.addJoin(String left,
String right)
This is the way that you should add a join of two tables. |
Criteria |
Criteria.addJoin(String left,
String right,
SqlEnum operator)
This is the way that you should add a join of two tables. |
Criteria |
Criteria.addNotIn(String column,
int[] values)
Adds a 'NOT IN' clause with the criteria supplied as an int array. |
Criteria |
Criteria.addNotIn(String column,
List values)
Adds a 'NOT IN' clause with the criteria supplied as a List. |
Criteria |
Criteria.addNotIn(String column,
Object[] values)
Adds a 'NOT IN' clause with the criteria supplied as an Object array. |
Criteria |
Criteria.addSelectColumn(String name)
Add select column. |
Criteria |
Criteria.and(Criteria.Criterion c)
This method adds a prepared Criterion object to the Criteria. |
Criteria |
Criteria.and(String column,
boolean value)
Convenience method to add a boolean to Criteria. |
Criteria |
Criteria.and(String column,
boolean value,
SqlEnum comparison)
Convenience method to add a boolean to Criteria. |
Criteria |
Criteria.and(String column,
double value)
Convenience method to add a double to Criteria. |
Criteria |
Criteria.and(String column,
double value,
SqlEnum comparison)
Convenience method to add a double to Criteria. |
Criteria |
Criteria.and(String column,
float value)
Convenience method to add a float to Criteria. |
Criteria |
Criteria.and(String column,
float value,
SqlEnum comparison)
Convenience method to add a float to Criteria. |
Criteria |
Criteria.and(String column,
int value)
Convenience method to add an int to Criteria. |
Criteria |
Criteria.and(String column,
int value,
SqlEnum comparison)
Convenience method to add an int to Criteria. |
Criteria |
Criteria.and(String column,
long value)
Convenience method to add a long to Criteria. |
Criteria |
Criteria.and(String column,
long value,
SqlEnum comparison)
Convenience method to add a long to Criteria. |
Criteria |
Criteria.and(String column,
Object value)
This method adds a new criterion to the list of criterias. |
Criteria |
Criteria.and(String column,
Object value,
SqlEnum comparison)
This method adds a new criterion to the list of criterias. |
Criteria |
Criteria.and(String table,
String column,
Object value)
This method adds a new criterion to the list of criterias. |
Criteria |
Criteria.and(String table,
String column,
Object value,
SqlEnum comparison)
This method adds a new criterion to the list of criterias. |
Criteria |
Criteria.andDate(String column,
int year,
int month,
int date)
Convenience method to add a Date object specified by year, month, and date into the Criteria. |
Criteria |
Criteria.andDate(String column,
int year,
int month,
int date,
SqlEnum comparison)
Convenience method to add a Date object specified by year, month, and date into the Criteria. |
Criteria |
Criteria.andIn(String column,
int[] values)
Adds an 'IN' clause with the criteria supplied as an int array. |
Criteria |
Criteria.andIn(String column,
List values)
Adds an 'IN' clause with the criteria supplied as a List. |
Criteria |
Criteria.andIn(String column,
Object[] values)
Adds an 'IN' clause with the criteria supplied as an Object array. |
Criteria |
Criteria.andNotIn(String column,
int[] values)
Adds a 'NOT IN' clause with the criteria supplied as an int array. |
Criteria |
Criteria.andNotIn(String column,
List values)
Adds a 'NOT IN' clause with the criteria supplied as a List. |
Criteria |
Criteria.andNotIn(String column,
Object[] values)
Adds a 'NOT IN' clause with the criteria supplied as an Object array. |
Criteria |
Criteria.or(Criteria.Criterion c)
This method adds a prepared Criterion object to the Criteria. |
Criteria |
Criteria.or(String column,
boolean value)
Convenience method to add a boolean to Criteria. |
Criteria |
Criteria.or(String column,
boolean value,
SqlEnum comparison)
Convenience method to add a boolean to Criteria. |
Criteria |
Criteria.or(String column,
double value)
Convenience method to add a double to Criteria. |
Criteria |
Criteria.or(String column,
double value,
SqlEnum comparison)
Convenience method to add a double to Criteria. |
Criteria |
Criteria.or(String column,
float value)
Convenience method to add a float to Criteria. |
Criteria |
Criteria.or(String column,
float value,
SqlEnum comparison)
Convenience method to add a float to Criteria. |
Criteria |
Criteria.or(String column,
int value)
Convenience method to add an int to Criteria. |
Criteria |
Criteria.or(String column,
int value,
SqlEnum comparison)
Convenience method to add an int to Criteria. |
Criteria |
Criteria.or(String column,
long value)
Convenience method to add a long to Criteria. |
Criteria |
Criteria.or(String column,
long value,
SqlEnum comparison)
Convenience method to add a long to Criteria. |
Criteria |
Criteria.or(String column,
Object value)
This method adds a new criterion to the list of criterias. |
Criteria |
Criteria.or(String column,
Object value,
SqlEnum comparison)
This method adds a new criterion to the list of criterias. |
Criteria |
Criteria.or(String table,
String column,
Object value)
This method adds a new criterion to the list of criterias. |
Criteria |
Criteria.or(String table,
String column,
Object value,
SqlEnum comparison)
This method adds a new criterion to the list of criterias. |
Criteria |
Criteria.orDate(String column,
int year,
int month,
int date)
Convenience method to add a Date object specified by year, month, and date into the Criteria. |
Criteria |
Criteria.orDate(String column,
int year,
int month,
int date,
SqlEnum comparison)
Convenience method to add a Date object specified by year, month, and date into the Criteria. |
Criteria |
Criteria.orIn(String column,
int[] values)
Adds an 'IN' clause with the criteria supplied as an int array. |
Criteria |
Criteria.orIn(String column,
List values)
Adds an 'IN' clause with the criteria supplied as a List. |
Criteria |
Criteria.orIn(String column,
Object[] values)
Adds an 'IN' clause with the criteria supplied as an Object array. |
Criteria |
Criteria.orNotIn(String column,
int[] values)
Adds a 'NOT IN' clause with the criteria supplied as an int array. |
Criteria |
Criteria.orNotIn(String column,
List values)
Adds a 'NOT IN' clause with the criteria supplied as a List. |
Criteria |
Criteria.orNotIn(String column,
Object[] values)
Adds a 'NOT IN' clause with the criteria supplied as an Object array. |
Criteria |
Criteria.setCascade(boolean b)
Set cascade. |
Criteria |
Criteria.setIgnoreCase(boolean b)
Sets ignore case. |
Criteria |
Criteria.setLimit(int limit)
Set limit. |
Criteria |
Criteria.setOffset(int offset)
Set offset. |
Criteria |
Criteria.setSingleRecord(boolean b)
Set single record? Set this to true if you expect the query
to result in only a single result record (the default behaviour is to
throw a TorqueException if multiple records are returned when the query
is executed). |
Methods in org.apache.torque.util with parameters of type Criteria | |
---|---|
static Query |
SQLBuilder.buildQueryClause(Criteria crit,
List params,
SQLBuilder.QueryCallback qc)
Builds a Query clause for Updating and deleting |
static void |
BasePeer.correctBooleans(Criteria criteria,
TableMap defaultTableMap)
Checks all columns in the criteria to see whether booleanchar and booleanint columns are queried with a boolean. |
int |
CountHelper.count(Criteria c)
The COUNT function returns the number of rows in a query. |
int |
CountHelper.count(Criteria c,
Connection conn)
The COUNT function returns the number of rows in a query. |
int |
CountHelper.count(Criteria c,
Connection conn,
String columnName)
Returns the number of rows in a query. |
int |
CountHelper.count(Criteria c,
String columnName)
Returns the number of rows in a query. |
static void |
BasePeer.createPreparedStatement(Criteria criteria,
StringBuffer queryString,
List params)
Create a new PreparedStatement. |
static String |
BasePeer.createQueryString(Criteria criteria)
Method to create an SQL query for actual execution based on values in a Criteria. |
static void |
BasePeer.doDelete(Criteria criteria)
Deprecated. This method causes unexpected results when joins are used. Please use doDelete(Criteria, String). |
static void |
BasePeer.doDelete(Criteria criteria,
Connection con)
Deprecated. This method causes unexpected results when joins are used. Please use doDelete(Criteria, String, Connection). |
protected static void |
BasePeer.doDelete(Criteria criteria,
String tableName)
Method to perform deletes based on values and keys in a Criteria. |
static void |
BasePeer.doDelete(Criteria criteria,
String tableName,
Connection con)
Method to perform deletes based on values and keys in a Criteria. |
static ObjectKey |
BasePeer.doInsert(Criteria criteria)
Method to perform inserts based on values and keys in a Criteria. |
static ObjectKey |
BasePeer.doInsert(Criteria criteria,
Connection con)
Method to perform inserts based on values and keys in a Criteria. |
static List |
BasePeer.doPSSelect(Criteria criteria)
Do a Prepared Statement select according to the given criteria |
static List |
BasePeer.doPSSelect(Criteria criteria,
Connection con)
Performs a SQL select using a PreparedStatement. |
static List |
BasePeer.doSelect(Criteria criteria)
Returns all results. |
static List |
BasePeer.doSelect(Criteria criteria,
Connection con)
Returns all results. |
static void |
BasePeer.doUpdate(Criteria updateValues)
Convenience method used to update rows in the DB. |
static void |
BasePeer.doUpdate(Criteria updateValues,
Connection con)
Convenience method used to update rows in the DB. |
static void |
BasePeer.doUpdate(Criteria selectCriteria,
Criteria updateValues)
Method used to update rows in the DB. |
static void |
BasePeer.doUpdate(Criteria criteria,
Criteria updateValues,
Connection con)
Method used to update rows in the DB. |
static String |
SQLBuilder.getTableNameForFromClause(String tableName,
Criteria criteria)
Returns the tablename which can be added to a From Clause. |
static Set |
SQLBuilder.getTableSet(Criteria crit,
SQLBuilder.TableCallback tableCallback)
Returns a set of all tables and possible aliases referenced from a criterion. |
void |
SQLBuilder.TableCallback.process(Set tables,
String key,
Criteria crit)
Callback Method for getTableSet() |
static void |
JoinBuilder.processJoins(DB db,
DatabaseMap dbMap,
Criteria criteria,
Query query)
adds the Joins from the criteria to the query |
static void |
VillageUtils.setVillageValue(Criteria crit,
String key,
Record rec,
String colName)
Factored out setting of a Village Record column from a Criteria Key |
Constructors in org.apache.torque.util with parameters of type Criteria | |
---|---|
LargeSelect(Criteria criteria,
int pageSize)
Creates a LargeSelect whose results are returned as a List
containing a maximum of pageSize Village Record
objects at a time, maintaining a maximum of
LargeSelect.memoryPageLimit pages of results in memory. |
|
LargeSelect(Criteria criteria,
int pageSize,
int memoryPageLimit)
Creates a LargeSelect whose results are returned as a List
containing a maximum of pageSize Village Record
objects at a time, maintaining a maximum of memoryPageLimit
pages of results in memory. |
|
LargeSelect(Criteria criteria,
int pageSize,
int memoryPageLimit,
String returnBuilderClassName)
Creates a LargeSelect whose results are returned as a List
containing a maximum of pageSize objects of the type
defined within the class named returnBuilderClassName at a
time, maintaining a maximum of memoryPageLimit pages of
results in memory. |
|
LargeSelect(Criteria criteria,
int pageSize,
String returnBuilderClassName)
Creates a LargeSelect whose results are returned as a List
containing a maximum of pageSize objects of the type
defined within the class named returnBuilderClassName at a
time, maintaining a maximum of LargeSelect.memoryPageLimit
pages of results in memory. |
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |