spring JPA相关命名规则

方法名中支持的关键字

以find为例，可替换为delete、count等：
| Keyword             | Sample                                                            | JPQL snippet                                                      |
| ------------------- | ----------------------------------------------------------------- | ----------------------------------------------------------------- |
| `And`               | `findByLastnameAndFirstname`                                      | `… where x.lastname = ?1 and x.firstname = ?2`                    |
| `Or`                | `findByLastnameOrFirstname`                                       | `… where x.lastname = ?1 or x.firstname = ?2`                     |
| `Is,Equals`         | `findByFirstname`,  `findByFirstnameIs`,  `findByFirstnameEquals` | `… where x.firstname = ?1`                                        |
| `Between`           | `findByStartDateBetween`                                          | `… where x.startDate between ?1 and ?2`                           |
| `LessThan`          | `findByAgeLessThan`                                               | `… where x.age < ?1`                                              |
| `LessThanEqual`     | `findByAgeLessThanEqual`                                          | `… where x.age <= ?1`                                             |
| `GreaterThan`       | `findByAgeGreaterThan`                                            | `… where x.age > ?1`                                              |
| `GreaterThanEqual`  | `findByAgeGreaterThanEqual`                                       | `… where x.age >= ?1`                                             |
| `After`             | `findByStartDateAfter`                                            | `… where x.startDate > ?1`                                        |
| `Before`            | `findByStartDateBefore`                                           | `… where x.startDate < ?1`                                        |
| `IsNull`            | `findByAgeIsNull`                                                 | `… where x.age is null`                                           |
| `IsNotNull,NotNull` | `findByAge(Is)NotNull`                                            | `… where x.age not null`                                          |
| `Like`              | `findByFirstnameLike`                                             | `… where x.firstname like ?1`                                     |
| `NotLike`           | `findByFirstnameNotLike`                                          | `… where x.firstname not like ?1`                                 |
| `StartingWith`      | `findByFirstnameStartingWith`                                     | `… where x.firstname like ?1`(parameter bound with appended `%`)  |
| `EndingWith`        | `findByFirstnameEndingWith`                                       | `… where x.firstname like ?1`(parameter bound with prepended `%`) |
| `Containing`        | `findByFirstnameContaining`                                       | `… where x.firstname like ?1`(parameter bound wrapped in `%`)     |
| `OrderBy`           | `findByAgeOrderByLastnameDesc`                                    | `… where x.age = ?1 order by x.lastname desc`                     |
| `Not`               | `findByLastnameNot`                                               | `… where x.lastname <> ?1`                                        |
| `In`                | `findByAgeIn(Collection<Age> ages)`                               | `… where x.age in ?1`                                             |
| `NotIn`             | `findByAgeNotIn(Collection<Age> ages)`                            | `… where x.age not in ?1`                                         |
| `True`              | `findByActiveTrue()`                                              | `… where x.active = true`                                         |
| `False`             | `findByActiveFalse()`                                             | `… where x.active = false`                                        |
| `IgnoreCase`        | `findByFirstnameIgnoreCase`                                       | `… where UPPER(x.firstame) = UPPER(?1)`                           |
参考资料

5.3.2. Query Creation
预览
除特别注明外，本站所有文章均为竹风清语原创，转载请注明出处来自： spring-jpaxiangguanmingmingguize
License CC BY-SA 4.0 以商业目的使用本网站原创内容需获许可，非商业目的使用授权遵循CC BY-NC 4.0
Loading comments...
0 条评论
暂无数据
预览