public class DBFuncExpr extends DBAbstractFuncExpr
There is no need to explicitly create instances of this class.
Instead use any of the following functions:
DBColumnExpr.abs(), DBColumnExpr.coalesce(Object), DBColumnExpr.convertTo(DataType),
DBColumnExpr.decode(java.util.Map, Object), DBColumnExpr.lower(), DBColumnExpr.min(),
DBColumnExpr.max(), DBColumnExpr.month(), DBColumnExpr.sum(),
DBColumnExpr.trim(), DBColumnExpr.upper(), DBColumnExpr.year()
| Modifier and Type | Field and Description |
|---|---|
protected Object[] |
params |
protected DBSqlPhrase |
phrase |
protected String |
template |
dataType, expr, isAggregate, logattributes, beanPropertyName, DBCOLATTR_TITLE, DBCOLATTR_TYPE, optionsCTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESIS, CTX_VALUE| Constructor and Description |
|---|
DBFuncExpr(DBColumnExpr expr,
DBSqlPhrase phrase,
Object[] params,
DataType dataType)
Constructs a new DBFuncExpr object set the specified parameters to this object.
|
DBFuncExpr(DBColumnExpr expr,
String template,
Object[] params,
boolean isAggregate,
DataType dataType)
Constructs a new DBFuncExpr object set the specified parameters to this object.
|
| 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)
Creates the SQL-Command adds a function to the SQL-Command.
|
Class<Enum<?>> |
getEnumType()
Maybe an Enum...
|
protected String |
getFunctionName()
returns the name of the function
|
addSQL, addXml, equals, getDatabase, getDataType, getDbms, getName, getRowSet, getUpdateColumn, isAggregateabs, 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, yearcheckParamNullprotected final DBSqlPhrase phrase
protected final Object[] params
protected String template
public DBFuncExpr(DBColumnExpr expr, DBSqlPhrase phrase, Object[] params, DataType dataType)
expr - the DBColumnExpr objectphrase - the SQL-phraseparams - an array of params which will be replaced in the templatedataType - indicates the data type of the function resultpublic DBFuncExpr(DBColumnExpr expr, String template, Object[] params, boolean isAggregate, DataType dataType)
expr - the DBColumnExpr objecttemplate - specifies a template for the expression. The template must contain a ? placeholder for the column expressionparams - an array of params which will be replaced in the templateisAggregate - indicates whether the function is an aggregate function (sum, min, max, avg, ...)dataType - indicates the data type of the function resultprotected String getFunctionName()
DBAbstractFuncExprgetFunctionName in class DBAbstractFuncExprpublic Class<Enum<?>> getEnumType()
DBAbstractFuncExprgetEnumType in interface ColumnExprgetEnumType in class DBAbstractFuncExprpublic void addReferencedColumns(Set<DBColumn> list)
DBExpraddReferencedColumns in class DBAbstractFuncExprlist - list to which all used column expressions must be addedDBExpr.addReferencedColumns(Set)public void addSQL(DBSQLBuilder sql, long context)
Copyright © 2008–2023 Apache Software Foundation. All rights reserved.