Mybatis+Mysql批量插入数据(插入一个集合)

int insertLists(List<SkyNews> list);

MapperXml:

<insert id="insertList" parameterType="java.util.List">
      insert into t_sky_news (id, site_id, column_id,`column_name`, title,`url`, article,author, create_user_id, image_link,
      resources, create_date, update_date,publish_date, is_publish, hit,  `type`)
      values
      <foreach collection="list" item="item"  separator=",">
          (#{item.id}, #{item.siteId}, #{item.columnId},
      #{item.columnName}, #{item.title}, #{item.url},#{item.article},
      #{item.author}, #{item.createUserId}, #{item.imageLink},
      #{item.resources}, #{item.createDate}, #{item.updateDate},
      #{item.publishDate}, #{item.isPublish}, #{item.hit},
      #{item.type})
</foreach>
</insert>