spring JPA相关命名规则

1
| Keyword             | Sample                                                            | JPQL snippet                                                      |
2
| ------------------- | ----------------------------------------------------------------- | ----------------------------------------------------------------- |
3
| `And`               | `findByLastnameAndFirstname`                                      | `… where x.lastname = ?1 and x.firstname = ?2`                    |
4
| `Or`                | `findByLastnameOrFirstname`                                       | `… where x.lastname = ?1 or x.firstname = ?2`                     |
5
| `Is,Equals`         | `findByFirstname`,  `findByFirstnameIs`,  `findByFirstnameEquals` | `… where x.firstname = ?1`                                        |
6
| `Between`           | `findByStartDateBetween`                                          | `… where x.startDate between ?1 and ?2`                           |
7
| `LessThan`          | `findByAgeLessThan`                                               | `… where x.age < ?1`                                              |
8
| `LessThanEqual`     | `findByAgeLessThanEqual`                                          | `… where x.age <= ?1`                                             |
9
| `GreaterThan`       | `findByAgeGreaterThan`                                            | `… where x.age > ?1`                                              |
10
| `GreaterThanEqual`  | `findByAgeGreaterThanEqual`                                       | `… where x.age >= ?1`                                             |
11
| `After`             | `findByStartDateAfter`                                            | `… where x.startDate > ?1`                                        |
12
| `Before`            | `findByStartDateBefore`                                           | `… where x.startDate < ?1`                                        |
13
| `IsNull`            | `findByAgeIsNull`                                                 | `… where x.age is null`                                           |
14
| `IsNotNull,NotNull` | `findByAge(Is)NotNull`                                            | `… where x.age not null`                                          |
15
| `Like`              | `findByFirstnameLike`                                             | `… where x.firstname like ?1`                                     |
16
| `NotLike`           | `findByFirstnameNotLike`                                          | `… where x.firstname not like ?1`                                 |
17
| `StartingWith`      | `findByFirstnameStartingWith`                                     | `… where x.firstname like ?1`(parameter bound with appended `%`)  |
18
| `EndingWith`        | `findByFirstnameEndingWith`                                       | `… where x.firstname like ?1`(parameter bound with prepended `%`) |
19
| `Containing`        | `findByFirstnameContaining`                                       | `… where x.firstname like ?1`(parameter bound wrapped in `%`)     |
20
| `OrderBy`           | `findByAgeOrderByLastnameDesc`                                    | `… where x.age = ?1 order by x.lastname desc`                     |
21
| `Not`               | `findByLastnameNot`                                               | `… where x.lastname <> ?1`                                        |
22
| `In`                | `findByAgeIn(Collection<Age> ages)`                               | `… where x.age in ?1`                                             |
23
| `NotIn`             | `findByAgeNotIn(Collection<Age> ages)`                            | `… where x.age not in ?1`                                         |
24
| `True`              | `findByActiveTrue()`                                              | `… where x.active = true`                                         |
25
| `False`             | `findByActiveFalse()`                                             | `… where x.active = false`                                        |
26
| `IgnoreCase`        | `findByFirstnameIgnoreCase`                                       | `… where UPPER(x.firstame) = UPPER(?1)`                           |