MybatisPlus中使用通用CRUD实现插入操作

超、凢脫俗 2023-10-18 17:21 34阅读 0赞

## 场景 ##

项目搭建专栏：

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

在MyBatisPlus介绍入门以及项目集成MyBatisPlus的基础上：

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

MyBatisPlus的通用CRUD:

官方文档：[https://baomidou.gitee.io/mybatis-plus-doc/\#/generic-crud][https_baomidou.gitee.io_mybatis-plus-doc_generic-crud]

MyBatis实现CRUD:

编写Mapper接口，并手动编写CRUD方法。

提供mapper.xml映射文件，并编写方法对应的SQL语句。

MyBatisPlus实现CRUD:

只需要创建Mapper接口，并继承BaseMapper接口。

## 实现 ##

新建EmployeeMapper接口以及mapper包

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

编写mapper接口使其继承BaseMapper

package com.badao.mapper;
    
    import com.badao.beans.Employee;
    import com.baomidou.mybatisplus.mapper.BaseMapper;
    
    /***
     * 泛型指定就是当前mapper接口所操作的实体类类型
     * @author Administrator
     * @Description:
     * @Time:2019年4月18日 下午8:36:59
     */
    
    public interface EmployeeMapper extends BaseMapper<Employee> {
    
    
    }

找到实体类Employee

添加主键策略以及制定表名

MP支持以下4种主键策略：

<table> 
 <thead> 
  <tr> 
   <th>值</th> 
   <th>描述</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>IdType.AUTO</td> 
   <td>数据库ID自增</td> 
  </tr> 
  <tr> 
   <td>IdType.INPUT</td> 
   <td>用户输入ID</td> 
  </tr> 
  <tr> 
   <td>IdType.ID_WORKER</td> 
   <td>全局唯一ID，内容为空自动填充（默认配置）</td> 
  </tr> 
  <tr> 
   <td>IdType.UUID</td> 
   <td>全局唯一ID，内容为空自动填充</td> 
  </tr> 
 </tbody> 
</table>

这里数据中的表设计的是自增，所以在id上指定

@TableId(value="id",type=IdType.AUTO)

指定数据库中的表名，如果表名与实体类名字一致则可以不用添加，如果名字不一致则必须添加。

@TableName(value="employee")

实体bean代码：

package com.badao.beans;
    
    import com.baomidou.mybatisplus.annotations.TableId;
    import com.baomidou.mybatisplus.annotations.TableName;
    import com.baomidou.mybatisplus.enums.IdType;
    
    @TableName(value="employee")
    public class Employee {
     
     @TableId(value="",type=IdType.AUTO)
     private Integer id;
     private String name;
     private String email;
     private Integer gender;
     private Integer age;
     public Integer getId() {
      return id;
     }
     public void setId(Integer id) {
      this.id = id;
     }
     public String getName() {
      return name;
     }
     public void setName(String name) {
      this.name = name;
     }
     public String getEmail() {
      return email;
     }
     public void setEmail(String email) {
      this.email = email;
     }
     public Integer getGender() {
      return gender;
     }
     public void setGender(Integer gender) {
      this.gender = gender;
     }
     public Integer getAge() {
      return age;
     }
     public void setAge(Integer age) {
      this.age = age;
     }
     
    }

编写单元测试方法

/***
      * 测试通用插入操作
      */
     @Test
     public void testCommonInsert() {
      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);
     }

运行单元测试

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

查看数据库效果：

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

## 源码下载 ##

[https://download.csdn.net/download/badao\_liumang\_qizhi/11126580][https_download.csdn.net_download_badao_liumang_qizhi_11126580]

[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_89385833]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/89385833
[https_baomidou.gitee.io_mybatis-plus-doc_generic-crud]: https://baomidou.gitee.io/mybatis-plus-doc/#/generic-crud
[Image 1]: 
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190419205822784.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/2019041921004250.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 2]: https://img-blog.csdnimg.cn/20190419210051274.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_11126580]: https://download.csdn.net/download/badao_liumang_qizhi/11126580