批量操作：批量添加，批量查询，批量修改，批量删除

1.批量添加：

<insert id="addtest">
        insert into test(age,name,status)
        values
        <foreach item="item" index="index" collection="list" separator=",">
            (#{item.age,jdbcType=BIGINT},#{item.name,jdbcType=STRING},#{item.age,jdbcType=BIT})
        </foreach>
    </insert>

2.批量查询：

 <select id="idList" resultType="entity">
        select * from test where flag = 0
        AND intersection_id in
        <foreach collection="idList" index="index" item="id" open="(" separator="," close=")">
            #{intersectionid}
        </foreach>
 </select>

3.批量修改：

 <update id="updateAgeList">
        UPDATE test SET direction =
        <foreach collection="updateAgeList" index="index" item="item" open="case ID" close="end" separator=" ">
            WHEN #{item.id,jdbcType=BIGINT} THEN #{item.age,jdbcType=INTEGER}
        </foreach>
        WHERE id in
        <foreach collection="updateAgeList" index="index" item="item" open="(" separator="," close=")">
            #{item.id,jdbcType=BIGINT}
        </foreach>
    </update>

4.批量删除：

<update id="idList">
    UPDATE test SET age,name,status = 1 where id in
    <foreach collection="idList" index="index" item="id" open="(" separator="," close=")">
        #{id}
    </foreach>
</update>