mybatis-plus入门应用及与现有mybatis架构融合

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.1.4.RELEASE</version>
    <relativePath/>
</parent>

2.引入 spring-boot-starter、spring-boot-starter-test、mybatis-plus-boot-starter、lombok、mysql 依赖：

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <scope>test</scope>
</dependency>
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <optional>true</optional>
</dependency>

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

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-generator</artifactId>
    <version>3.1.1</version>
</dependency>
<dependency>
    <groupId>org.apache.velocity</groupId>
    <artifactId>velocity-engine-core</artifactId>
    <version>2.1</version>
</dependency>

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

3.数据库配置

## 数据库配置 ##
spring:
datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://47.112.10.128:3306/study-test?useSSL=false&useUnicode=true&characterEncoding=utf8&tinyInt1isBit=false&allowMultiQueries=true
    username: root
    password: 123456

4. 在 Spring Boot 启动类中添加 @MapperScan 注解，扫描 Mapper 文件夹：

@SpringBootApplication
@MapperScan({"mybatis.mapper"})
public class MybatisApplication {
    public static void main(String[] args) {
        SpringApplication.run(MybatisApplication.class,args);
    }
}

5.实体类

@Data
public class User {
    private Long id;
    private String name;
    private Integer age;
    private String email;
}

6.Dao类，继承BaseMapper类

package mybatis.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import mybatis.entity.User;

public interface UserMapper extends BaseMapper<User> {
}

7.测试类

package mybatis;

import mybatis.entity.User;
import mybatis.mapper.UserMapper;
import org.junit.Assert;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import javax.annotation.Resource;
import java.util.List;

@RunWith(SpringRunner.class)
@SpringBootTest
public class MybatisTest {

    @Resource
    private UserMapper userMapper;

    @Test
    public void testSelect(){
        System.out.println(("----- selectAll method test ------"));
        List<User> userList = userMapper.selectList(null);
        Assert.assertEquals(11, userList.size());
        userList.forEach(System.out::println);//lambda写法
    }

}

How do it？

与springboot的结合使用。

2.1配置

.yml简单配置

## tomcat端口 ##
server:
port: 9999

## 数据库配置 ##
spring:
datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://47.112.10.128:3306/study-test?useSSL=false&useUnicode=true&characterEncoding=utf8&tinyInt1isBit=false&allowMultiQueries=true
    username: root
    password: 123456

# Logger Config
logging:
level:
    com.baomidou.mybatisplus.samples.quickstart: debug

mybatis-plus:
mapper-locations: classpath:mapper/**/*.xml

.yml其他配置

server:
port: 8080
#spring
spring:
aop:
    proxy-target-class: true

