mybatis 批量修改

mapper接口

 int importFault(@Param("list")List<Map<String,Object>> list);

mapper.xml

<update id="importFault" parameterType="java.util.List">
       <foreach collection="list" item="item" index="index" separator=";">
           UPDATE f_express
           <set>
               <if test="item.expressCode != null">
                   expressCode = #{item.expressCode},
               </if>
               <if test="item.expCompany != null">
                   expCompany = #{item.expCompany},
               </if>
               <if test="item.freight != null">
                   freight = #{item.freight},
               </if>
               wlState=2
           </set>
           WHERE cusCode = #{item.cusCode}
       </foreach>
</update>