mybatis批量插入

<resultMap id="BaseResultMap" type="com.bmac.entity.SoAndroidHour">
<id column="id" jdbcType="BIGINT" property="id" />
<result column="cardinfo_id" jdbcType="BIGINT" property="cardinfoId" />
<result column="card_code" jdbcType="VARCHAR" property="cardCode" />
<result column="issure_date" jdbcType="TIMESTAMP" property="issureDate" />
<result column="card_state" jdbcType="VARCHAR" property="cardState" />
<result column="export_date" jdbcType="TIMESTAMP" property="exportDate" />
<result column="open_third_party" jdbcType="VARCHAR" property="openThirdParty" />
<result column="open_factories" jdbcType="VARCHAR" property="openFactories" />
</resultMap>


<insert id="saveBatch" parameterType="list">
insert into so_android_hour
(cardinfo_id,card_code,issure_date,card_state,export_date,open_third_party,open_factories)
values
<foreach collection="list" item="item" open="(" separator="," close=")">
#{item.cardinfoId},
#{item.cardCode},
#{item.issureDate},
#{item.cardState},
#{item.exportDate},
#{item.openThirdParty},
#{item.openFactories}
</foreach>
</insert>

原文地址:https://www.cnblogs.com/huiandong/p/10148122.html