#DATABASE CONFIG 注意这里连得是sql server
datasource:
    druid:
      driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
      username: tdxuser
      password: ${MSSQL_PASSWORD:tdxgps}
      url: jdbc:sqlserver://${MSSQL_HOST:192.168.2.77:5609};databaseName=TDXDB
      initial-size: 1
      max-active: 20
      min-idle: 1
      max-wait: 60000
      validation-query: select 'x'
      validationQueryTimeout: 5
      test-on-borrow: false
      test-on-return: false
      test-while-idle: true
      time-between-eviction-runs-millis: 60000
      min-evictable-idle-time-millis: 300000
      filters: log4j
      filter:
        stat:
          enabled: true
          log-slow-sql: true
          slow-sql-millis: 1000
          merge-sql: true
          #db-type: sqlserver
        slf4j:
          enabled: true
          connection-log-enabled: true
          connection-close-after-log-enabled: true
          connection-commit-after-log-enabled: true
          connection-connect-after-log-enabled: true
          connection-connect-before-log-enabled: true
          connection-log-error-enabled: true
          data-source-log-enabled: true
          result-set-log-enabled: true
          statement-log-enabled: true
        wall:
          enabled: true
          config:
            alter-table-allow: false
            truncate-allow: false
            drop-table-allow: false
            #是否允许非以上基本语句的其他语句，缺省关闭，通过这个选项就能够屏蔽DDL
            none-base-statement-allow: false
            #检查UPDATE语句是否无where条件，这是有风险的，但不是SQL注入类型的风险
            update-where-none-check: true
            #SELECT ... INTO OUTFILE 是否允许，这个是mysql注入攻击的常见手段，缺省是禁止的
            select-into-outfile-allow: false
            #是否允许调用Connection.getMetadata方法，这个方法调用会暴露数据库的表信息
            metadata-allow: true
            #允许多条sql一起执行
            multiStatementAllow: true
          #对被认为是攻击的SQL进行LOG.error输出
          log-violation: true
          #对被认为是攻击的SQL抛出SQLExcepton
          throw-exception: true
          #db-type: mysql
      web-stat-filter:
        enabled: true
        url-pattern: /*
        exclusions: '*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*'
        #你可以配置principalSessionName，使得druid能够知道当前的cookie的用户是谁
        #principal-cookie-name: admin
        #你可以配置principalSessionName，使得druid能够知道当前的session的用户是谁
        #principal-session-name: admin
        #设置profileEnable能够监控单个url调用的sql列表。
        profile-enable: true
        #session统计功能
        session-stat-enable: false
        #最大session数
        session-stat-max-count: 100000
      stat-view-servlet:
        #allow: ${GATEWAY_HOST:172.26.114.241}
        enabled: true
        login-username: ${DRUID_USER:admin}
        login-password: ${DRUID_PWD:admin}
        url-pattern: /druid/*
        #允许清除记录
        reset-enable: false
      aop-patterns: com.tdx.account_service.service.*

# Redis配置
redis:
    #集群模式
    #cluster:
    # nodes:
    #    - 39.XXX.XX.69:6661
    #    - 39.XXX.XX.69:6662
    #    - 39.XXX.XX.69:6663
    #    - 39.XXX.XX.69:6664
    #    - 39.XXX.XX.69:6665
    #    - 39.XXX.XX.69:6666
    #单机模式
    host: ${REDIS_HOST:192.168.2.18}
  port: ${REDIS_PORT:7006}
    password: ${REDIS_PASSWORD:root}
    #连接超时时间（毫秒）
    timeout: 10000
    pool:
      config:
        max-idle: 20
        min-idle: 5
        max-active: 20
        max-wait: 2

#mybatis-plus
mybatis-plus:
mapper-locations: classpath*:/mapper/**Mapper.xml
#实体扫描，多个package用逗号或者分号分隔
typeAliasesPackage: com.tdx.account_service.entity
global-config:
    #主键类型 0:"数据库ID自增", 1:"用户输入ID",2:"全局唯一ID (数字类型唯一ID)", 3:"全局唯一ID UUID";
    id-type: 2
    #字段策略 0:"忽略判断",1:"非 NULL 判断"),2:"非空判断"
    field-strategy: 2
    #驼峰下划线转换
    db-column-underline: true
    #刷新mapper 调试神器
    refresh-mapper: true
    #数据库大写下划线转换
    #capital-mode: true
    #序列接口实现类配置
    #key-generator: com.baomidou.springboot.xxx
    #逻辑删除配置（下面3个配置）
    logic-delete-value: 0
    logic-not-delete-value: 1
    #自定义SQL注入器
    #sql-injector: com.baomidou.mybatisplus.mapper.LogicSqlInjector
    #自定义填充策略接口实现
    #meta-object-handler: com.baomidou.springboot.xxx
configuration:
    map-underscore-to-camel-case: true
    cache-enabled: false

#logging
logging:
level: warn

2.2代码生成器

可以帮我们生成代码框架，包括模块、controller、service、dao、entity以及xml。

依赖

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-generator</artifactId>
    <version>3.1.1</version>
</dependency>
<dependency>
    <groupId>org.apache.velocity</groupId>
    <artifactId>velocity-engine-core</artifactId>
    <version>2.1</version>
</dependency>

代码示例

package mybatis.generate;

import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.core.exceptions.MybatisPlusException;
import com.baomidou.mybatisplus.core.toolkit.StringPool;
import com.baomidou.mybatisplus.generator.AutoGenerator;
import com.baomidou.mybatisplus.generator.InjectionConfig;
import com.baomidou.mybatisplus.generator.config.*;
import com.baomidou.mybatisplus.generator.config.po.TableFill;
import com.baomidou.mybatisplus.generator.config.po.TableInfo;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;
import org.apache.commons.lang3.StringUtils;

import java.io.File;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

// 演示例子，执行 main 方法控制台输入模块表名回车自动生成对应项目目录中
public class GeneratorTest {

    /**
     * <p>
     * 读取控制台内容
     * </p>
     */
    public static String scanner(String tip) {
        Scanner scanner = new Scanner(System.in);
        StringBuilder help = new StringBuilder();
        help.append("请输入" + tip + "：");
        System.out.println(help.toString());
        if (scanner.hasNext()) {
            String ipt = scanner.next();
            if (StringUtils.isNotEmpty(ipt)) {
                return ipt;
            }
        }
        throw new MybatisPlusException("请输入正确的" + tip + "！");
    }

    public static void main(String[] args) {
        // 自定义需要填充的字段
        List<TableFill> tableFillList = new ArrayList<>();
        tableFillList.add(new TableFill("ASDD_SS", FieldFill.INSERT_UPDATE));
        // 代码生成器
        AutoGenerator mpg = new AutoGenerator();

        // 全局配置
        GlobalConfig gc = new GlobalConfig();
        String projectPath = System.getProperty("user.dir");
        gc.setOutputDir(projectPath + "/mybatis-plus/src/main/java");
        gc.setAuthor("zyz");
        gc.setOpen(false);
        gc.setBaseResultMap(true);
        gc.setBaseColumnList(true);
        gc.setEnableCache(true);//二级缓存
        gc.setFileOverride(true);//是否覆盖文件
        // gc.setSwagger2(true); 实体属性 Swagger2 注解
        mpg.setGlobalConfig(gc);

        // 数据源配置
        DataSourceConfig dsc = new DataSourceConfig();
        dsc.setUrl("jdbc:mysql://47.112.10.128:3306/study-test?useSSL=false&useUnicode=true&characterEncoding=utf8&tinyInt1isBit=false&allowMultiQueries=true");
        // dsc.setSchemaName("public");
        dsc.setDriverName("com.mysql.cj.jdbc.Driver");
        dsc.setUsername("root");
        dsc.setPassword("123456");
        mpg.setDataSource(dsc);

       // 包配置
        PackageConfig pc = new PackageConfig();
        pc.setModuleName(scanner("模块名"));
        pc.setParent("mybatis");//需要生成的包路径
        mpg.setPackageInfo(pc);

        // 自定义配置
        InjectionConfig cfg = new InjectionConfig() {
            @Override
            public void initMap() {
                // to do nothing
            }
        };

        // 如果模板引擎是 freemarker
//        String templatePath = "/templates/mapper.xml.ftl";
//         如果模板引擎是 velocity
         String templatePath = "/templates/mapper.xml.vm";

        //自定义mapper模板
         templatePath = "/templates/mapper.xml.ftl";

        // 自定义输出配置
        List<FileOutConfig> focList = new ArrayList<>();
//         自定义配置会被优先输出
        focList.add(new FileOutConfig(templatePath) {
            @Override
            public String outputFile(TableInfo tableInfo) {
                // 自定义输出文件名，如果你 Entity 设置了前后缀、此处注意 xml 的名称会跟着发生变化！！
                return projectPath + "/mybatis-plus/src/main/resources/mapper/" + pc.getModuleName()
                        + "/" + tableInfo.getEntityName() + "Mapper" + StringPool.DOT_XML;
            }
        });

        //自定义controller模板
        templatePath = "/templates/controller.java.ftl";

//         自定义配置会被优先输出
        focList.add(new FileOutConfig(templatePath) {
            @Override
            public String outputFile(TableInfo tableInfo) {
                // 自定义输出文件名 + pc.getModuleName()
                String expand = projectPath + "/mybatis-plus/src/main/java/mybatis/" +pc.getModuleName() + "/" + "controller";
                return String.format((expand + File.separator + "%s" + ".java"), tableInfo.getControllerName());
            }
        });
        /*
        cfg.setFileCreate(new IFileCreate() {
            @Override
            public boolean isCreate(ConfigBuilder configBuilder, FileType fileType, String filePath) {
                // 判断自定义文件夹是否需要创建
                checkDir("调用默认方法创建的目录");
                return false;
            }
        });
        */
        cfg.setFileOutConfigList(focList);
        mpg.setCfg(cfg);

        // 配置模板
        TemplateConfig templateConfig = new TemplateConfig();

        // 配置自定义输出模板
        //指定自定义模板路径，注意不要带上.ftl/.vm, 会根据使用的模板引擎自动识别
        // templateConfig.setEntity("templates/entity2.java");
        // templateConfig.setService();
//        templateConfig.setController(null);
        templateConfig.setXml(null);

        mpg.setTemplate(templateConfig);

        // 策略配置
        StrategyConfig strategy = new StrategyConfig();
        strategy.setNaming(NamingStrategy.underline_to_camel);
        strategy.setColumnNaming(NamingStrategy.underline_to_camel);
//        strategy.setSuperEntityClass("mybatis.BaseEntity");//设置父类
//        strategy.setEntityLombokModel(true);
        strategy.setRestControllerStyle(true);
//        strategy.setSuperControllerClass("mybatis.BaseController");//设置父类
        strategy.setInclude(scanner("表名，多个英文逗号分割").split(","));
//        strategy.setSuperEntityColumns("id");
//        strategy.setControllerMappingHyphenStyle(true);
        strategy.setTableFillList(tableFillList);
        strategy.setTablePrefix(pc.getModuleName() + "_");
        mpg.setStrategy(strategy);
        mpg.setTemplateEngine(new FreemarkerTemplateEngine());//默认模板引擎Velocity
        mpg.execute();
    }

}

