Mybatis Foreach用法

最新推荐文章于 2024-01-10 07:00:00 发布

Lazyafei

最新推荐文章于 2024-01-10 07:00:00 发布

阅读量228

点赞数

CC 4.0 BY-SA版权

分类专栏： Mybatis

本文链接：https://blog.youkuaiyun.com/tfstone/article/details/83753572

Mybatis 专栏收录该内容

3 篇文章

订阅专栏

<select id="queryParkNumByPerson" parameterType="map"  resultType="map">
        select DATE_FORMAT(a.createTime, '%Y-%m' ) as day,a.open_id,
        sum(price*number) as countNum
        from se_parts a
        WHERE DATE_FORMAT(a.createTime, '%Y-%m' ) =#{month}
        <if test="open_id !=null and open_id !=''">
            <![CDATA[ AND a.open_id = #{open_id}]]>
        </if>
        <if test="schoolids != null and schoolids != ''">
            AND a.school_id in
            <foreach collection="schoolids" open="(" close=")" separator="," item="ids">
                #{ids}
            </foreach>
        </if>
        <if test="slist != null and slist != ''">
            AND a.open_id in
            <foreach collection="slist" open="(" close=")" separator="," item="ids">
                #{ids.openid}
            </foreach>
        </if>
        <if test="schoolCode !=null and schoolCode !=''">
            <![CDATA[ AND a.school_id = #{schoolCode}]]>
        </if>
        GROUP BY DATE_FORMAT(a.createTime, '%Y-%m' ),a.open_id
</select>

schoolids 为数组

slist 为集合，openid为字段名