mybatis 获得插入记录主键

映射文件

<insert id="insertUserBaiscInfo" parameterType="hashmap">
<selectKey resultType="String" order="AFTER" keyProperty="id">
SELECT LAST_INSERT_ID() AS id
</selectKey>
INSERT INTO
u_userinfo
(
memberid,
nickname,
sex,
userpicurl
)
VALUES
(
#{memberid},
#{nickname},
#{sex},
#{userpicurl}
)
</insert>

调用:

 log.info("获得id="+map.get("memberid")); 

memberid是该表的主键

原文地址:https://www.cnblogs.com/caer/p/5681615.html