Spring Data JPA Query Methods
Spring Data JPA supports a way to create a query from the method name. Query methods are methods which are declared in the repository interface to perform CRUD operations on a database.
List of Query Methods Expressions
Keyword Expressions | Example |
And | findByFirstnameAndLastname(String firstname, String lastname) |
Or | Customer findByIdOrEmail(String id, String email) |
After, IsAfter | List<Customer> findByCreateDateAfter(LocalDateTime createdDate) |
Before, isBefore | List<Customer> findByCreateDateBefore(LocalDateTime createdDate) |
Containing, IsContaining, Contains | Customer findByFirstnameContaining(String firstname) |
Between, IsBetween | List<Customer> findByCreatedDateBetween(LocalDateTime createdDate, LocalDateTime createdDate) |
EndingWith, IsEndingWith, EndsWith | findByFirstnameEndingWith(String firstnameEndingWith) |
exists | existsByEmail(String email) |
False, IsFalse | findByEmailAndDeletedIsFalse(String email, boolean deleted) |
GreaterThan, IsGreaterThan | findByCreatedDateGreaterThan(LocalDateTime createdDate) |
GreaterThanEqual, IsGreaterThanEqual | findByCreatedDateGreaterThanEqual(LocalDateTime createdDate) |
In, IsIn | findByIdIn(List<String> ids) |
Is, Equals | findByDeletedIsTrue() |
IgnoreCase | findByFirstnameIqnoreCase(String firstname) |
Empty, IsEmpty | findByFirstnameEmpty() |
NotEmpty, IsNotEmpty | findByFirstnameNotEmpty() |
NotNull, IsNotNull | findByFirstnameNotNull() |
Null, IsNull | findByFirstnameNull() |
LessThan, IsLessThan | findByCreatedDateLessThan(LocalDateTime createdDate) |
LessThanEqual, IsLessThanEqual | findByCreatedDateLessThanEqual(LocalDateTime createdDate) |
Like, IsLike | findByFirstnameLike(String firstname) |
Near, IsNear | findByLocationNear(Point point) |
Not, IsNot | findByLastnameNot(String lastname) |
NotIn, IsNotIn | findByIdNotIn(String lastname) |
NotLike, IsNotLike | findByLastnameNotLike(String lastname) |
Regex, MatchesRegex, Matches | findByLastnameRegex(String regex) |
StartingWith, IsStartingWith, StartsWith | findByLastnameStartingWith(String startingWith) |
True, IsTrue | findByDeletedIsTrue() |
within, IsWithin | findByLocationWithin(Point point, Distance distance) |