Mybatis批量导入

<insert id="insertBatchExcel" parameterType="list">
insert into as_assets_info
(reference_no,asset_id,name,model,category_id,configured,quantity,start_date,end_date,account,assets_type,
purchase_time,purchase_people,purchase_expense,purchase_channels,remarks,assets_state,
create_person,create_time)
values
<foreach collection="list" index="index" item="item" open="" separator="," close="">
(
#{item.referenceNo},
#{item.assetId},
#{item.name},
#{item.model},
#{item.categoryId},
#{item.configured},
#{item.quantity},
#{item.startDate},
#{item.endDate},
#{item.account},
#{item.assetsType},
#{item.purchaseTime},
#{item.purchasePeople},
#{item.purchaseExpense},
#{item.purchaseChannels},
#{item.remarks},
#{item.assetsState},
#{item.createPerson},
#{item.createTime}
)
</foreach>
</insert>