Spring-Data-Jpa命名规范

最新推荐文章于 2023-11-13 11:29:29 发布

小马同学

最新推荐文章于 2023-11-13 11:29:29 发布

阅读量5.7k

点赞数 1

分类专栏： SpringBoot

本文链接：https://blog.csdn.net/qq_40205116/article/details/83990410

版权

28 篇文章

订阅专栏

本文详细解析了Spring Data JPA中的方法命名规范，包括如何通过方法名来表达SQL WHERE子句的各种条件，如AND、OR、BETWEEN等，以及如何使用关键字LIKE、IN、NULL进行复杂查询。

摘要由CSDN通过智能技术生成

spring-data-jpa命名规范

关键字	方法命名	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 ?
StartingWith	findByNameStartingWith	where name like '?%'
NotLike	findByNameNotLike	where name not like ?
EndingWith	findByNameEndingWith	where name like '%?'
OrderBy	findByIdOrderByXDesc	where id=? order by x desc
Like	findByNameLike	where name like '%?%'
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(?)