How to use named queries with JPA and JPQL

JPA Queries (6 Part Series)

1 SQL Select with IN clause from list with JPA
2 How to do a Select clause comparison of LocalDateTime in JPA
… 2 more parts…
3 How to use named queries with JPA and JPQL
4 How to use named parameters in JPA queries
5 Pagination with JPA queries
6 How to execute delete statements with jpa query

You can define several named queries on an entity by using the @NamedQueries and @NamedQuery annotations. For each named query you need to define a name and the jpql query itself:

import javax.persistence.*;

@Entity
@Access(AccessType.FIELD)
@Table(name = PartnerInitialLoad.TABLE_NAME)
@NamedQueries({
  @NamedQuery(
      name = FIND_MAX_PARTNERNUMMER,
      query = "select max(p.partnernummer) from PartnerInitialLoad p"),
  @NamedQuery(
      name = FIND_PARTNER_BY_STATUS,
      query =
          "select p from PartnerInitialLoad p where p.status = :status order by p.partnernummer asc")
})
public class PartnerInitialLoad {
  public static final String TABLE_NAME = "T_PARTNER_INITIAL_LOAD";

  public static final String FIND_MAX_PARTNERNUMMER = "findMaxPartnernummer";
  public static final String FIND_PARTNER_BY_STATUS = "findPartnerByStatus";

  public static final String PARAM_STATUS = "status"; //the value here has to match the one in jpql, here "status"

 // further entity details emitted for brevity
}

Enter fullscreen mode Exit fullscreen mode

Then use the named queries in your repository services. For that use the createNamedQuery method of the EntityManager,
which expects the name of the query you defined in the metadata, plus the type of the query result:

@Stateless
public class PartnerInitialLoadRepository {

  @Inject private EntityManager em;

  public List<PartnerInitialLoad> getPartnersByStatus(Integer chunkSize, String status) {
    var query =
        em.createNamedQuery(PartnerInitialLoad.FIND_UNPROCESSED_PARTNER, PartnerInitialLoad.class);
    query.setParameter(PartnerInitialLoad.PARAM_STATUS, status);
    query.setMaxResults(chunkSize);

    return query.getResultList();
  }

  public int getMaxPartnernummer() {
    var query = em.createNamedQuery(PartnerInitialLoad.FIND_MAX_PARTNERNUMMER, Integer.class);
    var singleResult = query.getSingleResult();

    return singleResult == null ? 0 : singleResult;
  }
}

Enter fullscreen mode Exit fullscreen mode

Shared with ️ from Codever. Use copy to mine functionality to add it to your personal snippets collection.

JPA Queries (6 Part Series)

1 SQL Select with IN clause from list with JPA
2 How to do a Select clause comparison of LocalDateTime in JPA
… 2 more parts…
3 How to use named queries with JPA and JPQL
4 How to use named parameters in JPA queries
5 Pagination with JPA queries
6 How to execute delete statements with jpa query

原文链接：How to use named queries with JPA and JPQL