话不多说上代码
<foreach collection="sfpchList" item="item" open="begin" close=";end;" separator=";">
update SF_SFXM
<set>
<if test="xmgk != null and xmgk != ''">
XMGK=#{xmgk},
</if>
<if test="sfdx != null and sfdx != ''">
SFDX=#{sfdx},
</if>
<if test="sfbz != null and sfbz != ''">
SFBZ=#{sfbz},
</if>
<if test="sfbzdw != null and sfbzdw != ''">
SFBZDW=#{sfbzdw},
</if>
<if test="sfdg != null and sfdg != ''">
SFDG=#{sfdg},
</if>
<if test="sbdw != null and sbdw != ''">
SBDW=#{sbdw},
</if>
<if test="yjsrze != null and yjsrze != ''">
YJSRZE=#{yjsrze},
</if>
<if test="srly != null and srly != ''">
SRLY=#{srly},
</if>
CZR = #{czr},
CZSJ = #{czsj}
</set>
where SFPCH = #{item.sfpch} and SFXMBH = #{item.sfxmbh}
</foreach>