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.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
static void LimitHelper.buildLimit(Criteria criteria, Query query)
          Update the Query object according to the limiting information available in the Criteria
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 selectCriteria, 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.
 

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-2005 Apache Software Foundation. All Rights Reserved.