| Package | Description | 
|---|---|
| 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. | 
| Modifier and Type | Field and Description | 
|---|---|
| static SqlEnum | Criteria. ALLComparison type. | 
| static SqlEnum | SqlEnum. ALLSQL Expression "ALL ". | 
| static SqlEnum | Criteria. ALT_NOT_EQUALComparison type. | 
| static SqlEnum | SqlEnum. ALT_NOT_EQUALSQL Expression "!=". | 
| static SqlEnum | SqlEnum. ASSQL Expression " AS ". | 
| static SqlEnum | SqlEnum. ASCSQL Expression "ASC". | 
| static SqlEnum | Criteria. CURRENT_DATE"CURRENT_DATE" ANSI SQL function | 
| static SqlEnum | SqlEnum. CURRENT_DATESQL Expression "CURRENT_DATE". | 
| static SqlEnum | Criteria. CURRENT_TIME"CURRENT_TIME" ANSI SQL function | 
| static SqlEnum | SqlEnum. CURRENT_TIMESQL Expression "CURRENT_TIME". | 
| static SqlEnum | Criteria. CURRENT_TIMESTAMP"CURRENT_TIMESTAMP" ANSI SQL function | 
| static SqlEnum | SqlEnum. CURRENT_TIMESTAMPSQL Expression "CURRENT_TIMESTAMP". | 
| static SqlEnum | SqlEnum. DESCSQL Expression "DESC". | 
| static SqlEnum | Criteria. DISTINCTComparison type. | 
| static SqlEnum | SqlEnum. DISTINCTSQL Expression "DISTINCT ". | 
| static SqlEnum | Criteria. EQUALComparison type. | 
| static SqlEnum | SqlEnum. EQUALSQL Expression "=". | 
| static SqlEnum | SqlEnum. ESCAPESQL Expression " ESCAPE ". | 
| static SqlEnum | SqlEnum. EXCEPTSQL Expression " EXCEPT ". | 
| static SqlEnum | SqlEnum. EXCEPT_ALLSQL Expression " EXCEPT ALL ". | 
| static SqlEnum | Criteria. GREATER_EQUALComparison type. | 
| static SqlEnum | SqlEnum. GREATER_EQUALSQL Expression ">=". | 
| static SqlEnum | Criteria. GREATER_THANComparison type. | 
| static SqlEnum | SqlEnum. GREATER_THANSQL Expression ">". | 
| static SqlEnum | Criteria. ILIKEComparison type. | 
| static SqlEnum | SqlEnum. ILIKESQL Expression " ILIKE ". | 
| static SqlEnum | Criteria. INComparison type. | 
| static SqlEnum | SqlEnum. INSQL Expression " IN ". | 
| static SqlEnum | SqlEnum. INTERSECTSQL Expression " INTERSECT ". | 
| static SqlEnum | SqlEnum. INTERSECT_ALLSQL Expression " INTERSECT ALL ". | 
| static SqlEnum | Criteria. ISNOTNULL"IS NOT NULL" null comparison | 
| static SqlEnum | SqlEnum. ISNOTNULLSQL Expression " IS NOT NULL". | 
| static SqlEnum | Criteria. ISNULL"IS NULL" null comparison | 
| static SqlEnum | SqlEnum. ISNULLSQL Expression " IS NULL". | 
| static SqlEnum | Criteria. JOINComparison type. | 
| static SqlEnum | SqlEnum. JOINSQL Expression "JOIN". | 
| static SqlEnum | Criteria. LESS_EQUALComparison type. | 
| static SqlEnum | SqlEnum. LESS_EQUALSQL Expression "<=". | 
| static SqlEnum | Criteria. LESS_THANComparison type. | 
| static SqlEnum | SqlEnum. LESS_THANSQL Expression "<". | 
| static SqlEnum | Criteria. LIKEComparison type. | 
| static SqlEnum | SqlEnum. LIKESQL Expression " LIKE ". | 
| static SqlEnum | SqlEnum. MINUSSQL Expression " MINUS ". | 
| static SqlEnum | SqlEnum. MINUS_ALLSQL Expression " MINUS ALL ". | 
| static SqlEnum | Criteria. NOT_EQUALComparison type. | 
| static SqlEnum | SqlEnum. NOT_EQUALSQL Expression "<>". | 
| static SqlEnum | Criteria. NOT_ILIKEComparison type. | 
| static SqlEnum | SqlEnum. NOT_ILIKESQL Expression " NOT ILIKE ". | 
| static SqlEnum | Criteria. NOT_INComparison type. | 
| static SqlEnum | SqlEnum. NOT_INSQL Expression " NOT IN ". | 
| static SqlEnum | Criteria. NOT_LIKEComparison type. | 
| static SqlEnum | SqlEnum. NOT_LIKESQL Expression " NOT LIKE ". | 
| static SqlEnum | SqlEnum. ONSQL Expression " ON ". | 
| static SqlEnum | SqlEnum. UNIONSQL Expression " UNION ". | 
| static SqlEnum | SqlEnum. UNION_ALLSQL Expression " UNION ALL ". | 
| Modifier and Type | Method and Description | 
|---|---|
| SqlEnum | Criterion. getComparison()Get the comparison. | 
| SqlEnum | Criteria. getSetOperator()Returns the operator between the set operations. | 
| Modifier and Type | Method and Description | 
|---|---|
| Criteria | Criteria. addJoin(Column left,
       Column right,
       SqlEnum comparison,
       JoinType joinType)Adds a join to the criteria, E.g. | 
| 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,
       SqlEnum comparison)Convenience method to AND a new date comparison with the conditions
 in this Criteria. | 
| PreparedStatementPartImpl | PreparedStatementPartImpl. append(SqlEnum toAppend)Appends a SqlEnum to this part. | 
| protected void | Criteria. appendSetOperation(Criteria other,
                  SqlEnum setOperator)Appends a set operation (union, except, intersect) to 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,
      SqlEnum comparison)Convenience method to OR a new date comparison 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,
         SqlEnum comparison)Convenience method to AND a new date comparison with the conditions
 in this Criteria. | 
| Constructor and Description | 
|---|
| Criterion(Object lValue,
         Object rValue,
         SqlEnum comparison)Create a new instance without verbatim sql. | 
| Criterion(Object lValue,
         Object rValue,
         SqlEnum comparison,
         String sql,
         Object[] preparedStatementReplacements)Create a new instance. | 
| Join(Column leftColumn,
    Column rightColumn,
    SqlEnum comparison,
    JoinType joinType)Constructor with the comparison operator. | 
| Modifier and Type | Method and Description | 
|---|---|
| SqlEnum | WhereClauseExpression. getOperator()Returns the value on the operator of the expression. | 
| SqlEnum | OrderBy. getOrder()Returns the order to order by (ASC or DESC). | 
| Modifier and Type | Method and Description | 
|---|---|
| void | WhereClauseExpression. setOperator(SqlEnum operator)Sets the value on the operator of the expression. | 
| Constructor and Description | 
|---|
| OrderBy(Column column,
       SqlEnum order,
       boolean ignoreCase)Constructor. | 
| WhereClauseExpression(Object lValue,
                     SqlEnum operator,
                     Object rValue,
                     String sql,
                     Object[] preparedStatementReplacements)Constructor. | 
Copyright © 2000–2020 The Apache Software Foundation. All rights reserved.