tomcat7-jpa-named-queries.md

Title: JPA: Named queries Tags: jpa|jpa-namedqueries Date: 2013-02-17 09:39:07 -0500 Author: Denevell

On your entity class if you put this below the @Entity annotation,

@NamedQuery(name="listAll",query="select tings from AnotherThing tings")

Then that will get all the AnotherThings from all the AnotherThings objects in the system. You can call this via:

TypedQuery<AnotherThing> q = em.createNamedQuery("listAll", AnotherThing.class);
List<AnotherThing> results = q.getResultList();
for (AnotherThing thing : results) {
}

If, in the NamedQuery, you put parameters like ':username', then your code will look like:

em.createNamedQuery("nameOfQuery")
    .setParameter("username", "Luke Vibert")
    .getResultList();