Spring-data-JPA生成JPQL语句方法名称中支持的关键字
来源:互联网 发布:平板淘宝怎么换皮肤 编辑:程序博客网 时间:2024/05/24 03:53
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)
官方文档:http://docs.spring.io/spring-data/jpa/docs/current/reference/html/
- Spring-data-JPA生成JPQL语句方法名称中支持的关键字
- Spring Data JPA 在方法名中支持的关键字
- spirng data jpa查询中支持的关键字
- jpa使用jpql,在程序中使用jpql语句的in
- spring-data-jpa hiberneate 中 uui的生成策略
- JPA JPQL 语句
- jpa的Jpql语言和方法
- Spring Data JPA查询关键字
- SPRING DATA JPA 查询关键字
- spring data jpa中@Query中的模糊查询<like关键字>
- spring data jpa 的delete方法
- Spring-data-JPA查询方法的总结
- Spring data JPA 中IN的使用
- spring data jpa @Query注解中delete语句报错
- spring-data-jpa @Query注解中delete语句报错
- spring data jpa @Query注解中delete语句报错 : @Modifying注解的使用
- Spring-data-jpa生成表格失败的可能原因
- SpringBoot中使用Spring Data Jpa 实现简单的动态查询的两种方法
- Java面向对象之包装类
- Python创建虚拟环境
- Currency Exchange (Bellman-Ford算法,判断是否有正权回路)
- 文章标题
- JZOJ2017.08.08 C组
- Spring-data-JPA生成JPQL语句方法名称中支持的关键字
- git 提交到远程另外仓库
- linux学习常用命令
- 数据结构上机测试2-2:单链表操作B
- Caffe学习:pycaffe利用caffemodel进行分类=>批处理
- Ecology8二次开发:HTML表单隐藏行与显示行
- 99乘法表
- java线程笔记
- python3 mysql数据导出到excel