Uses of Class
org.apache.torque.util.Criteria

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.addAsColumn(java.lang.String name, java.lang.String clause)
          Add an AS clause to the select columns.
 Criteria Criteria.add(Criteria.Criterion c)
          This method adds a prepared Criterion object to the Criteria.
 Criteria Criteria.add(java.lang.String column, java.lang.Object value)
          This method adds a new criterion to the list of criterias.
 Criteria Criteria.add(java.lang.String column, java.lang.Object value, SqlEnum comparison)
          This method adds a new criterion to the list of criterias.
 Criteria Criteria.add(java.lang.String table, java.lang.String column, java.lang.Object value)
          This method adds a new criterion to the list of criterias.
 Criteria Criteria.add(java.lang.String table, java.lang.String column, java.lang.Object value, SqlEnum comparison)
          This method adds a new criterion to the list of criterias.
 Criteria Criteria.add(java.lang.String column, boolean value)
          Convenience method to add a boolean to Criteria.
 Criteria Criteria.add(java.lang.String column, boolean value, SqlEnum comparison)
          Convenience method to add a boolean to Criteria.
 Criteria Criteria.add(java.lang.String column, int value)
          Convenience method to add an int to Criteria.
 Criteria Criteria.add(java.lang.String column, int value, SqlEnum comparison)
          Convenience method to add an int to Criteria.
 Criteria Criteria.add(java.lang.String column, long value)
          Convenience method to add a long to Criteria.
 Criteria Criteria.add(java.lang.String column, long value, SqlEnum comparison)
          Convenience method to add a long to Criteria.
 Criteria Criteria.add(java.lang.String column, float value)
          Convenience method to add a float to Criteria.
 Criteria Criteria.add(java.lang.String column, float value, SqlEnum comparison)
          Convenience method to add a float to Criteria.
 Criteria Criteria.add(java.lang.String column, double value)
          Convenience method to add a double to Criteria.
 Criteria Criteria.add(java.lang.String column, double value, SqlEnum comparison)
          Convenience method to add a double to Criteria.
 Criteria Criteria.addDate(java.lang.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(java.lang.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.addJoin(java.lang.String left, java.lang.String right)
          This is the way that you should add a join of two tables.
 Criteria Criteria.addJoin(java.lang.String left, java.lang.String right, SqlEnum operator)
          This is the way that you should add a join of two tables.
 Criteria Criteria.addIn(java.lang.String column, java.lang.Object[] values)
          Adds an 'IN' clause with the criteria supplied as an Object array.
 Criteria Criteria.addIn(java.lang.String column, int[] values)
          Adds an 'IN' clause with the criteria supplied as an int array.
 Criteria Criteria.addIn(java.lang.String column, java.util.List values)
          Adds an 'IN' clause with the criteria supplied as a List.
 Criteria Criteria.addNotIn(java.lang.String column, java.lang.Object[] values)
          Adds a 'NOT IN' clause with the criteria supplied as an Object array.
 Criteria Criteria.addNotIn(java.lang.String column, int[] values)
          Adds a 'NOT IN' clause with the criteria supplied as an int array.
 Criteria Criteria.addNotIn(java.lang.String column, java.util.List values)
          Adds a 'NOT IN' clause with the criteria supplied as a List.
 Criteria Criteria.setIgnoreCase(boolean b)
          Sets ignore case.
 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).
 Criteria Criteria.setCascade(boolean b)
          Set cascade.
 Criteria Criteria.setLimit(int limit)
          Set limit.
 Criteria Criteria.setOffset(int offset)
          Set offset.
 Criteria Criteria.addSelectColumn(java.lang.String name)
          Add select column.
 Criteria Criteria.addGroupByColumn(java.lang.String groupBy)
          Add group by column name.
 Criteria Criteria.addAscendingOrderByColumn(java.lang.String name)
          Add order by column name, explicitly specifying ascending.
 Criteria Criteria.addDescendingOrderByColumn(java.lang.String name)
          Add order by column name, explicitly specifying descending.
 Criteria Criteria.addHaving(Criteria.Criterion having)
          This method adds a prepared Criterion object to the Criteria as a having clause.
 Criteria Criteria.and(Criteria.Criterion c)
          This method adds a prepared Criterion object to the Criteria.
 Criteria Criteria.and(java.lang.String column, java.lang.Object value)
          This method adds a new criterion to the list of criterias.
 Criteria Criteria.and(java.lang.String column, java.lang.Object value, SqlEnum comparison)
          This method adds a new criterion to the list of criterias.
 Criteria Criteria.and(java.lang.String table, java.lang.String column, java.lang.Object value)
          This method adds a new criterion to the list of criterias.
 Criteria Criteria.and(java.lang.String table, java.lang.String column, java.lang.Object value, SqlEnum comparison)
          This method adds a new criterion to the list of criterias.
 Criteria Criteria.and(java.lang.String column, boolean value)
          Convenience method to add a boolean to Criteria.
 Criteria Criteria.and(java.lang.String column, boolean value, SqlEnum comparison)
          Convenience method to add a boolean to Criteria.
 Criteria Criteria.and(java.lang.String column, int value)
          Convenience method to add an int to Criteria.
 Criteria Criteria.and(java.lang.String column, int value, SqlEnum comparison)
          Convenience method to add an int to Criteria.
 Criteria Criteria.and(java.lang.String column, long value)
          Convenience method to add a long to Criteria.
 Criteria Criteria.and(java.lang.String column, long value, SqlEnum comparison)
          Convenience method to add a long to Criteria.
 Criteria Criteria.and(java.lang.String column, float value)
          Convenience method to add a float to Criteria.
 Criteria Criteria.and(java.lang.String column, float value, SqlEnum comparison)
          Convenience method to add a float to Criteria.
 Criteria Criteria.and(java.lang.String column, double value)
          Convenience method to add a double to Criteria.
 Criteria Criteria.and(java.lang.String column, double value, SqlEnum comparison)
          Convenience method to add a double to Criteria.
 Criteria Criteria.andDate(java.lang.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(java.lang.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(java.lang.String column, java.lang.Object[] values)
          Adds an 'IN' clause with the criteria supplied as an Object array.
 Criteria Criteria.andIn(java.lang.String column, int[] values)
          Adds an 'IN' clause with the criteria supplied as an int array.
 Criteria Criteria.andIn(java.lang.String column, java.util.List values)
          Adds an 'IN' clause with the criteria supplied as a List.
 Criteria Criteria.andNotIn(java.lang.String column, java.lang.Object[] values)
          Adds a 'NOT IN' clause with the criteria supplied as an Object array.
 Criteria Criteria.andNotIn(java.lang.String column, int[] values)
          Adds a 'NOT IN' clause with the criteria supplied as an int array.
 Criteria Criteria.andNotIn(java.lang.String column, java.util.List values)
          Adds a 'NOT IN' clause with the criteria supplied as a List.
 Criteria Criteria.or(Criteria.Criterion c)
          This method adds a prepared Criterion object to the Criteria.
 Criteria Criteria.or(java.lang.String column, java.lang.Object value)
          This method adds a new criterion to the list of criterias.
 Criteria Criteria.or(java.lang.String column, java.lang.Object value, SqlEnum comparison)
          This method adds a new criterion to the list of criterias.
 Criteria Criteria.or(java.lang.String table, java.lang.String column, java.lang.Object value)
          This method adds a new criterion to the list of criterias.
 Criteria Criteria.or(java.lang.String table, java.lang.String column, java.lang.Object value, SqlEnum comparison)
          This method adds a new criterion to the list of criterias.
 Criteria Criteria.or(java.lang.String column, boolean value)
          Convenience method to add a boolean to Criteria.
 Criteria Criteria.or(java.lang.String column, boolean value, SqlEnum comparison)
          Convenience method to add a boolean to Criteria.
 Criteria Criteria.or(java.lang.String column, int value)
          Convenience method to add an int to Criteria.
 Criteria Criteria.or(java.lang.String column, int value, SqlEnum comparison)
          Convenience method to add an int to Criteria.
 Criteria Criteria.or(java.lang.String column, long value)
          Convenience method to add a long to Criteria.
 Criteria Criteria.or(java.lang.String column, long value, SqlEnum comparison)
          Convenience method to add a long to Criteria.
 Criteria Criteria.or(java.lang.String column, float value)
          Convenience method to add a float to Criteria.
 Criteria Criteria.or(java.lang.String column, float value, SqlEnum comparison)
          Convenience method to add a float to Criteria.
 Criteria Criteria.or(java.lang.String column, double value)
          Convenience method to add a double to Criteria.
 Criteria Criteria.or(java.lang.String column, double value, SqlEnum comparison)
          Convenience method to add a double to Criteria.
 Criteria Criteria.orDate(java.lang.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(java.lang.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(java.lang.String column, java.lang.Object[] values)
          Adds an 'IN' clause with the criteria supplied as an Object array.
 Criteria Criteria.orIn(java.lang.String column, int[] values)
          Adds an 'IN' clause with the criteria supplied as an int array.
 Criteria Criteria.orIn(java.lang.String column, java.util.List values)
          Adds an 'IN' clause with the criteria supplied as a List.
 Criteria Criteria.orNotIn(java.lang.String column, java.lang.Object[] values)
          Adds a 'NOT IN' clause with the criteria supplied as an Object array.
 Criteria Criteria.orNotIn(java.lang.String column, int[] values)
          Adds a 'NOT IN' clause with the criteria supplied as an int array.
 Criteria Criteria.orNotIn(java.lang.String column, java.util.List values)
          Adds a 'NOT IN' clause with the criteria supplied as a List.
 

Methods in org.apache.torque.util with parameters of type Criteria
 void SQLBuilder.TableCallback.process(java.util.Set tables, java.lang.String key, Criteria crit)
          Callback Method for getTableSet()
static void VillageUtils.setVillageValue(Criteria crit, java.lang.String key, com.workingdogs.village.Record rec, java.lang.String colName)
          Factored out setting of a Village Record column from a Criteria Key
static java.util.Set SQLBuilder.getTableSet(Criteria crit, SQLBuilder.TableCallback tableCallback)
          Returns a set of all tables and possible aliases referenced from a criterion.
static Query SQLBuilder.buildQueryClause(Criteria crit, java.util.List params, SQLBuilder.QueryCallback qc)
          Builds a Query clause for Updating and deleting
static java.lang.String SQLBuilder.getTableNameForFromClause(java.lang.String tableName, Criteria criteria)
          Returns the tablename which can be added to a From Clause.
static void LimitHelper.buildLimit(Criteria criteria, Query query)
          Update the Query object according to the limiting information available in the Criteria
 int CountHelper.count(Criteria c)
          The COUNT function returns the number of rows in a query.
 int CountHelper.count(Criteria c, java.sql.Connection conn)
          The COUNT function returns the number of rows in a query.
 int CountHelper.count(Criteria c, java.lang.String columnName)
          Returns the number of rows in a query.
 int CountHelper.count(Criteria c, java.sql.Connection conn, java.lang.String columnName)
          Returns the number of rows in a query.
static void BasePeer.doDelete(Criteria criteria)
          Method to perform deletes based on values and keys in a Criteria.
static void BasePeer.doDelete(Criteria criteria, java.sql.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, java.sql.Connection con)
          Method to perform inserts based on values and keys in a Criteria.
static java.lang.String BasePeer.createQueryString(Criteria criteria)
          Method to create an SQL query for actual execution based on values in a Criteria.
static java.util.List BasePeer.doSelect(Criteria criteria)
          Returns all results.
static java.util.List BasePeer.doSelect(Criteria criteria, java.sql.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, java.sql.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, java.sql.Connection con)
          Method used to update rows in the DB.
static java.util.List BasePeer.doPSSelect(Criteria criteria, java.sql.Connection con)
          Performs a SQL select using a PreparedStatement.
static java.util.List BasePeer.doPSSelect(Criteria criteria)
          Do a Prepared Statement select according to the given criteria
static void BasePeer.createPreparedStatement(Criteria criteria, java.lang.StringBuffer queryString, java.util.List params)
          Create a new PreparedStatement.
static void JoinBuilder.processJoins(DB db, DatabaseMap dbMap, Criteria criteria, Query query)
          adds the Joins from the criteria to the query
 

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, java.lang.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.
LargeSelect(Criteria criteria, int pageSize, int memoryPageLimit, java.lang.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.
 



Copyright © 2000-2006 Apache Software Foundation. All Rights Reserved.