public class CaseStatement extends AbstractSQLFragment
Modifier and Type | Class and Description |
---|---|
static class |
CaseStatement.WhenThen |
AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport
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 |
COMMA, DEFAULT_SEPARATOR, EMPTY, EMPTY_ARRAY, INDENT, NEWLINE, SPACE
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 ...
|
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) |
appendToBuffer, argsToString, getStartOffset, getTextOrNull, getTextOrNull, getType, setStartOffset, surroundWithBrackets, surroundWithBrackets, toString
setParent
checkInit, checkInit, copyToImpl, equalsImpl, fireObjectUpdated, getOwnedObjectsImpl, getProperties, getReferenceIDsImpl, needsInitialization
addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, firePropertyChanged, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getParent, getProperty, getProperty, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, setID, setName, setProperties, setProperty
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
getParent, setParent
addObjectListener, copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getProperties, getReferenceIDs, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName
getProperty, getProperty, setProperties, setProperty
public static final java.lang.String CASE
public static final java.lang.String WHEN
public static final java.lang.String THEN
public static final java.lang.String ELSE
public static final java.lang.String END
public CaseStatement()
public CaseStatement(SQLFragment expression, CaseStatement.WhenThen[] whenThens, SQLFragment elseExpression)
public CaseStatement(SQLFragment expression, CaseStatement.WhenThen[] whenThens)
public CaseStatement(CaseStatement.WhenThen[] whenThens, SQLFragment elseExpression)
public CaseStatement(CaseStatement.WhenThen[] whenThens)
public SQLFragment getExpression()
public void setExpression(SQLFragment expression)
public CaseStatement.WhenThen[] getWhenThens()
public void setWhenThens(CaseStatement.WhenThen[] whenThens)
public SQLFragment getElseExpression()
public void setElseExpression(SQLFragment elseExpression)
public java.lang.String getSQLText()
SQLFragment