JPA Criteria API with multiple parameters

by

Concept is to construct array of javax.persistence.Predicate which contains only predicates we want to use:

Example entity to be queried:

@Entity
public class A {
    @Id private Long id;    
    String someAttribute;
    String someOtherAttribute;
    ...
}

Query itself:

    //some parameters to your method
    String param1 = "1";
    String paramNull = null;

    CriteriaBuilder qb = em.getCriteriaBuilder();
    CriteriaQuery cq = qb.createQuery();
    Root<A> customer = cq.from(A.class);

    //Constructing list of parameters
    List<Predicate> predicates = new ArrayList<Predicate>();

    //Adding predicates in case of parameter not being null
    if (param1 != null) {
        predicates.add(
                qb.equal(customer.get("someAttribute"), param1));
    }
    if (paramNull != null) {
        predicates.add(
                qb.equal(customer.get("someOtherAttribute"), paramNull));
    }
    //query itself
    cq.select(customer)
            .where(predicates.toArray(new Predicate[]{}));
    //execute query and do something with result
    em.createQuery(cq).getResultList();

More Related Contents:

  1. JPA & Criteria API – Select only specific columns
  2. Using the JPA Criteria API, can you do a fetch join that results in only one join?
  3. Really dynamic JPA CriteriaBuilder
  4. How to return a custom object from a Spring Data JPA GROUP BY query
  5. Connection to Db dies after >4
  6. How to choose the id generation strategy when using JPA and Hibernate
  7. How to view the SQL queries issued by JPA?
  8. JPQL Create new Object In Select Statement – avoid or embrace?
  9. Hibernate, @SequenceGenerator and allocationSize
  10. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  11. “detached entity passed to persist error” with JPA/EJB code
  12. Spring Data JPA – “No Property Found for Type” Exception
  13. Please explain about insertable=false and updatable=false in reference to the JPA @Column annotation
  14. What is the easiest way to ignore a JPA field during persistence?
  15. @Transactional method called from another method doesn’t obtain a transaction
  16. Hibernate bidirectional @ManyToOne, updating the not owning side not working
  17. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  18. Single DAO & generic CRUD methods (JPA/Hibernate + Spring)
  19. Is there such thing CASE expression in JPQL?
  20. JPA Criteria builder IN clause query
  21. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  22. How to map a map JSON column to Java Object with JPA
  23. JPA: JOIN in JPQL
  24. JpaRepository caches newly created object. How to refresh it?
  25. HQL joined query to eager fetch a large number of relationships
  26. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  27. What properties does @Column columnDefinition make redundant?
  28. DAO and Service layers (JPA/Hibernate + Spring) [duplicate]
  29. org.hibernate.loader.MultipleBagFetchException: cannot simultaneously fetch multiple bags
  30. JPA Updating Bidirectional Association

Leave a Comment