mybatis 更新操作

批量更新

dao

int batchUpdateWriteCardRecords(@Param("writeCardRecordsList")List<WriteCardRecords> writeCardRecordsList);

mapper

<update id="batchUpdateWriteCardRecords" parameterType="list">
	<foreach collection="writeCardRecordsList" item="item" index="index" open="" close="" separator=";">
		UPDATE write_card_records
		<set>
			old_missdn=#{item.oldMissdn},
			status=#{item.status},
			province=#{item.province},
			update_time=#{item.updateTime},
			data_integrity=#{item.dataIntegrity},
			not_integrity_reason=#{item.notIntegrityReason},
			systemName = #{item.systemname}
		</set>
		<where>
			eid=#{item.eid}
			and new_missdn=#{item.newMissdn}
			and time= #{item.time}
			and data_from=#{item.dataFrom}
		</where>
	</foreach>
</update>