MyBatis 如何获取返回自增主键值？

今天药忘吃喽~ 2022-12-13 11:29 217阅读 0赞

主键自增，可以在 insert 方法执行完之后把 id 设置到传入的对象的属性

#建表 SQL
    create table user(
    id int PRIMARY KEY auto_increment,
    name varchar(400)
    );
    
    
    < insert id="insertUser" parameterType="constxiong.po.User" useGeneratedKeys="true" keyProperty="id">
        insert into user(name) values(#{name})
    < /insert>
    
    //java 代码
    for (int i = 0; i < 10; i++) {
        User user = new User(null, "constxiong" + i);//这里 user.id = null
        userMapper.insertUser(user);
        System.out.println("id:" + user.getId());//插入数据库后，这里的 user.id 为主键值
    }

完整 Demo：

[https://javanav.com/val/3ac331d2674b4c108469cce54ae126f3.html][https_javanav.com_val_3ac331d2674b4c108469cce54ae126f3.html]

--------------------

### 【Java面试题与答案】整理推荐 ###

*  [基础与语法][Link 1]
 *  [集合][Link 2]
 *  [网络编程][Link 3]
 *  [并发编程][Link 4]
 *  [Web][]
 *  [安全][Link 5]
 *  [设计模式][Link 6]
 *  [框架][Link 7]
 *  [算法与数据结构][Link 8]
 *  [异常][Link 9]
 *  [文件解析与生成][Link 10]
 *  [Linux][]
 *  [MySQL][]
 *  [Oracle][]
 *  [Redis][]
 *  [Dubbo][]

[https_javanav.com_val_3ac331d2674b4c108469cce54ae126f3.html]: https://javanav.com/val/3ac331d2674b4c108469cce54ae126f3.html
[Link 1]: https://www.javanav.com/interview/93b0069472fd479393006c0e73043fc4.html
[Link 2]: https://www.javanav.com/interview/4147d95e693945e7a50345fd33ec817e.html
[Link 3]: https://www.javanav.com/interview/68a57ffc78de4133bb890bdd502ac418.html
[Link 4]: https://www.javanav.com/interview/36a24fa3258e45c89873f474ce914912.html
[Web]: https://www.javanav.com/interview/4e27cb63adb440c6825a159d35cf4010.html
[Link 5]: https://www.javanav.com/interview/03affb2ce3f04fda8853f714e5764906.html
[Link 6]: https://www.javanav.com/interview/07a32a9ff17a4006a53550ce658cafed.html
[Link 7]: https://www.javanav.com/interview/5c466456e9b54ab0a749b5948e51f1d3.html
[Link 8]: https://www.javanav.com/interview/943f917041ee4f05add24539f5b861b2.html
[Link 9]: https://www.javanav.com/interview/d3f058cfc05d4c6dadd821b622e84d36.html
[Link 10]: https://www.javanav.com/interview/67a50996c28f418e83b109ea42fc3eff.html
[Linux]: https://www.javanav.com/interview/00cccb81729540d1923bd0a0ef49533a.html
[MySQL]: https://www.javanav.com/interview/d311e78502a845f1a4bb307bd6aec2b3.html
[Oracle]: https://www.javanav.com/interview/5f29e9677edf4a16be3dce30d257c9ab.html
[Redis]: https://www.javanav.com/interview/066c62b3af4d4827b2243a822c3084a9.html
[Dubbo]: https://www.javanav.com/interview/9a3e7a7740324757abaab953f7ebc455.html