- 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 SummaryNested classes/interfaces inherited from class org.apache.derby.vti.RestrictionRestriction.AND, Restriction.ColumnQualifier, Restriction.OR
- 
Field SummaryFieldsModifier and TypeFieldDescriptionstatic final intOrdering operation constant representing '='static final intOrdering operation constant representing '>='static final intOrdering operation constant representing '>'static final intOrdering operation constant representing 'IS NOT NULL'static final intOrdering operation constant representing 'IS NULL'static final intOrdering operation constant representing '<='static final intOrdering operation constant representing '<'static final intOrdering operation constant representing '!static final longDerby serializes these objects in PreparedStatements
- 
Constructor SummaryConstructorsConstructorDescriptionColumnQualifier(String columnName, int comparisonOperator, Object constantOperand) Construct from pieces.
- 
Method SummaryModifier and TypeMethodDescriptionThe name of the column being compared.intThe type of comparison to perform.Get the constant value to which the column should be compared.toSQL()Turn this Restriction into WHERE clause text.
- 
Field Details- 
serialVersionUIDpublic static final long serialVersionUIDDerby serializes these objects in PreparedStatements- See Also:
 
- 
ORDER_OP_LESSTHANpublic static final int ORDER_OP_LESSTHANOrdering operation constant representing '<'- See Also:
 
- 
ORDER_OP_EQUALSpublic static final int ORDER_OP_EQUALSOrdering operation constant representing '='- See Also:
 
- 
ORDER_OP_LESSOREQUALSpublic static final int ORDER_OP_LESSOREQUALSOrdering operation constant representing '<='- See Also:
 
- 
ORDER_OP_GREATERTHANpublic static final int ORDER_OP_GREATERTHANOrdering operation constant representing '>'- See Also:
 
- 
ORDER_OP_GREATEROREQUALSpublic static final int ORDER_OP_GREATEROREQUALSOrdering operation constant representing '>='- See Also:
 
- 
ORDER_OP_ISNULLpublic static final int ORDER_OP_ISNULLOrdering operation constant representing 'IS NULL'- See Also:
 
- 
ORDER_OP_ISNOTNULLpublic static final int ORDER_OP_ISNOTNULLOrdering operation constant representing 'IS NOT NULL'- See Also:
 
- 
ORDER_OP_NOT_EQUALSpublic static final int ORDER_OP_NOT_EQUALSOrdering operation constant representing '!='- See Also:
 
 
- 
- 
Constructor Details- 
ColumnQualifierConstruct 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- 
getColumnNameThe name of the column being compared. - Returns:
- the name of the column being compared
 
- 
getComparisonOperatorpublic int getComparisonOperator()The type of comparison to perform. This is one of the ORDER_OP constants defined above. - Returns:
- an ORDER_OP representing the type of comparison to perform
 
- 
getConstantOperandGet 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. - Returns:
- the constant with which the column is being compared
 
- 
toSQLTurn this Restriction into WHERE clause text.- Specified by:
- toSQLin class- Restriction
- Returns:
- this Restriction as WHERE clause text
 
 
-