Mybatis的注解方式@Select进行条件判断和循环

最新推荐文章于 2024-10-28 17:34:28 发布

Mr_YDK

最新推荐文章于 2024-10-28 17:34:28 发布

阅读量4.3k

点赞数 3

分类专栏： Mybaitis 文章标签： mybatis

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

版权

Mybaitis 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

@Select("<script>select count(1) from table_123 where tenant = #{tenant} " +
        " <when test='statusList != null'> " +
        "   and status in " +
        "   <foreach collection='statusList' item='status' open='(' separator=',' close=')'>" +
        "       #{status}" +
        "   </foreach>" +
        " </when> " +
        " <when test='keyword != null'> " +
        " and LOCATE(#{keyword},task_name) > 0 " +
        " </when> " +
        " </script>")
Integer getTaskCounts(String tenant, String keyword, List<Integer> statusList);