public class DBCaseExpr extends DBColumnExpr
There is no need to explicitly create instances of this class.
Instead use DBColumnExpr.when(DBCompareExpr, Object)
attributes, beanPropertyName, DBCOLATTR_TITLE, DBCOLATTR_TYPE, optionsCTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESES, CTX_VALUE| Constructor and Description |
|---|
DBCaseExpr(DBCompareExpr compExpr,
DBColumnExpr trueExpr,
DBColumnExpr elseExpr)
Constructs a DBCaseExpr
|
| Modifier and Type | Method and Description |
|---|---|
void |
addReferencedColumns(Set<DBColumn> list)
Internal function to obtain all DBColumnExpr-objects used by this expression.
|
void |
addSQL(StringBuilder sql,
long context)
Used to build the SQL command.
|
Element |
addXml(Element parent,
long flags)
Add a description of this column with relevant metadata
to the supplied parent XML Element.
|
DBDatabase |
getDatabase()
Returns the database object to which this object belongs to.
|
DataType |
getDataType()
Returns the data type of this column expression.
|
String |
getName()
Returns the column name for this column expression.
|
DBColumn |
getUpdateColumn()
Returns the underlying physical column which may be used for updates.
|
boolean |
isAggregate()
Indicates wheter this function is an aggregate (sum, min, max, avg, ...) or not
|
abs, append, as, as, asc, avg, cmp, coalesce, convertTo, convertTo, count, countDistinct, day, decode, decode, decode, decode, decode, decode, desc, detectDataType, divideBy, getAttribute, getBeanPropertyName, getControlType, getExprFromPhrase, getExprFromPhrase, getOptions, getSourceColumn, getTitle, in, indexOf, indexOf, indexOf, is, isBetween, isGreaterThan, isLessOrEqual, isMoreOrEqual, isNot, isNotBetween, isSmallerThan, length, like, like, likeLower, likeUpper, lower, max, min, minus, minus, month, multiplyWith, notIn, notLike, nvl, parenthesis, plus, plus, replace, reverse, round, setAttribute, setBeanPropertyName, setControlType, setOptions, setTitle, substring, substring, substring, substring, substring, substring, sum, toChar, toChar, trim, trimLeft, trimRight, trunc, upper, when, yeargetObjectValue, getValueClasspublic DBCaseExpr(DBCompareExpr compExpr, DBColumnExpr trueExpr, DBColumnExpr elseExpr)
compExpr - the condition to be evaluatedtrueExpr - the expression returned if the condition is trueelseExpr - the expression returned if the condition is false (may be null)public DBDatabase getDatabase()
DBObjectgetDatabase in class DBObjectpublic DataType getDataType()
DBColumnExprgetDataType in interface ColumnExprgetDataType in class DBColumnExprDataTypepublic String getName()
DBColumnExprgetName in interface ColumnExprgetName in class DBColumnExprpublic DBColumn getUpdateColumn()
DBColumnExprgetUpdateColumn in class DBColumnExprpublic boolean isAggregate()
DBColumnExprisAggregate in class DBColumnExprpublic void addReferencedColumns(Set<DBColumn> list)
DBExpraddReferencedColumns in class DBExprlist - list to which all used column expressions must be addedpublic void addSQL(StringBuilder sql, long context)
DBExprpublic Element addXml(Element parent, long flags)
DBColumnExpraddXml in class DBColumnExprparent - the parent element to which to append the column descriptionflags - currently not usedCopyright © 2008–2015 Apache Software Foundation. All rights reserved.