目录结构

2.3调用示例

开启dao的扫描

@SpringBootApplication
//@MapperScan({"mybatis.mapper"})
@MapperScan({"mybatis.sys.mapper"})
public class MybatisApplication {
    public static void main(String[] args) {
        SpringApplication.run(MybatisApplication.class,args);
    }
}

代码生成器生成出来的代码，一般是没有任何代码的，但其实已经为我们完成了很多基础的CRUD接口的操作，demo如下：

package mybatis.sys.controller;

import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import mybatis.sys.entity.User;
import mybatis.sys.service.impl.UserServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
@RequestMapping("/sys/user")
public class UserController {

    @Autowired
    UserServiceImpl userService;

    //系统sql
    @GetMapping("/test")
    public String test(){

        List<User> list = userService.list();
        System.out.println(list.size());

//        Page<User> page = new Page<>(1, 5);
//        IPage<User> pageList = userService.page(page);

        //AbstractWrapper abstractWrapper = new AbstractWrapper(); // 抽象构造器
//        QueryWrapper<User> queryWrapper = new QueryWrapper<>(); // QueryWrapper
//        queryWrapper.ge("age",25).orderByDesc("age");
//        queryWrapper.ge("age",25).and(i -> i.ge("a",18).ge("b",20)); //相当于 age >= 25 and (a >= 18 and b >= 20)
        //ne eq gt it ie like between...
//        List<User> wrapperList = userService.list(queryWrapper);

//        UpdateWrapper<User> updateWrapper = new UpdateWrapper<>(); // UpdateWrapper

        return JSONObject.toJSONString(list);
    }
}

