Spring Data Jpa自定义方法关键字

Spring Data Jpa自定义方法关键字

关键字	方法名举例	对应的SQL
And	findByNameAndAge	where name = ? and age = ?
Or	findByNameOrAge	where name = ? or age = ?
Is	findByNameIs	where name = ?
Equals	findByNameEquals	where name = ?
Between	findByAgeBetween	where age between ? and ?
LessThan	findByAgeLessThan	where age < ?
LessThanEquals	findByAgeLessThanEqual	where age <= ?
GreatorThan	findByAgeGreaterThan	where age > ?
GreatorThanEquals	findByAgeGreaterThanEqual	where age >= ?
After	findByAgeAfter	where age > ?
Before	findByAgeBefore	where age < ?
IsNull	findByNameIsNull	where name is null
IsNotNull，NotNull	findByNameIsNotNull，findByNameNotNull	where name is not null
Not	findByNameNot	where name <>?
In	findByAgeIn	where age in (?)
NotIn	findByAgeNotIn	where age not in (?)
NotLike	findByNameNotLike	where name not like ?
Like	findByNameLike	where name like ?
StartingWith	findByNameStartingWith	where name like ‘?%’
EndingWith	findByNameEndingWith	where name like ‘%?’
Containing，Contains	findByNameContaining，findByNameContains	where name like ‘%?%’
OrderBy	findByOrderByAgeDesc	order by age desc
True	findByBossTrue	where boss = true
False	findByBossFalse	where boss = false
IgnoreCase	findByNameIgnoreCase	where UPPER(name) = UPPER(?)

学习交流群

817080571