@select 传入List数组

最新推荐文章于 2024-01-12 18:44:55 发布

sui5yue6_

最新推荐文章于 2024-01-12 18:44:55 发布

阅读量1k

点赞数 8

文章标签： mybatis

本文链接：https://blog.csdn.net/ganjiee0007/article/details/134736094

版权

文章讨论了在Dto中使用私有字段如bookId和count，以及使用@Select注解执行动态SQL查询的示例，特别提到了可能为老项目遗留的Map接收数据方式。

摘要由CSDN通过智能技术生成

Dto中定义 private Integer bookId; private Integer count;


    @Select({
            "<script>",
            "select  book_id,count(*) as count  from xx_book_likes where book_id in ",
            "<foreach collection='bookIds' item='book_id' open='(' separator=',' close=')'>",
            "#{book_id}",
            "</foreach>",
            " GROUP BY book_id ",
            "</script>"
    })
    List<XxbookLikeDto> countByXxBookIds(List<Integer> bookIds);}

还有一种写法是

@Select({
            "<script>",
                "select * from m_seller_index_banner where seller_id in ",
                "<foreach collection='sellerIds' item='id' open='(' separator=',' close=')'>",
                    "#{id}",
                "</foreach>",
            "</script>"
    })
List<Map<String,Object>> getBannersBySellerId(@Param("sellerIds") List<Integer> sellerIds);