Mybatis获取自增长ID

1、向xxMapping.xml配置中加上配置

<insert id="addRole" parameterType="com.yy.beans.Role" useGeneratedKeys="true" keyColumn="rid" keyProperty="rid">
    insert into t_role values (null,#{rname})
</insert>

keyColumn的值就是数据库中自增长字段名。

keyProperty的值就是实体类中自增长字段名。

2.插入成功后，直接通过对象的get的方法就能获得自增长的id值

public void addRole1() throws IOException {
        InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        RoleDao roleDao = sqlSession.getMapper(RoleDao.class);

        Role role = new Role("超级会员");
        roleDao.addRole(role);
        System.out.println("获取到的自增长ID为："+role.getRid());


        sqlSession.commit();
        sqlSession.close();
    }