mybatis中主键自增返回的两种方式

第一种：在xxxMapper.xml中
使用 useGeneratedKeys=“true” 和 keyProperty=“id” 属性 注意keyProperty的值为数据库对应实体主键字段

<insert id="insert" useGeneratedKeys="true" keyProperty="id">
        insert into user (openid, name, phone, sex, id_number, avatar, create_time)
        values (#{openid}, #{name}, #{phone}, #{sex}, #{idNumber}, #{avatar}, #{createTime})
    </insert>

第二种：在xxxMapper.java中使用
@Options(useGeneratedKeys = true, keyProperty = “id”)

	@Options(useGeneratedKeys = true, keyProperty = "id")
    @Insert("insert into user(openid, name, phone, sex, id_number, avatar, create_time) VALUE (#{openid},#{name},#{phone},#{sex},#{idNumber},#{avatar},#{createTime})")
    void insert(User user);