List-mybatis批量插入数据

来源:互联网 发布:网络体彩 编辑:程序博客网 时间:2024/05/18 05:42
 
<insert id="batchInsert" parameterType="list">    insert into mmall_order_item (id, order_no,user_id, product_id,      product_name, product_image, current_unit_price,      quantity, total_price, create_time,      update_time)    values    <foreach collection="orderItemList" index="index" item="item" separator=",">      (      #{item.id},#{item.orderNo},#{item.userId},#{item.productId},#{item.productName},#{item.productImage},#{item.currentUnitPrice},#{item.quantity},#{item.totalPrice},now(),now()      )    </foreach>  </insert>