mybatis 批量将list数据插入到数据库

mybatis 批量将list数据插入到数据库

	<!-- 为了保证lightName的唯一性,这里的唯一性是值在当前Floor是唯一的,并不是真个系统,是避免界面产生重复问题   -->
	<select id="selectExistsLightName" parameterType="java.util.List" resultType="LightDTO">
	    select 	    		
	    		lightName 
	    from 	
	    		smartLight 
	    where 
	    		floorId in
	    <foreach collection="list" index="index" item="item" open="("
	        separator="," close=")">
	        #{item.floorId}
	    </foreach>
	    and 
	    		lightName in
	    <foreach collection="list" index="index" item="item" open="("
	        separator="," close=")">
	        #{item.lightName}
	    </foreach>
	</select>
	
	<!-- 插入一条或多条light记录，传入参数为list -->
	<insert id="insertLightInfo" parameterType="java.util.List">
		insert into smartLight (lightType,lightAddress,lightSN,floorId,lightName) VALUES
		<foreach collection="list" item="item" index="index" separator=",">
			(#{item.lightType},#{item.lightAddress},#{item.lightSN},#{item.floorId},#{item.lightName})
		</foreach>
	</insert>