mybatis批量插入数据到数据库

dao层

 int insertBatch(@Param("list") List<plan> list);

xml

<insert id="insertBatch">
    INSERT INTO plan
    (
    plan_id,
    order_id,
    plan_no,
    nper_no,
    npers,
    create_time
    )
    VALUES
    <foreach collection="list" item="item" separator=",">
      (
      #{item.planId},
      #{item.orderId},
      #{item.planNo},
      #{item.nperNo},
      #{item.npers},
      #{item.createTime}
      )
    </foreach>
  </insert>