mybatis 实现Oracle的自增长id

mapper.xml文件 ：

这里selectKey会将结果设置给userId,在外部调用的时候直接传入用户名，密码即可

<insert id="insertUser" parameterType="user">
		<selectKey keyProperty="userId" resultType="String" order="BEFORE">
			select to_char(to_number(userid)+1) userid from (select userid from users order by userid desc) where rownum=1
		</selectKey>
		insert into users(userid, username, password) values(#{userId}, #{username}, #{password})
	</insert>

实体类中的属性：

 测试用例：

    public void testInsertUser() throws Exception {
        // 通过工厂得到 SqlSession
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User user = new User();
        user.setPassword("1234124");
        user.setUsername("wers");
        mapper.insertUser(user);
        sqlSession.commit();
    }