general java
[펌] JPA의 Repository 조회
'김용환'
2019. 10. 8. 01:28
맨날 까먹는 JPA의 Repository 조회 메소드 규칙은 다음과 같다.
https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#jpa.query-methods
Table 3. Supported keywords inside method namesKeyword | Sample | JPQL snippet |
---|
And
| findByLastnameAndFirstname
| … where x.lastname = ?1 and x.firstname = ?2
|
Or
| findByLastnameOrFirstname
| … where x.lastname = ?1 or x.firstname = ?2
|
Is , Equals
| findByFirstname ,findByFirstnameIs ,findByFirstnameEquals
| … where x.firstname = ?1
|
Between
| findByStartDateBetween
| … where x.startDate between ?1 and ?2
|
LessThan
| findByAgeLessThan
| … where x.age < ?1
|
LessThanEqual
| findByAgeLessThanEqual
| … where x.age <= ?1
|
GreaterThan
| findByAgeGreaterThan
| … where x.age > ?1
|
GreaterThanEqual
| findByAgeGreaterThanEqual
| … where x.age >= ?1
|
After
| findByStartDateAfter
| … where x.startDate > ?1
|
Before
| findByStartDateBefore
| … where x.startDate < ?1
|
IsNull , Null
| findByAge(Is)Null
| … where x.age is null
|
IsNotNull , NotNull
| findByAge(Is)NotNull
| … where x.age not null
|
Like
| findByFirstnameLike
| … where x.firstname like ?1
|
NotLike
| findByFirstnameNotLike
| … where x.firstname not like ?1
|
StartingWith
| findByFirstnameStartingWith
| … where x.firstname like ?1 (parameter bound with appended % )
|
EndingWith
| findByFirstnameEndingWith
| … where x.firstname like ?1 (parameter bound with prepended % )
|
Containing
| findByFirstnameContaining
| … where x.firstname like ?1 (parameter bound wrapped in % )
|
OrderBy
| findByAgeOrderByLastnameDesc
| … where x.age = ?1 order by x.lastname desc
|
Not
| findByLastnameNot
| … where x.lastname <> ?1
|
In
| findByAgeIn(Collection<Age> ages)
| … where x.age in ?1
|
NotIn
| findByAgeNotIn(Collection<Age> ages)
| … where x.age not in ?1
|
True
| findByActiveTrue()
| … where x.active = true
|
False
| findByActiveFalse()
| … where x.active = false
|
IgnoreCase
| findByFirstnameIgnoreCase
| … where UPPER(x.firstame) = UPPER(?1)
|