Mybatis 批量操作

 <!--批量插入-->
    <insert id="batchInsert" parameterType="list">
        insert into tb_user(name,age)
        values
        <foreach collection="list" item="i" separator=",">
            (#{i.name},#{i.age})
        </foreach>
    </insert>
    
    <!--批量更新-->
    <update id="batchUpdate" parameterType="list">
        <foreach collection="list" item="i" separator=";">
            update tb_user
            set name = #{i.name}, age = #{i.age}
            where id = #{i.id}
        </foreach>
    </update>
    
    <!--批量删除-->
    <delete id= "batchDelete" parameterType= "list">
        delete from tb_user
        where id in
        <foreach collection="list" item= "i" separator="," open= "(" close =")">
            #{i}
        </foreach >
    </delete >