Mysql insert插入成功后返回id

记一次mysql插入后返回当前插入记录的id。xml中，添加useGeneratedKeys="true" keyProperty="id"

<insert id="insertSelective" parameterType="com.xxx.model.WhiteUser" useGeneratedKeys="true"
          keyProperty="id">
    insert into white_user
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="idCard != null">
        id_card,
      </if>
      <if test="name != null">
        name,
      </if>
      <if test="phone != null">
        phone,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=INTEGER},
      </if>
      <if test="idCard != null">
        #{idCard,jdbcType=VARCHAR},
      </if>
      <if test="name != null">
        #{name,jdbcType=VARCHAR},
      </if>
      <if test="phone != null">
        #{phone,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>

java代码中这样调用即可返回当前记录的id

        whiteUserMapper.insertSelective(whiteUser);
        Integer id = whiteUser.getId();