Expression (XDEV Application Framework 6.0.1 API)

java.lang.Object
- xdev.db.sql.SqlObject
- - xdev.db.sql.Expression

All Implemented Interfaces:

Serializable

Direct Known Subclasses:

Column
```
public class Expression
extends SqlObject
```
This class represents a expression in the SQL API.
Expressions can be plain Strings or SQL objects like a Column.
To connect expression objects use the operator methods:
- eq(Object)
- ne(Object)
- gt(Object)
- gte(Object)
- lt(Object)
- lte(Object)
- ...
Author:

XDEV Software

See Also:

Serialized Form

Field Summary

Fields
Modifier and Type Field and Description

protected SqlExpression delegate

Fields
Modifier and Type	Field and Description
`protected SqlExpression`	`delegate`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`Expression`	`as(String alias)` Deprecated. replaced by `AS(String)`
`Expression`	`AS(String alias)` Creates an aliased version of this expression object.
`Condition`	`BETWEEN(Object lower, Object upper)`
`Condition`	`eq(Object value)` The equals operator (=) for expressions.
`Condition`	`gt(Object value)` The greater than operator (>) for expressions.
`Condition`	`gte(Object value)` The greater than equals operator (>=) for expressions.
`Condition`	`IN(Object... values)`
`Condition`	`IS_NOT_NULL()`
`Condition`	`IS_NULL()`
`Condition`	`LIKE(Object value)`
`Condition`	`lt(Object value)` The lower than operator (<) for expressions.
`Condition`	`lte(Object value)` The lower than equals operator (<=) for expressions.
`Condition`	`ne(Object value)` The not equals operator (!= \| <>) for expressions.
`Condition`	`NOT_BETWEEN(Object lower, Object upper)`
`Condition`	`NOT_IN(Object... values)`
`Condition`	`NOT_LIKE(Object value)`
`static Expression`	`valueOf(Object expression)` Wraps a plain object into a expression to be used in the SQL API.

Methods inherited from class xdev.db.sql.SqlObject
toString

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Field Detail
  - delegate
```
protected SqlExpression delegate
```
- Method Detail
  - valueOf
```
public static Expression valueOf(Object expression)
```
    Wraps a plain object into a expression to be used in the SQL API.
    
    Parameters:
    
    expression - the expression to wrap.
    
    Returns:
    
    a expression object
  - as
```
@Deprecated
public Expression as(String alias)
```
    Deprecated. replaced by AS(String)
  - AS
```
public Expression AS(String alias)
```
    Creates an aliased version of this expression object.
    
    Parameters:
    
    alias - the new alias
    
    Returns:
    
    a new expression object with an alias
  - eq
```
public Condition eq(Object value)
```
    The equals operator (=) for expressions.
    Connects this expression object and the expression parameter via the '=' operator and returns the connection as a new condition object.
    
    Parameters:
    
    value - the right side of the connection
    
    Returns:
    
    a new condition object
  - ne
```
public Condition ne(Object value)
```
    The not equals operator (!= | <>) for expressions.
    Connects this expression object and the expression parameter via the '!=' operator and returns the connection as a new condition object.
    
    Parameters:
    
    value - the right side of the connection
    
    Returns:
    
    a new condition object
  - gt
```
public Condition gt(Object value)
```
    The greater than operator (>) for expressions.
    Connects this expression object and the expression parameter via the '>' operator and returns the connection as a new condition object.
    
    Parameters:
    
    value - the right side of the connection
    
    Returns:
    
    a new condition object
  - lt
```
public Condition lt(Object value)
```
    The lower than operator (<) for expressions.
    Connects this expression object and the expression parameter via the '<' operator and returns the connection as a new condition object.
    
    Parameters:
    
    value - the right side of the connection
    
    Returns:
    
    a new condition object
  - gte
```
public Condition gte(Object value)
```
    The greater than equals operator (>=) for expressions.
    Connects this expression object and the expression parameter via the '>=' operator and returns the connection as a new condition object.
    
    Parameters:
    
    value - the right side of the connection
    
    Returns:
    
    a new condition object
  - lte
```
public Condition lte(Object value)
```
    The lower than equals operator (<=) for expressions.
    Connects this expression object and the expression parameter via the '<=' operator and returns the connection as a new condition object.
    
    Parameters:
    
    value - the right side of the connection
    
    Returns:
    
    a new condition object
  - IS_NULL
```
public Condition IS_NULL()
```
  - IS_NOT_NULL
```
public Condition IS_NOT_NULL()
```
  - IN
```
public Condition IN(Object... values)
```
  - NOT_IN
```
public Condition NOT_IN(Object... values)
```
  - LIKE
```
public Condition LIKE(Object value)
```
  - NOT_LIKE
```
public Condition NOT_LIKE(Object value)
```
  - BETWEEN
```
public Condition BETWEEN(Object lower,
                         Object upper)
```
  - NOT_BETWEEN
```
public Condition NOT_BETWEEN(Object lower,
                             Object upper)
```

Class Expression

Field Summary

Method Summary

Methods inherited from class xdev.db.sql.SqlObject

Methods inherited from class java.lang.Object

Field Detail

delegate

Method Detail

valueOf

as

AS

eq

ne

gt

lt

gte

lte

IS_NULL

IS_NOT_NULL

IN

NOT_IN

LIKE

NOT_LIKE

BETWEEN

NOT_BETWEEN