备注：其中分页插件、条件构造器查看后文。

2.4分页插件

Mybatis-plus内置依赖，无需再导包，只需添加分页插件配置Bean即可。

添加配置

@Configuration
public class MybatisConfig {

    /**
     * 分页插件
     */
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }

}

2.5条件构造器

内置抽象构造器AbstractWrapper，用于生成 sql 的 where 条件, entity 属性也用于生成 sql 的 where 条件，其子类包括QueryWrapper，UpdateWrapper，常用的QueryWrapper，条件如：

使用举例

QueryWrapper<User> queryWrapper = new QueryWrapper<>(); // QueryWrapper
queryWrapper.ge("age",25).orderByDesc("age");
queryWrapper.ge("age",25).and(i -> i.ge("a",18).ge("b",20)); //相当于 age >= 25 and (a >= 18 and b >= 20)

2.6自定义查询

Controller

//自定义sql
@GetMapping("/sql")
public String customSql(Integer id){
    User user = userService.getUserById(id);
    System.out.println(user.toString());
    return JSONObject.toJSONString(user);
}

//查询分页
@GetMapping("/page")
public String customPage(Integer minAge,Integer maxAge){
    Page<User> page = new Page<>(1, 5);
    IPage<User> listByAge = userService.getListByAge(page, minAge, maxAge);
    return JSONObject.toJSONString(listByAge);
}

