mybatis保存的时候返回值为数据库中主键的id值 [数据库教程]

database

select last_insert_id();

insert into t_user (id, avatar, create_time,

email, nick_name, password,

type, update_time, user_name,

file_id, register_method, token,

short_message, telephone, location,

job, city, district,

province, update_pw_time, salt,

github_url, qq_number, wechat_number,

user_log)

values (#{id,jdbcType=INTEGER}, #{avatar,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP},

#{email,jdbcType=VARCHAR}, #{nickName,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR},

#{type,jdbcType=INTEGER}, #{updateTime,jdbcType=TIMESTAMP}, #{userName,jdbcType=VARCHAR},

#{fileId,jdbcType=BIGINT}, #{registerMethod,jdbcType=VARCHAR}, #{token,jdbcType=VARCHAR},

#{shortMessage,jdbcType=VARCHAR}, #{telephone,jdbcType=VARCHAR}, #{location,jdbcType=VARCHAR},

#{job,jdbcType=VARCHAR}, #{city,jdbcType=VARCHAR}, #{district,jdbcType=VARCHAR},

#{province,jdbcType=VARCHAR}, #{updatePwTime,jdbcType=TIMESTAMP}, #{salt,jdbcType=VARCHAR},

#{githubUrl,jdbcType=VARCHAR}, #{qqNumber,jdbcType=VARCHAR}, #{wechatNumber,jdbcType=VARCHAR},

#{userLog,jdbcType=BIGINT})

mybatis保存的时候返回值为数据库中主键的id值