Uses of Interface
org.apache.empire.data.ColumnExpr

Packages that use ColumnExpr

Package	Description
org.apache.empire.commons	This package contains various common classes for error handling, specific data types and data type conversion.
org.apache.empire.data	This package contains interfaces for data and metadata handling.
org.apache.empire.data.bean	This package contains implmentations of Empire's data and metadata interfaces for JavaBeans of Data Tranfer Objects (DTO's).
org.apache.empire.data.list
org.apache.empire.db	This package contains the core Empire-DB implementation classes.
org.apache.empire.db.expr.column	This package contains SQL-generator classes for column expressions.
org.apache.empire.dbms.oracle	This package contains classes necessary to support the Oracle database system.
org.apache.empire.dbms.postgresql	This package contains classes necessary to support the PostgreSQL database system.

Uses of ColumnExpr in org.apache.empire.commons

Methods in org.apache.empire.commons with type parameters of type ColumnExpr

Modifier and Type	Method	Description
static <T extends ColumnExpr> T	ColumnUtils.setMinMaxValue(T columnExpr, Number minValue, Number maxValue)	Set the minimum and maximum values of a columnExpr
static <T extends ColumnExpr> T	ColumnUtils.setNumberFormat(T columnExpr, String numberType, boolean groupSeparator)	Sets the number format options for a columnExpr

Methods in org.apache.empire.commons with parameters of type ColumnExpr

Modifier and Type	Method	Description
static boolean	ObjectUtils.compareEqual(ColumnExpr expr, ColumnExpr other)	Compares two ColumnExpr for equality
static <T> T	ObjectUtils.convertColumnValue(ColumnExpr column, Object value, Class<T> valueType)	Converts a column value to a Java type
<T> T	ValueUtils.convertColumnValue(ColumnExpr column, Object value, Class<T> vt)	Converts a column value to a Java type Allows custom conversions and handling of special cases.
static String	ObjectUtils.formatColumnValue(ColumnExpr column, Object value, Locale locale)	Returns a formatted column value
String	ValueUtils.formatColumnValue(ColumnExpr column, Object value, Locale locale)	formats a column value into a string
Object	ColumnUtils.getColumnAttribute(ColumnExpr columnExpr, String name)	Returns the column attribute
int	ColumnUtils.getColumnMaxLength(ColumnExpr columnExpr)
NumberFormat	ColumnUtils.getColumnNumberFormat(ColumnExpr columnExpr, Locale locale)
double	ColumnUtils.getColumnSize(ColumnExpr columnExpr)	Return the size of the column of 0.0d if unknown
static int	ColumnUtils.getMaxLength(ColumnExpr columnExpr)	Return the maximum character length of a columnExpr
static Number	ColumnUtils.getMaxValue(ColumnExpr columnExpr)	Returns the maximum allowed value
static int	ColumnUtils.getMinLength(ColumnExpr columnExpr)	Returns the minimum length, usually 0
static Number	ColumnUtils.getMinValue(ColumnExpr columnExpr)	Returns the maximum allowed value or 0 if not set
static NumberFormat	ColumnUtils.getNumberFormat(ColumnExpr columnExpr, Locale locale)	Returns the number format for a particular columnExpr
void	ColumnUtils.setColumnNumberFormat(ColumnExpr columnExpr, String numberType, boolean groupSeparator)

Uses of ColumnExpr in org.apache.empire.data

Subinterfaces of ColumnExpr in org.apache.empire.data

Modifier and Type	Interface	Description
interface	Column	The column interface provides methods for accessing metadata that is only relevant for updating records.

Methods in org.apache.empire.data with type parameters of type ColumnExpr

Modifier and Type	Method	Description
<T extends ColumnExpr> T	ColumnExpr.setAttribute(String name, Object value)	Sets the value of a column attribute.

Methods in org.apache.empire.data that return ColumnExpr

Modifier and Type	Method	Description
ColumnExpr	RecordData.getColumn(int i)	returns the column expression for a given column This is the reverse operation of getFieldIndex()

Methods in org.apache.empire.data with parameters of type ColumnExpr

