oracle.javatools.db.sql

Class CaseStatement

java.lang.Object

oracle.javatools.db.AbstractDBObject

oracle.javatools.db.AbstractBuildableObject

oracle.javatools.db.AbstractChildBuildableObject

oracle.javatools.db.sql.AbstractSQLFragment

oracle.javatools.db.sql.CaseStatement

All Implemented Interfaces:

ChildDBObject, DBObject, SQLFragment, Copyable

public class CaseStatement
extends AbstractSQLFragment

Class to represent a case statement in a sql query.
CASE [expression]
WHEN condition THEN thenExpression
WHEN condition THEN thenExpression ...
[ELSE elseExpression]
END

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	CaseStatement.WhenThen

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	CASE
static java.lang.String	ELSE
static java.lang.String	END
static java.lang.String	THEN
static java.lang.String	WHEN

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, TYPE, WHERE

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

Constructors

Constructor and Description
CaseStatement()
CaseStatement(CaseStatement.WhenThen[] whenThens) CASE WHEN condition THEN thenExpression ...
CaseStatement(CaseStatement.WhenThen[] whenThens, SQLFragment elseExpression) CASE WHEN condition THEN thenExpression ...
CaseStatement(SQLFragment expression, CaseStatement.WhenThen[] whenThens) CASE expression WHEN condition THEN thenExpression ...
CaseStatement(SQLFragment expression, CaseStatement.WhenThen[] whenThens, SQLFragment elseExpression) CASE expression WHEN condition THEN thenExpression ...

Method Summary

Modifier and Type	Method and Description
SQLFragment	getElseExpression()
SQLFragment	getExpression()
java.lang.String	getSQLText() Return the SQL for this fragment.
CaseStatement.WhenThen[]	getWhenThens()
void	setElseExpression(SQLFragment elseExpression)
void	setExpression(SQLFragment expression)
void	setWhenThens(CaseStatement.WhenThen[] whenThens)

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

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

Methods inherited from class oracle.javatools.db.AbstractChildBuildableObject

setParent

Methods inherited from class oracle.javatools.db.AbstractBuildableObject

checkInit, checkInit, copyToImpl, 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, equalsImpl, 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.ChildDBObject

getParent, setParent

Methods inherited from interface oracle.javatools.db.DBObject

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

Field Detail

CASE

public static final java.lang.String CASE

See Also:

Constant Field Values

WHEN

public static final java.lang.String WHEN

See Also:

Constant Field Values

THEN

public static final java.lang.String THEN

See Also:

Constant Field Values

ELSE

public static final java.lang.String ELSE

See Also:

Constant Field Values

END

public static final java.lang.String END

See Also:

Constant Field Values

Constructor Detail

CaseStatement

public CaseStatement()

CaseStatement

public CaseStatement(SQLFragment expression,
                     CaseStatement.WhenThen[] whenThens,
                     SQLFragment elseExpression)

CASE expression WHEN condition THEN thenExpression ... ELSE elseExpression END

CaseStatement

public CaseStatement(SQLFragment expression,
                     CaseStatement.WhenThen[] whenThens)

CASE expression WHEN condition THEN thenExpression ... END

CaseStatement

public CaseStatement(CaseStatement.WhenThen[] whenThens,
                     SQLFragment elseExpression)

CASE WHEN condition THEN thenExpression ... ELSE elseExpression END

CaseStatement

public CaseStatement(CaseStatement.WhenThen[] whenThens)

CASE WHEN condition THEN thenExpression ... END

Method Detail

getExpression

public SQLFragment getExpression()

setExpression

public void setExpression(SQLFragment expression)

getWhenThens

public CaseStatement.WhenThen[] getWhenThens()

setWhenThens

public void setWhenThens(CaseStatement.WhenThen[] whenThens)

getElseExpression

public SQLFragment getElseExpression()

setElseExpression

public void setElseExpression(SQLFragment elseExpression)

getSQLText

public java.lang.String getSQLText()

Description copied from interface: SQLFragment

Return the SQL for this fragment. This contains no validation - if the implementation is incomplete it will just return what it has. Error checking of fragments should be done using a SQLQueryBuilder.

Returns:

a string representing the SQL text for this object.