springboot+mybatis批量插入数据时只返回最后一条数据的主键
springboot版本2.0.3
mybatis使用的是springboot组件mybatis-spring-boot-starter,版本1.3.5
mapper
<insert id="insertBatch" useGeneratedKeys="true" keyProperty="id" parameterType="java.util.List">
insert into order_room (
oid, roomid, rnum, state, assigntime, assignuid
) values
<foreach collection="list" index="index" item="item" separator=",">
(
#{item.oid}, #{item.roomid}, #{item.rnum}, #{item.state}, #{item.assigntime}, #{item.assignuid}
)
</foreach>
</insert>