MybatisPlus中插入数据获取主键值

叁歲伎倆 2023-10-18 17:24 0阅读 0赞

## 场景 ##

项目搭建专栏：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/column/info/37194][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_column_info_37194]

基础搭建：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/89407994][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_89407994]

## 实现 ##

编写单元测试方法

/***
      * 测试插入数据获取主键
      */
     @Test
     public void testInsertReturnId() {
      Employee employee = new Employee();
      employee.setName("霸道获取主键");
      employee.setAge(23);
      employee.setEmail("123@163.com");
      employee.setGender(1);
      int result = employeeMapper.insert(employee);
      System.out.println("************************"+result);
      Integer id = employee.getId();
      System.out.println("*********************"+id);
     }

主键id设置为自增，在插入数据时没有对其赋值，要想获取插入后的

数据的主键id值，可以直接在插入后通过Integer id = employee.getId();获取。

运行测试

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70][]

查看数据库

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1][]

## 源码下载 ##

[https://download.csdn.net/download/badao\_liumang\_qizhi/11131709][https_download.csdn.net_download_badao_liumang_qizhi_11131709]

[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_column_info_37194]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/column/info/37194
[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_89407994]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/89407994
[Image 1]: 
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190421130412640.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20190421130423443.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[https_download.csdn.net_download_badao_liumang_qizhi_11131709]: https://download.csdn.net/download/badao_liumang_qizhi/11131709