@select 传入List数组

最新推荐文章于 2024-03-04 11:41:30 发布

sui5yue6_

最新推荐文章于 2024-03-04 11:41:30 发布

阅读量745

点赞数 8

文章标签： mybatis

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

版权

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);