舒大少博客

手机扫码查看

2020java框架教程之mybatis获取刚刚插入的id(自增)

一：插入记录

需求：新增一个用户

DDL操作

二：获取自增id

<insert id="insertUsers" parameterType="Users" useGeneratedKeys="true" keyProperty="id">
    insert into users(username,password,rolename,identity,mobile)
    values(#{username},#{password},#{rolename},#{identity},#{mobile})
</insert>

@Test
public void test10(){
    SqlSession sqlSession = MybatisUtils.getSqlSession();
    UsersDao mapper = sqlSession.getMapper(UsersDao.class);
    Users users=new Users("可admin444","admin444","可admin444","7","144");
    int i = mapper.insertUsers(users);
    if(i>0) System.out.println("新增成功");
    else System.out.println("新增失败");
    sqlSession.commit();//事务提交
    sqlSession.close();
    System.out.println(users);
}

也可以在mybatis-config.xml配置

<settings>
    <setting name="useGeneratedKeys" value="true"/>
</settings>