学习-spring data jpa
2024-09-05 13:17:11
spring data jpa对照表
Keyword | Sample | JPQL snippet |
---|---|---|
And | findByLastnameAndFirstname | … where x.lastname = ?1 and x.firstname = ?2 |
Or | findByLastnameOrFirstname | … where x.lastname = ?1 or x.firstname = ?2 |
Is,Equals | 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 nul |
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 ages) | … where x.age in ?1 |
NotIn | findByAgeNotIn(Collection 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) |
最新文章
- LINUX 下grep命令查找
- 安装中文版cacti监控华为交换机流量并实现95计费
- iOS 程序员 6 级考试(答案和解释)
- js 和 c# 方法互调
- ubuntu中安装Rstdio无法切换中文输入法
- cocos2d-x游戏开发系列教程-坦克大战游戏启动界面的编写
- [转]iOS Tutorial – Dumping the Application Heap from Memory
- OllyDBG V1.10聆风听雨汉化版
- FNV算法实战
- PHP AJAX 简介
- thinkpad彻底消除";触摸键盘";图标
- GOF23种设计模式概括
- HDU4899 Hero meet devil DP套DP
- Ubuntu 16.04 上安装 MySQL 5.7 教程
- eclipse打断点调试进入到class文件中,不显示变量值的解决办法汇总
- Docker容器学习梳理 - SSH方式登陆容器
- MVC开发中的常见错误-03-System.Data.Entity.Validation.DbEntityValidationException: 对一个或多个实体的验证失败。有关详细信息,请参见“EntityValidationErrors”属性。
- centos7管理用户权限
- php 正则获取字符串中的汉字preg_match_all
- win7下oracle的安装
热门文章
- Unity 插件宝典 (张忠喜 廖一庭 著)
- 数组去重--ES6方法
- 算法六Z自形变换
- Nginx Cache-Control
- win10怎么打开服务界面?
- Python platform 模块
- Flink,Storm,SparkStreaming性能对比
- 锁定文件失败,打不开磁盘“D:\biehl\centos\taotao\taotao-dubbo-register\CentOS-000001.vmdk”或它所依赖的某个快照磁盘。模块“Disk”启动失败。未能启动虚拟机
- WPF-如何添加用户控件(同一个程序集与非同一个程序集)
- Asp.Net Core 中的静态文件