JpaRepository 命名规范

最新推荐文章于 2025-09-17 16:39:25 发布

原创最新推荐文章于 2025-09-17 16:39:25 发布 · 4.2k 阅读

4 ·

CC 4.0 BY-SA版权

JPA 专栏收录该内容

2 篇文章

订阅专栏

本文总结了使用JPQL进行数据库查询的各种方法，包括条件查询、范围查询、排序等，并提供了对应的JPQL语句示例。适合希望提高数据库操作效率的开发者阅读。

                    
                        
                    
                    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