<insert id="batchInsert"parameterType="java.util.List">

insert into DATA (ID, TEXT, STAUTS)

<foreach close=")"collection="list"item="item"index="index"open="("separator="union">

select

#{item.id,jdbcType=VARCHAR},

#{item.text,jdbcType=VARCHAR},

#{item.stauts,jdbcType=VARCHAR}

from dual

</foreach>

</insert>

AND r.license_plate IN

				<foreach collection="rdRiskEventInfoList" item="item" index="index" open="(" separator="," close=")">

					#{item}

				</foreach>

update rd_risk_event_info SET truck_risk_id=#{id, jdbcType=VARCHAR} where id in

		<foreach item="item" index="index" collection="idList" open="("

			separator="," close=")">

			#{item.id}

		</foreach>