sql插入时返回插入主键id（id位自动增长）

Controller

 	@RequestMapping(value = "/getAddTest", method = RequestMethod.POST)
    @ApiOperation(value = "测试添加返回主键id")
    public ApiResult getAddTest(EmployUser user) {
        employeeService.getAddTest(user);
        return ApiResult.ok();
    }

Service

void getAddTest(EmployUser user);

Impl

 @Override
    public void getAddTest(EmployUser user) {
        employeeMapper.testAdd( user);
        Integer id = user.getId();
        System.out.println(id);
    }

Mapper

void testAdd(EmployUser user);

XML

<insert id="testAdd" useGeneratedKeys="true" keyProperty="id" parameterType="EmployUser">
    INSERT INTO gs_employee_user ( phone_number, full_name)
    VALUES
        (#{phoneNumber} , #{fullName} );
</insert>

 <!--   关键   useGeneratedKeys="true" keyProperty="id"
 只需要在insert标签中加入
useGeneratedKeys="true" keyProperty="id"
这个主键id通过实体类的属性.getId就ok了
-->
<insert id="testAdd" useGeneratedKeys="true" keyProperty="id" parameterType="EmployUser">