oracle.javatools.db.sql
Class CaseStatement

java.lang.Object
  oracle.javatools.db.AbstractDBObject
      oracle.javatools.db.AbstractChildDBObject
          oracle.javatools.db.sql.AbstractSQLFragment
              oracle.javatools.db.sql.CaseStatement

All Implemented Interfaces:

ChildDBObject, DBObject, SQLFragment, Copyable, DynamicPropertySet

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

static class

CaseStatement.WhenThen

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

AbstractDBObject.ChildSupport

Field Summary

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

DEFAULT_SEPARATOR, EMPTY, EMPTY_ARRAY, NEWLINE, SPACE

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

CONNECTBY, FROM, GROUPBY, HAVING, NOCYCLE, ORDERBY, SELECT, STARTWITH, TYPE, WHERE

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

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

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, argsToString, getTextOrNull, getTextOrNull, getType, setParent, surroundWithBrackets, surroundWithBrackets, toString

Methods inherited from class oracle.javatools.db.AbstractChildDBObject

copyToImpl, findParent, getParent, getProperty, setProperty

Methods inherited from class oracle.javatools.db.AbstractDBObject

changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getOwnedObjectsImpl, getProperties, getProperty, getReferenceIDs, getReferenceIDsImpl, hashCode, includeOwnedObject, includesType, includesType, removeThisAsParent, replaceReferenceIDs, setID, setName, setProperties

Methods inherited from class java.lang.Object

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

Methods inherited from interface oracle.javatools.db.ChildDBObject

getParent

Methods inherited from interface oracle.javatools.db.DBObject

copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, replaceReferenceIDs, setID, setName

Methods inherited from interface oracle.javatools.util.DynamicPropertySet

getProperties, getProperty, getProperty, 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.