1.准备添加对象的集合List<TbSpecificationOption>
2)增加映射接口批量添加方法:
3)sql.xml增加insertBatch片段
<insert id="insertBatch" parameterType="java.util.List" >
insert into tb_specification_option (id, option_name, spec_id,
orders)
values
<foreach collection="records" item="record" index="index" separator=",">
(#{record.id,jdbcType=BIGINT}, #{record.optionName,jdbcType=VARCHAR}, #{record.specId,jdbcType=BIGINT},
#{record.orders,jdbcType=INTEGER})
</foreach>
</insert>