jpa常用查询方法使用总结&自定义sql查询

最新推荐文章于 2025-06-13 17:46:38 发布

风度啊

最新推荐文章于 2025-06-13 17:46:38 发布

阅读量8.8k

点赞数 7

CC 4.0 BY-SA版权

文章标签： sql java 数据库 jpa

本文链接：https://blog.csdn.net/qq_42651201/article/details/122365650

本文介绍Java持久化API(JPA)的自定义查询方法，包括单条件、多条件、in查询、like查询等，并展示了如何使用自定义SQL进行复杂查询及数据更新。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

文章目录

一、JPA自定义查询方法

方法名需要按指定规则来起：
单条数据：find+by+对象属性名
多条数据：findAll+by+对象属性名

实体类

@Data
public class People {

    private String id;
    private String name;
    private String code;
    private Integer age;
}

1.1 单条件查询一条数据

People findByCode(String code);

1.2 单条件查询多条数据

List<People> findAllByCode(String code);

1.3 多条件查询数据

People findByCodeAndAgeAndName(String code,Integer age,String name);

1.4 查询某一个字段

查到字段所在数据，从整条数据中再拿单个字段

People findByName(String name);

1.5 in查询

List<People> findByCodeIn(List<String> codes);

1.6 like查询

List<People> findAllByNameLike(String name);

二、自定义sql查询

2.1 单条件查询

@Query(value = "select * from people where code =?1 ",nativeQuery = true)
People findPeopleCustomizing(String code);

2.2 多条件查询

@Query(value = "select * from people where code =?1 and age = ?2",nativeQuery = true)
People findPeopleCustomizing(String code,Integer age);

2.3 复杂多条件查询

@Query(value = "select * from people where code =?1 and age = ?2 and name in (?3) ",nativeQuery = true)
People findPeopleCustomizing(String code,Integer age,List<String> name);

2.4 根据id修改数据

@Modifying(clearAutomatically = true)
@Query(nativeQuery = true,value = "update people set code = ?1 where id = ?2 ")
int updatePeople(String code, String id);

总览

@Repository
public interface PeopleRepository extends JpaRepository<People,String>, JpaSpecificationExecutor<People> {

    //jpa自带的方法，方法名需要按制定规则来起
    //1.单条件查询一条数据
    People findByCode(String code);

    //2.单条件查询多条数据
    List<People> findAllByCode(String code);

    //3.多条件查询数据
    People findByCodeAndAgeAndName(String code,Integer age,String name);

    //4.查询某一个字段
    People findByName(String name);

    //5.in查询
    List<People> findByCodeIn(List<String> codes);

    //6.like查询
    List<People> findAllByNameLike(String name);

    //自定义sql，方法名随意
    //1.自定义sql：单条件查询
    @Query(value = "select * from people where code =?1 ",nativeQuery = true)
    People findPeopleCustomizing(String code);

    //2.自定义sql：多条件查询
    @Query(value = "select * from people where code =?1 and age = ?2",nativeQuery = true)
    People findPeopleCustomizing(String code,Integer age);

    //3.自定义sql：复杂多条件查询
    @Query(value = "select * from people where code =?1 and age = ?2 and name in (?3) ",nativeQuery = true)
    People findPeopleCustomizing(String code,Integer age,List<String> name);

    //4.自定义sql：根据id修改数据
    @Modifying(clearAutomatically = true)
    @Query(nativeQuery = true,value = "update people set code = ?1 where id = ?2 ")
    int updatePeople(String code, String id);

}