mapper mysql 主键_mybatis插入数据时返回主键(mysql数据库)

第一种方式使用useGeneratedKeys属性

User类

public class User {

private int id;

private String username;

private Date birthday;

private String sex;

private String address;

...

mapper文件

insert into user(username, birthday, sex, address)

values (#{username}, #{birthday}, #{sex}, #{address})

在insert标签中需要将useGeneratedKeys属性设置为true

keyProperty属性值是主键对应的pojo中的属性

返回的主键会放置在入参对象中的id属性上

mapper接口

public interface UserMapper {

void insertUser(User user) throws Exception;

}

测试代码

@Test

public void testInserUser () throws Exception {

SqlSession sqlSession = sqlSessionFactory.openSession();

UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

User user = new User();

user.setUsername("张三");

us