Spring Data JPA 在方法名中支持的关键字
来源:互联网 发布:linux ping -s 编辑:程序博客网 时间:2024/05/13 17:56
From:点击这里
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
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
IgnoreCase
findByFirstnameIgnoreCase
… where UPPER(x.firstame) = UPPER(?1)
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
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
IgnoreCase
findByFirstnameIgnoreCase
… where UPPER(x.firstame) = UPPER(?1)
- Spring Data JPA 在方法名中支持的关键字
- Spring-data-JPA生成JPQL语句方法名称中支持的关键字
- spirng data jpa查询中支持的关键字
- 在spring data jpa中使用redis的通用list及entity存储方法
- spring data jpa 创建方法名进行简单查询
- Spring Data JPA根据属性名查询方法
- Spring Data JPA查询关键字
- SPRING DATA JPA 查询关键字
- Spring Date JPA 底层方法名对应关键字
- spring data jpa中@Query中的模糊查询<like关键字>
- spring data jpa 的delete方法
- Spring-data-JPA查询方法的总结
- Spring data JPA 中IN的使用
- 继续配置spring data jpa 在tomcat中
- SpringBoot中使用Spring Data Jpa 实现简单的动态查询的两种方法
- spring data jpa save 方法中,不能自动关联,新建的关联项
- Spring boot 中Spring data JPA的应用(一)
- jpa和spring data jpa的理解
- 画弧线填充描边与使用中心
- JVM的Classloader机制
- 背包问题
- 如何使用SyntaxNet进行中文模型的使用
- Leetcode 162. Find Peak Element
- Spring Data JPA 在方法名中支持的关键字
- 关于cocos2dx加载不到libcocos2dcpp.so
- UITabBar 设置选中、未选中状态下title的字体颜色
- Java 类型转换操作符
- 生理周期
- IMP-00032 IMP-00008
- 几种主流JSON技术的比较及简单的应用示例
- 2017年2月7日
- Python多线程跑Hive批一例