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, log
attributes, beanPropertyName, DBCOLATTR_TITLE, DBCOLATTR_TYPE, options
CTX_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, isAggregate
abs, 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, 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, year
checkParamNull
protected 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()
DBAbstractFuncExpr
getFunctionName
in class DBAbstractFuncExpr
public Class<Enum<?>> getEnumType()
DBAbstractFuncExpr
getEnumType
in interface ColumnExpr
getEnumType
in class DBAbstractFuncExpr
public void addReferencedColumns(Set<DBColumn> list)
DBExpr
addReferencedColumns
in class DBAbstractFuncExpr
list
- 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.