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