public interface Expression extends SelectItem, PredicateOperand
Modifier and Type | Method and Description |
---|---|
Expression |
abs()
Absolute value.
|
Expression |
concat(Expression... str)
Concatenate a string with other string(s).
|
Expression |
concat(String... str)
Concatenate a string with other string(s).
|
Expression |
dividedBy(Expression expr)
Division.
|
Expression |
dividedBy(Number num)
Division.
|
Predicate |
in(Class... classes)
Create a predicate for testing whether the expression value is a member
of the argument list.
|
Predicate |
in(Enum<?>... enums)
Create a predicate for testing whether the expression value is a member
of the argument list.
|
Predicate |
in(Expression... params)
Create a predicate for testing whether the expression value is a member
of the argument list.
|
Predicate |
in(Number... nums)
Create a predicate for testing whether the expression value is a member
of the argument list.
|
Predicate |
in(String... strings)
Create a predicate for testing whether the expression value is a member
of the argument list.
|
Predicate |
in(Subquery subquery)
Create a predicate for testing whether the expression value is a member
of a subquery result.
|
Predicate |
isNull()
Create a predicate for testing whether the value of the expression is
null.
|
Expression |
length()
String length This method must be invoked on an expression corresponding
to a string.
|
Expression |
locate(Expression str)
Locate a string contained within the string corresponding to the
expression on which the method was invoked.
|
Expression |
locate(Expression str,
Expression position)
Locate a string contained within the string corresponding to the
expression on which the method was invoked, starting at a specified
search position.
|
Expression |
locate(Expression str,
int position)
Locate a string contained within the string corresponding to the
expression on which the method was invoked, starting at a specified
search position.
|
Expression |
locate(String str)
Locate a string contained within the string corresponding to the
expression on which the method was invoked.
|
Expression |
locate(String str,
Expression position)
Locate a string contained within the string corresponding to the
expression on which the method was invoked, starting at a specified
search position.
|
Expression |
locate(String str,
int position)
Locate a string contained within the string corresponding to the
expression on which the method was invoked, starting at a specified
search position.
|
Expression |
lower()
Convert string to lowercase.
|
Predicate |
member(PathExpression arg)
Create a predicate for testing whether the expression is a member of the
association or element collection denoted by the path expression.
|
Expression |
minus()
Unary minus.
|
Expression |
minus(Expression expr)
Subtraction.
|
Expression |
minus(Number num)
Subtraction.
|
Expression |
mod(Expression expr)
Modulo operation.
|
Expression |
mod(int num)
Modulo operation.
|
Expression |
plus(Expression expr)
Addition.
|
Expression |
plus(Number num)
Addition.
|
Expression |
sqrt()
Square root.
|
Expression |
substring(Expression start)
Extract a substring starting at specified position through to the end of
the string.
|
Expression |
substring(Expression start,
Expression len)
Extract a substring.
|
Expression |
substring(Expression start,
int len)
Extract a substring.
|
Expression |
substring(int start)
Extract a substring starting at specified position through to the end of
the string.
|
Expression |
substring(int start,
Expression len)
Extract a substring.
|
Expression |
substring(int start,
int len)
Extract a substring.
|
Expression |
times(Expression expr)
Multiplication.
|
Expression |
times(Number num)
Multiplication.
|
Expression |
trim()
Trim leading and trailing blanks.
|
Expression |
trim(char c)
Trim leading and trailing occurrences of character from the string.
|
Expression |
trim(char c,
TrimSpec spec)
Trim occurrences of the character from leading or trailing (or both)
positions of the string, as specified by trim spec.
|
Expression |
trim(Expression expr)
Trim leading and trailing occurrences of character specified by the
expression argument from the string.
|
Expression |
trim(Expression expr,
TrimSpec spec)
Trim occurrences of the character specified by the expression argument
from leading or trailing (or both) positions of the string, as specified
by trim spec.
|
Expression |
trim(TrimSpec spec)
Trim leading, trailing blanks (or both) as specified by trim spec.
|
Expression |
upper()
Convert string to uppercase.
|
asc, desc
between, between, between, between, between, between, between, between, between, between, between, between, between, equal, equal, equal, equal, equal, equal, equal, equal, greaterEqual, greaterEqual, greaterEqual, greaterEqual, greaterEqual, greaterThan, greaterThan, greaterThan, greaterThan, greaterThan, lessEqual, lessEqual, lessEqual, lessEqual, lessEqual, lessThan, lessThan, lessThan, lessThan, lessThan, like, like, like, like, like, like, notEqual, notEqual, notEqual, notEqual, notEqual, notEqual, notEqual, notEqual
Predicate member(PathExpression arg)
arg
- -
a path expression that specifies a collection-valued
association or an element collectionPredicate isNull()
Predicate in(String... strings)
strings
- Predicate in(Number... nums)
nums
- Predicate in(Enum<?>... enums)
enums
- Predicate in(Class... classes)
classes
- Predicate in(Expression... params)
params
- Predicate in(Subquery subquery)
subquery
- Expression length()
Expression concat(String... str)
str
- -
string(s)Expression concat(Expression... str)
str
- -
expression(s) corresponding to string(s)Expression substring(int start)
start
- -
start position (1 indicates first position)Expression substring(Expression start)
start
- -
expression denoting start position (1 indicates first
position)Expression substring(int start, int len)
start
- -
start position (1 indicates first position)len
- -
length of the substring to be returnedExpression substring(int start, Expression len)
start
- -
start position (1 indicates first position)len
- -
expression denoting length of the substring to returnExpression substring(Expression start, int len)
start
- -
expression denoting start position (1 indicates first
position)len
- -
length of the substring to returnExpression substring(Expression start, Expression len)
start
- -
expression denoting start position (1 indicates first
position)len
- -
expression denoting length of the substring to returnExpression lower()
Expression upper()
Expression trim()
Expression trim(TrimSpec spec)
spec
- -
trim specificationExpression trim(char c)
c
- -
character to be trimmedExpression trim(char c, TrimSpec spec)
c
- -
character to be trimmedspec
- -
trim specificationExpression trim(Expression expr)
expr
- -
expression corresponding to the character to be trimmedExpression trim(Expression expr, TrimSpec spec)
expr
- -
expression corresponding to the character to be trimmedspec
- -
trim specificationExpression locate(String str)
str
- -
string to be locatedExpression locate(Expression str)
str
- -
expression corresponding to the string to be locatedExpression locate(String str, int position)
str
- -
string to be locatedposition
- -
position at which to start the searchExpression locate(String str, Expression position)
str
- -
string to be locatedposition
- -
expression corresponding to position at which to start
the searchExpression locate(Expression str, int position)
str
- -
expression corresponding to the string to be locatedposition
- -
position at which to start the searchExpression locate(Expression str, Expression position)
str
- -
expression corresponding to the string to be locatedposition
- -
expression corresponding to position at which to start
the searchExpression plus(Number num)
num
- -
number to be addedExpression plus(Expression expr)
expr
- -
expression corresponding to number to be addedExpression minus()
Expression minus(Number num)
num
- -
subtrahendExpression minus(Expression expr)
expr
- -
expression corresponding to subtrahendExpression dividedBy(Number num)
num
- -
divisorExpression dividedBy(Expression expr)
expr
- -
expression corresponding to the divisorExpression times(Number num)
num
- -
multiplierExpression times(Expression expr)
expr
- -
expression corresponding to the multiplierExpression abs()
Expression sqrt()
Expression mod(int num)
num
- -
integer divisorExpression mod(Expression expr)
expr
- -
expression corresponding to integer divisorCopyright © 2006–2022 Apache Software Foundation. All rights reserved.