Package org.apache.torque.criteria
Class SqlEnum
- java.lang.Object
-
- org.apache.torque.criteria.SqlEnum
-
- All Implemented Interfaces:
Serializable
public final class SqlEnum extends Object implements Serializable
A typesafe enum of SQL string fragments. Used by Criteria and SqlExpression to build queries. Criteria also makes most of the constants available in order to specify a criterion.- Since:
- 3.0
- Version:
- $Id: SqlEnum.java 1850965 2019-01-10 17:21:29Z painter $
- Author:
- , Thomas Fischer
- See Also:
- Serialized Form
-
-
Field Summary
Fields Modifier and Type Field Description static SqlEnumALLSQL Expression "ALL ".static SqlEnumALT_NOT_EQUALSQL Expression "!static SqlEnumASSQL Expression " AS ".static SqlEnumASCSQL Expression "ASC".static SqlEnumCURRENT_DATESQL Expression "CURRENT_DATE".static SqlEnumCURRENT_TIMESQL Expression "CURRENT_TIME".static SqlEnumCURRENT_TIMESTAMPSQL Expression "CURRENT_TIMESTAMP".static SqlEnumDESCSQL Expression "DESC".static SqlEnumDISTINCTSQL Expression "DISTINCT ".static SqlEnumEQUALSQL Expression "=".static SqlEnumESCAPESQL Expression " ESCAPE ".static SqlEnumEXCEPTSQL Expression " EXCEPT ".static SqlEnumEXCEPT_ALLSQL Expression " EXCEPT ALL ".static SqlEnumGREATER_EQUALSQL Expression ">=".static SqlEnumGREATER_THANSQL Expression ">".static SqlEnumILIKESQL Expression " ILIKE ".static SqlEnumINSQL Expression " IN ".static SqlEnumINTERSECTSQL Expression " INTERSECT ".static SqlEnumINTERSECT_ALLSQL Expression " INTERSECT ALL ".static SqlEnumISNOTNULLSQL Expression " IS NOT NULL".static SqlEnumISNULLSQL Expression " IS NULL".static SqlEnumJOINSQL Expression "JOIN".static SqlEnumLESS_EQUALSQL Expression "<=".static SqlEnumLESS_THANSQL Expression "<".static SqlEnumLIKESQL Expression " LIKE ".static SqlEnumMINUSSQL Expression " MINUS ".static SqlEnumMINUS_ALLSQL Expression " MINUS ALL ".static SqlEnumNOT_EQUALSQL Expression "<>".static SqlEnumNOT_ILIKESQL Expression " NOT ILIKE ".static SqlEnumNOT_INSQL Expression " NOT IN ".static SqlEnumNOT_LIKESQL Expression " NOT LIKE ".static SqlEnumONSQL Expression " ON ".static SqlEnumUNIONSQL Expression " UNION ".static SqlEnumUNION_ALLSQL Expression " UNION ALL ".
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description booleanequals(Object o)returns whether o is the same SqlEnum as this object.intgetNumberOfCompareOperands()Returns the number of operands, if the SqlEnum is a comparison operator.inthashCode()returns a hashcode for this object which is consistent with equals()StringtoString()
-
-
-
Field Detail
-
EQUAL
public static final SqlEnum EQUAL
SQL Expression "=".
-
NOT_EQUAL
public static final SqlEnum NOT_EQUAL
SQL Expression "<>".
-
ALT_NOT_EQUAL
public static final SqlEnum ALT_NOT_EQUAL
SQL Expression "!=".
-
GREATER_THAN
public static final SqlEnum GREATER_THAN
SQL Expression ">".
-
LESS_THAN
public static final SqlEnum LESS_THAN
SQL Expression "<".
-
GREATER_EQUAL
public static final SqlEnum GREATER_EQUAL
SQL Expression ">=".
-
LESS_EQUAL
public static final SqlEnum LESS_EQUAL
SQL Expression "<=".
-
LIKE
public static final SqlEnum LIKE
SQL Expression " LIKE ".
-
NOT_LIKE
public static final SqlEnum NOT_LIKE
SQL Expression " NOT LIKE ".
-
ILIKE
public static final SqlEnum ILIKE
SQL Expression " ILIKE ".
-
NOT_ILIKE
public static final SqlEnum NOT_ILIKE
SQL Expression " NOT ILIKE ".
-
IN
public static final SqlEnum IN
SQL Expression " IN ".
-
NOT_IN
public static final SqlEnum NOT_IN
SQL Expression " NOT IN ".
-
JOIN
public static final SqlEnum JOIN
SQL Expression "JOIN".
-
DISTINCT
public static final SqlEnum DISTINCT
SQL Expression "DISTINCT ".
-
ALL
public static final SqlEnum ALL
SQL Expression "ALL ".
-
ASC
public static final SqlEnum ASC
SQL Expression "ASC".
-
DESC
public static final SqlEnum DESC
SQL Expression "DESC".
-
ISNULL
public static final SqlEnum ISNULL
SQL Expression " IS NULL".
-
ISNOTNULL
public static final SqlEnum ISNOTNULL
SQL Expression " IS NOT NULL".
-
CURRENT_DATE
public static final SqlEnum CURRENT_DATE
SQL Expression "CURRENT_DATE".
-
CURRENT_TIME
public static final SqlEnum CURRENT_TIME
SQL Expression "CURRENT_TIME".
-
CURRENT_TIMESTAMP
public static final SqlEnum CURRENT_TIMESTAMP
SQL Expression "CURRENT_TIMESTAMP".
-
ON
public static final SqlEnum ON
SQL Expression " ON ".
-
AS
public static final SqlEnum AS
SQL Expression " AS ".
-
ESCAPE
public static final SqlEnum ESCAPE
SQL Expression " ESCAPE ".
-
UNION
public static final SqlEnum UNION
SQL Expression " UNION ".
-
UNION_ALL
public static final SqlEnum UNION_ALL
SQL Expression " UNION ALL ".
-
INTERSECT
public static final SqlEnum INTERSECT
SQL Expression " INTERSECT ".
-
INTERSECT_ALL
public static final SqlEnum INTERSECT_ALL
SQL Expression " INTERSECT ALL ".
-
EXCEPT
public static final SqlEnum EXCEPT
SQL Expression " EXCEPT ".
-
EXCEPT_ALL
public static final SqlEnum EXCEPT_ALL
SQL Expression " EXCEPT ALL ".
-
MINUS
public static final SqlEnum MINUS
SQL Expression " MINUS ".
-
MINUS_ALL
public static final SqlEnum MINUS_ALL
SQL Expression " MINUS ALL ".
-
-
Method Detail
-
getNumberOfCompareOperands
public int getNumberOfCompareOperands()
Returns the number of operands, if the SqlEnum is a comparison operator. A Set operand (e.g. in IN) is counted as one operand.- Returns:
- the number of compare operands, or -1 if the SqlEnum is no comparison operator.
-
equals
public boolean equals(Object o)
returns whether o is the same SqlEnum as this object. Two SqlEnums are considered equal if they contain the same String.
-
-