使用IN语法对已有List数据集合作为参数查询数据;
参数集合:remarkIdStr
SELECT remark_id, user_id, article_id, remark_content, remark_video, remark_picture, remark_like_num, remark_stepon_num, is_flag, create_time FROM gg_remark WHERE remark_id IN <foreach item="item" index="index" collection="remarkIdStr" open="(" separator="," close=")"> #{item} </foreach>
mybatis 中 IN语法 + list集合类型数据查询数据
原文:https://www.cnblogs.com/90s-ITBoy/p/14134568.html