@SelectKey获取插入数据后的主键id.
- keyColumn:主键列名
- keyProperty:主键在java类的属性名
- before:获取id是插入前,还是插入后,一般取值:false
- resultType:返回类型 一般取值:Integer.class
- statement: 定义sql语句,获取插入数据后的主键
@Mapper
public interface UserMapper {
@SelectKey(keyColumn = "id",keyProperty = "id",before = false,
statement = {"select last_insert_id()"},resultType = Integer.class)
@Insert("insert into user(username,birthday,user_sex,user_address)
values(#{username},#{birthday},#{userSex},#{userAddress})")
int insetUser(User user);
}



