The Java EE 7 Tutorial
40.1 Overview of the Criteria and Metamodel APIs
Similar to JPQL, the Criteria API is based on the abstract schema of persistent entities, their relationships, and embedded objects. The Criteria API operates on this abstract schema to allow developers to find, modify, and delete persistent entities by invoking Java Persistence API entity operations. The Metamodel API works in concert with the Criteria API to model persistent entity classes for Criteria queries.
The Criteria API and JPQL are closely related and are designed to allow similar operations in their queries. Developers familiar with JPQL syntax will find equivalent object-level operations in the Criteria API.
The following simple Criteria query returns all instances of the Pet
entity in the data source:
EntityManager em = ...; CriteriaBuilder cb = em.getCriteriaBuilder(); CriteriaQuery<Pet> cq = cb.createQuery(Pet.class); Root<Pet> pet = cq.from(Pet.class); cq.select(pet); TypedQuery<Pet> q = em.createQuery(cq); List<Pet> allPets = q.getResultList();
The equivalent JPQL query is
SELECT p FROM Pet p
This query demonstrates the basic steps to create a Criteria query.
-
Use an
EntityManager
instance to create aCriteriaBuilder
object. -
Create a query object by creating an instance of the
CriteriaQuery
interface. This query object's attributes will be modified with the details of the query. -
Set the query root by calling the
from
method on theCriteriaQuery
object. -
Specify what the type of the query result will be by calling the
select
method of theCriteriaQuery
object. -
Prepare the query for execution by creating a
TypedQuery<T>
instance, specifying the type of the query result. -
Execute the query by calling the
getResultList
method on theTypedQuery<T>
object. Because this query returns a collection of entities, the result is stored in aList
.
The tasks associated with each step are discussed in detail in this chapter.
To create a CriteriaBuilder
instance, call the getCriteriaBuilder
method on the EntityManager
instance:
CriteriaBuilder cb = em.getCriteriaBuilder();
Use the CriteriaBuilder
instance to create a query object:
CriteriaQuery<Pet> cq = cb.createQuery(Pet.class);
The query will return instances of the Pet
entity. To create a typesafe query, specify the type of the query when you create the CriteriaQuery
object.
Call the from
method of the query object to set the FROM
clause of the query and to specify the root of the query:
Root<Pet> pet = cq.from(Pet.class);
Call the select
method of the query object, passing in the query root, to set the SELECT
clause of the query:
cq.select(pet);
Now, use the query object to create a TypedQuery<T>
object that can be executed against the data source. The modifications to the query object are captured to create a ready-to-execute query:
TypedQuery<Pet> q = em.createQuery(cq);
Execute this typed query object by calling its getResultList
method, because this query will return multiple entity instances. The following statement stores the results in a List<Pet>
collection-valued object:
List<Pet> allPets = q.getResultList();