//wrapper 条件构造器
@GetMapping("/wrapper")
public String customWrapper(Integer minAge,Integer maxAge){
    Page<User> page = new Page<>(1, 5);
    IPage<User> listByWrapper = userService.getListByWrapper(page, minAge, maxAge);
    return JSONObject.toJSONString(listByWrapper);
}

Dao

User getUserById(@Param("id") int id);

IPage<User> getListByAge(Page<User> page, @Param("minAge") int minAge, @Param("maxAge") int maxAge);

IPage<User> getListByWrapper(Page<User> page, @Param(Constants.WRAPPER) Wrapper wrapper);

Service

@Resource
UserMapper userMapper;

//自定义sql
public User getUserById(int id){
    return userMapper.getUserById(id);
}

//分页查询
public IPage<User> getListByAge(Page<User> page,int minAge, int maxAge){
    return userMapper.getListByAge(page,minAge,maxAge);
}

//条件构造器
public IPage<User> getListByWrapper(Page<User> page, int minAge, int maxAge){
    QueryWrapper<User> queryWrapper = new QueryWrapper<>();
    queryWrapper.ge("age",minAge).le("age",maxAge).orderByDesc("age");
    return userMapper.getListByWrapper(page,queryWrapper);
}

Xml

<select id="getUserById" resultType="mybatis.sys.entity.User">
    select * from user where id = #{id}
</select>

<select id="getListByAge" resultType="mybatis.sys.entity.User">
    select * from user where 1=1
    <if test="minAge != null">
        and age >= #{minAge}
    </if>
    <if test="maxAge != null">
        and age <= #{maxAge}
    </if>
</select>

<select id="getListByWrapper" resultType="mybatis.sys.entity.User">
    select * from user ${ew.customSqlSegment}
</select>

Do more？

3.1 sql性能分析插件

添加配置

@Configuration
public class MybatisConfig {

    /**
     * SQL执行效率插件- 性能分析插件
     */
    @Bean
    @Profile({"dev","test"})// 设置 dev test 环境开启
//    @Profile({"prod"})// 设置 dev test 环境开启
    public PerformanceInterceptor performanceInterceptor() {
        PerformanceInterceptor performanceInterceptor = new PerformanceInterceptor();
        performanceInterceptor.setFormat(true); //格式化sql
        performanceInterceptor.setMaxTime(1000); //设置运行时长，超过自动停止
//        performanceInterceptor.setMaxTime(20); //设置运行时长，超过自动停止
        return performanceInterceptor;
    }
}

输出示例

Time：56 ms - ID：mybatis.sys.mapper.UserMapper.getUserById

User(name=女枪, age=26, email=zyz@163.com)

Execute SQL：

select

from

user

where

id = 8

3.2 sql攻击阻断器

@Configuration
public class MybatisConfig {

