Mybatis实现批处理存储

unijun

<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>