方法命名规则查询

关键字	示例	JPQL
And	findByAgeAndHeight	where age = ? and height = ?
Or	findByAgeOrHeight	where age = ? or height = ?
In	findByAgeIn	where age in ?
NotIn	findByAgeNotIn	where age not in ?
	findByAge	where age = ?
Is	findByAgeIs	where age = ?
Not	findByAgeNot	where age != ?
Equals	findByAgeEquals	where age=?
Like	findByNameLike	where name like ?
NotLike	findByNameNotLike	where name not like ?
Between	findByDateBetween	where date between ?1 and ?2
Containing	findByNameContaining	where name like ?1
OrderBy	findByAgeOrderByCreateTimeDesc	where age=? order by createTime desc
StartingWith	findByNameStartingWith	where name like ?%
EndingWith	findByNameEndingWith	where name like %?
IsNull	findByNameIsNull	where name is null
IsNotNull	findByNameIsNotNull	where name not null
NotNull	findByNameNotNull	where name not null
LessThan	findByDateLessThan	where date < ?
LessThanEqual	findByAgeLessThanEqual	where age <= ?
GreaterThan	findByDateGreaterThan	where date > ?
GreaterThanEqual	findByDateGreaterThanEqual	where date >= ?
After	findByDateAfter	where date > ?
Before	findByDateBefore	where date < ?
TRUE	findByResultTrue	where result = true
FALSE	findByResultFalse	where result = false
IgnoreCase	findByNameIgnoreCase	where name = ?

注意：MySQL数据库不区分大小写，IgnoreCase在MySQL中无效
注意：方法命名规则查询不支持动态查询，参数必须赋值不然会报编译时异常