mybatis返回插入值的主键

1、主键为int型自增主键
<insert id="loginRegist" parameterType="com.wucai.po.LoginCustom">
<!-- 返回最后一条插入记录的自增主键 -->
  <selectKey keyProperty="lid" order="AFTER" resultType="int">
  SELECT LAST_INSERT_ID()
  </selectKey>
INSERT INTO login (
LID, Email, Password, Flag
)
VALUES(
#{lid}, #{email}, #{password}, #{flag} 
)
</insert>


2、主键为UUID类型的非自增主键
<insert id="loginRegist" parameterType="com.wucai.po.LoginCustom">
<!-- 返回最后一条插入记录的非自增主键 -->
<selectKey keyProperty="lid" order="BEFORE" resultType="java.lang.String">
  SELECT uuid();
  </selectKey>
INSERT INTO login (
LID, Email, Password, Flag
)
VALUES(
#{lid}, #{email}, #{password}, #{flag} 
)
</insert>