Spring Data JPA自定义查询方法的关键字

记录下来方便以后随时查

查询谓词关键字：

mysql关键字	关键字表达式	样例	sql
AND	And	findByAgeAndName(age,name)	where …and …
OR	Or	findByAgeOrName(age,name)
AFTER	After, IsAfter	findByStartTimeAfter(startTime)	where startTime > ?1
BEFORE	Before	findByStartTimeBefore(startTime)	where startTime < ?1
BETWEEN	Between	findByStartTimeBetween(start, end)	where startTime > ?1 and startTime < ?2
ENDING_WITH	EndingWith, IsEndingWith, EndsWith	findByFirstnameEndsWith(firstname)	where firstname like ‘%firstname’
STARTING_WITH	StartingWith
IS	Is,Equals	findByFirstname,findByFirstnameIs,findByFirstnameEquals	where firstname = ?1
	LessThan	findByAgeLessThan	where age < ?1
	LessThanEqual	findByAgeLessThanEqual	where age <= ?1
	GreaterThan	findByAgeGreaterThan	where age > ?1
	GreaterThanEqual	findByAgeGreaterThanEqual	where age >= ?1
	IsNull	findByAgeIsNull	where age is null
	IsNotNull,NotNull	findByAgeNotNull	where age is not null
	Like	findByFirstnameLike	where firstname like ?1
	NotLike	findByFirstnameNotLike	where firstname not like ?1
	OrderBy	findByAgeOrderByLastnameDesc	where age = ?1 order by lastname desc
IN	In	findByAgeIn(Collection ages)	where age in (…)
	NotIn	findByAgeNotIn(Collection ages)	where age not in (…)
	True	findByFlagTrue	where flag = true
	False	findByFlagFalse	where flag = false
	IgnoreCase	findByFirstnameIgnoreCase	where UPPER(firstname) = UPPER(?1)