2.10.1.11. Named Queries
Query templates can be statically declared using the NamedQuery and NamedQueries annotations.
For example:
@Entity
@NamedQueries({
@NamedQuery(name="magsOverPrice",
query="SELECT x FROM Magazine x WHERE x.price ?1"),
@NamedQuery(name="magsByTitle",
query="SELECT x FROM Magazine x WHERE x.title = :titleParam")
})
public class Magazine {
...
}
These declarations will define two named queries called magsOverPrice and magsByTitle.
public Query createNamedQuery(String name);
You retrieve named queries with the above EntityManager method.
For example:
EntityManager em = ...
Query q = em.createNamedQuery("magsOverPrice");
q.setParameter(1, 5.0f);
ListMagazine results = (ListMagazine) q.getResultList();
EntityManager em = ...
Query q = em.createNamedQuery("magsByTitle");
q.setParameter("titleParam", "JDJ");
ListMagazine results = (ListMagazine) q.getResultList();