Modifier and Type	Method	Description
Object	RecordData.get(ColumnExpr column)	returns the record value for a particular column
<V> V	RecordData.get(ColumnExpr column, Class<V> valueType)	returns the record value for a particular column
int	RecordData.getFieldIndex(ColumnExpr column)	returns the index of the given column expression Indexed operations provide better performance for bulk processing
boolean	RecordData.isNull(ColumnExpr column)	checks if the record contains no value (null) for the given column

Method parameters in org.apache.empire.data with type arguments of type ColumnExpr

Modifier and Type	Method	Description
int	RecordData.setBeanProperties(Object bean, Collection<? extends ColumnExpr> ignoreList)	copies all field values into a static Java Bean.

Uses of ColumnExpr in org.apache.empire.data.bean

Classes in org.apache.empire.data.bean that implement ColumnExpr

Modifier and Type	Class	Description
class	BeanProperty	BeanObject This class defines Metadata for a single property.

Methods in org.apache.empire.data.bean with type parameters of type ColumnExpr

Modifier and Type	Method	Description
<T extends ColumnExpr> T	BeanProperty.setAttribute(String name, Object value)	Sets an attribute for this column

Methods in org.apache.empire.data.bean with parameters of type ColumnExpr

Modifier and Type	Method	Description
protected String	BeanRecordProxy.formatValue(ColumnExpr column, Object value)	Convert a non-string value to a string
final Object	BeanRecordProxy.get(ColumnExpr column)
<V> V	BeanRecordProxy.get(ColumnExpr column, Class<V> valueType)
protected final Object	BeanRecordProxy.getBeanProperty(Object bean, ColumnExpr column)
int	BeanRecordProxy.getFieldIndex(ColumnExpr column)
final String	BeanRecordProxy.getText(ColumnExpr column)	Returns the value of a column as a formatted text This converts the value to a string if necessary and performs an options lookup To customize conversion please override convertToString()
boolean	BeanRecordProxy.isNull(ColumnExpr column)

Method parameters in org.apache.empire.data.bean with type arguments of type ColumnExpr

Modifier and Type	Method	Description
int	BeanRecordProxy.setBeanProperties(Object bean, Collection<? extends ColumnExpr> ignoreList)

Uses of ColumnExpr in org.apache.empire.data.list

Fields in org.apache.empire.data.list declared as ColumnExpr

Modifier and Type	Field	Description
protected final ColumnExpr[]	DataListHead.columns

Methods in org.apache.empire.data.list that return ColumnExpr

Modifier and Type	Method	Description
ColumnExpr	DataListEntry.getColumn(int index)
ColumnExpr[]	DataListHead.getColumns()

Methods in org.apache.empire.data.list with parameters of type ColumnExpr

Modifier and Type	Method	Description
protected String	DataListHead.formatValue(ColumnExpr column, Object value)	Convert a non-string value to a string Overwrite this function in order to provide a locale
Object	DataListEntry.get(ColumnExpr column)	Returns a data value for the desired column .
final <V> V	DataListEntry.get(ColumnExpr column, Class<V> valueType)	returns the record value for a particular column
final Object[]	DataListEntry.getArray(ColumnExpr... columns)	Returns an array of values for the given column expressions
final boolean	DataListEntry.getBoolean(ColumnExpr column)	Returns a data value for the desired column.
int	DataListHead.getColumnIndex(ColumnExpr column)
final Date	DataListEntry.getDate(ColumnExpr column)	Returns the value as as a java.util.Date object The data value is converted to a Date if necessary.
final BigDecimal	DataListEntry.getDecimal(ColumnExpr column)	Returns a data value for the desired column.
final double	DataListEntry.getDouble(ColumnExpr column)	Returns a data value for the desired column.
final <T extends Enum<?>> T	DataListEntry.getEnum(ColumnExpr column, Class<T> enumType)	Returns the value of a field as an enum For numeric columns the value is assumed to be an ordinal of the enumeration item For non numeric columns the value is assumed to be the name of the enumeration item
int	DataListEntry.getFieldIndex(ColumnExpr column)
final int	DataListEntry.getInt(ColumnExpr column)	Returns a data value for the desired column.
final LocalDate	DataListEntry.getLocalDate(ColumnExpr column)	Returns a data value for the desired column.
final LocalDateTime	DataListEntry.getLocalDateTime(ColumnExpr column)	Returns a data value for the desired column.
final long	DataListEntry.getLong(ColumnExpr column)	Returns a data value for the desired column.
final String	DataListEntry.getString(ColumnExpr column)	Returns a data value for the desired column.
String	DataListEntry.getText(ColumnExpr column)	Returns the value of a column as a formatted text This converts the value to a string if necessary and performs an options lookup To customize conversion please override convertToString()
final Timestamp	DataListEntry.getTimestamp(ColumnExpr column)	Returns the value as as a java.sql.Timestamp object
boolean	DataListEntry.hasField(ColumnExpr column)
final boolean	DataListEntry.isNull(ColumnExpr column)	Checks whether or not the value for the given column is null.
boolean	DataListEntry.isZero(ColumnExpr column)	Returns true if a numeric value is Zero For numeric columns only!
void	DataListEntry.modifyValue(ColumnExpr col, Object value)	Modifies a particular value
protected void	DataListEntry.setBeanProperty(ColumnExpr column, Object bean, Object value)	Set a single property value on a java bean object

