Spring Boot学习笔记（三）Spring Data Jpa 快速上手（二） jpa命名规则 与 Jpql、Sql

1.1 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 ?
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	findByNameNot	where name <> ?
True	findByAaaTue	where aaa = true
False	findByAaaFalse	where aaa = false
IgnoreCase	findByNameIgnoreCase	where UPPER(name)=UPPER(?)
top	findTop100	top

1.2 命名示例

继承接口CrudRepository<UserEntity,Integer>, JpaSpecificationExecutor

public interface UserEntityRepository extends CrudRepository<UserEntity,Integer>, JpaSpecificationExecutor<UserEntity> {
   
//    根据命名规则进行查询
//    find + by + 所需要查询
//    findOneBy和findBy效果相同，因为此处没有使用like
//    推荐使用findOneBy的写法，以免产生歧义
    public UserEntity findByEmail(String email);
    public UserEntity findOneByEmail(String email);

//    根据命名规则模糊查询
//    find + by + 属性名称 + Like | isnull
//    此处的email应该为 = “%xxxx%”，对于like 需要自行添加%
//    此处的findBy与findAllBy的效果相同
    public List<UserEntity