MyBatis应用获取主键

简单获取数据库刚存储数据的主键

在映射文件中配置selectKey信息

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="userMapper">
<insert id="save" parameterType="user">
      <selectKey resultType="int" keyColumn="id" keyProperty="id">
          select Last_INSERT_ID()
      </selectKey>
        insert into user values (#{id},#{username},#{password})
    </insert>
</mapper>

测试代码

public void test2() throws IOException {    
//模拟user对象    
User user = new User();    
user.setUsername("xxx");    
user.setPassword("abc");    
//获得核心配置文件    
InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");    
//获得session工厂对象    
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);    
//获得session回话对象    
SqlSession sqlSession = sqlSessionFactory.openSession(true);    
//执行操作  参数：namespace+id
    sqlSession.insert("userMapper.save",user);  
    //获取刚存储得数据的主键id
    System.out.println(user.getId());    
//mybatis执行更新操作  提交事务    //sqlSession.commit();    
    //释放资源    
    sqlSession.close();}