Method parameters in org.apache.empire.data.list with type arguments of type ColumnExpr

Modifier and Type	Method	Description
int	DataListEntry.setBeanProperties(Object bean, Collection<? extends ColumnExpr> ignoreList)	Injects the current field values into a java bean.

Constructors in org.apache.empire.data.list with parameters of type ColumnExpr

Modifier	Constructor	Description
	DataListHead(ColumnExpr[] columns)	Constructs a DataListHead based on an DataListEntry constructor

Uses of ColumnExpr in org.apache.empire.db

Classes in org.apache.empire.db that implement ColumnExpr

Modifier and Type	Class	Description
class	DBColumn	This is the base class for all database columns that have a physical representation.
class	DBColumnExpr	This class is the base class for all expressions that represent a single value.
protected static class	DBCommandExpr.DBCmdColumn	This class wraps a column of sql command in a special command column object.
class	DBQueryColumn
class	DBTableColumn	This class represent one column of a table.
static class	DBView.DBViewColumn	DBViewColumn

Methods in org.apache.empire.db with type parameters of type ColumnExpr

Modifier and Type	Method	Description
<T extends ColumnExpr> T	DBColumnExpr.setAttribute(String name, Object value)	Sets the value of a column attribute.

Methods in org.apache.empire.db with parameters of type ColumnExpr

