Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

## Uses of Class
org.apache.torque.criteria.Criteria

Packages that use Criteria
org.apache.torque.criteria | This package contains Torque's Criteria classes.
org.apache.torque.sql | This package contains classes which are mainly used in the SQL generation process.
org.apache.torque.util | Misc.

Uses of Criteria in org.apache.torque.criteria

Methods in org.apache.torque.criteria that return Criteria
`Criteria` | `Criteria.addAlias(String alias, Criteria subselect)` Allows one to specify an alias for a subselect.
`Criteria` | `Criteria.addAlias(String alias, String table)` Allows one to specify an alias for a table.
`Criteria` | `Criteria.addAscendingOrderByColumn(Column column)` Adds an order by clause, explicitly specifying ascending.
`Criteria` | `Criteria.addAscendingOrderByColumn(Column column, boolean ignoreCase)` Add an order by clause, explicitly specifying ascending.
`Criteria` | `Criteria.addAsColumn(String name, Column clause)` Add an AS clause to the select columns.
`Criteria` | `Criteria.addDescendingOrderByColumn(Column column)` Add order by column name, explicitly specifying descending.
`Criteria` | `Criteria.addDescendingOrderByColumn(Column column, boolean ignoreCase)` Add order by column name, explicitly specifying descending.
`Criteria` | `Criteria.addFrom(FromElement fromElement)` Adds a new Element to the from clause.
`Criteria` | `Criteria.addFrom(String tableName)` Adds a table to the from clause, not using a joinType or joinCondition.
`Criteria` | `Criteria.addGroupByColumn(Column groupBy)` Add a group by clause.
`Criteria` | `Criteria.addHaving(Criterion having)` This method adds a prepared Criterion object to the Criteria as a having clause.
`Criteria` | `Criteria.addJoin(Column left, Column right)` Adds a join to the criteria, E.g.
`Criteria` | `Criteria.addJoin(Column left, Column right, JoinType joinType)` Adds a join to the criteria, E.g.
`Criteria` | `Criteria.addJoin(Column left, Column right, SqlEnum comparison, JoinType joinType)` Adds a join to the criteria, E.g.
`Criteria` | `Criteria.addJoin(PreparedStatementPart leftTable, PreparedStatementPart rightTable, Criterion joinCondition, JoinType joinType)` Adds a join to the criteria, E.g.
`Criteria` | `Criteria.addJoin(String leftTable, String rightTable, Criterion joinCondition, JoinType joinType)` Adds a join to the criteria, E.g.
`Criteria` | `Criteria.addSelectColumn(Column column)` Adds a select column to the Criteria.
`Criteria` | `Criteria.and(Criterion criterion)` "AND"s Criterion object with the conditions in this Criteria.
`Criteria` | `Criteria.and(Object lValue, Object rValue)` "AND"s a new condition with the conditions in this Criteria.
`Criteria` | `Criteria.and(Object lValue, Object rValue, SqlEnum comparison)` "AND"s a new condition with the conditions in this Criteria.
`Criteria` | `Criteria.andDate(Object lValue, int year, int month, int day)` Convenience method to AND a new date comparison with the conditions in this Criteria.
`Criteria` | `Criteria.andDate(Object lValue, int year, int month, int day, SqlEnum comparison)` Convenience method to AND a new date comparison with the conditions in this Criteria.
`Criteria` | `Criteria.andIn(Object lValue, Collection<?> rValues)` Convenience method to AND a "in" comparison with the conditions in this Criteria.
`Criteria` | `Criteria.andIn(Object lValue, Object[] rValues)` Convenience method to AND a "in" comparison with the conditions in this Criteria.
`Criteria` | `Criteria.andNotIn(Object lValue, Collection<?> rValues)` Convenience method to AND a "not in" comparison with the conditions in this Criteria.
`Criteria` | `Criteria.andNotIn(Object lValue, Object[] rValues)` Convenience method to AND a "not in" comparison with the conditions in this Criteria.
`Criteria` | `Criteria.andVerbatimSql(String sql, Object[] replacements)` Ands a verbatim sql condition to this Criteria.
`Criteria` | `Criteria.andVerbatimSql(String sql, Object[] replacements, Column toAddToFromClause1, Column toAddToFromClause2)` ANDs a verbatim sql condition to this Criteria.
`Criteria` | `Criteria.forUpdate()` Sets that FOR UPDATE clause should be added to the query.
`Criteria` | `Criteria.getSubselectForAlias(String alias)` Returns the subselect associated with an alias.
`Criteria` | `Criteria.or(Criterion criterion)` "OR"s a Criterion object with the conditions in this Criteria.
`Criteria` | `Criteria.or(Object lValue, Object rValue)` "OR"s a new condition with the conditions in this Criteria.
`Criteria` | `Criteria.or(Object lValue, Object rValue, SqlEnum comparison)` "OR"s a new condition with the conditions in this Criteria.
`Criteria` | `Criteria.orDate(Object lValue, int year, int month, int day)` Convenience method to OR a new date comparison with the conditions in this Criteria.
`Criteria` | `Criteria.orDate(Object lValue, int year, int month, int day, SqlEnum comparison)` Convenience method to OR a new date comparison with the conditions in this Criteria.
`Criteria` | `Criteria.orIn(Object lValue, Collection<?> rValues)` Convenience method to OR a "in" comparison with the conditions in this Criteria.
`Criteria` | `Criteria.orIn(Object lValue, Object[] rValues)` Convenience method to OR a "in" comparison with the conditions in this Criteria.
`Criteria` | `Criteria.orNotIn(Object lValue, Collection<?> rValues)` Convenience method to OR a "not in" comparison with the conditions in this Criteria.
`Criteria` | `Criteria.orNotIn(Object lValue, Object[] rValues)` Convenience method to OR a "not in" comparison with the conditions in this Criteria.
`Criteria` | `Criteria.orVerbatimSql(String sql, Object[] replacements)` ORs a verbatim sql condition to this Criteria.
`Criteria` | `Criteria.orVerbatimSql(String sql, Object[] replacements, Column toAddToFromClause1, Column toAddToFromClause2)` ORs a verbatim sql condition to this Criteria.
`Criteria` | `Criteria.setForUpdate(boolean forUpdate)` Sets whether FOR UPDATE clause should be added to the query.
`Criteria` | `Criteria.setIgnoreCase(boolean ignoreCase)` Sets whether case should be ignored in where clauses and order by whenever String columns are encountered.
`Criteria` | `Criteria.setLimit(int limit)` Set a limit for the query
`Criteria` | `Criteria.setOffset(long offset)` Set the offset.
`Criteria` | `Criteria.setSingleRecord(boolean b)` Switch the check on or off that a query returns exactly one record.
`Criteria` | `Criteria.where(Criterion criterion)` "AND"s Criterion object with the conditions in this Criteria.
`Criteria` | `Criteria.where(Object lValue, Object rValue)` "AND"s a new condition with the conditions in this Criteria.
`Criteria` | `Criteria.where(Object lValue, Object rValue, SqlEnum comparison)` "AND"s a new condition with the conditions in this Criteria.
`Criteria` | `Criteria.whereDate(Object lValue, int year, int month, int day)` Convenience method to AND a new date comparison with the conditions in this Criteria.
`Criteria` | `Criteria.whereDate(Object lValue, int year, int month, int day, SqlEnum comparison)` Convenience method to AND a new date comparison with the conditions in this Criteria.
`Criteria` | `Criteria.whereIn(Object lValue, Collection<?> rValues)` Convenience method to AND a "in" comparison with the conditions in this Criteria.
`Criteria` | `Criteria.whereIn(Object lValue, Object[] rValues)` Convenience method to AND a "in" comparison with the conditions in this Criteria.
`Criteria` | `Criteria.whereNotIn(Object lValue, Collection<?> rValues)` Convenience method to AND a "not in" comparison with the conditions in this Criteria.
`Criteria` | `Criteria.whereNotIn(Object lValue, Object[] rValues)` Convenience method to AND a "not in" comparison with the conditions in this Criteria.
`Criteria` | `Criteria.whereVerbatimSql(String sql, Object[] replacements)` Convenience method to AND a verbatim sql condition to this Criteria.
`Criteria` | `Criteria.whereVerbatimSql(String sql, Object[] replacements, Column toAddToFromClause1, Column toAddToFromClause2)` Convenience method to AND a verbatim sql condition to this Criteria.

