mysql数据库xml写法
<update id="batchUpdate" parameterType="java.util.List">
<foreach collection="list" item="item" index="index" open="" close="" separator=";">
update t_application_expertInfo
set
approver_User_Name = #{item.approverUserName,jdbcType=VARCHAR},
approver_User_Id = #{item.approverUserId,jdbcType=BIGINT},
approval_comments = #{item.approvalComments,jdbcType=VARCHAR},
approval_time = #{item.approvalTime,jdbcType=TIMESTAMP},
status = #{item.status,jdbcType=VARCHAR}
where id = #{item.id,jdbcType=BIGINT}
and status = '0'
</foreach>
</update>
oracle写法
<update id="updateRawData" parameterType="java.util.List">
<foreach collection="list" item="item" index="index" open="begin" close=";end;" separator=";">
update dataCollectResult s set s.result = #{item.result}
where s.dcDataId = #{item.dcDataId} and s.siteName = #{item.siteName}
</foreach>
</update>