Mybatis-批量更新

<!-- mybatis根据id批量更新对象属性 --> <update id="batchUpdatePeopleInfo" parameterType="java.util.List" > update people_info <set> <trim prefix="people_name =case " suffix="end,"> <foreach collection="list" item="item" index="index"> when id=#{item.id} then #{item.peopleName} </foreach> </trim> <trim prefix="mobile_phone =case" suffix="end,"> <foreach collection="list" item="item" index="index"> when id=#{item.id} then #{item.mobilePhone} </foreach> </trim> <trim prefix="consignee_address =case" suffix="end,"> <foreach collection="list" item="item" index="index"> when id=#{item.id} then #{item.consigneeAddress} </foreach> </trim> </set> where id in <foreach collection="list" index="index" item="item" separator="," open="(" close=")"> #{item.id} </foreach> </update>