public class DBCaseMapExpr extends DBCaseExpr
There is no need to explicitly create instances of this class.
Instead use DBDatabase.caseMap(DBColumnExpr, Object, Object, Object)
attributes, beanPropertyName, DBCOLATTR_TITLE, DBCOLATTR_TYPE, optionsCTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESIS, CTX_VALUE| Constructor and Description |
|---|
DBCaseMapExpr(DBColumnExpr caseExpr,
Map<? extends Object,? extends Object> valueMap,
Object elseValue)
constructs a DBCaseSelectExpr expr
|
DBCaseMapExpr(DBColumnExpr caseExpr,
Object cmpVal,
Object trueValue,
Object elseValue) |
DBCaseMapExpr(DBColumnExpr caseExpr,
Object cmpVal1,
Object trueValue1,
Object cmpVal2,
Object trueValue2,
Object elseValue) |
| Modifier and Type | Method and Description |
|---|---|
void |
addReferencedColumns(Set<DBColumn> list)
Internal function to obtain all DBColumnExpr-objects used by this expression.
|
void |
addSQL(DBSQLBuilder sql,
long context)
Used to build the SQL command.
|
boolean |
equals(Object other)
Returns true if other is equal to this expression
|
String |
getName()
Returns the column name for this column expression.
|
addXml, getDatabase, getDataType, getEnumType, getRowSet, getSourceColumnExpr, getUpdateColumn, init, initDataTypeFromValue, isAggregate, isNotNull, isNullabs, aggregate, append, as, as, asc, avg, ceiling, cmp, coalesce, concat, concat, convertTo, convertTo, count, countDistinct, day, decode, decode, decode, decode, decode, decode, decodeEnum, decodeSort, desc, divideBy, floor, format, function, getAttribute, getBeanPropertyName, getControlType, getExprFromPhrase, getExprFromPhrase, getJavaType, getOptions, getSourceColumn, getTitle, in, in, in, indexOf, indexOf, indexOf, is, isBetween, isGreaterThan, isLessOrEqual, isMoreOrEqual, isNot, isNotBetween, isSmallerThan, length, like, like, likeLower, likeUpper, lower, max, min, minus, minus, modulo, month, multiplyWith, notIn, notIn, notIn, notLike, nvl, on, parenthesis, plus, plus, prepend, qualified, replace, reverse, round, setAttribute, setBeanPropertyName, setControlType, setOptions, setTitle, stringAgg, stringAgg, substring, substring, substring, substring, substring, substring, sum, toChar, toChar, toString, trim, trimLeft, trimRight, trunc, upper, when, yearcheckParamNullpublic DBCaseMapExpr(DBColumnExpr caseExpr, Map<? extends Object,? extends Object> valueMap, Object elseValue)
caseExpr - the case expressionvalueMap - the value MapelseValue - the else Expressionpublic DBCaseMapExpr(DBColumnExpr caseExpr, Object cmpVal, Object trueValue, Object elseValue)
public String getName()
DBColumnExprgetName in interface ColumnExprgetName in class DBColumnExprpublic boolean equals(Object other)
public void addReferencedColumns(Set<DBColumn> list)
DBExpraddReferencedColumns in class DBExprlist - list to which all used column expressions must be addedpublic void addSQL(DBSQLBuilder sql, long context)
DBExprCopyright © 2008–2023 Apache Software Foundation. All rights reserved.