Mybatis实现批量增加、批量删除和批量修改

1、批量增加

<!--批量增加-->
<insert id="saveSignData" parameterType="java.util.List">
        insert
        　　into
        sign
        　　(user_id, sign_time, sign_status, late_time)
        values
        　　<foreach collection="list" item="item" index="index" separator=",">
            　　(#{item.userId,jdbcType=INTEGER},#{item.signTime,jdbcType=VARCHAR},
            　　#{item.signStatus,jdbcType=VARCHAR}, #{item.lateTime,jdbcType=VARCHAR})
        　　</foreach>
</insert>

 

2、批量删除

 <!--批量删除-->
    <delete id="deletes" parameterType="java.util.List">
        delete from team where id in
        <foreach collection="list" item="ids" open="(" separator="," close=")">
            #{ids,jdbcType=INTEGER}
        </foreach>
   </delete>

 

3、批量修改

<update id="updateStudents">
        update
            user
        set
            team =
            <foreach collection="list" item="item" index="index" separator=" " open="case" close="end">
                when id = #{item.id} then ''
            </foreach>
        where
            id
        in
            <foreach collection="list" item="item" index="index" separator="," open="(" close=")">
                #{item.id}
            </foreach>
</update>