Jpa的dao层实现分页查询及日期范围过滤

Mr_YDK

于 2024-07-29 08:50:10 发布

阅读量303

点赞数 8

分类专栏：随笔文章标签： java sql

本文链接：https://blog.csdn.net/ydk888888/article/details/140761670

版权

随笔专栏收录该内容

33 篇文章 2 订阅

订阅专栏

@Query(value = "SELECT * FROM xxx" +
        "WHERE (:name IS NULL OR name LIKE %:name%) " +
        "AND (:startDate IS NULL OR create_time >= :startDate) " +
        "AND (:endDate IS NULL OR create_time <= :endDate) " +
        "ORDER BY id " +
        "LIMIT :start, :size",
        nativeQuery = true)
List<xxxEntity> listxxxs(@Param("name") String name,
                                            @Param("startDate") String startDate,
                                            @Param("endDate") String endDate,
                                            @Param("start") Integer start,@Param("size") Integer size);

@Query(value = "SELECT count(1) FROM xxx" +
        "WHERE (:name IS NULL OR name LIKE %:name%) " +
        "AND (:startDate IS NULL OR create_time >= :startDate) " +
        "AND (:endDate IS NULL OR create_time <= :endDate) ",
        nativeQuery = true)
Integer countxxxs(@Param("name") String name,
                        @Param("startDate") String startDate,
                        @Param("endDate") String endDate);