|
关键字
|
例子
|
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 = ? (
忽略大小写 ) |
好了，写这么多，只是为了说明，见名知意的重要性。方法名跟关键字挂钩的。
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
文章由极客之音整理，本文链接：https://www.bmabk.com/index.php/post/117788.html
