Spring Data方法命名规范

 

关键字	例子	JPQL
And	fifindByNameAndAge(String name, Integer age)	where name = ? and age = ?
Or	fifindByNameOrAge(String name, Integer age)	where name = ? or age = ?
Is	fifindByName(String name)	where name = ?
Between	fifindByAgeBetween(Integer min, Integer max)	where age between ? and ?
LessThan	fifindByAgeLessThan(Integer age)	where age < ?
LessThanEqual	fifindByAgeLessThanEqual(Integer age)	where age <= ?
GreaterThan	fifindByAgeGreaterThan(Integer age)	where age > ?
GreaterThanEqual	fifindByAgeGreaterThanEqual(Integer age)	where age >= ?
After	等同于 GreaterThan
Before	等同于 LessThan
IsNull	fifindByNameIsNull()	where name is null
IsNotNull	fifindByNameIsNotNull()	where name is not null
Like	fifindByNameLike(String name)	where name like ?
NotLike	fifindByNameNotLike(String name)	where name not like ?
StartingWith	fifindByNameStartingWith(String name)	where name like '?%'
EndingWith	fifindByNameEndingWith(String name)	where name like '%?'
Containing	fifindByNameContaining(String name)	where name like '%?%'
OrderByXx[desc]	fifindByIdOrderByXx[Desc] (Long id)	where id = ? order by Xx [desc]
Not	fifindByNameNot(String name)	where name != ?
In	fifindByIdIn(List<Long> ids)	where id in ( ... )
NotIn	fifindByIdNotIn(List<Long> ids)	where id not in ( ... )
True	fifindByXxTrue()	where Xx = true
False	fifindByXxFalse()	where Xx = false
IgnoreCase	fifindByNameIgnoreCase(String name)	where name = ? ( 忽略大小写 )

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

好了，写这么多，只是为了说明，见名知意的重要性。方法名跟关键字挂钩的。