    /**
     *攻击sql阻断器配置
     */

@Bean
public PaginationInterceptor paginationInterceptor() {

    //攻击sql阻断器
    PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
    List<ISqlParser> sqlParserList = new ArrayList<>();
    // 攻击 SQL 阻断解析器、加入解析链
   sqlParserList.add(new BlockAttackSqlParser());
    paginationInterceptor.setSqlParserList(sqlParserList);

    return new PaginationInterceptor();
    }
}

3.3 乐观锁插件

@Configuration
public class MybatisConfig {

    /**
     * 乐观锁插件
     * 字段需加注解 @Version
     * @return
     */
    @Bean
    public OptimisticLockerInterceptor optimisticLockerInterceptor() {
        return new OptimisticLockerInterceptor();
    }

}

备注:需要字段上加上注解Version，如下：

        /**
        * 姓名
        */
        @Version
private String name;

3.4 其他插件

参考官网：https://mp.baomidou.com/guide/

第二篇 Mybatis-plus与现有mybatis框架的融合

以下主要是针对项目二组的技术框架的融合。

要解决的问题有哪些？

maven依赖

添加mybatis-plus依赖

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.1.1</version>
</dependency>
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.0.1</version>
</dependency>

同时需要去掉之前依赖的mybatis、mybatis-spring的依赖，以免因为版本冲突造成运行异常，因为mybatis-plus自己维护了这些依赖，3.1.1对应的版本分别为mybatis-3.5.1和mybatis-spring-2.0.1。

兼容原分页插件依赖

<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>1.2.9</version>
    <exclusions>
        <exclusion> 
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </exclusion>
       <exclusion> 
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
        </exclusion>
    </exclusions>
</dependency>

1.2配置修改

配置文件

###mybatis配置
#mybatis:
# dao-locations: classpath:mapper/**/*.xml
# type-aliases-package: com.youka.dao
mybatis-plus:
mapper-locations: classpath:mapper/**/*.xml
type-aliases-package: com.youka.dao

去掉之前的mybatis的配置，新增mybatis-plus的配置。

☆动态数据源☆

Mybatis-plus的动态数据源配置不支持原生的SqlSessionFactory，需要配置MybatisSqlSessionFactoryBean，如下：

@Bean(name = "sqlSessionFactory")
public SqlSessionFactory mybatisSqlSessionFactoryBean() throws Exception {

//原生写法SqlSessionFactory

VFS.addImplClass(SpringBootVFS.class);
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(roundRobinDataSouceProxy());
//    sqlSessionFactoryBean.setTypeAliasesPackage(typeAliasesPackage);
        sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(mapperLocations));
        sqlSessionFactoryBean.getObject().getConfiguration().setMapUnderscoreToCamelCase(true);
        // 设置分页
        sqlSessionFactoryBean.setPlugins(new Interceptor[] { new PageInterceptor() });
        return sqlSessionFactoryBean.getObject();

//MybatisSqlSessionFactoryBean
       MybatisSqlSessionFactoryBean mybatisPlus = new MybatisSqlSessionFactoryBean();
        mybatisPlus.setDataSource(roundRobinDataSouceProxy());
        mybatisPlus.setVfs(SpringBootVFS.class);
        // 设置mapper.xml文件的路径
        ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
//        Resource[] resource = (Resource[]) resolver.getResources(mapperLocations);
        mybatisPlus.setMapperLocations(resolver.getResources(mapperLocations));
        mybatisPlus.setTypeAliasesPackage(typeAliasesPackage);
        mybatisPlus.setPlugins(new Interceptor[]{paginationInterceptor,performanceInterceptor});
        return mybatisPlus.getObject();
    }

插件的配置

Mybatis-plus的动态数据源不支持预注入插件配置，需要我们手动指定需要注入的插件。

预注入写法

@Configuration
public class MybatisPlusConfig {

