Spring Data支持的关键字
2021-04-23 10:27
标签：mes upper art starting tab des ESS body like Spring Data支持的关键字 标签：mes upper art starting tab des ESS body like 原文地址：https://www.cnblogs.com/xuruiming/p/13270149.html
关键字
方法命名
sql where字句
And
findByNameAndPwd
where name= ? and pwd =?
Or
findByNameOrSex
where name= ? or sex=?
Is,Equals
findById,findByIdEquals
where id= ?
Between
findByIdBetween
where id between ? and ?
LessThan
findByIdLessThan
where id
LessThanEquals
findByIdLessThanEquals
where id
GreaterThan
findByIdGreaterThan
where id > ?
GreaterThanEquals
findByIdGreaterThanEquals
where id > = ?
After
findByIdAfter
where id > ?
Before
findByIdBefore
where id
IsNull
findByNameIsNull
where name is null
isNotNull,NotNull
findByNameNotNull
where name is not null
Like
findByNameLike
where name like ?
NotLike
findByNameNotLike
where name not like ?
StartingWith
findByNameStartingWith
where name like ‘?%‘
EndingWith
findByNameEndingWith
where name like ‘%?‘
Containing
findByNameContaining
where name like ‘%?%‘
OrderBy
findByIdOrderByXDesc
where id=? order by x desc
Not
findByNameNot
where name ?
In
findByIdIn(Collection> c)
where id in (?)
NotIn
findByIdNotIn(Collection> c)
where id not in (?)
True
findByAaaTue
where aaa = true
False
findByAaaFalse
where aaa = false
IgnoreCase
findByNameIgnoreCase
where UPPER(name)=UPPER(?)
上一篇：Java学习之旅第4天
下一篇：Java虚拟机之自动内存管理机制