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