<update id="updateLicaiAllList" parameterType="java.util.List">
<foreach collection="list" item="item" index="index" open="begin" close=";end;" separator=";">
update tmi_licai_all t
set
t.est_amount=#{item.estAmount,jdbcType=NUMERIC}
where t.licai_id = #{item.licaiId,jdbcType=NUMERIC}
</foreach>
</update>
<foreach collection="list" item="item" index="index" open="begin" close=";end;" separator=";">
update tmi_licai_all t
set
t.est_amount=#{item.estAmount,jdbcType=NUMERIC}
where t.licai_id = #{item.licaiId,jdbcType=NUMERIC}
</foreach>
</update>