Mybatis 循环查询foreach使用方法

动态sql

批量新增与删除

<!--批量插入-->
    <insert id="batchsave">
        INSERT INTO t_product (name, salary, color) values
        <!--
           collection:要么是array要么是list
           item: 循环迭代的元素，给每个元素取一个别名叫做i
           separator:分隔符，循环迭代的时候以,进行分割
       -->
        <foreach collection="list" item="i" separator=",">
            (#{i.name},#{i.salary},#{i.color})
        </foreach>
    </insert>
    <!--根据id批量删除-->
    <delete id="batchDeleteById">
        DELETE FROM t_product WHERE id IN
        <foreach collection="array" item="i" separator="," close=")" open="(">
            #{i}
        </foreach>
    </delete>
    <!--批量删除-->
    <delete id="batchDelete">
        DELETE FROM t_product WHERE id IN
        <foreach collection="list" item="i" open="(" close=")" separator=",">
            #{i.id}
        </foreach>
    </delete>