Spring data jpa Supported keywords inside method names
来源:互联网 发布:网络私募 编辑:程序博客网 时间:2024/06/05 20:26
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)
阅读全文
0 0
- Spring data jpa Supported keywords inside method names
- Spring data jpa 自定义SQL语句遇到错误Not supported for DML operations
- Jpa到Spring data jpa
- Spring Data JPA
- Spring-Data-Jpa
- Spring Data JPA
- Spring data jpa
- Spring Data JPA 使用
- Spring Data JPA
- Spring Data JPA
- spring data JPA 配置
- Spring Data JPA
- Spring Jpa Data
- spring-data-jpa 使用
- spring data jpa初试
- Spring Data jpa Repository
- spring data JPA 配置
- spring Data Jpa入门
- supervisor
- C#图像处理(各种旋转、改变大小、柔化、锐化、雾化、底片、浮雕、黑白、滤镜效果)
- 机器学习算法原理与编程学习(2)
- 逆向工程核心原理学习笔记(二):字符串检索法查找main函数
- 四大主流新闻App竞品分析
- Spring data jpa Supported keywords inside method names
- hdoj 2008
- 第一章 hadoop集群搭建
- 逆向工程核心原理学习笔记(三):检索API方法
- Java如何进行异常处理
- 《Python-第一个小程序》---购物车购物学习小例子
- DateTime总结
- DragDrop 注册失败的解决方法(详细,经过测试)
- linux sed命令详解