<insert id="batchInsert" useGeneratedKeys="true" parameterType="java.util.List">
<selectKey resultType="int" keyProperty="id" order="AFTER">
SELECT
LAST_INSERT_ID()
</selectKey>
insert into t_estate (id,
seller_type, seller_id,
owner_type, owner_id,
estate_model_id,
name,
serial_number, remark,
validity_date, new_status,
old,
estate_place_id,
code, image_id,
user_id, buy_price, buy_date,
update_time, create_time,
status,rent_status
)
values
<foreach collection="list" item="item" index="index"
separator=",">
(#{item.id,jdbcType=INTEGER},
#{item.sellerType,jdbcType=SMALLINT},
#{item.sellerId,jdbcType=INTEGER},
#{item.ownerType,jdbcType=INTEGER},
#{item.ownerId,jdbcType=INTEGER},
#{item.estateModelId,jdbcType=INTEGER},
#{item.name,jdbcType=VARCHAR},
#{item.serialNumber,jdbcType=VARCHAR},
#{item.remark,jdbcType=VARCHAR},
#{item.validityDate,jdbcType=DATE},
#{item.newStatus,jdbcType=INTEGER},
#{item.old,jdbcType=INTEGER},
#{item.estatePlaceId,jdbcType=INTEGER},
#{item.code,jdbcType=VARCHAR},
#{item.imageId,jdbcType=INTEGER},
#{item.userId,jdbcType=INTEGER},
#{item.buyPrice,jdbcType=DECIMAL},
#{item.buyDate,jdbcType=DATE},
#{item.updateTime,jdbcType=TIMESTAMP},
#{item.createTime,jdbcType=TIMESTAMP},
#{item.status,jdbcType=SMALLINT},
#{item.rentStatus,jdbcType=INTEGER}
)
</foreach>
</insert>
<selectKey resultType="int" keyProperty="id" order="AFTER">
SELECT
LAST_INSERT_ID()
</selectKey>
insert into t_estate (id,
seller_type, seller_id,
owner_type, owner_id,
estate_model_id,
name,
serial_number, remark,
validity_date, new_status,
old,
estate_place_id,
code, image_id,
user_id, buy_price, buy_date,
update_time, create_time,
status,rent_status
)
values
<foreach collection="list" item="item" index="index"
separator=",">
(#{item.id,jdbcType=INTEGER},
#{item.sellerType,jdbcType=SMALLINT},
#{item.sellerId,jdbcType=INTEGER},
#{item.ownerType,jdbcType=INTEGER},
#{item.ownerId,jdbcType=INTEGER},
#{item.estateModelId,jdbcType=INTEGER},
#{item.name,jdbcType=VARCHAR},
#{item.serialNumber,jdbcType=VARCHAR},
#{item.remark,jdbcType=VARCHAR},
#{item.validityDate,jdbcType=DATE},
#{item.newStatus,jdbcType=INTEGER},
#{item.old,jdbcType=INTEGER},
#{item.estatePlaceId,jdbcType=INTEGER},
#{item.code,jdbcType=VARCHAR},
#{item.imageId,jdbcType=INTEGER},
#{item.userId,jdbcType=INTEGER},
#{item.buyPrice,jdbcType=DECIMAL},
#{item.buyDate,jdbcType=DATE},
#{item.updateTime,jdbcType=TIMESTAMP},
#{item.createTime,jdbcType=TIMESTAMP},
#{item.status,jdbcType=SMALLINT},
#{item.rentStatus,jdbcType=INTEGER}
)
</foreach>
</insert>