批量insert insert后返回id

在xml的insert添加

<selectKey resultType="java.lang.Integer" keyProperty="id" order="AFTER" >
      SELECT LAST_INSERT_ID()
</selectKey>

批量插入数据

<insert id="insertBatch" parameterType="java.util.List">
    <selectKey resultType="java.lang.Integer" keyProperty="id"
               order="AFTER">
        SELECT LAST_INSERT_ID()
    </selectKey>
    insert into 表名
    (字段,字段,字段)
    values
    <foreach collection ="list" item="item" index= "index" separator =",">
        (
        #{item.字段名},#{item.字段名},#{item.字段名}
        )
    </foreach>
</insert>