Methods in org.apache.torque.criteria with parameters of type Criteria
`Criteria` | `Criteria.addAlias(String alias, Criteria subselect)` Allows one to specify an alias for a subselect.

Constructors in org.apache.torque.criteria with parameters of type Criteria
`Criteria(Criteria toCopy)` Copy-constructor.

Uses of Criteria in org.apache.torque.sql

Methods in org.apache.torque.sql with parameters of type Criteria
`static Query` | `SqlBuilder.buildQuery(Criteria crit)` Builds a Query from a criteria.
`static String` | `SqlBuilder.guessFullTableFromCriteria(Criteria criteria)` Guesses a table name from a criteria by inspecting the first column in the criteria.

Uses of Criteria in org.apache.torque.util

Methods in org.apache.torque.util that return Criteria
`Criteria` | `SummaryHelper.buildCriteria(Criteria c)` Builds the criteria to use in summarizing the information.

Methods in org.apache.torque.util with parameters of type Criteria
`void` | `BasePeerImpl.addSelectColumns(Criteria criteria)` Add all the columns needed to create a new object.
`Criteria` | `SummaryHelper.buildCriteria(Criteria c)` Builds the criteria to use in summarizing the information.
`void` | `BasePeerImpl.correctBooleans(Criteria criteria)` Checks all columns in the criteria to see whether booleanchar and booleanint columns are queried with a boolean.
`static void` | `BasePeer.correctBooleans(Criteria criteria)` Deprecated. 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, Column column)` 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, Column column)` Returns the number of rows in a query.
`int` | `CountHelper.count(Criteria c, Connection conn, String columnName, TableMap tableMap)` Returns the number of rows in a query.
`int` | `CountHelper.count(Criteria c, String columnName)` Returns the number of rows in a query.
`int` | `BasePeerImpl.doDelete(Criteria criteria)` Deletes rows from a database table.
`static int` | `BasePeer.doDelete(Criteria criteria)` Deprecated. This method causes unexpected results when joins are used. Please use doDelete( org.apache.torque.criteria.Criteria, TableMap). This method will be removed in a future version of Torque.
`int` | `BasePeerImpl.doDelete(Criteria criteria, Connection connection)` Deletes rows from a table.
`static int` | `BasePeer.doDelete(Criteria criteria, Connection con)` Deprecated. This method causes unexpected results when joins are used. Please use doDelete(org.apache.torque.criteria.Criteria, TableMap, Connection). This method will be removed in a future version of Torque.
`List<T>` | `BasePeerImpl.doSelect(Criteria criteria)` Selects objects from a database.
`List<T>` | `BasePeerImpl.doSelect(Criteria criteria, Connection connection)` Selects objects from a database within a transaction.
`static
`<T> List<T>`
` | `BasePeer.doSelect(Criteria criteria, RecordMapper<T> mapper)` Deprecated. Selects rows from a database an maps them to objects.
`static
`<T> List<T>`
` | `BasePeer.doSelect(Criteria criteria, RecordMapper<T> mapper, Connection connection)` Deprecated. Selects rows from a database an maps them to objects.
`
`<TT> List<TT>`
` | `BasePeerImpl.doSelect(Criteria criteria, RecordMapper<TT> mapper)` Selects rows from a database an maps them to objects.
`
`<TT> List<TT>`
` | `BasePeerImpl.doSelect(Criteria criteria, RecordMapper<TT> mapper, Connection connection)` Performs a SQL `select` using a PreparedStatement.
`T` | `BasePeerImpl.doSelectSingleRecord(Criteria criteria)` Selects at most one object from a database.
`T` | `BasePeerImpl.doSelectSingleRecord(Criteria criteria, Connection connection)` Selects at most one object from a database within a transaction.
`static
`<T> T`
` | `BasePeer.doSelectSingleRecord(Criteria criteria, RecordMapper<T> mapper)` Deprecated. Selects at most a single row from a database an maps them to objects.
`static
`<T> T`
` | `BasePeer.doSelectSingleRecord(Criteria criteria, RecordMapper<T> mapper, Connection connection)` Deprecated. Selects at most a single row from a database an maps them to objects.
`
`<TT> TT`
` | `BasePeerImpl.doSelectSingleRecord(Criteria criteria, RecordMapper<TT> mapper)` Selects at most a single row from a database an maps them to objects.
`
`<TT> TT`
` | `BasePeerImpl.doSelectSingleRecord(Criteria criteria, RecordMapper<TT> mapper, Connection connection)` Selects at most a single row from a database an maps them to objects.
`int` | `BasePeerImpl.doUpdate(Criteria selectCriteria, ColumnValues updateValues)` Executes an update against the database.
`static int` | `BasePeer.doUpdate(Criteria selectCriteria, ColumnValues updateValues)` Deprecated. Executes an update against the database.
`int` | `BasePeerImpl.doUpdate(Criteria criteria, ColumnValues updateValues, Connection connection)` Executes an update against the database.
`static int` | `BasePeer.doUpdate(Criteria criteria, ColumnValues updateValues, Connection connection)` Deprecated. Executes an update against the database.
`protected void` | `BasePeerImpl.setDbName(Criteria crit)` Sets the database name in the passed criteria to the table's default, if it is not already set.
`List<ListOrderedMapCI>` | `SummaryHelper.summarize(Criteria crit)` Return a list of ListOrderedMapCI objects with the results of the summary query.
`List<ListOrderedMapCI>` | `SummaryHelper.summarize(Criteria crit, Connection conn)` Return a list of OrderedMap objects with the results of the summary query.
`List<ListOrderedMapCI>` | `SummaryHelper.summarize(Criteria crit, List<Class<?>> resultTypes)` Return a list of ListOrderedMapCI objects with the results of the summary query.
`List<ListOrderedMapCI>` | `SummaryHelper.summarize(Criteria crit, List<Class<?>> resultTypes, Connection conn)` Return a list of ListOrderedMapCI objects with the results of the summary query.

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

Copyright © 2000-2013 The Apache Software Foundation. All Rights Reserved.