java.io.Serializable
public static class Restriction.ColumnQualifier extends 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
Restriction.AND, Restriction.ColumnQualifier, Restriction.OR
Modifier and Type | Field | Description |
---|---|---|
private java.lang.String |
_columnName |
name of column being restricted
|
private int |
_comparisonOperator |
comparison operator, one of the ORDER_OP constants
|
private java.lang.Object |
_constantOperand |
value to compare the column to
|
private java.lang.String[] |
OPERATOR_SYMBOLS |
|
static int |
ORDER_OP_EQUALS |
Ordering operation constant representing '='
|
static int |
ORDER_OP_GREATEROREQUALS |
Ordering operation constant representing '>='
|
static int |
ORDER_OP_GREATERTHAN |
Ordering operation constant representing '>'
|
static int |
ORDER_OP_ISNOTNULL |
Ordering operation constant representing 'IS NOT NULL'
|
static int |
ORDER_OP_ISNULL |
Ordering operation constant representing 'IS NULL'
|
static int |
ORDER_OP_LESSOREQUALS |
Ordering operation constant representing '<='
|
static int |
ORDER_OP_LESSTHAN |
Ordering operation constant representing '<'
|
static int |
ORDER_OP_NOT_EQUALS |
Ordering operation constant representing '!
|
static long |
serialVersionUID |
Derby serializes these objects in PreparedStatements
|
Constructor | Description |
---|---|
ColumnQualifier(java.lang.String columnName,
int comparisonOperator,
java.lang.Object constantOperand) |
Construct from pieces.
|
Modifier and Type | Method | Description |
---|---|---|
java.lang.String |
getColumnName() |
The name of the column being compared.
|
int |
getComparisonOperator() |
The type of comparison to perform.
|
java.lang.Object |
getConstantOperand() |
Get the constant value to which the column should be compared.
|
protected java.lang.String |
toEscapedString(java.lang.Object o) |
|
java.lang.String |
toSQL() |
Turn this Restriction into a string suitable for use in a WHERE clause.
|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
parenthesize
public static final long serialVersionUID
public static final int ORDER_OP_LESSTHAN
public static final int ORDER_OP_EQUALS
public static final int ORDER_OP_LESSOREQUALS
public static final int ORDER_OP_GREATERTHAN
public static final int ORDER_OP_GREATEROREQUALS
public static final int ORDER_OP_ISNULL
public static final int ORDER_OP_ISNOTNULL
public static final int ORDER_OP_NOT_EQUALS
private java.lang.String[] OPERATOR_SYMBOLS
private java.lang.String _columnName
private int _comparisonOperator
private java.lang.Object _constantOperand
public ColumnQualifier(java.lang.String columnName, int comparisonOperator, java.lang.Object constantOperand)
Construct from pieces.
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.public java.lang.String getColumnName()
The name of the column being compared.
public int getComparisonOperator()
The type of comparison to perform. This is one of the ORDER_OP constants defined above.
public java.lang.Object 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.
public java.lang.String toSQL()
Restriction
toSQL
in class Restriction
protected java.lang.String toEscapedString(java.lang.Object o)
Apache Derby V10.14 Internals - Copyright © 2004,2018 The Apache Software Foundation. All Rights Reserved.