Class CaseExpression

java.lang.Object

org.datanucleus.store.rdbms.sql.expression.SQLExpression

org.datanucleus.store.rdbms.sql.expression.CaseExpression

public class CaseExpression
extends SQLExpression

Expression representing the SQL construct

CASE WHEN expr1 THEN val1 WHEN expr2 THEN val2 ELSE valN END

.

Nested Class Summary

Nested classes/interfaces inherited from class SQLExpression

SQLExpression.ColumnExpressionList

Field Summary

Fields

Modifier and Type	Field	Description
(package private) SQLExpression[]	actionExprs
(package private) SQLExpression	elseExpr
(package private) SQLExpression[]	whenExprs

Fields inherited from class SQLExpression

lowestOperator, mapping, parameterName, st, stmt, subExprs, table

Constructor Summary

Constructors

Constructor	Description
CaseExpression(SQLExpression[] whenExprs, SQLExpression[] actionExprs, SQLExpression elseExpr)

Method Summary

Modifier and Type	Method	Description
BooleanExpression	eq(SQLExpression expr)	Equality operator (equals to)
BooleanExpression	ge(SQLExpression expr)	Relational operator (greater than or equals)
BooleanExpression	gt(SQLExpression expr)	Relational operator (greater than)
BooleanExpression	le(SQLExpression expr)	Relational operator (lower than or equals)
BooleanExpression	lt(SQLExpression expr)	Relational operator (lower than)
BooleanExpression	ne(SQLExpression expr)	Not equality operator (not equals to)

Methods inherited from class SQLExpression

add, and, bitAnd, bitOr, cast, com, distinct, div, encloseInParentheses, eor, getJavaTypeMapping, getLowestOperator, getNumberOfSubExpressions, getParameterName, getSQLStatement, getSQLTable, getSubExpression, in, invoke, ior, is, isParameter, mod, mul, neg, not, setJavaTypeMapping, sub, toSQLText, unDistinct

Methods inherited from class Object

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

Field Details

whenExprs

SQLExpression[] whenExprs

actionExprs

SQLExpression[] actionExprs

elseExpr

SQLExpression elseExpr

Constructor Details

CaseExpression

public CaseExpression(SQLExpression[] whenExprs,
 SQLExpression[] actionExprs,
 SQLExpression elseExpr)

Method Details

eq

public BooleanExpression eq(SQLExpression expr)

Description copied from class: SQLExpression

Equality operator (equals to)

Overrides:

eq in class SQLExpression

Parameters:

expr - the right-hand operand

Returns:

The type of an equality expression is a boolean

ne

public BooleanExpression ne(SQLExpression expr)

Description copied from class: SQLExpression

Not equality operator (not equals to)

Overrides:

ne in class SQLExpression

Parameters:

expr - the right-hand operand

Returns:

The type of an equality expression is a boolean

ge

public BooleanExpression ge(SQLExpression expr)

Description copied from class: SQLExpression

Relational operator (greater than or equals)

Overrides:

ge in class SQLExpression

Parameters:

expr - the right-hand operand

Returns:

true if the value of the left-hand operand is greater than or equal the value of the right-hand operand, and otherwise is false.

gt

public BooleanExpression gt(SQLExpression expr)

Description copied from class: SQLExpression

Relational operator (greater than)

Overrides:

gt in class SQLExpression

Parameters:

expr - the right-hand operand

Returns:

true if the value of the left-hand operand is greater than the value of the right-hand operand, and otherwise is false.

le

public BooleanExpression le(SQLExpression expr)

Description copied from class: SQLExpression

Relational operator (lower than or equals)

Overrides:

le in class SQLExpression

Parameters:

expr - the right-hand operand

Returns:

true if the value of the left-hand operand is less than or equal to the value of the right-hand operand, and otherwise is false.

lt

public BooleanExpression lt(SQLExpression expr)

Description copied from class: SQLExpression

Relational operator (lower than)

Overrides:

lt in class SQLExpression

Parameters:

expr - the right-hand operand

Returns:

true if the value of the left-hand operand is less than the value of the right-hand operand, and otherwise is false.