mybatis批量操作

 insert into config_translate_picture(translate_id, ctp_picture_url, sort_no)
        values
        <foreach collection="list" item="dto" index="index" separator=",">
            (#{translateId}, #{dto.ctpPictureUrl}, #{dto.sortNo})
        </foreach>

批量新增

<foreach collection="materialClassList" item="materialClass" index="index" separator=";">
            UPDATE material_class SET sort_no = #{materialClass.sortNo}
            WHERE
            material_class_id = #{materialClass.materialClassId}
        </foreach>

批量修改

delete from config_notice
        where notice_id in
        <foreach collection="noticeIdList" item="noticeId" open="(" close=")" separator="," >
            #{noticeId}
        </foreach>

批量删除