mybatis批量操作

　　//插入    
　　<insert id="batchAdd">
                insert into TLMS_LessonClass_Lecture(
                lessonClassLectureId,
                lessonClassId,
                lessonId,
                title,
                beginDate,
                endDate,
                memo,
                content,
                displayOrder,
                lastUpdateDate,
                lastUpdateUserId
                ) values
                <foreach collection="list" item="item" separator=",">
                    (#{item.lessonClassLectureId},#{item.lessonClassId},#{item.lessonId},
                    #{item.title},#{item.beginDate},#{item.endDate},
                    #{item.memo},#{item.content},#{item.displayOrder},
                    #{item.lastUpdateDate},#{item.lastUpdateUserId})
                </foreach>
            </insert>
            //删除
            <delete id = "remove">
                delete FROM TPLT_PayDues where payDuesId in
                <foreach item="item" index="index" collection="array" open="(" separator="," close=")">
                        #{item}
                </foreach>
            </delete>
　　　　　　//修改

<update id="auditPassPltDues" parameterType="arraylist">
    update TPLT_PayDues set auditStatus = 1 where payDuesId in
    <foreach item="item" index="index" collection="array" open="(" separator="," close=")">
        #{item}
    </foreach>
</update>