mybatis foreach标签查一组数据

会吐水的杰尼龟

于 2022-01-19 16:21:08 发布

阅读量289

点赞数

文章标签： java

本文链接：https://blog.youkuaiyun.com/weixin_47397751/article/details/122583838

版权

<if test="list != null and list.size() > 0">
            and (brand_id,clientele_id) in

            <foreach item="item" collection="list" separator="," open="(" close=")">
                <trim prefix="(" suffix=")" suffixOverrides=",">
                    #{item.brandId},#{item.clienteleId}
                </trim>

            </foreach>