JpaRepository 命名规范

最新推荐文章于 2024-08-13 10:46:24 发布

heqianqiann

最新推荐文章于 2024-08-13 10:46:24 发布

阅读量4.1k

点赞数

分类专栏： JPA

本文链接：https://blog.csdn.net/Thousa_Ho/article/details/74355752

版权

JPA 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

                    
                        
                    
                    KeywordSampleJPQL
AndfindByLastnameAndFirstnamewhere x.lastname=?1 and x.firstname=?2
OrfindByLastnameOrFirstnamewhere x.lastname=?1 or x.firstname=?2
BetweenfindByStartDateBetweenwhere x.startDate between ?1 and ?2
LessThanfindByAgeLessThanwhere x.startDate < ?1
GreaterThanfindByAgeGreaterThanwhere x.startDate >?1
AfterfindByStartDateAfterwhere x.startDate >n ?1
BeforefindByStartDateBeforewhere x.startDate < ?1
IsNullfindByAgeIsNullwhere x.age is null
IsNotNull,NotNullfindByAge(Is)NotNullwhere x.age not null
LikefindByFirstnameLikewhere x.firstname like ?1
notLikefindByFirstnameNotLikewhere x.firstname not like ?1
StartingWithfindByFirstnameStartingWithXXXwhere x.firstname like ?1(parameter bound with appended %)
EndingWithfindByFirstnameEndingWithXXXwhere x.firstname like ?1(parameter bound with appended %)
ContainingfindByFirstnameContainingwhere x.firstname like ?1(parameter bound wrapped in %)
OrderByfindByAgeOrderByLastnamewhere x.age = ?1 order by x.lastname desc
NotfindByLastnameNotwhere x.lastname <> ?1
NotInfindByAgeNotIn(Collection age )where x.age not in ?1
TruefindByActiveTrue()where x.active = true
FalsefindByActiveFalse()where x.active = false

                

Keyword	Sample	JPQL
And	findByLastnameAndFirstname	where x.lastname=?1 and x.firstname=?2
Or	findByLastnameOrFirstname	where x.lastname=?1 or x.firstname=?2
Between	findByStartDateBetween	where x.startDate between ?1 and ?2
LessThan	findByAgeLessThan	where x.startDate < ?1
GreaterThan	findByAgeGreaterThan	where x.startDate >?1
After	findByStartDateAfter	where x.startDate >n ?1
Before	findByStartDateBefore	where x.startDate < ?1
IsNull	findByAgeIsNull	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	findByFirstnameStartingWithXXX	where x.firstname like ?1(parameter bound with appended %)
EndingWith	findByFirstnameEndingWithXXX	where x.firstname like ?1(parameter bound with appended %)
Containing	findByFirstnameContaining	where x.firstname like ?1(parameter bound wrapped in %)
OrderBy	findByAgeOrderByLastname	where x.age = ?1 order by x.lastname desc
Not	findByLastnameNot	where x.lastname <> ?1
NotIn	findByAgeNotIn(Collection age )	where x.age not in ?1
True	findByActiveTrue()	where x.active = true
False	findByActiveFalse()	where x.active = false