Really dynamic JPA CriteriaBuilder

by

You can pass an array of predicates to the CriteriaBuilder, deciding on equal or like as you go. For this, build a list and pack the contents of the list into an array in a single and statement. Like this: 

final List<Predicate> predicates = new ArrayList<Predicate>();

for (final Entry<String, String> e : myPredicateMap.entrySet()) {

    final String key = e.getKey();
    final String value = e.getValue();

    if ((key != null) && (value != null)) {

        if (value.contains("%")) {
            predicates.add(criteriaBuilder.like(root.<String> get(key), value));
        } else {
            predicates.add(criteriaBuilder.equal(root.get(key), value));
        }
    }
}

query.where(criteriaBuilder.and(predicates.toArray(new Predicate[predicates.size()])));
query.select(count);

In case you need to distingiush between and and or, use two lists.

More Related Contents:

  1. JPA CascadeType.ALL does not delete orphans
  2. How can I validate two or more fields in combination?
  3. Storing a Map using JPA
  4. How to properly express JPQL “join fetch” with “where” clause as JPA 2 CriteriaQuery?
  5. Hibernate – @ElementCollection – Strange delete/insert behavior
  6. JPA: unidirectional many-to-one and cascading delete
  7. JPA Query selecting only specific columns without using Criteria Query?
  8. JPA & Criteria API – Select only specific columns
  9. JPA/Hibernate Static Metamodel Attributes not Populated — NullPointerException
  10. JPA Criteria API – How to add JOIN clause (as general sentence as possible)
  11. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  12. Silently ignored remove()
  13. JPA Criteria builder IN clause query
  14. How to define unidirectional OneToMany relationship in JPA
  15. Hibernate generates negative id values when using a sequence
  16. Using the JPA Criteria API, can you do a fetch join that results in only one join?
  17. java.lang.IllegalStateException: Multiple representations of the same entity with @ManyToMany 3 entities
  18. JPA Criteria API with multiple parameters
  19. Rollback on every checked exception, whenever I say @Transactional
  20. Hibernate triggering constraint violations using orphanRemoval
  21. JPA Criteria Tutorial [closed]
  22. Change Table Name of an Entity on runtime? [duplicate]
  23. JPA Select latest instance for each item
  24. Hibernate throws MultipleBagFetchException – cannot simultaneously fetch multiple bags
  25. How to store date/time and timestamps in UTC time zone with JPA and Hibernate
  26. How to create and handle composite primary key in JPA
  27. JPA entity without id
  28. MappedSuperclass – Change SequenceGenerator in Subclass
  29. Large Objects may not be used in auto-commit mode
  30. How to configure transaction management for working with 2 different db in Spring?

Leave a Comment