Modifier and Type	Method	Description
protected int	DBReader.findFieldIndex(ColumnExpr column)	finds the field Index of a given column expression Internally used as helper for getFieldIndex()
protected String	DBRecordData.formatValue(ColumnExpr column, Object value)	Convert a non-string value to a string
Object	DBRecordData.get(ColumnExpr column)	Returns a data value for the desired column .
final <V> V	DBRecordData.get(ColumnExpr column, Class<V> valueType)	returns the record value for a particular column
final Object[]	DBRecordData.getArray(ColumnExpr... columns)	Returns an array of values for the given column expressions
final boolean	DBRecordData.getBoolean(ColumnExpr column)	Returns a data value for the desired column.
int	DBQuery.getColumnIndex(ColumnExpr columnExpr)	Gets the index of a particular column expression.
int	DBRowSet.getColumnIndex(ColumnExpr columnExpr)	Gets the index of a particular column expression.
final Date	DBRecordData.getDate(ColumnExpr column)	Returns the value as as a java.util.Date object The data value is converted to a Date if necessary.
final Date	DBRecordData.getDateTime(ColumnExpr column)	Deprecated.
final BigDecimal	DBRecordData.getDecimal(ColumnExpr column)	Returns a data value for the desired column.
final double	DBRecordData.getDouble(ColumnExpr column)	Returns a data value for the desired column.
final <T extends Enum<?>> T	DBRecordData.getEnum(ColumnExpr column, Class<T> enumType)	Returns the value of a field as an enum For numeric columns the value is assumed to be an ordinal of the enumeration item For non numeric columns the value is assumed to be the name of the enumeration item
int	DBReader.getFieldIndex(ColumnExpr column)	Returns the index value by a specified DBColumnExpr object.
int	DBRecordBase.getFieldIndex(ColumnExpr column)	Returns the index value by a specified DBColumnExpr object.
abstract int	DBRecordData.getFieldIndex(ColumnExpr column)
final int	DBRecordData.getInt(ColumnExpr column)	Returns a data value for the desired column.
final LocalDate	DBRecordData.getLocalDate(ColumnExpr column)	Returns a data value for the desired column.
final LocalDateTime	DBRecordData.getLocalDateTime(ColumnExpr column)	Returns a data value for the desired column.
final long	DBRecordData.getLong(ColumnExpr column)	Returns a data value for the desired column.
String	DBColumnExpr.getNumberType(ColumnExpr columnExpr)	Returns the number type assigned to this column expression
int	DBQuery.getQueryColumnIndex(ColumnExpr columnExpr)	Returns the index of a column in the underlying query
final String	DBRecordData.getString(ColumnExpr column)	Returns a data value for the desired column.
String	DBRecordData.getText(ColumnExpr column)	Returns the value of a column as a formatted text This converts the value to a string if necessary and performs an options lookup To customize conversion please override convertToString()
final Timestamp	DBRecordData.getTimestamp(ColumnExpr column)	Returns the value as as a java.sql.Timestamp object
final boolean	DBRecordData.isNull(ColumnExpr column)	Checks whether or not the value for the given column is null.
boolean	DBRecordData.isZero(ColumnExpr column)	Returns true if a numeric value is Zero For numeric columns only!
protected void	DBRecordData.setBeanProperty(ColumnExpr column, Object bean, Object value)	Set a single property value on a java bean object

Method parameters in org.apache.empire.db with type arguments of type ColumnExpr

Modifier and Type	Method	Description
int	DBRecordData.setBeanProperties(Object bean, Collection<? extends ColumnExpr> ignoreList)	Injects the current field values into a java bean.

Uses of ColumnExpr in org.apache.empire.db.expr.column

Classes in org.apache.empire.db.expr.column that implement ColumnExpr

Modifier and Type	Class	Description
class	DBAbstractFuncExpr	This implements some basic functionality for SQL functions based on a column expression
class	DBAliasExpr	This class allows column renaming in SQL.
class	DBCalcExpr	This class is used for performing calculations in SQL It handles the mathematical operations ("+", "-", "*", "/") for the current column.
class	DBCaseExpr	This class represents a SQL case expression like "case when ?
class	DBCaseMapExpr	This class is used to create a SQL CASE constraint in the form of case {expr} when {value1} then {result1} when {value2} then {result2} ...
class	DBCaseWhenExpr	This class is used to create a SQL CASE constraint in the form of case when {cond1} then {result1} when {cond2} then {result2} ...
class	DBCmdResultExpr
class	DBCoalesceExpr
class	DBConcatExpr	This class is used for performing string concatenation in SQL
class	DBConcatFuncExpr	DBConcatExpression
class	DBConvertExpr	This class is used to convert a value to a different data type.
class	DBCountExpr	This class is used to add the "count" statement to the SQL-Command.
class	DBDecodeExpr	This class is used to decode a set of keys to the corresponding target values.
class	DBFuncExpr	This class is used for performing various SQL functions on a column or column expression.
class	DBParenthesisExpr	This class allows column renaming in SQL.
class	DBScalarExpr	This class is used for declaring scalar functions in SQL (like e.g. random).
class	DBValueExpr	This class is used for declaring constant values in SQL.
class	DBVarArgsFuncExpr

Uses of ColumnExpr in org.apache.empire.dbms.oracle

Classes in org.apache.empire.dbms.oracle that implement ColumnExpr

Modifier and Type	Class	Description
class	OracleRowNumExpr	implements a column expression for the Oracle rownum function

Uses of ColumnExpr in org.apache.empire.dbms.postgresql

Classes in org.apache.empire.dbms.postgresql that implement ColumnExpr

Modifier and Type	Class	Description
class	PostgresBoolAndOrExpr
class	PostgresFuncExpr
class	PostgresIntervalExpr