    /**
     * 分页插件及攻击sql阻断器配置
     */
    @Bean("paginationInterceptor")
    public PaginationInterceptor paginationInterceptor() {

//        //攻击sql阻断器
//        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
//        List<ISqlParser> sqlParserList = new ArrayList<>();
//        // 攻击 SQL 阻断解析器、加入解析链
//        sqlParserList.add(new BlockAttackSqlParser());
//        paginationInterceptor.setSqlParserList(sqlParserList);

        return new PaginationInterceptor();
    }

    /**
     * SQL执行效率插件- 性能分析插件
     */
    @Bean("performanceInterceptor")
    @Profile({"develop", "master"})// 设置 dev test 环境开启
//    @Profile({"prod"})// 设置 dev test 环境开启
    public PerformanceInterceptor performanceInterceptor() {
        PerformanceInterceptor performanceInterceptor = new PerformanceInterceptor();
        performanceInterceptor.setFormat(true); //格式化sql
        performanceInterceptor.setMaxTime(1000); //设置运行时长，超过自动停止
//        performanceInterceptor.setMaxTime(20); //设置运行时长，超过自动停止
        return performanceInterceptor;
    }

    /**
     * 乐观锁插件
     * 字段需加注解 @Version
     *
     * @return
     */
    @Bean
    public OptimisticLockerInterceptor optimisticLockerInterceptor() {
        return new OptimisticLockerInterceptor();
    }

}

手动注入写法

@Resource(name = "paginationInterceptor")
private PaginationInterceptor paginationInterceptor;

@Resource(name = "performanceInterceptor")
private PerformanceInterceptor performanceInterceptor;

@Bean(name = "sqlSessionFactory")
    public SqlSessionFactory mybatisSqlSessionFactoryBean() throws Exception {
        MybatisSqlSessionFactoryBean mybatisPlus = new MybatisSqlSessionFactoryBean();
        mybatisPlus.setDataSource(roundRobinDataSouceProxy());
        mybatisPlus.setVfs(SpringBootVFS.class);
        // 设置mapper.xml文件的路径
        ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
//        Resource[] resource = (Resource[]) resolver.getResources(mapperLocations);
        mybatisPlus.setMapperLocations(resolver.getResources(mapperLocations));
        mybatisPlus.setTypeAliasesPackage(typeAliasesPackage);
       mybatisPlus.setPlugins(new Interceptor[]{paginationInterceptor,performanceInterceptor});
        return mybatisPlus.getObject();
    }

1.3代码结构调整

Controller

无需调整

Service

public class InsTypeServiceImpl extends ServiceImpl<InsTypeMapper, InsType>

继承ServiceImpl

Mapper

public interface InsTypeMapper extends BaseMapper<InsType>

继承BaseMapper

Xml

无需修改

Entity

无需修改

代码运行测试

测试现有接口

/youka/sysPageConfig/sys/login/getConfig

测试现有接口分页

/youka/ins/selectInsTypes?pageNum=1&pageSize=2

测试mybatis-plus接口（包含分页）

@RestController
@RequestMapping("/sys/login")
public class Test {

    @Autowired
    InsTypeServiceImpl insTypeService;

    @Resource
    InsTypeMapper insTypeMapper;

    /**
     * 获取保险类型
     * @return
     */
    @RequestMapping(value = "/test", method = RequestMethod.GET)
    public String test(){

        // mybatis-plus 接口
        List<InsType> list = insTypeService.list();

        // mybatis-plus 接口分页
        Page<InsType> page = new Page<>(1, 3);
        IPage<InsType> iPage = insTypeService.page(page);
        IPage<InsType> selectPage = insTypeMapper.selectPage(page, new QueryWrapper<>());

        return JSONObject.toJSONString(iPage);
    }
}

测试sql性能分析插件

谢谢！

爱游泳的小肥猪

关注

1
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
mybatis-plus入门应用及与现有mybatis架构融合

目录第一篇 Mybatis-plus入门 11. What is it？ 11.1 定义 11.2 特点 21.3 快速使用 22. How do it？ 52.1配置 52.2代码生成器 102.3调用示例 152.4分页插件 162...
复制链接

扫一扫

专栏目录