JPA书写动态sql

最新推荐文章于 2024-05-15 23:43:08 发布

小白不忙

最新推荐文章于 2024-05-15 23:43:08 发布

阅读量706

点赞数

文章标签： sql 数据库 java

本文链接：https://blog.csdn.net/qq_52589982/article/details/130510286

版权

    @Query(value =
            "SELECT t_recruit_plan.create_time,title,COUNT(*) c,class_type FROM t_recruit_sign_up JOIN t_recruit_plan  ON t_recruit_sign_up.plan_id=t_recruit_plan.id " +
                    "                WHERE 1=1" +
                    "                and IF ( ?1 != '', t_recruit_plan.title like %?1%, 1=1) " +
                    "                and IF ( ?2 != '', t_recruit_plan.create_time >= ?2, 1=1) " +
                    "                and IF ( ?3 != '', t_recruit_plan.create_time<=?3, 1=1) " +
                    "                GROUP BY t_recruit_sign_up.plan_id ORDER BY t_recruit_plan.create_time DESC LIMIT ?4,?5" ,nativeQuery = true)
    List<Map<String, Object>> selectAll(String title, Date p1, Date p2, int i, Integer pageSize);