<insertid="batchInsert"useGeneratedKeys="true"parameterType="java.util.List">
<selectKeyresultType="int"keyProperty="id"order="AFTER">
SELECT
LAST_INSERT_ID()
</selectKey>
insertintot_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
<foreachcollection="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>