spring-data-jpa Repositories Finding all instances of an entity class with an attribute matching a specified value
Example
All instances of an entity class with one of the class attributes matching a specified value can be retrieved as follows:
public interface FooRepository extends CrudRepository<Foo, Long> {
List<Foo> findAllByName(String name);
}
Invoking the findAllByName method results in the JPA query select foo from Foo foo where foo.name = :name will be executed on the underlying database.
Points to note
namemust be an attribute on theFooentity class.- The method name must begin with
find,getorread. Other keywords likeselectwill not work. - There is no guarantee on the order in which the results will be returned.
