<update id="updateDb2" parameterType="list">
update profile_factory_information infoLEFT JOIN basic_org_user buser ON buser.userId = info.userId
<trim prefix="set" suffixOverrides=",">
<trim prefix="company =case" suffix="end,"><foreach collection="list" item="item" index="index">
<if test="item.company!=null"> <!-- 需要更新的字段company-->
when buser.mobile=#{item.mobile} then #{item.company}
</if>
</foreach>
</trim>
<trim prefix=" classify =case" suffix="end,"><foreach collection="list" item="item" index="index">
<if test="item.classify!=null"> <!-- 需要更新的字段classify-->
when buser.mobile=#{item.mobile} then #{item.classify}
</if>
</foreach>
</trim>
<trim prefix=" userName =case" suffix="end,"><foreach collection="list" item="item" index="index">
<if test="item.userName!=null"> <!-- 需要更新的字段 userName -->
when buser.mobile=#{item.mobile} then #{item.userName}
</if>
</foreach>
</trim>
</trim>
where<foreach collection="list" separator="or" item="item" index="index" >
buser.mobile=#{item.mobile} <!-- 判断条件mobile-->
</foreach>