Spring Data JDBC支持的查询方法谓词关键字和修饰符query method predicate keywords and modifiers

系统管理员 2023-09-26 10:58 101阅读 0赞

<table> Table 9. Query predicate keywords 
 <thead> 
 <tr> 
 <th>Logical keyword</th> 
 <th>Keyword expressions</th> 
 </tr> 
 </thead> 
 <tbody> 
 <tr> 
 <td> <code>AND</code> </td> 
 <td> <code>And</code> </td> 
 </tr> 
 <tr> 
 <td> <code>OR</code> </td> 
 <td> <code>Or</code> </td> 
 </tr> 
 <tr> 
 <td> <code>AFTER</code> </td> 
 <td> <code>After</code>,&nbsp;<code>IsAfter</code> </td> 
 </tr> 
 <tr> 
 <td> <code>BEFORE</code> </td> 
 <td> <code>Before</code>,&nbsp;<code>IsBefore</code> </td> 
 </tr> 
 <tr> 
 <td> <code>CONTAINING</code> </td> 
 <td> <code>Containing</code>,&nbsp;<code>IsContaining</code>,&nbsp;<code>Contains</code> </td> 
 </tr> 
 <tr> 
 <td> <code>BETWEEN</code> </td> 
 <td> <code>Between</code>,&nbsp;<code>IsBetween</code> </td> 
 </tr> 
 <tr> 
 <td> <code>ENDING_WITH</code> </td> 
 <td> <code>EndingWith</code>,&nbsp;<code>IsEndingWith</code>,&nbsp;<code>EndsWith</code> </td> 
 </tr> 
 <tr> 
 <td> <code>EXISTS</code> </td> 
 <td> <code>Exists</code> </td> 
 </tr> 
 <tr> 
 <td> <code>FALSE</code> </td> 
 <td> <code>False</code>,&nbsp;<code>IsFalse</code> </td> 
 </tr> 
 <tr> 
 <td> <code>GREATER_THAN</code> </td> 
 <td> <code>GreaterThan</code>,&nbsp;<code>IsGreaterThan</code> </td> 
 </tr> 
 <tr> 
 <td> <code>GREATER_THAN_EQUALS</code> </td> 
 <td> <code>GreaterThanEqual</code>,&nbsp;<code>IsGreaterThanEqual</code> </td> 
 </tr> 
 <tr> 
 <td> <code>IN</code> </td> 
 <td> <code>In</code>,&nbsp;<code>IsIn</code> </td> 
 </tr> 
 <tr> 
 <td> <code>IS</code> </td> 
 <td> <code>Is</code>,&nbsp;<code>Equals</code>, (or no keyword) </td> 
 </tr> 
 <tr> 
 <td> <code>IS_EMPTY</code> </td> 
 <td> <code>IsEmpty</code>,&nbsp;<code>Empty</code> </td> 
 </tr> 
 <tr> 
 <td> <code>IS_NOT_EMPTY</code> </td> 
 <td> <code>IsNotEmpty</code>,&nbsp;<code>NotEmpty</code> </td> 
 </tr> 
 <tr> 
 <td> <code>IS_NOT_NULL</code> </td> 
 <td> <code>NotNull</code>,&nbsp;<code>IsNotNull</code> </td> 
 </tr> 
 <tr> 
 <td> <code>IS_NULL</code> </td> 
 <td> <code>Null</code>,&nbsp;<code>IsNull</code> </td> 
 </tr> 
 <tr> 
 <td> <code>LESS_THAN</code> </td> 
 <td> <code>LessThan</code>,&nbsp;<code>IsLessThan</code> </td> 
 </tr> 
 <tr> 
 <td> <code>LESS_THAN_EQUAL</code> </td> 
 <td> <code>LessThanEqual</code>,&nbsp;<code>IsLessThanEqual</code> </td> 
 </tr> 
 <tr> 
 <td> <code>LIKE</code> </td> 
 <td> <code>Like</code>,&nbsp;<code>IsLike</code> </td> 
 </tr> 
 <tr> 
 <td> <code>NEAR</code> </td> 
 <td> <code>Near</code>,&nbsp;<code>IsNear</code> </td> 
 </tr> 
 <tr> 
 <td> <code>NOT</code> </td> 
 <td> <code>Not</code>,&nbsp;<code>IsNot</code> </td> 
 </tr> 
 <tr> 
 <td> <code>NOT_IN</code> </td> 
 <td> <code>NotIn</code>,&nbsp;<code>IsNotIn</code> </td> 
 </tr> 
 <tr> 
 <td> <code>NOT_LIKE</code> </td> 
 <td> <code>NotLike</code>,&nbsp;<code>IsNotLike</code> </td> 
 </tr> 
 <tr> 
 <td> <code>REGEX</code> </td> 
 <td> <code>Regex</code>,&nbsp;<code>MatchesRegex</code>,&nbsp;<code>Matches</code> </td> 
 </tr> 
 <tr> 
 <td> <code>STARTING_WITH</code> </td> 
 <td> <code>StartingWith</code>,&nbsp;<code>IsStartingWith</code>,&nbsp;<code>StartsWith</code> </td> 
 </tr> 
 <tr> 
 <td> <code>TRUE</code> </td> 
 <td> <code>True</code>,&nbsp;<code>IsTrue</code> </td> 
 </tr> 
 <tr> 
 <td> <code>WITHIN</code> </td> 
 <td> <code>Within</code>,&nbsp;<code>IsWithin</code> </td> 
 </tr> 
 </tbody> 
</table>

In addition to filter predicates, the following list of modifiers is supported:

<table> Table 10. Query predicate modifier keywords 
 <thead> 
 <tr> 
 <th>Keyword</th> 
 <th>Description</th> 
 </tr> 
 </thead> 
 <tbody> 
 <tr> 
 <td> <code>IgnoreCase</code>,&nbsp;<code>IgnoringCase</code> </td> 
 <td> Used with a predicate keyword for case-insensitive comparison. </td> 
 </tr> 
 <tr> 
 <td> <code>AllIgnoreCase</code>,&nbsp;<code>AllIgnoringCase</code> </td> 
 <td> Ignore case for all suitable properties. Used somewhere in the query method predicate. </td> 
 </tr> 
 <tr> 
 <td> <code>OrderBy…</code> </td> 
 <td> Specify a static sorting order followed by the property path and direction (e. g.&nbsp;<code>OrderByFirstnameAscLastnameDesc</code>). </td> 
 </tr> 
 </tbody> 
</table>