MyBatisPlus中全局Sql注入器应用_逻辑删除使用

以你之姓@ 2023-10-18 17:47 24阅读 0赞

## 场景 ##

项目搭建专栏：

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

MyBatisPlus中自定义全局操作流程：

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

### 什么是逻辑删除 ###

假删除、逻辑删除，并不会真正的从数据库中将数据删除掉，而是将当前被删除的

这条数据的一个逻辑字段置为删除状态。

## 实现 ##

### 全局配置注入LogicSqlInjector ###

打开项目的applicationContext.xml

<bean id="logicSqlInjector" class="com.baomidou.mybatisplus.mapper.LogicSqlInjector"></bean>
    
    然后在全局策略配置中注入
    
    
     <bean id ="globalConfiguration" class="com.baomidou.mybatisplus.entity.GlobalConfiguration">
      
      <property name="dbColumnUnderline" value="true"></property>
      
      
      <property name="idType" value="0"></property>
      
      
      
      
      
      
      
      
      <property name="sqlInjector" ref="logicSqlInjector" />
      
      
      <property name="logicDeleteValue" value="1" />
         <property name="logicNotDeleteValue" value="0" />
      
     </bean>

注：

logicDeleteValue // 逻辑删除全局值  
logicNotDeleteValue // 逻辑未删除全局值

### 添加logic字段 ###

数据库中添加logic字段

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

对应实体类添加字段

@TableLogic
     private Integer logicFlag;//逻辑删除

添加注解@TableLogic并生成get和set方法。

完整实体类

package com.badao.beans;
    
    import java.io.Serializable;
    
    import com.baomidou.mybatisplus.activerecord.Model;
    import com.baomidou.mybatisplus.annotations.TableField;
    import com.baomidou.mybatisplus.annotations.TableId;
    import com.baomidou.mybatisplus.annotations.TableLogic;
    import com.baomidou.mybatisplus.annotations.TableName;
    import com.baomidou.mybatisplus.annotations.Version;
    import com.baomidou.mybatisplus.enums.IdType;
    import com.mchange.util.FailSuppressedMessageLogger;
    
    @TableName(value="employee")
    public class Employee  extends Model<Model>{
     
     @TableId(value="id",type=IdType.AUTO)
     private Integer id;
     //@TableField(value="last_name")
     private String name;
     private String email;
     private Integer gender;
     private Integer age;
     @TableField(exist=false)
     private String remark;
     @Version
        private Integer version;
     @TableLogic
     private Integer logicFlag;//逻辑删除
     public Integer getVersion() {
      return version;
     }
     public Integer getLogicFlag() {
      return logicFlag;
     }
     public void setLogicFlag(Integer logicFlag) {
      this.logicFlag = logicFlag;
     }
     public void setVersion(Integer version) {
      this.version = version;
     }
     public String getRemark() {
      return remark;
     }
     public void setRemark(String remark) {
      this.remark = remark;
     }
     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;
     }
     
     /***
      * 必须指定当前实体类的主键属性
      */
     @Override
     protected Serializable pkVal() {
      // TODO Auto-generated method stub
      return id;
     }
     
    }

## 测试 ##

编写测试方法

/***
      *  逻辑删除
      */
     @Test
     public void testlogicdelete() {
      
       int result = employeeMapper.deleteById(24);
       System.out.println("***********"+result);
      
     }

## 效果 ##

会在mp自带查询和更新方法的sql后面，追加『逻辑删除字段』=『LogicNotDeleteValue默认值』 删除方法: deleteById()和其他delete方法, 底层SQL调用的是update tbl\_xxx set 『逻辑删除字段』=『logicDeleteValue默认值』

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

此时再查看数据库，逻辑删除字段已经变为1。

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

此时修改测试方法查询id为24的实体类。

/***
      *  逻辑删除
      */
     @Test
     public void testlogicdelete() {
      
       /*int result = employeeMapper.deleteById(24);
       System.out.println("***********"+result);*/
       Employee employee =employeeMapper.selectById(24);
       System.out.println(employee);
      
     }

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

已经查询不到了。

## 源码下载 ##

[https://download.csdn.net/download/badao\_liumang\_qizhi/11148612][https_download.csdn.net_download_badao_liumang_qizhi_11148612]

[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_89608052]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/89608052
[Image 1]: 
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/2019042819315773.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/20190428193305559.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/20190428193317771.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 3]: https://img-blog.csdnimg.cn/20190428193327354.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_11148612]: https://download.csdn.net/download/badao_liumang_qizhi/11148612