【mybatis】插入数据并返回主键

<!-- 插入数据并返回主键 -->
  <insert id="insertRechargeMsgReturnKey" 
  		useGeneratedKeys="true" keyColumn="order_id" keyProperty="orderId"
  		parameterType="com.ipp.model.RechargeOrder">
  	insert into recharge_order (RECHARGE_TYPE, MOBILE, 
      FACEVALUE, RECHARGE_TIME, STATUS, 
      RETMSG, UPDATE_TIME)
    values (#{rechargeType}, #{mobile},#{facevalue}, #{rechargeTime}, #{status}, 
      #{retmsg}, #{updateTime})
      <selectKey resultType="int" keyProperty="orderId" order="AFTER">
      	SELECT LAST_INSERT_ID()
      </selectKey>
  </insert>

配置如上

在普通的插入语句中加上

useGeneratedKeys="true" keyColumn="表主键" keyProperty="对应字段"

并在下面加上一个标签:

<selectKey resultType="int" keyProperty="orderId" order="AFTER">
    SELECT LAST_INSERT_ID()
</selectKey>

将最后插入的主键返回