Mybatis实现批处理存储

<insert id="insertHistoryAlarmBatch" parameterType="java.util.List">
		insert into HistoryAlarmInfo (historyID, hnbID, hnbName, serialNumber,
		locationPathNo,
		distancetoPathAccess, alarmSeqId, alarmRaisedTime,
		alarmClearedTime, managedObjectInstance,
		alarmType,
		probableCause,
		alarmID, perceivedSeverity, additionalText, additionalInformation,
		clearedManner) values
		<foreach collection="list" item="item" index="index"
			separator=", ">
			(#{item.historyID}, #{item.hnbID}, #{item.hnbName},
			#{item.serialNumber}, #{item.locationPathNo},
			#{item.distancetoPathAccess}, #{item.alarmSeqId},
			#{item.alarmRaisedTime},
			#{item.alarmClearedTime},
			#{item.managedObjectInstance}, #{item.alarmType},
			#{item.probableCause}, #{item.alarmID}, #{item.perceivedSeverity},
			#{item.additionalText}, #{item.additionalInformation},
			#{item.clearedManner})
		</foreach>
	</insert>

 

评论

1 楼 Gymsx 2014-08-30  

1、有没有考虑非null的情况
2、默认值的问题