@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);
}