Spring Data JPA: Query by Example?

by

This is now possible with Spring Data. Check out http://docs.spring.io/spring-data/jpa/docs/current/reference/html/#query-by-example

Person person = new Person();                         
person.setLastname("Smith");                          
Example<Person> example = Example.of(person);
List<Person> results = personRepository.findAll(example);

Note that this requires very recent 2016 versions

    <dependency>
        <groupId>org.springframework.data</groupId>
        <artifactId>spring-data-jpa</artifactId>
        <version>1.10.1.RELEASE</version>       
    </dependency>
    <dependency>
        <groupId>org.springframework.data</groupId>
        <artifactId>spring-data-commons</artifactId>
        <version>1.12.1.RELEASE</version>
    </dependency>

see https://github.com/paulvi/com.example.spring.findbyexample

More Related Contents:

  1. Dynamic spring data jpa repository query with arbitrary AND clauses
  2. setMaxResults for Spring-Data-JPA annotation?
  3. Using generics in Spring Data JPA repositories
  4. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  5. Handling soft-deletes with Spring JPA
  6. Filtering database rows with spring-data-jpa and spring-mvc
  7. Spring CrudRepository findByInventoryIds(List inventoryIdList) – equivalent to IN clause
  8. Spring-Data FETCH JOIN with Paging is not working
  9. Why use returned instance after save() on Spring Data JPA Repository?
  10. How to use @Transactional with Spring Data?
  11. Spring Data JPA: query ManyToMany
  12. How to store @Query sql in external file for CrudRepository?
  13. Spring Data – Multi-column searches
  14. Spring Data JPA find by embedded object property
  15. Missing CrudRepository#findOne method
  16. How to enable LockModeType.PESSIMISTIC_WRITE when looking up entities with Spring Data JPA?
  17. Best way of handling entities inheritance in Spring Data JPA
  18. Spring Data + JPA with multiple datasources but only one set of Repositories
  19. Spring Data JPA – Is it possible to sort on a calculated property?
  20. Spring-Data-Jpa Repository – Underscore on Entity Column Name
  21. What’s the difference between Spring Data’s MongoTemplate and MongoRepository?
  22. How to maintain bi-directional relationships with Spring Data REST and JPA?
  23. Implementing custom methods of Spring Data repository and exposing them through REST
  24. How to do a Mongo aggregation query in Spring Data?
  25. Java SE + Spring Data + Hibernate
  26. Filtering data with Spring boot CrudRepository
  27. Use abstract super class as parameter for Spring data repository
  28. Are you supposed to have one repository per table in JPA?
  29. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  30. How to instrument / advice a Spring Data (JPA) repository?

Leave a Comment