Spring Data JDBC 查询方法对应的SQL关键词

阳光穿透心脏的1/2处 2023-09-26 10:26 8阅读 0赞

<table> Table 3. Supported keywords for query methods 
 <thead> 
 <tr> 
 <th>Keyword</th> 
 <th>Sample</th> 
 <th>Logical result</th> 
 </tr> 
 </thead> 
 <tbody> 
 <tr> 
 <td> <code>After</code> </td> 
 <td> <code>findByBirthdateAfter(Date date)</code> </td> 
 <td> <code>birthdate &gt; date</code> </td> 
 </tr> 
 <tr> 
 <td> <code>GreaterThan</code> </td> 
 <td> <code>findByAgeGreaterThan(int age)</code> </td> 
 <td> <code>age &gt; age</code> </td> 
 </tr> 
 <tr> 
 <td> <code>GreaterThanEqual</code> </td> 
 <td> <code>findByAgeGreaterThanEqual(int age)</code> </td> 
 <td> <code>age &gt;= age</code> </td> 
 </tr> 
 <tr> 
 <td> <code>Before</code> </td> 
 <td> <code>findByBirthdateBefore(Date date)</code> </td> 
 <td> <code>birthdate &lt; date</code> </td> 
 </tr> 
 <tr> 
 <td> <code>LessThan</code> </td> 
 <td> <code>findByAgeLessThan(int age)</code> </td> 
 <td> <code>age &lt; age</code> </td> 
 </tr> 
 <tr> 
 <td> <code>LessThanEqual</code> </td> 
 <td> <code>findByAgeLessThanEqual(int age)</code> </td> 
 <td> <code>age &lt;= age</code> </td> 
 </tr> 
 <tr> 
 <td> <code>Between</code> </td> 
 <td> <code>findByAgeBetween(int from, int to)</code> </td> 
 <td> <code>age BETWEEN from AND to</code> </td> 
 </tr> 
 <tr> 
 <td> <code>NotBetween</code> </td> 
 <td> <code>findByAgeNotBetween(int from, int to)</code> </td> 
 <td> <code>age NOT BETWEEN from AND to</code> </td> 
 </tr> 
 <tr> 
 <td> <code>In</code> </td> 
 <td> <code>findByAgeIn(Collection&lt;Integer&gt; ages)</code> </td> 
 <td> <code>age IN (age1, age2, ageN)</code> </td> 
 </tr> 
 <tr> 
 <td> <code>NotIn</code> </td> 
 <td> <code>findByAgeNotIn(Collection ages)</code> </td> 
 <td> <code>age NOT IN (age1, age2, ageN)</code> </td> 
 </tr> 
 <tr> 
 <td> <code>IsNotNull</code>, <code>NotNull</code> </td> 
 <td> <code>findByFirstnameNotNull()</code> </td> 
 <td> <code>firstname IS NOT NULL</code> </td> 
 </tr> 
 <tr> 
 <td> <code>IsNull</code>, <code>Null</code> </td> 
 <td> <code>findByFirstnameNull()</code> </td> 
 <td> <code>firstname IS NULL</code> </td> 
 </tr> 
 <tr> 
 <td> <code>Like</code>, <code>StartingWith</code>, <code>EndingWith</code> </td> 
 <td> <code>findByFirstnameLike(String name)</code> </td> 
 <td> <code>firstname LIKE name</code> </td> 
 </tr> 
 <tr> 
 <td> <code>NotLike</code>, <code>IsNotLike</code> </td> 
 <td> <code>findByFirstnameNotLike(String name)</code> </td> 
 <td> <code>firstname NOT LIKE name</code> </td> 
 </tr> 
 <tr> 
 <td> <code>Containing</code> on String </td> 
 <td> <code>findByFirstnameContaining(String name)</code> </td> 
 <td> <code>firstname LIKE '%' + name + '%'</code> </td> 
 </tr> 
 <tr> 
 <td> <code>NotContaining</code> on String </td> 
 <td> <code>findByFirstnameNotContaining(String name)</code> </td> 
 <td> <code>firstname NOT LIKE '%' + name + '%'</code> </td> 
 </tr> 
 <tr> 
 <td> <code>(No keyword)</code> </td> 
 <td> <code>findByFirstname(String name)</code> </td> 
 <td> <code>firstname = name</code> </td> 
 </tr> 
 <tr> 
 <td> <code>Not</code> </td> 
 <td> <code>findByFirstnameNot(String name)</code> </td> 
 <td> <code>firstname != name</code> </td> 
 </tr> 
 <tr> 
 <td> <code>IsTrue</code>, <code>True</code> </td> 
 <td> <code>findByActiveIsTrue()</code> </td> 
 <td> <code>active IS TRUE</code> </td> 
 </tr> 
 <tr> 
 <td> <code>IsFalse</code>, <code>False</code> </td> 
 <td> <code>findByActiveIsFalse()</code> </td> 
 <td> <code>active IS FALSE</code> </td> 
 </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
 <tr> 
 <td></td> 
 <td>Query derivation is limited to properties that can be used in a <code>WHERE</code> clause without using joins.</td> 
 </tr> 
 </tbody> 
</table>