keyword in Jpa

最新推荐文章于 2024-07-08 16:16:33 发布

转载最新推荐文章于 2024-07-08 16:16:33 发布 · 1k 阅读

spring mvc 专栏收录该内容

18 篇文章

订阅专栏

本文详细解析了JPQL查询中各种操作符的用法，包括逻辑运算符、比较运算符、区间运算符、数值运算符等，并通过具体示例展示了如何在实际应用中运用这些查询技巧。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Keyword Sample JPQL snippet
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.age < ?1
GreaterThan findByAgeGreaterThan… where x.age > ?1
After findByStartDateAfter… where x.startDate > ?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 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> age)… where x.age not in ?1
True findByActiveTrue()… where x.active = true
False findByActiveFalse()… where x.active = false