oracle.javatools.db.sql

Class WhereObject

java.lang.Object

oracle.javatools.db.AbstractDBObject

oracle.javatools.db.AbstractBuildableObject

oracle.javatools.db.AbstractChildBuildableObject

oracle.javatools.db.sql.AbstractSQLFragment

oracle.javatools.db.sql.Operation

oracle.javatools.db.sql.WhereObject

All Implemented Interfaces:

ChildDBObject, DBObject, SQLFragment, SQLFragmentWithDatatype, Copyable

Direct Known Subclasses:

OnJoinCondition

public class WhereObject
extends Operation

Object that represents a clause in the WHERE statement of a SQL query. The WHERE statement itself is one of these objects, and can contain child WhereObjects.

Since:

10.1.3

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	WhereObject.WhereOperator Valid operators for a WhereObject.

Nested classes/interfaces inherited from class oracle.javatools.db.AbstractDBObject

AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	TYPE

Fields inherited from class oracle.javatools.db.sql.AbstractSQLFragment

AS, COMMA, DEFAULT_SEPARATOR, EMPTY, EMPTY_ARRAY, INDENT, LEFT_PAREN, NEWLINE, RIGHT_PAREN, SPACE

Fields inherited from interface oracle.javatools.db.sql.SQLFragment

CONNECTBY, FROM, GROUPBY, HAVING, MODEL, NOCYCLE, ORDERBY, ORDERSIBLINGSBY, PRIOR, SELECT, STARTWITH, WHERE

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

Constructors

Constructor and Description
WhereObject() Creates an empty WhereObject.
WhereObject(SQLFragment exp) Where object with only one clause.
WhereObject(SQLFragment[] expressions, WhereObject.WhereOperator logic) Creates a WhereObject with the given expressions.

Method Summary

Modifier and Type	Method and Description
WhereObject.WhereOperator	getOperator() Gets whether this is an AND or OR condition.
java.lang.String	getOperatorText()
java.lang.String	getType() Returns the type of this object.
void	setOperator(WhereObject.WhereOperator logic) Sets whether this is an AND or OR condition.

Methods inherited from class oracle.javatools.db.sql.Operation

addArgument, addArgument, addArguments, checkArgument, checkNewSize, copyToImpl, equalsImpl, getArgumentCount, getArguments, getDataTypeID, getDistinctText, getSeparator, getSQLText, removeArgument, setArguments, setCommutative, setFunctionFormat, setSeparator

Methods inherited from class oracle.javatools.db.sql.AbstractSQLFragment

appendToBuffer, appendToBuffer, argsToString, getName, getStartOffset, getTextOrNull, getTextOrNull, setStartOffset, surroundWithBrackets, surroundWithBrackets, toString

Methods inherited from class oracle.javatools.db.AbstractChildBuildableObject

setParent

Methods inherited from class oracle.javatools.db.AbstractBuildableObject

checkInit, checkInit, getOwnedObjectsImpl, getProperties, getReferenceIDsImpl, needsInitialization, processPropertyChange, setID

Methods inherited from class oracle.javatools.db.AbstractDBObject

addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, fireObjectUpdated, firePropertyChanged, getChildSupport, getChildSupport, getID, getOwnedObjects, getOwnedObjects, getParent, getProperty, getProperty, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, setName, setProperties, setProperty

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface oracle.javatools.db.sql.SQLFragment

getStartOffset

Methods inherited from interface oracle.javatools.db.ChildDBObject

getParent, setParent

Methods inherited from interface oracle.javatools.db.DBObject

addObjectListener, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getProperties, getProperty, getProperty, getReferenceIDs, hashCode, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName, setProperties, setProperty

Field Detail

TYPE

public static final java.lang.String TYPE

See Also:

Constant Field Values

Constructor Detail

WhereObject

public WhereObject()

Creates an empty WhereObject.

WhereObject

public WhereObject(SQLFragment exp)

Where object with only one clause. Used only for a WHERE expression without an AND or OR.

WhereObject

public WhereObject(SQLFragment[] expressions,
                   WhereObject.WhereOperator logic)

Creates a WhereObject with the given expressions. The boolean parameter sets whether to use an AND or OR.

Method Detail

getType

public java.lang.String getType()

Description copied from interface: DBObject

Returns the type of this object. Valid types include things like tables, views, synonyms, and columns.

Specified by:

getType in interface DBObject

Overrides:

getType in class AbstractSQLFragment

Returns:

a string describing the type of object.

setOperator

public void setOperator(WhereObject.WhereOperator logic)

Sets whether this is an AND or OR condition.

getOperator

public WhereObject.WhereOperator getOperator()

Gets whether this is an AND or OR condition.

getOperatorText

public java.lang.String getOperatorText()

Specified by:

getOperatorText in class Operation