spirng data jpa查询中支持的关键字

不念不忘少年蓝@ 2022-07-28 06:27 144阅读 0赞

Table 2.3. Supported keywords inside method names

<table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid silver; word-break:break-word; height:484px; width:1057px">      
 <thead style="margin:0px; padding:0px"> 
  <tr style="margin:0px; padding:0px"> 
   <th style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> Keyword</th> 
   <th style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> Sample</th> 
   <th style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> JPQL snippet</th> 
  </tr> 
 </thead> 
 <tbody style="margin:0px; padding:0px"> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">And</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByLastnameAndFirstname</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.lastname = ?1 and x.firstname = ?2</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">Or</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByLastnameOrFirstname</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.lastname = ?1 or x.firstname = ?2</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">Is,Equals</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByFirstname,findByFirstnameIs,findByFirstnameEquals</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.firstname = 1?</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">Between</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByStartDateBetween</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.startDate between 1? and ?2</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">LessThan</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByAgeLessThan</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.age &lt; ?1</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">LessThanEqual</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByAgeLessThanEqual</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.age &lt;= ?1</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">GreaterThan</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByAgeGreaterThan</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.age &gt; ?1</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">GreaterThanEqual</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByAgeGreaterThanEqual</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.age &gt;= ?1</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">After</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByStartDateAfter</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.startDate &gt; ?1</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">Before</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByStartDateBefore</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.startDate &lt; ?1</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">IsNull</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByAgeIsNull</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.age is null</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">IsNotNull,NotNull</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByAge(Is)NotNull</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.age not null</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">Like</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByFirstnameLike</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.firstname like ?1</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">NotLike</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByFirstnameNotLike</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.firstname not like ?1</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">StartingWith</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByFirstnameStartingWith</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.firstname like ?1</code>&nbsp;(parameter bound with appended&nbsp;<code style="margin:0px; padding:0px">%</code>)</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">EndingWith</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByFirstnameEndingWith</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.firstname like ?1</code>&nbsp;(parameter bound with prepended&nbsp;<code style="margin:0px; padding:0px">%</code>)</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">Containing</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByFirstnameContaining</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.firstname like ?1</code>&nbsp;(parameter bound wrapped in&nbsp;<code style="margin:0px; padding:0px">%</code>)</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">OrderBy</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByAgeOrderByLastnameDesc</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.age = ?1 order by x.lastname desc</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">Not</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByLastnameNot</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.lastname &lt;&gt; ?1</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">In</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByAgeIn(Collection&lt;Age&gt; ages)</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.age in ?1</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">NotIn</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByAgeNotIn(Collection&lt;Age&gt; age)</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.age not in ?1</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">True</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByActiveTrue()</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.active = true</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">False</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByActiveFalse()</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where x.active = false</code></td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">IgnoreCase</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">findByFirstnameIgnoreCase</code></td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <code style="margin:0px; padding:0px">… where UPPER(x.firsta</code></td> 
  </tr> 
 </tbody> 
</table>