MybatisPlusInterceptor實現(xiàn)sql攔截器超詳細教程

更新時間：2023年08月01日 08:36:45 作者：學不會揍你

這篇文章主要給大家介紹了關于MybatisPlusInterceptor實現(xiàn)sql攔截器超詳細教程的相關資料,文中通過示例代碼介紹的非常詳細,對大家學習或者工作具有一定的參考借鑒價值,需要的朋友可以參考下

1 . 導入pom

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.2</version>
        </dependency>

2 . 配置下MybatisPlus的yml

mybatis-plus:
  mapper-locations:
  - classpath:mapper/*/*Mapper.xml  
  global-config:
    db-config:
      id-type: auto
    banner: true
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

3 . 實體類

@Data
@TableName("sys_user")
@ApiModel(value = "SysUser對象", description = "用戶信息")
public class SysUser implements Serializable {
    @TableId("SU_CODE")
    @ApiModelProperty(value = "用戶編碼")
    private String suCode;
    @TableField("SUS_CODE")
    @ApiModelProperty(value = "分類編碼")
    private String susCode;
    @TableField("SU_NAME")
    @ApiModelProperty(value = "用戶姓名")
    private String suName;
    @TableField("SU_SEX")
    @ApiModelProperty(value = "性別：0未知，1男，2女")
    private Integer suSex;
    @TableField("SU_AGE")
    @ApiModelProperty(value = "年齡")
    private Integer suAge;
}

4 . DTO

@Data
@ApiModel(value = "SysUserDTO對象", description = "用戶信息DTO")
public class SysUserDTO {
    @ApiModelProperty(value = "用戶編碼")
    private String suCode;
    @ApiModelProperty(value = "分類編碼")
    private String susCode;
    @ApiModelProperty(value = "用戶姓名")
    private String suName;
    @ApiModelProperty(value = "性別：0未知，1男，2女")
    private Integer suSex;
    @ApiModelProperty(value = "年齡")
    private Integer suAge;
    private Integer page = 1;
    private Integer limit = 10;
}

5 . MybatisPlus的config

import cn.hutool.core.util.ArrayUtil;
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.autoconfigure.ConfigurationCustomizer;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.handler.TenantLineHandler;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.TenantLineInnerInterceptor;
import lombok.extern.slf4j.Slf4j;
import net.sf.jsqlparser.expression.Expression;
import net.sf.jsqlparser.expression.LongValue;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Slf4j
@Configuration
public class MybatisPlusConfig {
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        log.info("進入sql攔截器");
        //分頁攔截器插件
        //如果用了分頁插件注意先 add TenantLineInnerInterceptor 再 add PaginationInnerInterceptor
        interceptor.addInnerInterceptor(new TenantLineInnerInterceptor(new TenantLineHandler() {
            //租戶id(拼接sql的條件的值)
            @Override
            public Expression getTenantId() {
                return new LongValue(1);
            }
            //追加的字段(拼接sql的條件)
            @Override
            public String getTenantIdColumn() {
                return "SU_CODE";
            }
            //去掉實體類字段
            @Override
            public boolean ignoreTable(String tableName) {
                String[] arr = new String[]{
                        "susCode",
                        "suName",
                        "suSex",
                        "suAge"
                };
                return ArrayUtil.contains(arr, tableName);
            }
        }));
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return interceptor;
    }
    // 用了分頁插件必須設置 MybatisConfiguration#useDeprecatedExecutor = false
    //        interceptor.addInnerInterceptor(new PaginationInnerInterceptor());
    @Bean
    public ConfigurationCustomizer configurationCustomizer() {
        return configuration -> configuration.setUseDeprecatedExecutor(false);
    }
}

6 . controller

@RestController
@RequestMapping("exam")
public class SysUserController {
    @Autowired
    private SysUserService sysUserService;
    @RequestMapping("list")
    public IPage<SysUser> list(SysUserDTO userDTO) {
        IPage<SysUser> page = new Page<>(userDTO.getPage(), userDTO.getLimit());
        return sysUserService.page(page);
    }
}