The CriteriaBuilder interface defines additional methods for creating expressions. These methods correspond to the arithmetic, string, date, time, and case operators and functions of JPQL.
Table 22–2 Conditional Methods in the CriteriaBuilder Interface
Conditional Method |
Description |
---|---|
equal |
Tests whether two expressions are equal. |
notEqual |
Tests whether two expressions are not equal. |
gt |
Tests whether the first numeric expression is greater than the second numeric expression. |
ge |
Tests whether the first numeric expression is greater than or equal to the second numeric expression. |
lt |
Tests whether the first numeric expression is less than the second numeric expression. |
le |
Tests whether the first numeric expression is less than or equal to the second numeric expression. |
between |
Tests whether the first expression is between the second and third expression in value. |
like |
Tests whether the expression matches a given pattern. |
CriteriaQuery<Pet> cq = cb.createQuery(Pet.class); Metamodel m = em.getMetamodel(); EntityType<Pet> Pet_ = m.entity(Pet.class); Root<Pet> pet = cq.from(Pet.class); cq.where(cb.equal(pet.get(Pet_.name)), "Fido"); ...
CriteriaQuery<Pet> cq = cb.createQuery(Pet.class); Metamodel m = em.getMetamodel(); EntityType<Pet> Pet_ = m.entity(Pet.class); Root<Pet> pet = cq.from(Pet.class); Date someDate = new Date(...); cq.where(cb.gt(pet.get(Pet_.birthday)), date);
CriteriaQuery<Pet> cq = cb.createQuery(Pet.class); Metamodel m = em.getMetamodel(); EntityType<Pet> Pet_ = m.entity(Pet.class); Root<Pet> pet = cq.from(Pet.class); Date firstDate = new Date(...); Date secondDate = new Date(...); cq.where(cb.between(pet.get(Pet_.birthday)), firstDate, secondDate);
CriteriaQuery<Pet> cq = cb.createQuery(Pet.class); Metamodel m = em.getMetamodel(); EntityType<Pet> Pet_ = m.entity(Pet.class); Root<Pet> pet = cq.from(Pet.class); cq.where(cb.like(pet.get(Pet_.name)), "*do");
Multiple conditional predicates can be specified by using the compound predicate methods of the CriteriaBuilder interface.
Table 22–3 Compound Predicate Methods in the CriteriaBuilder Interface
Method |
Description |
---|---|
and |
A logical conjunction of two boolean expressions. |
or |
A logical disjunction of two boolean expressions. |
not |
A logical negation of the given boolean expression. |
CriteriaQuery<Pet> cq = cb.createQuery(Pet.class); Metamodel m = em.getMetamodel(); EntityType<Pet> Pet_ = m.entity(Pet.class); Root<Pet> pet = cq.from(Pet.class); cq.where(cb.equal(pet.get(Pet_.name), "Fido") .and(cb.equal(pet.get(Pet_.color), "brown");