mybatis插入数据后返回主键id

设置插入数据后返回主键id，有俩种方法

1.

<insert id="insert" parameterType="com.ypf.pojo.TDog" useGeneratedKeys="true" keyProperty="id">
    INSERT INTO t_dog(dogName,dogSex,dogAge) values(#{dogName},#{dogSex},#{dogAge});
</insert>

2.

    <insert id="insert" parameterType="com.ypf.pojo.TDog" >
       <selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="id">
          SELECT LAST_INSERT_ID()
       </selectKey>
      INSERT INTO t_dog(dogName,dogSex,dogAge) values(#{dogName},#{dogSex},#{dogAge});
    </insert>

通过插入的对象来获得主键id

dogService.addDog(dog);
int dogId = dog.getId();