|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface CriteriaBuilder
Used to construct criteria queries, compound selections, expressions, predicates, orderings.
Note that Predicate
is used instead of Expression<Boolean>
in this API in order to work around the fact that Java
generics are not compatible with varags.
Nested Class Summary | |
---|---|
static interface |
CriteriaBuilder.Case<R>
Interface used to build general case expressions. |
static interface |
CriteriaBuilder.Coalesce<T>
Interface used to build coalesce expressions. |
static interface |
CriteriaBuilder.In<T>
Interface used to build in predicates. |
static interface |
CriteriaBuilder.SimpleCase<C,R>
Interface used to build simple case expressions. |
static class |
CriteriaBuilder.Trimspec
Used to specify how strings are trimmed. |
Method Summary | ||
---|---|---|
|
abs(Expression<N> x)
Create an expression that returns the absolute value of its argument. |
|
|
all(Subquery<Y> subquery)
Create an all expression over the subquery results. |
|
Predicate |
and(Expression<java.lang.Boolean> x,
Expression<java.lang.Boolean> y)
Create a conjunction of the given boolean expressions. |
|
Predicate |
and(Predicate... restrictions)
Create a conjunction of the given restriction predicates. |
|
|
any(Subquery<Y> subquery)
Create an any expression over the subquery results. |
|
CompoundSelection<java.lang.Object[]> |
array(Selection<?>... selections)
Create an array-valued selection item. |
|
Order |
asc(Expression<?> x)
Create an ordering by the ascending value of the expression. |
|
|
avg(Expression<N> x)
Create an aggregate expression applying the avg operation. |
|
|
between(Expression<? extends Y> v,
Expression<? extends Y> x,
Expression<? extends Y> y)
Create a predicate for testing whether the first argument is between the second and third arguments in value. |
|
|
between(Expression<? extends Y> v,
Y x,
Y y)
Create a predicate for testing whether the first argument is between the second and third arguments in value. |
|
|
coalesce()
Create a coalesce expression. |
|
|
coalesce(Expression<? extends Y> x,
Expression<? extends Y> y)
Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise. |
|
|
coalesce(Expression<? extends Y> x,
Y y)
Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise. |
|
Expression<java.lang.String> |
concat(Expression<java.lang.String> x,
Expression<java.lang.String> y)
Create an expression for string concatenation. |
|
Expression<java.lang.String> |
concat(Expression<java.lang.String> x,
java.lang.String y)
Create an expression for string concatenation. |
|
Expression<java.lang.String> |
concat(java.lang.String x,
Expression<java.lang.String> y)
Create an expression for string concatenation. |
|
Predicate |
conjunction()
Create a conjunction (with zero conjuncts). |
|
|
construct(java.lang.Class<Y> resultClass,
Selection<?>... selections)
Create a selection item corresponding to a constructor. |
|
Expression<java.lang.Long> |
count(Expression<?> x)
Create an aggregate expression applying the count operation. |
|
Expression<java.lang.Long> |
countDistinct(Expression<?> x)
Create an aggregate expression applying the count distinct operation. |
|
CriteriaQuery<java.lang.Object> |
createQuery()
Create a CriteriaQuery object. |
|
|
createQuery(java.lang.Class<T> resultClass)
Create a CriteriaQuery object with the specified result
type. |
|
CriteriaQuery<Tuple> |
createTupleQuery()
Create a CriteriaQuery object that returns a tuple of
objects as its result. |
|
Expression<java.sql.Date> |
currentDate()
Create expression to return current date. |
|
Expression<java.sql.Time> |
currentTime()
Create expression to return current time. |
|
Expression<java.sql.Timestamp> |
currentTimestamp()
Create expression to return current timestamp. |
|
Order |
desc(Expression<?> x)
Create an ordering by the descending value of the expression. |
|
|
diff(Expression<? extends N> x,
Expression<? extends N> y)
Create an expression that returns the difference between its arguments. |
|
|
diff(Expression<? extends N> x,
N y)
Create an expression that returns the difference between its arguments. |
|
|
diff(N x,
Expression<? extends N> y)
Create an expression that returns the difference between its arguments. |
|
Predicate |
disjunction()
Create a disjunction (with zero disjuncts). |
|
Predicate |
equal(Expression<?> x,
Expression<?> y)
Create a predicate for testing the arguments for equality. |
|
Predicate |
equal(Expression<?> x,
java.lang.Object y)
Create a predicate for testing the arguments for equality. |
|
Predicate |
exists(Subquery<?> subquery)
Create a predicate testing the existence of a subquery result. |
|
|
function(java.lang.String name,
java.lang.Class<T> type,
Expression<?>... args)
Create an expression for the execution of a database function. |
|
Predicate |
ge(Expression<? extends java.lang.Number> x,
Expression<? extends java.lang.Number> y)
Create a predicate for testing whether the first argument is greater than or equal to the second. |
|
Predicate |
ge(Expression<? extends java.lang.Number> x,
java.lang.Number y)
Create a predicate for testing whether the first argument is greater than or equal to the second. |
|
|
greaterThan(Expression<? extends Y> x,
Expression<? extends Y> y)
Create a predicate for testing whether the first argument is greater than the second. |
|
|
greaterThan(Expression<? extends Y> x,
Y y)
Create a predicate for testing whether the first argument is greater than the second. |
|
|
greaterThanOrEqualTo(Expression<? extends Y> x,
Expression<? extends Y> y)
Create a predicate for testing whether the first argument is greater than or equal to the second. |
|
|
greaterThanOrEqualTo(Expression<? extends Y> x,
Y y)
Create a predicate for testing whether the first argument is greater than or equal to the second. |
|
|
greatest(Expression<X> x)
Create an aggregate expression for finding the greatest of the values (strings, dates, etc). |
|
Predicate |
gt(Expression<? extends java.lang.Number> x,
Expression<? extends java.lang.Number> y)
Create a predicate for testing whether the first argument is greater than the second. |
|
Predicate |
gt(Expression<? extends java.lang.Number> x,
java.lang.Number y)
Create a predicate for testing whether the first argument is greater than the second. |
|
|
in(Expression<? extends T> expression)
Create predicate to test whether given expression is contained in a list of values. |
|
|
isEmpty(Expression<C> collection)
Create a predicate that tests whether a collection is empty. |
|
Predicate |
isFalse(Expression<java.lang.Boolean> x)
Create a predicate testing for a false value. |
|
|
isMember(E elem,
Expression<C> collection)
Create a predicate that tests whether an element is a member of a collection. |
|
|
isMember(Expression<E> elem,
Expression<C> collection)
Create a predicate that tests whether an element is a member of a collection. |
|
|
isNotEmpty(Expression<C> collection)
Create a predicate that tests whether a collection is not empty. |
|
|
isNotMember(E elem,
Expression<C> collection)
Create a predicate that tests whether an element is not a member of a collection. |
|
|
isNotMember(Expression<E> elem,
Expression<C> collection)
Create a predicate that tests whether an element is not a member of a collection. |
|
Predicate |
isNotNull(Expression<?> x)
Create a predicate to test whether the expression is not null. |
|
Predicate |
isNull(Expression<?> x)
Create a predicate to test whether the expression is null. |
|
Predicate |
isTrue(Expression<java.lang.Boolean> x)
Create a predicate testing for a true value. |
|
|
keys(M map)
Create an expression that returns the keys of a map. |
|
Predicate |
le(Expression<? extends java.lang.Number> x,
Expression<? extends java.lang.Number> y)
Create a predicate for testing whether the first argument is less than or equal to the second. |
|
Predicate |
le(Expression<? extends java.lang.Number> x,
java.lang.Number y)
Create a predicate for testing whether the first argument is less than or equal to the second. |
|
|
least(Expression<X> x)
Create an aggregate expression for finding the least of the values (strings, dates, etc). |
|
Expression<java.lang.Integer> |
length(Expression<java.lang.String> x)
Create expression to return length of a string. |
|
|
lessThan(Expression<? extends Y> x,
Expression<? extends Y> y)
Create a predicate for testing whether the first argument is less than the second. |
|
|
lessThan(Expression<? extends Y> x,
Y y)
Create a predicate for testing whether the first argument is less than the second. |
|
|
lessThanOrEqualTo(Expression<? extends Y> x,
Expression<? extends Y> y)
Create a predicate for testing whether the first argument is less than or equal to the second. |
|
|
lessThanOrEqualTo(Expression<? extends Y> x,
Y y)
Create a predicate for testing whether the first argument is less than or equal to the second. |
|
Predicate |
like(Expression<java.lang.String> x,
Expression<java.lang.String> pattern)
Create a predicate for testing whether the expression satisfies the given pattern. |
|
Predicate |
like(Expression<java.lang.String> x,
Expression<java.lang.String> pattern,
char escapeChar)
Create a predicate for testing whether the expression satisfies the given pattern. |
|
Predicate |
like(Expression<java.lang.String> x,
Expression<java.lang.String> pattern,
Expression<java.lang.Character> escapeChar)
Create a predicate for testing whether the expression satisfies the given pattern. |
|
Predicate |
like(Expression<java.lang.String> x,
java.lang.String pattern)
Create a predicate for testing whether the expression satisfies the given pattern. |
|
Predicate |
like(Expression<java.lang.String> x,
java.lang.String pattern,
char escapeChar)
Create a predicate for testing whether the expression satisfies the given pattern. |
|
Predicate |
like(Expression<java.lang.String> x,
java.lang.String pattern,
Expression<java.lang.Character> escapeChar)
Create a predicate for testing whether the expression satisfies the given pattern. |
|
|
literal(T value)
Create an expression for a literal. |
|
Expression<java.lang.Integer> |
locate(Expression<java.lang.String> x,
Expression<java.lang.String> pattern)
Create expression to locate the position of one string within another, returning position of first character if found. |
|
Expression<java.lang.Integer> |
locate(Expression<java.lang.String> x,
Expression<java.lang.String> pattern,
Expression<java.lang.Integer> from)
Create expression to locate the position of one string within another, returning position of first character if found. |
|
Expression<java.lang.Integer> |
locate(Expression<java.lang.String> x,
java.lang.String pattern)
Create expression to locate the position of one string within another, returning position of first character if found. |
|
Expression<java.lang.Integer> |
locate(Expression<java.lang.String> x,
java.lang.String pattern,
int from)
Create expression to locate the position of one string within another, returning position of first character if found. |
|
Expression<java.lang.String> |
lower(Expression<java.lang.String> x)
Create expression for converting a string to lowercase. |
|
Predicate |
lt(Expression<? extends java.lang.Number> x,
Expression<? extends java.lang.Number> y)
Create a predicate for testing whether the first argument is less than the second. |
|
Predicate |
lt(Expression<? extends java.lang.Number> x,
java.lang.Number y)
Create a predicate for testing whether the first argument is less than the second. |
|
|
max(Expression<N> x)
Create an aggregate expression applying the numerical max operation. |
|
|
min(Expression<N> x)
Create an aggregate expression applying the numerical min operation. |
|
Expression<java.lang.Integer> |
mod(Expression<java.lang.Integer> x,
Expression<java.lang.Integer> y)
Create an expression that returns the modulus of its arguments. |
|
Expression<java.lang.Integer> |
mod(Expression<java.lang.Integer> x,
java.lang.Integer y)
Create an expression that returns the modulus of its arguments. |
|
Expression<java.lang.Integer> |
mod(java.lang.Integer x,
Expression<java.lang.Integer> y)
Create an expression that returns the modulus of its arguments. |
|
|
neg(Expression<N> x)
Create an expression that returns the arithmetic negation of its argument. |
|
Predicate |
not(Expression<java.lang.Boolean> restriction)
Create a negation of the given restriction. |
|
Predicate |
notEqual(Expression<?> x,
Expression<?> y)
Create a predicate for testing the arguments for inequality. |
|
Predicate |
notEqual(Expression<?> x,
java.lang.Object y)
Create a predicate for testing the arguments for inequality. |
|
Predicate |
notLike(Expression<java.lang.String> x,
Expression<java.lang.String> pattern)
Create a predicate for testing whether the expression does not satisfy the given pattern. |
|
Predicate |
notLike(Expression<java.lang.String> x,
Expression<java.lang.String> pattern,
char escapeChar)
Create a predicate for testing whether the expression does not satisfy the given pattern. |
|
Predicate |
notLike(Expression<java.lang.String> x,
Expression<java.lang.String> pattern,
Expression<java.lang.Character> escapeChar)
Create a predicate for testing whether the expression does not satisfy the given pattern. |
|
Predicate |
notLike(Expression<java.lang.String> x,
java.lang.String pattern)
Create a predicate for testing whether the expression does not satisfy the given pattern. |
|
Predicate |
notLike(Expression<java.lang.String> x,
java.lang.String pattern,
char escapeChar)
Create a predicate for testing whether the expression does not satisfy the given pattern. |
|
Predicate |
notLike(Expression<java.lang.String> x,
java.lang.String pattern,
Expression<java.lang.Character> escapeChar)
Create a predicate for testing whether the expression does not satisfy the given pattern. |
|
|
nullif(Expression<Y> x,
Expression<?> y)
Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not. |
|
|
nullif(Expression<Y> x,
Y y)
Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not. |
|
|
nullLiteral(java.lang.Class<T> resultClass)
Create an expression for a null literal with the given type. |
|
Predicate |
or(Expression<java.lang.Boolean> x,
Expression<java.lang.Boolean> y)
Create a disjunction of the given boolean expressions. |
|
Predicate |
or(Predicate... restrictions)
Create a disjunction of the given restriction predicates. |
|
|
parameter(java.lang.Class<T> paramClass)
Create a parameter expression. |
|
|
parameter(java.lang.Class<T> paramClass,
java.lang.String name)
Create a parameter expression with the given name. |
|
|
prod(Expression<? extends N> x,
Expression<? extends N> y)
Create an expression that returns the product of its arguments. |
|
|
prod(Expression<? extends N> x,
N y)
Create an expression that returns the product of its arguments. |
|
|
prod(N x,
Expression<? extends N> y)
Create an expression that returns the product of its arguments. |
|
Expression<java.lang.Number> |
quot(Expression<? extends java.lang.Number> x,
Expression<? extends java.lang.Number> y)
Create an expression that returns the quotient of its arguments. |
|
Expression<java.lang.Number> |
quot(Expression<? extends java.lang.Number> x,
java.lang.Number y)
Create an expression that returns the quotient of its arguments. |
|
Expression<java.lang.Number> |
quot(java.lang.Number x,
Expression<? extends java.lang.Number> y)
Create an expression that returns the quotient of its arguments. |
|
|
selectCase()
Create a general case expression. |
|
|
selectCase(Expression<? extends C> expression)
Create a simple case expression. |
|
|
size(C collection)
Create an expression that tests the size of a collection. |
|
|
size(Expression<C> collection)
Create an expression that tests the size of a collection. |
|
|
some(Subquery<Y> subquery)
Create a some expression over the subquery results. |
|
Expression<java.lang.Double> |
sqrt(Expression<? extends java.lang.Number> x)
Create an expression that returns the square root of its argument. |
|
Expression<java.lang.String> |
substring(Expression<java.lang.String> x,
Expression<java.lang.Integer> from)
Create an expression for substring extraction. |
|
Expression<java.lang.String> |
substring(Expression<java.lang.String> x,
Expression<java.lang.Integer> from,
Expression<java.lang.Integer> len)
Create an expression for substring extraction. |
|
Expression<java.lang.String> |
substring(Expression<java.lang.String> x,
int from)
Create an expression for substring extraction. |
|
Expression<java.lang.String> |
substring(Expression<java.lang.String> x,
int from,
int len)
Create an expression for substring extraction. |
|
|
sum(Expression<? extends N> x,
Expression<? extends N> y)
Create an expression that returns the sum of its arguments. |
|
|
sum(Expression<? extends N> x,
N y)
Create an expression that returns the sum of its arguments. |
|
|
sum(Expression<N> x)
Create an aggregate expression applying the sum operation. |
|
|
sum(N x,
Expression<? extends N> y)
Create an expression that returns the sum of its arguments. |
|
Expression<java.lang.Double> |
sumAsDouble(Expression<java.lang.Float> x)
Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result. |
|
Expression<java.lang.Long> |
sumAsLong(Expression<java.lang.Integer> x)
Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result. |
|
Expression<java.math.BigDecimal> |
toBigDecimal(Expression<? extends java.lang.Number> number)
Typecast. |
|
Expression<java.math.BigInteger> |
toBigInteger(Expression<? extends java.lang.Number> number)
Typecast. |
|
Expression<java.lang.Double> |
toDouble(Expression<? extends java.lang.Number> number)
Typecast. |
|
Expression<java.lang.Float> |
toFloat(Expression<? extends java.lang.Number> number)
Typecast. |
|
Expression<java.lang.Integer> |
toInteger(Expression<? extends java.lang.Number> number)
Typecast. |
|
Expression<java.lang.Long> |
toLong(Expression<? extends java.lang.Number> number)
Typecast. |
|
Expression<java.lang.String> |
toString(Expression<java.lang.Character> character)
Typecast. |
|
Expression<java.lang.String> |
trim(char t,
Expression<java.lang.String> x)
Create expression to trim character from both ends of a string. |
|
Expression<java.lang.String> |
trim(CriteriaBuilder.Trimspec ts,
char t,
Expression<java.lang.String> x)
Create expression to trim character from a string. |
|
Expression<java.lang.String> |
trim(CriteriaBuilder.Trimspec ts,
Expression<java.lang.Character> t,
Expression<java.lang.String> x)
Create expression to trim character from a string. |
|
Expression<java.lang.String> |
trim(CriteriaBuilder.Trimspec ts,
Expression<java.lang.String> x)
Create expression to trim blanks from a string. |
|
Expression<java.lang.String> |
trim(Expression<java.lang.Character> t,
Expression<java.lang.String> x)
Create expression to trim character from both ends of a string. |
|
Expression<java.lang.String> |
trim(Expression<java.lang.String> x)
Create expression to trim blanks from both ends of a string. |
|
CompoundSelection<Tuple> |
tuple(Selection<?>... selections)
Create a tuple-valued selection item. |
|
Expression<java.lang.String> |
upper(Expression<java.lang.String> x)
Create expression for converting a string to uppercase. |
|
|
values(M map)
Create an expression that returns the values of a map. |
Method Detail |
---|
CriteriaQuery<java.lang.Object> createQuery()
CriteriaQuery
object.
<T> CriteriaQuery<T> createQuery(java.lang.Class<T> resultClass)
CriteriaQuery
object with the specified result
type.
resultClass
- type of the query result
CriteriaQuery<Tuple> createTupleQuery()
CriteriaQuery
object that returns a tuple of
objects as its result.
<Y> CompoundSelection<Y> construct(java.lang.Class<Y> resultClass, Selection<?>... selections)
resultClass
- class whose instance is to be constructedselections
- arguments to the constructor
IllegalArgumentException
- if an argument is a
tuple- or array-valued selection itemCompoundSelection<Tuple> tuple(Selection<?>... selections)
selections
- selection items
IllegalArgumentException
- if an argument is a
tuple- or array-valued selection itemCompoundSelection<java.lang.Object[]> array(Selection<?>... selections)
selections
- selection items
IllegalArgumentException
- if an argument is a
tuple- or array-valued selection itemOrder asc(Expression<?> x)
x
- expression used to define the ordering
Order desc(Expression<?> x)
x
- expression used to define the ordering
<N extends java.lang.Number> Expression<java.lang.Double> avg(Expression<N> x)
x
- expression representing input value to avg operation
<N extends java.lang.Number> Expression<N> sum(Expression<N> x)
x
- expression representing input value to sum operation
Expression<java.lang.Long> sumAsLong(Expression<java.lang.Integer> x)
x
- expression representing input value to sum operation
Expression<java.lang.Double> sumAsDouble(Expression<java.lang.Float> x)
x
- expression representing input value to sum operation
<N extends java.lang.Number> Expression<N> max(Expression<N> x)
x
- expression representing input value to max operation
<N extends java.lang.Number> Expression<N> min(Expression<N> x)
x
- expression representing input value to min operation
<X extends java.lang.Comparable<? super X>> Expression<X> greatest(Expression<X> x)
x
- expression representing input value to greatest
operation
<X extends java.lang.Comparable<? super X>> Expression<X> least(Expression<X> x)
x
- expression representing input value to least
operation
Expression<java.lang.Long> count(Expression<?> x)
x
- expression representing input value to count
operation
Expression<java.lang.Long> countDistinct(Expression<?> x)
x
- expression representing input value to
count distinct operation
Predicate exists(Subquery<?> subquery)
subquery
- subquery whose result is to be tested
<Y> Expression<Y> all(Subquery<Y> subquery)
subquery
- subquery
<Y> Expression<Y> some(Subquery<Y> subquery)
any
expression.
subquery
- subquery
<Y> Expression<Y> any(Subquery<Y> subquery)
some
expression.
subquery
- subquery
Predicate and(Expression<java.lang.Boolean> x, Expression<java.lang.Boolean> y)
x
- boolean expressiony
- boolean expression
Predicate and(Predicate... restrictions)
restrictions
- zero or more restriction predicates
Predicate or(Expression<java.lang.Boolean> x, Expression<java.lang.Boolean> y)
x
- boolean expressiony
- boolean expression
Predicate or(Predicate... restrictions)
restrictions
- zero or more restriction predicates
Predicate not(Expression<java.lang.Boolean> restriction)
restriction
- restriction expression
Predicate conjunction()
Predicate disjunction()
Predicate isTrue(Expression<java.lang.Boolean> x)
x
- expression to be tested
Predicate isFalse(Expression<java.lang.Boolean> x)
x
- expression to be tested
Predicate isNull(Expression<?> x)
x
- expression
Predicate isNotNull(Expression<?> x)
x
- expression
Predicate equal(Expression<?> x, Expression<?> y)
x
- expressiony
- expression
Predicate equal(Expression<?> x, java.lang.Object y)
x
- expressiony
- object
Predicate notEqual(Expression<?> x, Expression<?> y)
x
- expressiony
- expression
Predicate notEqual(Expression<?> x, java.lang.Object y)
x
- expressiony
- object
<Y extends java.lang.Comparable<? super Y>> Predicate greaterThan(Expression<? extends Y> x, Expression<? extends Y> y)
x
- expressiony
- expression
<Y extends java.lang.Comparable<? super Y>> Predicate greaterThan(Expression<? extends Y> x, Y y)
x
- expressiony
- value
<Y extends java.lang.Comparable<? super Y>> Predicate greaterThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)
x
- expressiony
- expression
<Y extends java.lang.Comparable<? super Y>> Predicate greaterThanOrEqualTo(Expression<? extends Y> x, Y y)
x
- expressiony
- value
<Y extends java.lang.Comparable<? super Y>> Predicate lessThan(Expression<? extends Y> x, Expression<? extends Y> y)
x
- expressiony
- expression
<Y extends java.lang.Comparable<? super Y>> Predicate lessThan(Expression<? extends Y> x, Y y)
x
- expressiony
- value
<Y extends java.lang.Comparable<? super Y>> Predicate lessThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)
x
- expressiony
- expression
<Y extends java.lang.Comparable<? super Y>> Predicate lessThanOrEqualTo(Expression<? extends Y> x, Y y)
x
- expressiony
- value
<Y extends java.lang.Comparable<? super Y>> Predicate between(Expression<? extends Y> v, Expression<? extends Y> x, Expression<? extends Y> y)
v
- expressionx
- expressiony
- expression
<Y extends java.lang.Comparable<? super Y>> Predicate between(Expression<? extends Y> v, Y x, Y y)
v
- expressionx
- valuey
- value
Predicate gt(Expression<? extends java.lang.Number> x, Expression<? extends java.lang.Number> y)
x
- expressiony
- expression
Predicate gt(Expression<? extends java.lang.Number> x, java.lang.Number y)
x
- expressiony
- value
Predicate ge(Expression<? extends java.lang.Number> x, Expression<? extends java.lang.Number> y)
x
- expressiony
- expression
Predicate ge(Expression<? extends java.lang.Number> x, java.lang.Number y)
x
- expressiony
- value
Predicate lt(Expression<? extends java.lang.Number> x, Expression<? extends java.lang.Number> y)
x
- expressiony
- expression
Predicate lt(Expression<? extends java.lang.Number> x, java.lang.Number y)
x
- expressiony
- value
Predicate le(Expression<? extends java.lang.Number> x, Expression<? extends java.lang.Number> y)
x
- expressiony
- expression
Predicate le(Expression<? extends java.lang.Number> x, java.lang.Number y)
x
- expressiony
- value
<N extends java.lang.Number> Expression<N> neg(Expression<N> x)
x
- expression
<N extends java.lang.Number> Expression<N> abs(Expression<N> x)
x
- expression
<N extends java.lang.Number> Expression<N> sum(Expression<? extends N> x, Expression<? extends N> y)
x
- expressiony
- expression
<N extends java.lang.Number> Expression<N> sum(Expression<? extends N> x, N y)
x
- expressiony
- value
<N extends java.lang.Number> Expression<N> sum(N x, Expression<? extends N> y)
x
- valuey
- expression
<N extends java.lang.Number> Expression<N> prod(Expression<? extends N> x, Expression<? extends N> y)
x
- expressiony
- expression
<N extends java.lang.Number> Expression<N> prod(Expression<? extends N> x, N y)
x
- expressiony
- value
<N extends java.lang.Number> Expression<N> prod(N x, Expression<? extends N> y)
x
- valuey
- expression
<N extends java.lang.Number> Expression<N> diff(Expression<? extends N> x, Expression<? extends N> y)
x
- expressiony
- expression
<N extends java.lang.Number> Expression<N> diff(Expression<? extends N> x, N y)
x
- expressiony
- value
<N extends java.lang.Number> Expression<N> diff(N x, Expression<? extends N> y)
x
- valuey
- expression
Expression<java.lang.Number> quot(Expression<? extends java.lang.Number> x, Expression<? extends java.lang.Number> y)
x
- expressiony
- expression
Expression<java.lang.Number> quot(Expression<? extends java.lang.Number> x, java.lang.Number y)
x
- expressiony
- value
Expression<java.lang.Number> quot(java.lang.Number x, Expression<? extends java.lang.Number> y)
x
- valuey
- expression
Expression<java.lang.Integer> mod(Expression<java.lang.Integer> x, Expression<java.lang.Integer> y)
x
- expressiony
- expression
Expression<java.lang.Integer> mod(Expression<java.lang.Integer> x, java.lang.Integer y)
x
- expressiony
- value
Expression<java.lang.Integer> mod(java.lang.Integer x, Expression<java.lang.Integer> y)
x
- valuey
- expression
Expression<java.lang.Double> sqrt(Expression<? extends java.lang.Number> x)
x
- expression
Expression<java.lang.Long> toLong(Expression<? extends java.lang.Number> number)
number
- numeric expression
Expression<java.lang.Integer> toInteger(Expression<? extends java.lang.Number> number)
number
- numeric expression
Expression<java.lang.Float> toFloat(Expression<? extends java.lang.Number> number)
number
- numeric expression
Expression<java.lang.Double> toDouble(Expression<? extends java.lang.Number> number)
number
- numeric expression
Expression<java.math.BigDecimal> toBigDecimal(Expression<? extends java.lang.Number> number)
number
- numeric expression
Expression<java.math.BigInteger> toBigInteger(Expression<? extends java.lang.Number> number)
number
- numeric expression
Expression<java.lang.String> toString(Expression<java.lang.Character> character)
character
- expression
<T> Expression<T> literal(T value)
value
- value represented by the expression
IllegalArgumentException
- if value is null<T> Expression<T> nullLiteral(java.lang.Class<T> resultClass)
resultClass
- type of the null literal
<T> ParameterExpression<T> parameter(java.lang.Class<T> paramClass)
paramClass
- parameter class
<T> ParameterExpression<T> parameter(java.lang.Class<T> paramClass, java.lang.String name)
paramClass
- parameter classname
- name that can be used to refer to
the parameter
<C extends java.util.Collection<?>> Predicate isEmpty(Expression<C> collection)
collection
- expression
<C extends java.util.Collection<?>> Predicate isNotEmpty(Expression<C> collection)
collection
- expression
<C extends java.util.Collection<?>> Expression<java.lang.Integer> size(Expression<C> collection)
collection
- expression
<C extends java.util.Collection<?>> Expression<java.lang.Integer> size(C collection)
collection
- collection
<E,C extends java.util.Collection<E>> Predicate isMember(Expression<E> elem, Expression<C> collection)
elem
- element expressioncollection
- expression
<E,C extends java.util.Collection<E>> Predicate isMember(E elem, Expression<C> collection)
elem
- elementcollection
- expression
<E,C extends java.util.Collection<E>> Predicate isNotMember(Expression<E> elem, Expression<C> collection)
elem
- element expressioncollection
- expression
<E,C extends java.util.Collection<E>> Predicate isNotMember(E elem, Expression<C> collection)
elem
- elementcollection
- expression
<V,M extends java.util.Map<?,V>> Expression<java.util.Collection<V>> values(M map)
map
- map
<K,M extends java.util.Map<K,?>> Expression<java.util.Set<K>> keys(M map)
map
- map
Predicate like(Expression<java.lang.String> x, Expression<java.lang.String> pattern)
x
- string expressionpattern
- string expression
Predicate like(Expression<java.lang.String> x, java.lang.String pattern)
x
- string expressionpattern
- string
Predicate like(Expression<java.lang.String> x, Expression<java.lang.String> pattern, Expression<java.lang.Character> escapeChar)
x
- string expressionpattern
- string expressionescapeChar
- escape character expression
Predicate like(Expression<java.lang.String> x, Expression<java.lang.String> pattern, char escapeChar)
x
- string expressionpattern
- string expressionescapeChar
- escape character
Predicate like(Expression<java.lang.String> x, java.lang.String pattern, Expression<java.lang.Character> escapeChar)
x
- string expressionpattern
- stringescapeChar
- escape character expression
Predicate like(Expression<java.lang.String> x, java.lang.String pattern, char escapeChar)
x
- string expressionpattern
- stringescapeChar
- escape character
Predicate notLike(Expression<java.lang.String> x, Expression<java.lang.String> pattern)
x
- string expressionpattern
- string expression
Predicate notLike(Expression<java.lang.String> x, java.lang.String pattern)
x
- string expressionpattern
- string
Predicate notLike(Expression<java.lang.String> x, Expression<java.lang.String> pattern, Expression<java.lang.Character> escapeChar)
x
- string expressionpattern
- string expressionescapeChar
- escape character expression
Predicate notLike(Expression<java.lang.String> x, Expression<java.lang.String> pattern, char escapeChar)
x
- string expressionpattern
- string expressionescapeChar
- escape character
Predicate notLike(Expression<java.lang.String> x, java.lang.String pattern, Expression<java.lang.Character> escapeChar)
x
- string expressionpattern
- stringescapeChar
- escape character expression
Predicate notLike(Expression<java.lang.String> x, java.lang.String pattern, char escapeChar)
x
- string expressionpattern
- stringescapeChar
- escape character
Expression<java.lang.String> concat(Expression<java.lang.String> x, Expression<java.lang.String> y)
x
- string expressiony
- string expression
Expression<java.lang.String> concat(Expression<java.lang.String> x, java.lang.String y)
x
- string expressiony
- string
Expression<java.lang.String> concat(java.lang.String x, Expression<java.lang.String> y)
x
- stringy
- string expression
Expression<java.lang.String> substring(Expression<java.lang.String> x, Expression<java.lang.Integer> from)
x
- string expressionfrom
- start position expression
Expression<java.lang.String> substring(Expression<java.lang.String> x, int from)
x
- string expressionfrom
- start position
Expression<java.lang.String> substring(Expression<java.lang.String> x, Expression<java.lang.Integer> from, Expression<java.lang.Integer> len)
x
- string expressionfrom
- start position expressionlen
- length expression
Expression<java.lang.String> substring(Expression<java.lang.String> x, int from, int len)
x
- string expressionfrom
- start positionlen
- length
Expression<java.lang.String> trim(Expression<java.lang.String> x)
x
- expression for string to trim
Expression<java.lang.String> trim(CriteriaBuilder.Trimspec ts, Expression<java.lang.String> x)
ts
- trim specificationx
- expression for string to trim
Expression<java.lang.String> trim(Expression<java.lang.Character> t, Expression<java.lang.String> x)
t
- expression for character to be trimmedx
- expression for string to trim
Expression<java.lang.String> trim(CriteriaBuilder.Trimspec ts, Expression<java.lang.Character> t, Expression<java.lang.String> x)
ts
- trim specificationt
- expression for character to be trimmedx
- expression for string to trim
Expression<java.lang.String> trim(char t, Expression<java.lang.String> x)
t
- character to be trimmedx
- expression for string to trim
Expression<java.lang.String> trim(CriteriaBuilder.Trimspec ts, char t, Expression<java.lang.String> x)
ts
- trim specificationt
- character to be trimmedx
- expression for string to trim
Expression<java.lang.String> lower(Expression<java.lang.String> x)
x
- string expression
Expression<java.lang.String> upper(Expression<java.lang.String> x)
x
- string expression
Expression<java.lang.Integer> length(Expression<java.lang.String> x)
x
- string expression
Expression<java.lang.Integer> locate(Expression<java.lang.String> x, Expression<java.lang.String> pattern)
x
- expression for string to be searchedpattern
- expression for string to be located
Expression<java.lang.Integer> locate(Expression<java.lang.String> x, java.lang.String pattern)
x
- expression for string to be searchedpattern
- string to be located
Expression<java.lang.Integer> locate(Expression<java.lang.String> x, Expression<java.lang.String> pattern, Expression<java.lang.Integer> from)
x
- expression for string to be searchedpattern
- expression for string to be locatedfrom
- expression for position at which to start search
Expression<java.lang.Integer> locate(Expression<java.lang.String> x, java.lang.String pattern, int from)
x
- expression for string to be searchedpattern
- string to be locatedfrom
- position at which to start search
Expression<java.sql.Date> currentDate()
Expression<java.sql.Timestamp> currentTimestamp()
Expression<java.sql.Time> currentTime()
<T> CriteriaBuilder.In<T> in(Expression<? extends T> expression)
expression
- to be tested against list of values
<Y> Expression<Y> coalesce(Expression<? extends Y> x, Expression<? extends Y> y)
x
- expressiony
- expression
<Y> Expression<Y> coalesce(Expression<? extends Y> x, Y y)
x
- expressiony
- value
<Y> Expression<Y> nullif(Expression<Y> x, Expression<?> y)
x
- expressiony
- expression
<Y> Expression<Y> nullif(Expression<Y> x, Y y)
x
- expressiony
- value
<T> CriteriaBuilder.Coalesce<T> coalesce()
<C,R> CriteriaBuilder.SimpleCase<C,R> selectCase(Expression<? extends C> expression)
expression
- to be tested against the case conditions
<R> CriteriaBuilder.Case<R> selectCase()
<T> Expression<T> function(java.lang.String name, java.lang.Class<T> type, Expression<?>... args)
name
- function nametype
- expected result typeargs
- function arguments
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
Copyright © 2009-2011, Oracle Corporation and/or its affiliates. All Rights Reserved. Use is subject to license terms.
Generated on 10-February-2011 12:41