javax.persistence.criteria
Interface CriteriaBuilder
public interface CriteriaBuilder
Method Summary |
|
abs(Expression<N> x)
|
|
all(Subquery<Y> subquery)
|
Predicate |
and(Expression<Boolean> x,
Expression<Boolean> y)
|
Predicate |
and(Predicate... restrictions)
|
|
any(Subquery<Y> subquery)
|
CompoundSelection<Object[]> |
array(Selection<?>... selections)
|
Order |
asc(Expression<?> x)
|
|
avg(Expression<N> x)
|
|
between(Expression<? extends Y> v,
Expression<? extends Y> x,
Expression<? extends Y> y)
|
|
between(Expression<? extends Y> v,
Y x,
Y y)
|
|
coalesce()
|
|
coalesce(Expression<? extends Y> x,
Expression<? extends Y> y)
|
|
coalesce(Expression<? extends Y> x,
Y y)
|
Expression<String> |
concat(Expression<String> x,
Expression<String> y)
|
Expression<String> |
concat(Expression<String> x,
String y)
|
Expression<String> |
concat(String x,
Expression<String> y)
|
Predicate |
conjunction()
|
|
construct(Class<Y> resultClass,
Selection<?>... selections)
|
Expression<Long> |
count(Expression<?> x)
|
Expression<Long> |
countDistinct(Expression<?> x)
|
CriteriaQuery<Object> |
createQuery()
|
|
createQuery(Class<T> resultClass)
|
CriteriaQuery<Tuple> |
createTupleQuery()
|
Expression<Date> |
currentDate()
|
Expression<Time> |
currentTime()
|
Expression<Timestamp> |
currentTimestamp()
|
Order |
desc(Expression<?> x)
|
|
diff(Expression<? extends N> x,
Expression<? extends N> y)
|
|
diff(Expression<? extends N> x,
N y)
|
|
diff(N x,
Expression<? extends N> y)
|
Predicate |
disjunction()
|
Predicate |
equal(Expression<?> x,
Expression<?> y)
|
Predicate |
equal(Expression<?> x,
Object y)
|
Predicate |
exists(Subquery<?> subquery)
|
|
function(String name,
Class<T> type,
Expression<?>... args)
|
Predicate |
ge(Expression<? extends Number> x,
Expression<? extends Number> y)
|
Predicate |
ge(Expression<? extends Number> x,
Number y)
|
|
greaterThan(Expression<? extends Y> x,
Expression<? extends Y> y)
|
|
greaterThan(Expression<? extends Y> x,
Y y)
|
|
greaterThanOrEqualTo(Expression<? extends Y> x,
Expression<? extends Y> y)
|
|
greaterThanOrEqualTo(Expression<? extends Y> x,
Y y)
|
|
greatest(Expression<X> x)
|
Predicate |
gt(Expression<? extends Number> x,
Expression<? extends Number> y)
|
Predicate |
gt(Expression<? extends Number> x,
Number y)
|
|
in(Expression<? extends T> expression)
|
|
isEmpty(Expression<C> collection)
|
Predicate |
isFalse(Expression<Boolean> x)
|
|
isMember(E elem,
Expression<C> collection)
|
|
isMember(Expression<E> elem,
Expression<C> collection)
|
|
isNotEmpty(Expression<C> collection)
|
|
isNotMember(E elem,
Expression<C> collection)
|
|
isNotMember(Expression<E> elem,
Expression<C> collection)
|
Predicate |
isNotNull(Expression<?> x)
|
Predicate |
isNull(Expression<?> x)
|
Predicate |
isTrue(Expression<Boolean> x)
|
|
keys(M map)
|
Predicate |
le(Expression<? extends Number> x,
Expression<? extends Number> y)
|
Predicate |
le(Expression<? extends Number> x,
Number y)
|
|
least(Expression<X> x)
|
Expression<Integer> |
length(Expression<String> x)
|
|
lessThan(Expression<? extends Y> x,
Expression<? extends Y> y)
|
|
lessThan(Expression<? extends Y> x,
Y y)
|
|
lessThanOrEqualTo(Expression<? extends Y> x,
Expression<? extends Y> y)
|
|
lessThanOrEqualTo(Expression<? extends Y> x,
Y y)
|
Predicate |
like(Expression<String> x,
Expression<String> pattern)
|
Predicate |
like(Expression<String> x,
Expression<String> pattern,
char escapeChar)
|
Predicate |
like(Expression<String> x,
Expression<String> pattern,
Expression<Character> escapeChar)
|
Predicate |
like(Expression<String> x,
String pattern)
|
Predicate |
like(Expression<String> x,
String pattern,
char escapeChar)
|
Predicate |
like(Expression<String> x,
String pattern,
Expression<Character> escapeChar)
|
|
literal(T value)
|
Expression<Integer> |
locate(Expression<String> x,
Expression<String> pattern)
|
Expression<Integer> |
locate(Expression<String> x,
Expression<String> pattern,
Expression<Integer> from)
|
Expression<Integer> |
locate(Expression<String> x,
String pattern)
|
Expression<Integer> |
locate(Expression<String> x,
String pattern,
int from)
|
Expression<String> |
lower(Expression<String> x)
|
Predicate |
lt(Expression<? extends Number> x,
Expression<? extends Number> y)
|
Predicate |
lt(Expression<? extends Number> x,
Number y)
|
|
max(Expression<N> x)
|
|
min(Expression<N> x)
|
Expression<Integer> |
mod(Expression<Integer> x,
Expression<Integer> y)
|
Expression<Integer> |
mod(Expression<Integer> x,
Integer y)
|
Expression<Integer> |
mod(Integer x,
Expression<Integer> y)
|
|
neg(Expression<N> x)
|
Predicate |
not(Expression<Boolean> restriction)
|
Predicate |
notEqual(Expression<?> x,
Expression<?> y)
|
Predicate |
notEqual(Expression<?> x,
Object y)
|
Predicate |
notLike(Expression<String> x,
Expression<String> pattern)
|
Predicate |
notLike(Expression<String> x,
Expression<String> pattern,
char escapeChar)
|
Predicate |
notLike(Expression<String> x,
Expression<String> pattern,
Expression<Character> escapeChar)
|
Predicate |
notLike(Expression<String> x,
String pattern)
|
Predicate |
notLike(Expression<String> x,
String pattern,
char escapeChar)
|
Predicate |
notLike(Expression<String> x,
String pattern,
Expression<Character> escapeChar)
|
|
nullif(Expression<Y> x,
Expression<?> y)
|
|
nullif(Expression<Y> x,
Y y)
|
|
nullLiteral(Class<T> resultClass)
|
Predicate |
or(Expression<Boolean> x,
Expression<Boolean> y)
|
Predicate |
or(Predicate... restrictions)
|
|
parameter(Class<T> paramClass)
|
|
parameter(Class<T> paramClass,
String name)
|
|
prod(Expression<? extends N> x,
Expression<? extends N> y)
|
|
prod(Expression<? extends N> x,
N y)
|
|
prod(N x,
Expression<? extends N> y)
|
Expression<Number> |
quot(Expression<? extends Number> x,
Expression<? extends Number> y)
|
Expression<Number> |
quot(Expression<? extends Number> x,
Number y)
|
Expression<Number> |
quot(Number x,
Expression<? extends Number> y)
|
|
selectCase()
|
|
selectCase(Expression<? extends C> expression)
|
|
size(C collection)
|
|
size(Expression<C> collection)
|
|
some(Subquery<Y> subquery)
|
Expression<Double> |
sqrt(Expression<? extends Number> x)
|
Expression<String> |
substring(Expression<String> x,
Expression<Integer> from)
|
Expression<String> |
substring(Expression<String> x,
Expression<Integer> from,
Expression<Integer> len)
|
Expression<String> |
substring(Expression<String> x,
int from)
|
Expression<String> |
substring(Expression<String> x,
int from,
int len)
|
|
sum(Expression<? extends N> x,
Expression<? extends N> y)
|
|
sum(Expression<? extends N> x,
N y)
|
|
sum(Expression<N> x)
|
|
sum(N x,
Expression<? extends N> y)
|
Expression<Double> |
sumAsDouble(Expression<Float> x)
|
Expression<Long> |
sumAsLong(Expression<Integer> x)
|
Expression<BigDecimal> |
toBigDecimal(Expression<? extends Number> number)
|
Expression<BigInteger> |
toBigInteger(Expression<? extends Number> number)
|
Expression<Double> |
toDouble(Expression<? extends Number> number)
|
Expression<Float> |
toFloat(Expression<? extends Number> number)
|
Expression<Integer> |
toInteger(Expression<? extends Number> number)
|
Expression<Long> |
toLong(Expression<? extends Number> number)
|
Expression<String> |
toString(Expression<Character> character)
|
Expression<String> |
trim(char t,
Expression<String> x)
|
Expression<String> |
trim(CriteriaBuilder.Trimspec ts,
char t,
Expression<String> x)
|
Expression<String> |
trim(CriteriaBuilder.Trimspec ts,
Expression<Character> t,
Expression<String> x)
|
Expression<String> |
trim(CriteriaBuilder.Trimspec ts,
Expression<String> x)
|
Expression<String> |
trim(Expression<Character> t,
Expression<String> x)
|
Expression<String> |
trim(Expression<String> x)
|
CompoundSelection<Tuple> |
tuple(Selection<?>... selections)
|
Expression<String> |
upper(Expression<String> x)
|
|
values(M map)
|
createQuery
CriteriaQuery<Object> createQuery()
createQuery
<T> CriteriaQuery<T> createQuery(Class<T> resultClass)
createTupleQuery
CriteriaQuery<Tuple> createTupleQuery()
construct
<Y> CompoundSelection<Y> construct(Class<Y> resultClass,
Selection<?>... selections)
tuple
CompoundSelection<Tuple> tuple(Selection<?>... selections)
array
CompoundSelection<Object[]> array(Selection<?>... selections)
asc
Order asc(Expression<?> x)
desc
Order desc(Expression<?> x)
avg
<N extends Number> Expression<Double> avg(Expression<N> x)
sum
<N extends Number> Expression<N> sum(Expression<N> x)
sumAsLong
Expression<Long> sumAsLong(Expression<Integer> x)
sumAsDouble
Expression<Double> sumAsDouble(Expression<Float> x)
max
<N extends Number> Expression<N> max(Expression<N> x)
min
<N extends Number> Expression<N> min(Expression<N> x)
greatest
<X extends Comparable<? super X>> Expression<X> greatest(Expression<X> x)
least
<X extends Comparable<? super X>> Expression<X> least(Expression<X> x)
count
Expression<Long> count(Expression<?> x)
countDistinct
Expression<Long> countDistinct(Expression<?> x)
exists
Predicate exists(Subquery<?> subquery)
all
<Y> Expression<Y> all(Subquery<Y> subquery)
some
<Y> Expression<Y> some(Subquery<Y> subquery)
any
<Y> Expression<Y> any(Subquery<Y> subquery)
and
Predicate and(Expression<Boolean> x,
Expression<Boolean> y)
and
Predicate and(Predicate... restrictions)
or
Predicate or(Expression<Boolean> x,
Expression<Boolean> y)
or
Predicate or(Predicate... restrictions)
not
Predicate not(Expression<Boolean> restriction)
conjunction
Predicate conjunction()
disjunction
Predicate disjunction()
isTrue
Predicate isTrue(Expression<Boolean> x)
isFalse
Predicate isFalse(Expression<Boolean> x)
isNull
Predicate isNull(Expression<?> x)
isNotNull
Predicate isNotNull(Expression<?> x)
equal
Predicate equal(Expression<?> x,
Expression<?> y)
equal
Predicate equal(Expression<?> x,
Object y)
notEqual
Predicate notEqual(Expression<?> x,
Expression<?> y)
notEqual
Predicate notEqual(Expression<?> x,
Object y)
greaterThan
<Y extends Comparable<? super Y>> Predicate greaterThan(Expression<? extends Y> x,
Expression<? extends Y> y)
greaterThan
<Y extends Comparable<? super Y>> Predicate greaterThan(Expression<? extends Y> x,
Y y)
greaterThanOrEqualTo
<Y extends Comparable<? super Y>> Predicate greaterThanOrEqualTo(Expression<? extends Y> x,
Expression<? extends Y> y)
greaterThanOrEqualTo
<Y extends Comparable<? super Y>> Predicate greaterThanOrEqualTo(Expression<? extends Y> x,
Y y)
lessThan
<Y extends Comparable<? super Y>> Predicate lessThan(Expression<? extends Y> x,
Expression<? extends Y> y)
lessThan
<Y extends Comparable<? super Y>> Predicate lessThan(Expression<? extends Y> x,
Y y)
lessThanOrEqualTo
<Y extends Comparable<? super Y>> Predicate lessThanOrEqualTo(Expression<? extends Y> x,
Expression<? extends Y> y)
lessThanOrEqualTo
<Y extends Comparable<? super Y>> Predicate lessThanOrEqualTo(Expression<? extends Y> x,
Y y)
between
<Y extends Comparable<? super Y>> Predicate between(Expression<? extends Y> v,
Expression<? extends Y> x,
Expression<? extends Y> y)
between
<Y extends Comparable<? super Y>> Predicate between(Expression<? extends Y> v,
Y x,
Y y)
gt
Predicate gt(Expression<? extends Number> x,
Expression<? extends Number> y)
gt
Predicate gt(Expression<? extends Number> x,
Number y)
ge
Predicate ge(Expression<? extends Number> x,
Expression<? extends Number> y)
ge
Predicate ge(Expression<? extends Number> x,
Number y)
lt
Predicate lt(Expression<? extends Number> x,
Expression<? extends Number> y)
lt
Predicate lt(Expression<? extends Number> x,
Number y)
le
Predicate le(Expression<? extends Number> x,
Expression<? extends Number> y)
le
Predicate le(Expression<? extends Number> x,
Number y)
neg
<N extends Number> Expression<N> neg(Expression<N> x)
abs
<N extends Number> Expression<N> abs(Expression<N> x)
sum
<N extends Number> Expression<N> sum(Expression<? extends N> x,
Expression<? extends N> y)
sum
<N extends Number> Expression<N> sum(Expression<? extends N> x,
N y)
sum
<N extends Number> Expression<N> sum(N x,
Expression<? extends N> y)
prod
<N extends Number> Expression<N> prod(Expression<? extends N> x,
Expression<? extends N> y)
prod
<N extends Number> Expression<N> prod(Expression<? extends N> x,
N y)
prod
<N extends Number> Expression<N> prod(N x,
Expression<? extends N> y)
diff
<N extends Number> Expression<N> diff(Expression<? extends N> x,
Expression<? extends N> y)
diff
<N extends Number> Expression<N> diff(Expression<? extends N> x,
N y)
diff
<N extends Number> Expression<N> diff(N x,
Expression<? extends N> y)
quot
Expression<Number> quot(Expression<? extends Number> x,
Expression<? extends Number> y)
quot
Expression<Number> quot(Expression<? extends Number> x,
Number y)
quot
Expression<Number> quot(Number x,
Expression<? extends Number> y)
mod
Expression<Integer> mod(Expression<Integer> x,
Expression<Integer> y)
mod
Expression<Integer> mod(Expression<Integer> x,
Integer y)
mod
Expression<Integer> mod(Integer x,
Expression<Integer> y)
sqrt
Expression<Double> sqrt(Expression<? extends Number> x)
toLong
Expression<Long> toLong(Expression<? extends Number> number)
toInteger
Expression<Integer> toInteger(Expression<? extends Number> number)
toFloat
Expression<Float> toFloat(Expression<? extends Number> number)
toDouble
Expression<Double> toDouble(Expression<? extends Number> number)
toBigDecimal
Expression<BigDecimal> toBigDecimal(Expression<? extends Number> number)
toBigInteger
Expression<BigInteger> toBigInteger(Expression<? extends Number> number)
toString
Expression<String> toString(Expression<Character> character)
literal
<T> Expression<T> literal(T value)
nullLiteral
<T> Expression<T> nullLiteral(Class<T> resultClass)
parameter
<T> ParameterExpression<T> parameter(Class<T> paramClass)
parameter
<T> ParameterExpression<T> parameter(Class<T> paramClass,
String name)
isEmpty
<C extends Collection<?>> Predicate isEmpty(Expression<C> collection)
isNotEmpty
<C extends Collection<?>> Predicate isNotEmpty(Expression<C> collection)
size
<C extends Collection<?>> Expression<Integer> size(Expression<C> collection)
size
<C extends Collection<?>> Expression<Integer> size(C collection)
isMember
<E,C extends Collection<E>> Predicate isMember(Expression<E> elem,
Expression<C> collection)
isMember
<E,C extends Collection<E>> Predicate isMember(E elem,
Expression<C> collection)
isNotMember
<E,C extends Collection<E>> Predicate isNotMember(Expression<E> elem,
Expression<C> collection)
isNotMember
<E,C extends Collection<E>> Predicate isNotMember(E elem,
Expression<C> collection)
values
<V,M extends Map<?,V>> Expression<Collection<V>> values(M map)
keys
<K,M extends Map<K,?>> Expression<Set<K>> keys(M map)
like
Predicate like(Expression<String> x,
Expression<String> pattern)
like
Predicate like(Expression<String> x,
String pattern)
like
Predicate like(Expression<String> x,
Expression<String> pattern,
Expression<Character> escapeChar)
like
Predicate like(Expression<String> x,
Expression<String> pattern,
char escapeChar)
like
Predicate like(Expression<String> x,
String pattern,
Expression<Character> escapeChar)
like
Predicate like(Expression<String> x,
String pattern,
char escapeChar)
notLike
Predicate notLike(Expression<String> x,
Expression<String> pattern)
notLike
Predicate notLike(Expression<String> x,
String pattern)
notLike
Predicate notLike(Expression<String> x,
Expression<String> pattern,
Expression<Character> escapeChar)
notLike
Predicate notLike(Expression<String> x,
Expression<String> pattern,
char escapeChar)
notLike
Predicate notLike(Expression<String> x,
String pattern,
Expression<Character> escapeChar)
notLike
Predicate notLike(Expression<String> x,
String pattern,
char escapeChar)
concat
Expression<String> concat(Expression<String> x,
Expression<String> y)
concat
Expression<String> concat(Expression<String> x,
String y)
concat
Expression<String> concat(String x,
Expression<String> y)
substring
Expression<String> substring(Expression<String> x,
Expression<Integer> from)
substring
Expression<String> substring(Expression<String> x,
int from)
substring
Expression<String> substring(Expression<String> x,
Expression<Integer> from,
Expression<Integer> len)
substring
Expression<String> substring(Expression<String> x,
int from,
int len)
trim
Expression<String> trim(Expression<String> x)
trim
Expression<String> trim(CriteriaBuilder.Trimspec ts,
Expression<String> x)
trim
Expression<String> trim(Expression<Character> t,
Expression<String> x)
trim
Expression<String> trim(CriteriaBuilder.Trimspec ts,
Expression<Character> t,
Expression<String> x)
trim
Expression<String> trim(char t,
Expression<String> x)
trim
Expression<String> trim(CriteriaBuilder.Trimspec ts,
char t,
Expression<String> x)
lower
Expression<String> lower(Expression<String> x)
upper
Expression<String> upper(Expression<String> x)
length
Expression<Integer> length(Expression<String> x)
locate
Expression<Integer> locate(Expression<String> x,
Expression<String> pattern)
locate
Expression<Integer> locate(Expression<String> x,
String pattern)
locate
Expression<Integer> locate(Expression<String> x,
Expression<String> pattern,
Expression<Integer> from)
locate
Expression<Integer> locate(Expression<String> x,
String pattern,
int from)
currentDate
Expression<Date> currentDate()
currentTimestamp
Expression<Timestamp> currentTimestamp()
currentTime
Expression<Time> currentTime()
in
<T> CriteriaBuilder.In<T> in(Expression<? extends T> expression)
coalesce
<Y> Expression<Y> coalesce(Expression<? extends Y> x,
Expression<? extends Y> y)
coalesce
<Y> Expression<Y> coalesce(Expression<? extends Y> x,
Y y)
nullif
<Y> Expression<Y> nullif(Expression<Y> x,
Expression<?> y)
nullif
<Y> Expression<Y> nullif(Expression<Y> x,
Y y)
coalesce
<T> CriteriaBuilder.Coalesce<T> coalesce()
selectCase
<C,R> CriteriaBuilder.SimpleCase<C,R> selectCase(Expression<? extends C> expression)
selectCase
<R> CriteriaBuilder.Case<R> selectCase()
function
<T> Expression<T> function(String name,
Class<T> type,
Expression<?>... args)
Copyright © 2003-2011 The Apache Software Foundation. All Rights Reserved.