关于java插入数据返回主键问题

我之前以为在xml中设置了useGeneratedKeys="true" keyProperty="id"就可以了
其实不然，这只是返回自增主键id。
如果用的是uuid字符串我就们就需要在下面加入一行代码

<selectKey keyProperty="id" order="AFTER" resultType="java.lang.Long">
      select LAST_INSERT_ID()
</selectKey>

xml示例代码

<insert id="insertSelective" parameterType="com.demo.GoodsSpecPO" useGeneratedKeys="true" keyProperty="id">
    <selectKey keyProperty="id" order="AFTER" resultType="java.lang.Long">
      select LAST_INSERT_ID()
    </selectKey>
    insert into table_name
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="specIndex != null">
        spec_index,
      </if>
      <if test="name != null">
        `name`,
      </if>
      <if test="type != null">
        `type`,
      </if>
      <if test="categoryId != null">
        category_id,
      </if>
      <if test="creator != null">
        creator,
      </if>
      <if test="creatorId != null">
        creator_id,
      </if>
      <if test="updator != null">
        updator,
      </if>

        create_time,

        update_time,

        deleted,

      <if test="version != null">
        version,
      </if>
    </trim>