Class Restriction.ColumnQualifier
- All Implemented Interfaces:
Serializable
- Enclosing class:
Restriction
A simple comparison of a column to a constant value. The comparison has the form:
column OP constant
where OP is one of the following:
< = <= > >= IS NULL IS NOT NULL
- See Also:
-
Nested Class Summary
Nested classes/interfaces inherited from class org.apache.derby.vti.Restriction
Restriction.AND, Restriction.ColumnQualifier, Restriction.OR
-
Field Summary
FieldsModifier and TypeFieldDescriptionprivate String
name of column being restrictedprivate int
comparison operator, one of the ORDER_OP constantsprivate Object
value to compare the column toprivate String[]
static final int
Ordering operation constant representing '='static final int
Ordering operation constant representing '>='static final int
Ordering operation constant representing '>'static final int
Ordering operation constant representing 'IS NOT NULL'static final int
Ordering operation constant representing 'IS NULL'static final int
Ordering operation constant representing '<='static final int
Ordering operation constant representing '<'static final int
Ordering operation constant representing '!static final long
Derby serializes these objects in PreparedStatements -
Constructor Summary
ConstructorsConstructorDescriptionColumnQualifier
(String columnName, int comparisonOperator, Object constantOperand) Construct from pieces. -
Method Summary
Methods inherited from class org.apache.derby.vti.Restriction
parenthesize
-
Field Details
-
serialVersionUID
public static final long serialVersionUIDDerby serializes these objects in PreparedStatements- See Also:
-
ORDER_OP_LESSTHAN
public static final int ORDER_OP_LESSTHANOrdering operation constant representing '<'- See Also:
-
ORDER_OP_EQUALS
public static final int ORDER_OP_EQUALSOrdering operation constant representing '='- See Also:
-
ORDER_OP_LESSOREQUALS
public static final int ORDER_OP_LESSOREQUALSOrdering operation constant representing '<='- See Also:
-
ORDER_OP_GREATERTHAN
public static final int ORDER_OP_GREATERTHANOrdering operation constant representing '>'- See Also:
-
ORDER_OP_GREATEROREQUALS
public static final int ORDER_OP_GREATEROREQUALSOrdering operation constant representing '>='- See Also:
-
ORDER_OP_ISNULL
public static final int ORDER_OP_ISNULLOrdering operation constant representing 'IS NULL'- See Also:
-
ORDER_OP_ISNOTNULL
public static final int ORDER_OP_ISNOTNULLOrdering operation constant representing 'IS NOT NULL'- See Also:
-
ORDER_OP_NOT_EQUALS
public static final int ORDER_OP_NOT_EQUALSOrdering operation constant representing '!='- See Also:
-
OPERATOR_SYMBOLS
-
_columnName
name of column being restricted -
_comparisonOperator
private int _comparisonOperatorcomparison operator, one of the ORDER_OP constants -
_constantOperand
value to compare the column to
-
-
Constructor Details
-
ColumnQualifier
Construct from pieces.
- Parameters:
columnName
- Name of column as declared in the CREATE FUNCTION statement.comparisonOperator
- One of the ORDER_OP constants.constantOperand
- Constant value to which the column should be compared.
-
-
Method Details
-
getColumnName
The name of the column being compared.
-
getComparisonOperator
public int getComparisonOperator()The type of comparison to perform. This is one of the ORDER_OP constants defined above.
-
getConstantOperand
Get the constant value to which the column should be compared. The constant value must be an Object of the Java type which corresponds to the SQL type of the column. The column's SQL type was declared in the CREATE FUNCTION statement. The mapping of SQL types to Java types is defined in table 4 of chapter 14 of the original JDBC 1 specification (dated 1996). Bascially, these are the Java wrapper values you would expect. For instance, SQL INT maps to java.lang.Integer, SQL CHAR maps to java.lang.String, etc.. This object will be null if the comparison operator is ORDER_OP_ISNULL or ORDER_OP_ISNOTNULL.
-
toSQL
Description copied from class:Restriction
Turn this Restriction into a string suitable for use in a WHERE clause.- Specified by:
toSQL
in classRestriction
-
toEscapedString
-