spring_jpa接口命名规则

r囧r小猫 2022-11-02 14:29 163阅读 0赞

<table> 
 <tbody> 
  <tr> 
   <td style="text-align:center;vertical-align:middle;">关键字</td> 
   <td style="text-align:center;vertical-align:middle;">方法命名</td> 
   <td style="text-align:center;vertical-align:middle;">sql where字句</td> 
  </tr> 
  <tr> 
   <td>And</td> 
   <td>findByNameAndPwd</td> 
   <td>where name= ? and pwd =?</td> 
  </tr> 
  <tr> 
   <td>Or</td> 
   <td>findByNameOrSex</td> 
   <td>where name= ? or sex=?</td> 
  </tr> 
  <tr> 
   <td>Is,Equals</td> 
   <td>findById,findByIdEquals</td> 
   <td>where id= ?</td> 
  </tr> 
  <tr> 
   <td>Between</td> 
   <td>findByIdBetween</td> 
   <td>where id between ? and ?</td> 
  </tr> 
  <tr> 
   <td>LessThan</td> 
   <td>findByIdLessThan</td> 
   <td>where id &lt; ?</td> 
  </tr> 
  <tr> 
   <td>LessThanEquals</td> 
   <td>findByIdLessThanEquals</td> 
   <td>where id &lt;= ?</td> 
  </tr> 
  <tr> 
   <td>GreaterThan</td> 
   <td>findByIdGreaterThan</td> 
   <td>where id &gt; ?</td> 
  </tr> 
  <tr> 
   <td>GreaterThanEquals</td> 
   <td>findByIdGreaterThanEquals</td> 
   <td>where id &gt; = ?</td> 
  </tr> 
  <tr> 
   <td>After</td> 
   <td>findByIdAfter</td> 
   <td>where id &gt; ?</td> 
  </tr> 
  <tr> 
   <td>Before</td> 
   <td>findByIdBefore</td> 
   <td>where id &lt; ?</td> 
  </tr> 
  <tr> 
   <td>IsNull</td> 
   <td>findByNameIsNull</td> 
   <td>where name is null</td> 
  </tr> 
  <tr> 
   <td>isNotNull,NotNull</td> 
   <td>findByNameNotNull</td> 
   <td>where name is not null</td> 
  </tr> 
  <tr> 
   <td>Like</td> 
   <td>findByNameLike</td> 
   <td>where name like ?</td> 
  </tr> 
  <tr> 
   <td>NotLike</td> 
   <td>findByNameNotLike</td> 
   <td>where name not like ?</td> 
  </tr> 
  <tr> 
   <td>StartingWith</td> 
   <td>findByNameStartingWith</td> 
   <td>where name like '?%'</td> 
  </tr> 
  <tr> 
   <td>EndingWith</td> 
   <td>findByNameEndingWith</td> 
   <td>where name like '%?'</td> 
  </tr> 
  <tr> 
   <td>Containing</td> 
   <td>findByNameContaining</td> 
   <td>where name like '%?%'</td> 
  </tr> 
  <tr> 
   <td>OrderBy</td> 
   <td>findByIdOrderByXDesc</td> 
   <td>where id=? order by x desc</td> 
  </tr> 
  <tr> 
   <td>Not</td> 
   <td>findByNameNot</td> 
   <td>where name &lt;&gt; ?</td> 
  </tr> 
  <tr> 
   <td>In</td> 
   <td>findByIdIn(Collection&lt;?&gt; c)</td> 
   <td>where id in (?)</td> 
  </tr> 
  <tr> 
   <td>NotIn</td> 
   <td>findByNameNot</td> 
   <td>where name &lt;&gt; ?</td> 
  </tr> 
  <tr> 
   <td>True</td> 
   <td>findByAaaTue</td> 
   <td>where aaa = true</td> 
  </tr> 
  <tr> 
   <td>False</td> 
   <td>findByAaaFalse</td> 
   <td>where aaa = false</td> 
  </tr> 
  <tr> 
   <td>IgnoreCase</td> 
   <td>findByNameIgnoreCase</td> 
   <td>where UPPER(name)=UPPER(?)</td> 
  </tr> 
  <tr> 
   <td>top</td> 
   <td>findTop100</td> 
   <td>top 10/where ROWNUM &lt;=10</td> 
  </tr> 
 </tbody> 
</table>