mybatis批量更新

直接上项目中的代码xml：

    <update id="batchUpdateRecord" parameterType="list">
        update request_record
        <trim prefix="set" suffixOverrides=",">
            <trim prefix="track_nums = case" suffix="end,">
                <foreach collection="list" item="i" index="index">
                    <if test="i.trackNums!=null and i.trackNums!= ''">
                        when request_record_id=#{i.requestRecordId} then #{i.trackNums}
                    if>
                foreach>
            trim>
            <trim prefix="response_status = case" suffix="end,">
                <foreach collection="list" item="i" index="index">
                    <if test="i.responseStatus!=null and i.responseStatus!= ''">
                        when request_record_id=#{i.requestRecordId} then #{i.responseStatus}
                    if>
                foreach>
            trim>
        trim>
        where
        <foreach collection="list" separator="or" item="i" index="index" >
            request_record_id=#{i.requestRecordId}
        foreach>
    update>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

dao：

void batchUpdateSitfRequestRecord(List<Map<String, String>> records);
1