<N extends Number> Expression<N> |
CriteriaBuilder.abs(Expression<N> x) |
Create an expression that returns the absolute value
of its argument.
|
Predicate |
CriteriaBuilder.and(Expression<Boolean> x,
Expression<Boolean> y) |
Create a conjunction of the given boolean expressions.
|
Order |
CriteriaBuilder.asc(Expression<?> x) |
Create an ordering by the ascending value of the expression.
|
<N extends Number> Expression<Double> |
CriteriaBuilder.avg(Expression<N> x) |
Create an aggregate expression applying the avg operation.
|
<Y extends Comparable<? super Y>> Predicate |
CriteriaBuilder.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.
|
<Y extends Comparable<? super Y>> Predicate |
CriteriaBuilder.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.
|
<N extends Number> Expression<N> |
CriteriaBuilder.ceiling(Expression<N> x) |
Create an expression that returns the ceiling of its
argument, that is, the smallest integer greater than
or equal to its argument.
|
<Y> Expression<Y> |
CriteriaBuilder.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.
|
<Y> Expression<Y> |
CriteriaBuilder.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<String> |
CriteriaBuilder.concat(Expression<String> x,
Expression<String> y) |
Create an expression for string concatenation.
|
Expression<String> |
CriteriaBuilder.concat(Expression<String> x,
String y) |
Create an expression for string concatenation.
|
Expression<String> |
CriteriaBuilder.concat(String x,
Expression<String> y) |
Create an expression for string concatenation.
|
Expression<Long> |
CriteriaBuilder.count(Expression<?> x) |
Create an aggregate expression applying the count operation.
|
Expression<Long> |
CriteriaBuilder.countDistinct(Expression<?> x) |
Create an aggregate expression applying the count distinct
operation.
|
Order |
CriteriaBuilder.desc(Expression<?> x) |
Create an ordering by the descending value of the expression.
|
<N extends Number> Expression<N> |
CriteriaBuilder.diff(Expression<? extends N> x,
Expression<? extends N> y) |
Create an expression that returns the difference
between its arguments.
|
<N extends Number> Expression<N> |
CriteriaBuilder.diff(Expression<? extends N> x,
N y) |
Create an expression that returns the difference
between its arguments.
|
<N extends Number> Expression<N> |
CriteriaBuilder.diff(N x,
Expression<? extends N> y) |
Create an expression that returns the difference
between its arguments.
|
Predicate |
CriteriaBuilder.equal(Expression<?> x,
Expression<?> y) |
Create a predicate for testing the arguments for equality.
|
Predicate |
CriteriaBuilder.equal(Expression<?> x,
Object y) |
Create a predicate for testing the arguments for equality.
|
Expression<Double> |
CriteriaBuilder.exp(Expression<? extends Number> x) |
Create an expression that returns the exponential
of its argument, that is, Euler's number e
raised to the power of its argument.
|
<N extends Number> Expression<N> |
CriteriaBuilder.floor(Expression<N> x) |
Create an expression that returns the floor of its
argument, that is, the largest integer smaller than
or equal to its argument.
|
<T> Expression<T> |
CriteriaBuilder.function(String name,
Class<T> type,
Expression<?>... args) |
Create an expression for the execution of a database
function.
|
Predicate |
CriteriaBuilder.ge(Expression<? extends Number> x,
Expression<? extends Number> y) |
Create a predicate for testing whether the first argument is
greater than or equal to the second.
|
Predicate |
CriteriaBuilder.ge(Expression<? extends Number> x,
Number y) |
Create a predicate for testing whether the first argument is
greater than or equal to the second.
|
<Y extends Comparable<? super Y>> Predicate |
CriteriaBuilder.greaterThan(Expression<? extends Y> x,
Expression<? extends Y> y) |
Create a predicate for testing whether the first argument is
greater than the second.
|
<Y extends Comparable<? super Y>> Predicate |
CriteriaBuilder.greaterThan(Expression<? extends Y> x,
Y y) |
Create a predicate for testing whether the first argument is
greater than the second.
|
<Y extends Comparable<? super Y>> Predicate |
CriteriaBuilder.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.
|
<Y extends Comparable<? super Y>> Predicate |
CriteriaBuilder.greaterThanOrEqualTo(Expression<? extends Y> x,
Y y) |
Create a predicate for testing whether the first argument is
greater than or equal to the second.
|
<X extends Comparable<? super X>> Expression<X> |
CriteriaBuilder.greatest(Expression<X> x) |
Create an aggregate expression for finding the greatest of
the values (strings, dates, etc).
|
AbstractQuery<T> |
AbstractQuery.groupBy(Expression<?>... grouping) |
Specify the expressions that are used to form groups over
the query results.
|
CriteriaQuery<T> |
CriteriaQuery.groupBy(Expression<?>... grouping) |
Specify the expressions that are used to form groups over
the query results.
|
Subquery<T> |
Subquery.groupBy(Expression<?>... grouping) |
Specify the expressions that are used to form groups over
the subquery results.
|
Predicate |
CriteriaBuilder.gt(Expression<? extends Number> x,
Expression<? extends Number> y) |
Create a predicate for testing whether the first argument is
greater than the second.
|
Predicate |
CriteriaBuilder.gt(Expression<? extends Number> x,
Number y) |
Create a predicate for testing whether the first argument is
greater than the second.
|
AbstractQuery<T> |
AbstractQuery.having(Expression<Boolean> restriction) |
Specify a restriction over the groups of the query.
|
CriteriaQuery<T> |
CriteriaQuery.having(Expression<Boolean> restriction) |
Specify a restriction over the groups of the query.
|
Subquery<T> |
Subquery.having(Expression<Boolean> restriction) |
Specify a restriction over the groups of the subquery.
|
<T> CriteriaBuilder.In<T> |
CriteriaBuilder.in(Expression<? extends T> expression) |
Create predicate to test whether given expression
is contained in a list of values.
|
Predicate |
Expression.in(Expression<?>... values) |
Create a predicate to test whether the expression is a member
of the argument list.
|
Predicate |
Expression.in(Expression<Collection<?>> values) |
Create a predicate to test whether the expression is a member
of the collection.
|
<C extends Collection<?>> Predicate |
CriteriaBuilder.isEmpty(Expression<C> collection) |
Create a predicate that tests whether a collection is empty.
|
Predicate |
CriteriaBuilder.isFalse(Expression<Boolean> x) |
Create a predicate testing for a false value.
|
<E,C extends Collection<E>> Predicate |
CriteriaBuilder.isMember(E elem,
Expression<C> collection) |
Create a predicate that tests whether an element is
a member of a collection.
|
<E,C extends Collection<E>> Predicate |
CriteriaBuilder.isMember(Expression<E> elem,
Expression<C> collection) |
Create a predicate that tests whether an element is
a member of a collection.
|
<C extends Collection<?>> Predicate |
CriteriaBuilder.isNotEmpty(Expression<C> collection) |
Create a predicate that tests whether a collection is
not empty.
|
<E,C extends Collection<E>> Predicate |
CriteriaBuilder.isNotMember(E elem,
Expression<C> collection) |
Create a predicate that tests whether an element is
not a member of a collection.
|
<E,C extends Collection<E>> Predicate |
CriteriaBuilder.isNotMember(Expression<E> elem,
Expression<C> collection) |
Create a predicate that tests whether an element is
not a member of a collection.
|
Predicate |
CriteriaBuilder.isNotNull(Expression<?> x) |
Create a predicate to test whether the expression is not null.
|
Predicate |
CriteriaBuilder.isNull(Expression<?> x) |
Create a predicate to test whether the expression is null.
|
Predicate |
CriteriaBuilder.isTrue(Expression<Boolean> x) |
Create a predicate testing for a true value.
|
Predicate |
CriteriaBuilder.le(Expression<? extends Number> x,
Expression<? extends Number> y) |
Create a predicate for testing whether the first argument is
less than or equal to the second.
|
Predicate |
CriteriaBuilder.le(Expression<? extends Number> x,
Number y) |
Create a predicate for testing whether the first argument is
less than or equal to the second.
|
<X extends Comparable<? super X>> Expression<X> |
CriteriaBuilder.least(Expression<X> x) |
Create an aggregate expression for finding the least of
the values (strings, dates, etc).
|
Expression<Integer> |
CriteriaBuilder.length(Expression<String> x) |
Create expression to return length of a string.
|
<Y extends Comparable<? super Y>> Predicate |
CriteriaBuilder.lessThan(Expression<? extends Y> x,
Expression<? extends Y> y) |
Create a predicate for testing whether the first argument is
less than the second.
|
<Y extends Comparable<? super Y>> Predicate |
CriteriaBuilder.lessThan(Expression<? extends Y> x,
Y y) |
Create a predicate for testing whether the first argument is
less than the second.
|
<Y extends Comparable<? super Y>> Predicate |
CriteriaBuilder.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.
|
<Y extends Comparable<? super Y>> Predicate |
CriteriaBuilder.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 |
CriteriaBuilder.like(Expression<String> x,
Expression<String> pattern) |
Create a predicate for testing whether the expression
satisfies the given pattern.
|
Predicate |
CriteriaBuilder.like(Expression<String> x,
Expression<String> pattern,
char escapeChar) |
Create a predicate for testing whether the expression
satisfies the given pattern.
|
Predicate |
CriteriaBuilder.like(Expression<String> x,
Expression<String> pattern,
Expression<Character> escapeChar) |
Create a predicate for testing whether the expression
satisfies the given pattern.
|
Predicate |
CriteriaBuilder.like(Expression<String> x,
String pattern) |
Create a predicate for testing whether the expression
satisfies the given pattern.
|
Predicate |
CriteriaBuilder.like(Expression<String> x,
String pattern,
char escapeChar) |
Create a predicate for testing whether the expression
satisfies the given pattern.
|
Predicate |
CriteriaBuilder.like(Expression<String> x,
String pattern,
Expression<Character> escapeChar) |
Create a predicate for testing whether the expression
satisfies the given pattern.
|
Expression<Double> |
CriteriaBuilder.ln(Expression<? extends Number> x) |
Create an expression that returns the natural logarithm
of its argument.
|
Expression<Integer> |
CriteriaBuilder.locate(Expression<String> x,
Expression<String> pattern) |
Create expression to locate the position of one string
within another, returning position of first character
if found.
|
Expression<Integer> |
CriteriaBuilder.locate(Expression<String> x,
Expression<String> pattern,
Expression<Integer> from) |
Create expression to locate the position of one string
within another, returning position of first character
if found.
|
Expression<Integer> |
CriteriaBuilder.locate(Expression<String> x,
String pattern) |
Create expression to locate the position of one string
within another, returning position of first character
if found.
|
Expression<Integer> |
CriteriaBuilder.locate(Expression<String> x,
String pattern,
int from) |
Create expression to locate the position of one string
within another, returning position of first character
if found.
|
Expression<String> |
CriteriaBuilder.lower(Expression<String> x) |
Create expression for converting a string to lowercase.
|
Predicate |
CriteriaBuilder.lt(Expression<? extends Number> x,
Expression<? extends Number> y) |
Create a predicate for testing whether the first argument is
less than the second.
|
Predicate |
CriteriaBuilder.lt(Expression<? extends Number> x,
Number y) |
Create a predicate for testing whether the first argument is
less than the second.
|
<N extends Number> Expression<N> |
CriteriaBuilder.max(Expression<N> x) |
Create an aggregate expression applying the numerical max
operation.
|
<N extends Number> Expression<N> |
CriteriaBuilder.min(Expression<N> x) |
Create an aggregate expression applying the numerical min
operation.
|
Expression<Integer> |
CriteriaBuilder.mod(Expression<Integer> x,
Expression<Integer> y) |
Create an expression that returns the modulus
(remainder under integer division) of its
arguments.
|
Expression<Integer> |
CriteriaBuilder.mod(Expression<Integer> x,
Integer y) |
Create an expression that returns the modulus
(remainder under integer division) of its
arguments.
|
Expression<Integer> |
CriteriaBuilder.mod(Integer x,
Expression<Integer> y) |
Create an expression that returns the modulus
(remainder under integer division) of its
arguments.
|
<N extends Number> Expression<N> |
CriteriaBuilder.neg(Expression<N> x) |
Create an expression that returns the arithmetic negation
of its argument.
|
Predicate |
CriteriaBuilder.not(Expression<Boolean> restriction) |
Create a negation of the given restriction.
|
Predicate |
CriteriaBuilder.notEqual(Expression<?> x,
Expression<?> y) |
Create a predicate for testing the arguments for inequality.
|
Predicate |
CriteriaBuilder.notEqual(Expression<?> x,
Object y) |
Create a predicate for testing the arguments for inequality.
|
Predicate |
CriteriaBuilder.notLike(Expression<String> x,
Expression<String> pattern) |
Create a predicate for testing whether the expression
does not satisfy the given pattern.
|
Predicate |
CriteriaBuilder.notLike(Expression<String> x,
Expression<String> pattern,
char escapeChar) |
Create a predicate for testing whether the expression
does not satisfy the given pattern.
|
Predicate |
CriteriaBuilder.notLike(Expression<String> x,
Expression<String> pattern,
Expression<Character> escapeChar) |
Create a predicate for testing whether the expression
does not satisfy the given pattern.
|
Predicate |
CriteriaBuilder.notLike(Expression<String> x,
String pattern) |
Create a predicate for testing whether the expression
does not satisfy the given pattern.
|
Predicate |
CriteriaBuilder.notLike(Expression<String> x,
String pattern,
char escapeChar) |
Create a predicate for testing whether the expression
does not satisfy the given pattern.
|
Predicate |
CriteriaBuilder.notLike(Expression<String> x,
String pattern,
Expression<Character> escapeChar) |
Create a predicate for testing whether the expression
does not satisfy the given pattern.
|
<Y> Expression<Y> |
CriteriaBuilder.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.
|
<Y> Expression<Y> |
CriteriaBuilder.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.
|
CollectionJoin<Z,E> |
CollectionJoin.on(Expression<Boolean> restriction) |
Modify the join to restrict the result according to the
specified ON condition and return the join object.
|
Join<Z,X> |
Join.on(Expression<Boolean> restriction) |
Modify the join to restrict the result according to the
specified ON condition and return the join object.
|
ListJoin<Z,E> |
ListJoin.on(Expression<Boolean> restriction) |
Modify the join to restrict the result according to the
specified ON condition and return the join object.
|
MapJoin<Z,K,V> |
MapJoin.on(Expression<Boolean> restriction) |
Modify the join to restrict the result according to the
specified ON condition and return the join object.
|
SetJoin<Z,E> |
SetJoin.on(Expression<Boolean> restriction) |
Modify the join to restrict the result according to the
specified ON condition and return the join object.
|
Predicate |
CriteriaBuilder.or(Expression<Boolean> x,
Expression<Boolean> y) |
Create a disjunction of the given boolean expressions.
|
Expression<R> |
CriteriaBuilder.Case.otherwise(Expression<? extends R> result) |
Add an "else" clause to the case expression.
|
Expression<R> |
CriteriaBuilder.SimpleCase.otherwise(Expression<? extends R> result) |
Add an "else" clause to the case expression.
|
Expression<Double> |
CriteriaBuilder.power(Expression<? extends Number> x,
Expression<? extends Number> y) |
Create an expression that returns the first argument
raised to the power of its second argument.
|
Expression<Double> |
CriteriaBuilder.power(Expression<? extends Number> x,
Number y) |
Create an expression that returns the first argument
raised to the power of its second argument.
|
<N extends Number> Expression<N> |
CriteriaBuilder.prod(Expression<? extends N> x,
Expression<? extends N> y) |
Create an expression that returns the product
of its arguments.
|
<N extends Number> Expression<N> |
CriteriaBuilder.prod(Expression<? extends N> x,
N y) |
Create an expression that returns the product
of its arguments.
|
<N extends Number> Expression<N> |
CriteriaBuilder.prod(N x,
Expression<? extends N> y) |
Create an expression that returns the product
of its arguments.
|
Expression<Number> |
CriteriaBuilder.quot(Expression<? extends Number> x,
Expression<? extends Number> y) |
Create an expression that returns the quotient
of its arguments.
|
Expression<Number> |
CriteriaBuilder.quot(Expression<? extends Number> x,
Number y) |
Create an expression that returns the quotient
of its arguments.
|
Expression<Number> |
CriteriaBuilder.quot(Number x,
Expression<? extends Number> y) |
Create an expression that returns the quotient
of its arguments.
|
<T extends Number> Expression<T> |
CriteriaBuilder.round(Expression<T> x,
Integer n) |
Create an expression that returns the first argument
rounded to the number of decimal places given by the
second argument.
|
Subquery<T> |
Subquery.select(Expression<T> expression) |
Specify the item that is to be returned as the subquery
result.
|
<C,R> CriteriaBuilder.SimpleCase<C,R> |
CriteriaBuilder.selectCase(Expression<? extends C> expression) |
Create a simple case expression.
|
<Y> CriteriaUpdate<T> |
CriteriaUpdate.set(Path<Y> attribute,
Expression<? extends Y> value) |
Update the value of the specified attribute.
|
<Y> CriteriaUpdate<T> |
CriteriaUpdate.set(SingularAttribute<? super T,Y> attribute,
Expression<? extends Y> value) |
Update the value of the specified attribute.
|
Expression<Integer> |
CriteriaBuilder.sign(Expression<? extends Number> x) |
Create an expression that returns the sign of its
argument, that is, 1 if its argument is
positive, -1 if its argument is negative,
or 0 if its argument is exactly zero.
|
<C extends Collection<?>> Expression<Integer> |
CriteriaBuilder.size(Expression<C> collection) |
Create an expression that tests the size of a collection.
|
Expression<Double> |
CriteriaBuilder.sqrt(Expression<? extends Number> x) |
Create an expression that returns the square root
of its argument.
|
Expression<String> |
CriteriaBuilder.substring(Expression<String> x,
int from) |
Create an expression for substring extraction.
|
Expression<String> |
CriteriaBuilder.substring(Expression<String> x,
int from,
int len) |
Create an expression for substring extraction.
|
Expression<String> |
CriteriaBuilder.substring(Expression<String> x,
Expression<Integer> from) |
Create an expression for substring extraction.
|
Expression<String> |
CriteriaBuilder.substring(Expression<String> x,
Expression<Integer> from,
Expression<Integer> len) |
Create an expression for substring extraction.
|
<N extends Number> Expression<N> |
CriteriaBuilder.sum(Expression<? extends N> x,
Expression<? extends N> y) |
Create an expression that returns the sum
of its arguments.
|
<N extends Number> Expression<N> |
CriteriaBuilder.sum(Expression<? extends N> x,
N y) |
Create an expression that returns the sum
of its arguments.
|
<N extends Number> Expression<N> |
CriteriaBuilder.sum(Expression<N> x) |
Create an aggregate expression applying the sum operation.
|
<N extends Number> Expression<N> |
CriteriaBuilder.sum(N x,
Expression<? extends N> y) |
Create an expression that returns the sum
of its arguments.
|
Expression<Double> |
CriteriaBuilder.sumAsDouble(Expression<Float> x) |
Create an aggregate expression applying the sum operation to a
Float-valued expression, returning a Double result.
|
Expression<Long> |
CriteriaBuilder.sumAsLong(Expression<Integer> x) |
Create an aggregate expression applying the sum operation to an
Integer-valued expression, returning a Long result.
|
Expression<BigDecimal> |
CriteriaBuilder.toBigDecimal(Expression<? extends Number> number) |
Typecast.
|
Expression<BigInteger> |
CriteriaBuilder.toBigInteger(Expression<? extends Number> number) |
Typecast.
|
Expression<Double> |
CriteriaBuilder.toDouble(Expression<? extends Number> number) |
Typecast.
|
Expression<Float> |
CriteriaBuilder.toFloat(Expression<? extends Number> number) |
Typecast.
|
Expression<Integer> |
CriteriaBuilder.toInteger(Expression<? extends Number> number) |
Typecast.
|
Expression<Long> |
CriteriaBuilder.toLong(Expression<? extends Number> number) |
Typecast.
|
Expression<String> |
CriteriaBuilder.toString(Expression<Character> character) |
Typecast.
|
Expression<String> |
CriteriaBuilder.trim(char t,
Expression<String> x) |
Create expression to trim character from both ends of
a string.
|
Expression<String> |
CriteriaBuilder.trim(CriteriaBuilder.Trimspec ts,
char t,
Expression<String> x) |
Create expression to trim character from a string.
|
Expression<String> |
CriteriaBuilder.trim(CriteriaBuilder.Trimspec ts,
Expression<Character> t,
Expression<String> x) |
Create expression to trim character from a string.
|
Expression<String> |
CriteriaBuilder.trim(CriteriaBuilder.Trimspec ts,
Expression<String> x) |
Create expression to trim blanks from a string.
|
Expression<String> |
CriteriaBuilder.trim(Expression<Character> t,
Expression<String> x) |
Create expression to trim character from both ends of
a string.
|
Expression<String> |
CriteriaBuilder.trim(Expression<String> x) |
Create expression to trim blanks from both ends of
a string.
|
Expression<String> |
CriteriaBuilder.upper(Expression<String> x) |
Create expression for converting a string to uppercase.
|
CriteriaBuilder.Coalesce<T> |
CriteriaBuilder.Coalesce.value(Expression<? extends T> value) |
Add an argument to the coalesce expression.
|
CriteriaBuilder.In<T> |
CriteriaBuilder.In.value(Expression<? extends T> value) |
Add to list of values to be tested against.
|
CriteriaBuilder.Case<R> |
CriteriaBuilder.Case.when(Expression<Boolean> condition,
Expression<? extends R> result) |
Add a when/then clause to the case expression.
|
CriteriaBuilder.Case<R> |
CriteriaBuilder.Case.when(Expression<Boolean> condition,
R result) |
Add a when/then clause to the case expression.
|
CriteriaBuilder.SimpleCase<C,R> |
CriteriaBuilder.SimpleCase.when(C condition,
Expression<? extends R> result) |
Add a when/then clause to the case expression.
|
CriteriaBuilder.SimpleCase<C,R> |
CriteriaBuilder.SimpleCase.when(Expression<? extends C> condition,
Expression<? extends R> result) |
Add a when/then clause to the case expression.
|
CriteriaBuilder.SimpleCase<C,R> |
CriteriaBuilder.SimpleCase.when(Expression<? extends C> condition,
R result) |
Add a when/then clause to the case expression.
|
AbstractQuery<T> |
AbstractQuery.where(Expression<Boolean> restriction) |
Modify the query to restrict the query results according
to the specified boolean expression.
|
CriteriaDelete<T> |
CriteriaDelete.where(Expression<Boolean> restriction) |
Modify the delete query to restrict the target of the deletion
according to the specified boolean expression.
|
CriteriaQuery<T> |
CriteriaQuery.where(Expression<Boolean> restriction) |
Modify the query to restrict the query result according
to the specified boolean expression.
|
CriteriaUpdate<T> |
CriteriaUpdate.where(Expression<Boolean> restriction) |
Modify the update query to restrict the target of the update
according to the specified boolean expression.
|
Subquery<T> |
Subquery.where(Expression<Boolean> restriction) |
Modify the subquery to restrict the result according
to the specified boolean expression.
|