Mybatis如何批量插入数据

Dao接口

 int batchInsertProductCategory(List<ProductCategory> productCategoryList);

mapper实现

<insert id="batchInsertProductCategory" parameterType="java.util.List">
	INSERT INTO
    tb_product_category(product_category_name,priority,
    create_time,shop_id)
    VALUES
    <foreach collection="list" item="productCategory" index="index"
             separator=",">
        (
        #{productCategory.productCategoryName},
        #{productCategory.priority},
        #{productCategory.createTime},
        #{productCategory.shopId}
        )
    </foreach>
</insert>