mybatis用foreach循环添加多条数据

 <insert id="insertSelfBatch">
    insert into bfc_media_position (media_id, latitude,
      longitude, name, code, status, gis)
    values
    <foreach collection="record" index="index" item="item" separator=",">
      (
      #{item.mediaId,jdbcType=BIGINT}, #{item.latitude,jdbcType=DECIMAL},
      #{item.longitude,jdbcType=DECIMAL}, #{item.name,jdbcType=VARCHAR}, #{item.code,jdbcType=VARCHAR},
      #{item.status,jdbcType=INTEGER}, GeomFromText(#{item.gis})
      )
    </foreach>
  </insert>

/**
     * gis为字符串，格式point(123.1 23.4)
     * @param record
     * @return
     */
    int insertSelfBatch(@Param("record") List<Mediaposition> record);