1.自己写返回主键
keyProperty="userId"中userId对应的值是领域模型TbSysUser中对应的userId;不是数据库中对应的字段名
<!-- 测试插入返回主键 -->
<insert id="addUser" parameterType="com.czht.wdp.core.sys.pojo.TbSysUser" useGeneratedKeys="true" keyProperty="userId">
insert into tb_sys_user(account,username,password,phone,email) values(#{account}, #{username}, #{password}, #{phone},#{email})
</insert>
2.使用mapper自带的也可以获得主键
@Override
public Integer addUser(SysUserDto sysUserDto) {
sysUserDto.setPassword(MD5Util.MD5(sysUserDto.getPassword()));
TbSysUser tbSysUser = BeanUtils.convert(sysUserDto, TbSysUser.class);
int ok = sysUserMapper.insertSelective(tbSysUser);//Mybatis自带的新增也可以获得主键
sysUserDto.setUserId(tbSysUser.getUserId());
return ok;
}