MyBatis 是不是不支持 批量插入 id自增长的数据

MyBatis \u662f\u4e0d\u662f\u4e0d\u652f\u6301 \u6279\u91cf\u63d2\u5165 id\u81ea\u589e\u957f\u7684\u6570\u636e

\u6211\u8fd9\u6837\u5199\u7684\u3002


SELECT T\u65e6\u4f9b\u6d4b\u4f73\u723b\u7c27\u8be7\u4f2a\u8d85\u9570_MSG_SMSINFO_SEQ.NEXTVAL AS id FROM dual

INSERT INTO T_MSG_SMSINFO ( ) VALUES
<foreach collection="list" item="item" index="index"
separator=",">
( #{item.id},#{item.ecid},#{item.userid},#{item.sendermsisdn},#{item.receiverinfo},
#{item.totalrec},#{item.smsorigin},#{item.originid},#{item.smscontent},#{item.smstype},
#{item.scheduletime},#{item.auditstatus},#{item.inserttime},#{item.updatetime}
)



\u5c31\u662f\u5728\uff1a

SELECT T_MSG_SMSINFO_SEQ.NEXTVAL AS id FROM dual

\u6709\u95ee\u9898

\u662f\u7684.......................

支持的，如果是Oracle，需要先建一个序列sequence
<insert id="insert" parameterType="Order" >
<selectKey resultType="java.lang.Long" keyProperty="orderId" order="BEFORE" >
select SEQ_ORDER_ID.nextval from dual
</selectKey>
insert into Order values(.....)

扩展阅读：mybatis-plus面试题 ... mybatis-plus缺点 ... mybatis-plus模糊查询 ... mybatis中$和井号区别 ... mybatis generator ... springboot mybatis ... mybatis flex ... mybatis中和$与#的区别 ... mybatis二级缓存优缺点 ...