org.apache.empire.db.expr.column

Class DBConvertExpr

java.lang.Object

org.apache.empire.db.DBObject

org.apache.empire.db.DBExpr

org.apache.empire.db.DBColumnExpr

org.apache.empire.db.expr.column.DBAbstractFuncExpr

org.apache.empire.db.expr.column.DBConvertExpr

All Implemented Interfaces:

Serializable, ColumnExpr

public class DBConvertExpr
extends DBAbstractFuncExpr

This class is used to convert a value to a different data type. This function uses the DBDatabaseDriver.getConvertPhrase function to obtain a conversion template.

There is no need to explicitly create instances of this class.
Instead use DBColumnExpr.convertTo(DataType)

Author:

doebele

See Also:

Serialized Form

Field Summary

Fields inherited from class org.apache.empire.db.expr.column.DBAbstractFuncExpr

dataType, expr, isAggregate, updateColumn

Fields inherited from class org.apache.empire.db.DBColumnExpr

attributes, beanPropertyName, DBCOLATTR_TITLE, DBCOLATTR_TYPE, options

Fields inherited from class org.apache.empire.db.DBExpr

CTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESES, CTX_VALUE

Constructor Summary

Constructors

Constructor and Description
DBConvertExpr(DBColumnExpr expr, DataType dataType, Object format) Constructs a DBDecodeExpr

Method Summary

Methods

Modifier and Type	Method and Description
void	addSQL(StringBuilder sql, long context) Used to build the SQL command.
protected String	getFunctionName() returns the name of the function

Methods inherited from class org.apache.empire.db.expr.column.DBAbstractFuncExpr

addReferencedColumns, addSQL, addXml, getDatabase, getDatabaseDriver, getDataType, getName, getUpdateColumn, isAggregate

Methods inherited from class org.apache.empire.db.DBColumnExpr

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, year

Methods inherited from class org.apache.empire.db.DBExpr

getObjectValue, getValueClass

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DBConvertExpr

public DBConvertExpr(DBColumnExpr expr,
             DataType dataType,
             Object format)

Constructs a DBDecodeExpr

Parameters:

expr - the expression to be converted

dataType - the target data type

format - optional formatting information

Method Detail

getFunctionName

protected String getFunctionName()

Description copied from class: DBAbstractFuncExpr

returns the name of the function

Specified by:

getFunctionName in class DBAbstractFuncExpr

Returns:

the function name

addSQL

public void addSQL(StringBuilder sql,
          long context)

Description copied from class: DBExpr

Used to build the SQL command. SQL for this expression must be appended to StringBuilder.

Specified by:

addSQL in class DBExpr

Parameters:

sql - the string buffer used to build the sql command

context - context flag for this SQL-Command (see CTX_??? constants).