| 关键字 | 样品方法 | SQPL片段 | 原生SQL | 备注 |
| And | findPersonByLastNameAndFirstName(String lastName,String firstName) | ...where x.lastName = 1? and x.firstName = 2? | ...where lastName = 1? and firstName = 2? | 两个字段的&操作 |
| Or | ||||
| Is、Equals | ||||
| Between | ||||
| LessThan | ||||
| LessThanEqual | ||||
| GreaterThan | ||||
| GreaterThanEqual | ||||
| After | ||||
| Before | ||||
| isNull、Null | ||||
| isNotNull、NotNull | ||||
| Like | ||||
| NotLike | ||||
| StartingWith | ||||
| EndingWith | ||||
| Containing | ||||
| OrderBy | ||||
| Not | ||||
| In | ||||
| NotIn | ||||
| True | ||||
| False | ||||
| IgnoreCase |
原文:https://www.cnblogs.com/chaoyou/p/11698482.html