JPA：方法命名规则

傷城~ 2023-09-24 12:37 85阅读 0赞

> 我是 ABin-阿斌：写一生代码，创一世佳话，筑一览芳华。 如果小伙伴们觉得文章有点 feel ，那就点个赞再走哦。  
> ![在这里插入图片描述][20201016161427585.png_pic_center]

## 一、注意： ##

*  下面这些方法都是查询操作，方法命名中如果 find 看着可读性不强可以改成 get
 *  这些方法命名，可以让 JPA 底层自动帮我们生成 SQL ，适用于单表、非复杂 SQL 语句实现
 *  如果想要查询 SQL 语句，那么我们可以在日志打印中查看。记得在 YML 中开启日志记录

<table> 
 <thead> 
  <tr> 
   <th>关键字</th> 
   <th>方法命名</th> 
   <th>sql where字句</th> 
  </tr> 
 </thead> 
 <tbody> 
  <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>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>LessThanEqual</td> 
   <td>findByIdLessThanEqual</td> 
   <td>where id &lt;=?</td> 
  </tr> 
  <tr> 
   <td>GreaterThan</td> 
   <td>findByIdGreaterThan</td> 
   <td>where id &gt; ?</td> 
  </tr> 
  <tr> 
   <td>GreaterThanEqual</td> 
   <td>findByIdGreaterThanEqual</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>find ByIdBefore</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>findByNameIsNotNull</td> 
   <td>where name is not null</td> 
  </tr> 
  <tr> 
   <td>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>findByIdOrderByAgeDescAndIdAsc</td> 
   <td>where id = ? order by age desc,id asc</td> 
  </tr> 
  <tr> 
   <td>Not</td> 
   <td>findByNameNot</td> 
   <td>where name &lt;&gt; ?</td> 
  </tr> 
  <tr> 
   <td>In</td> 
   <td>findByNameIn</td> 
   <td>where name in (?)</td> 
  </tr> 
  <tr> 
   <td>NotIn</td> 
   <td>findByIdNotIn</td> 
   <td>where id not in (?)</td> 
  </tr> 
  <tr> 
   <td>True</td> 
   <td>findByDelStatusTrue</td> 
   <td>where delStatus = true</td> 
  </tr> 
  <tr> 
   <td>False</td> 
   <td>findByDelStatusFalse</td> 
   <td>where delStatus = false</td> 
  </tr> 
  <tr> 
   <td>IgnoreCase</td> 
   <td>findByNameIgnoreCase</td> 
   <td>where UPPER(name) = UPPER(?)</td> 
  </tr> 
 </tbody> 
</table>

## 二、更多细节 ##

*  更加详细的 JPA 相关知识可以看我的这篇文章：[JPA的具体介绍与使用][JPA] 或这篇文章 [JAP的深入了解与优雅操作][JAP]

[20201016161427585.png_pic_center]: https://img-blog.csdnimg.cn/20201016161427585.png#pic_center
[JPA]: https://blog.csdn.net/Mango_Bin/article/details/127002337
[JAP]: https://zhongpan.tech/2020/07/20/034-best-practice-of-multi-table-joint-query-in-spring-data-jpa/