jpa两种自定义SQL的方式

最新推荐文章于 2024-05-11 14:07:46 发布

harveyST

最新推荐文章于 2024-05-11 14:07:46 发布

阅读量1.1w

点赞数

分类专栏： Java 文章标签： jpa java 框架

本文链接：https://blog.csdn.net/weixin_43871859/article/details/93918361

版权

Java 专栏收录该内容

6 篇文章 1 订阅

订阅专栏

当你的抽象类继承了JpaRepository类时，就会拥有一些基本的增删改查操作。但是，很多时候只有这些简单的功能是不够的的，jpa也支持原生SQL和实体类SQL进行自定义查询。
1. 原生SQL

@Query(value = "SELECT t2.userId, t1.title, t1.content, t1.completeTime, t2.scheduleState" +
            " FROM schedule t1 LEFT JOIN schedule_user t2 ON t1.id = t2.schedule_id " +
            " WHERE t2.user_id = ?1 AND t2.schedule_state = ?2", nativeQuery=true)
    List<ScheduleUserView> findScheduleListByState(Long userId, int scheduleState);

2. 实体类SQL

@Query(value = "SELECT new com.x3.schedule.saas.table.ScheduleUserView(" +
            " t2.userId, t1.title, t1.content, t1.completeTime, t2.scheduleState)" +
            " FROM ScheduleTable t1 LEFT JOIN ScheduleUserTable t2 ON t1.scheduleId = t2.scheduleId " +
            " WHERE t2.userId = ?1 AND t2.scheduleState = ?2")
    List<ScheduleUserView> findScheduleListByState(Long userId, int scheduleState);