Mybatis批量保存

mapper.xml

  <insert id="addAll" >
    insert into vr_icon (<include refid="Base_Column_List"></include>)
    values
    <foreach item="item" index="index" collection="vrIconList" separator="," >
      (#{item.id,jdbcType=INTEGER},#{item.iconId,jdbcType=VARCHAR})
    </foreach>
  </insert>

mapper.java

int addAll(@Param("vrIconList") List<VrIcon> vrIconList);