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>