Mybatis添加用户信息同时获取自增的主键
void insertUser(User user);
<insert id="insertUser" useGeneratedKeys="true" keyProperty="id">
insert into t_user values(null,#{username},#{password},#{age},#{gender},#{email})
</insert>
@Test
public void insertUserTest(){
SqlSession sqlSession = SqlSessionUtil.getSqlSession();
SpecialSQLMapper mapper = sqlSession.getMapper(SpecialSQLMapper.class);
User user = new User(null,"lise","78322",27,"女","78322@qq.com");
mapper.insertUser(user);
System.out.println("user = " + user);
}