mybatis插入返回自动生成的主键

1、在相应insert语句中加入两个属性useGeneratedKeys="true" keyProperty="id"；keyProperty中对应相应id的字段名；

具体如下：

<insert id="insert" parameterType="com.test.domain.User" useGeneratedKeys="true" keyProperty="id">
    insert into lend_order
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        id,
      </if>
      <if test="userName != null" >
        user_name
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        #{id,jdbcType=BIGINT},
      </if>
      <if test="userName != null" >
        #{userName,jdbcType=VARCHAR}
      </if>
    </trim>

</insert>

2、在service中返回user.getId();