Springboot整合MybatisPlus的實(shí)現(xiàn)過程解析

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>com.cun</groupId>
  <artifactId>plus</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>jar</packaging>

  <name>plus</name>
  <description>Demo project for Spring Boot</description>

  <parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>1.5.14.RELEASE</version>
    <relativePath/> <!-- lookup parent from repository -->
  </parent>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    <java.version>1.8</java.version>
  </properties>

  <dependencies>

    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-web</artifactId>
    </dependency>

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

    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-test</artifactId>
      <scope>test</scope>
    </dependency>

    <!-- https://mvnrepository.com/artifact/com.baomidou/mybatis-plus-boot-starter -->
    <dependency>
      <groupId>com.baomidou</groupId>
      <artifactId>mybatis-plus-boot-starter</artifactId>
      <version>2.3</version>
    </dependency>
    <!-- 代碼生成器默認(rèn)使用如下模版引擎 -->
<!--    <dependency>
      <groupId>org.apache.velocity</groupId>
      <artifactId>velocity-engine-core</artifactId>
      <version>2.0</version>
    </dependency>-->
    <!-- freemarker 模板引擎 -->
    <dependency>
      <groupId>org.freemarker</groupId>
      <artifactId>freemarker</artifactId>
      <version>2.3.28</version>
    </dependency>


    <!--Druid-->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid-spring-boot-starter</artifactId>
      <version>1.1.10</version>
    </dependency>

  </dependencies>

  <build>
    <plugins>
      <plugin>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-maven-plugin</artifactId>
      </plugin>
    </plugins>
  </build>
</project>

package com.cun.plus;

import com.baomidou.mybatisplus.enums.IdType;
import com.baomidou.mybatisplus.generator.AutoGenerator;
import com.baomidou.mybatisplus.generator.config.DataSourceConfig;
import com.baomidou.mybatisplus.generator.config.GlobalConfig;
import com.baomidou.mybatisplus.generator.config.PackageConfig;
import com.baomidou.mybatisplus.generator.config.StrategyConfig;
import com.baomidou.mybatisplus.generator.config.rules.DbType;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;

public class CodeGenerator {
  public static void main(String[] args) {
    //1. 全局配置
    GlobalConfig config = new GlobalConfig();
    config.setActiveRecord(false) // 是否支持AR模式
        .setAuthor("len") // 作者
        .setOutputDir(".\\src\\main\\java") // 生成路徑
        .setFileOverride(true) // 文件覆蓋
        .setIdType(IdType.AUTO) // 主鍵策略
        .setServiceName("I%sService") // 設(shè)置生成的service接口的名字的首字母是否為I
        // IUserService
        .setBaseResultMap(true)
        .setBaseColumnList(true);

    //2. 數(shù)據(jù)源配置
    DataSourceConfig dsConfig = new DataSourceConfig();
    dsConfig.setDbType(DbType.MYSQL) // 設(shè)置數(shù)據(jù)庫類型
        .setDriverName("com.mysql.jdbc.Driver")
        .setUrl("jdbc:mysql://localhost:3306/mydatab?useSSL=true&verifyServerCertificate=false&allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8")
        .setUsername("root")
        .setPassword("lqq74561");

    //3. 策略配置

    //配置要生成的表的表名
    String[] tableName = {"system_power_type","system_admin","company","power_api","power_action","power_action_api","power_action_group","power_admin_group","power_group"};
    StrategyConfig stConfig = new StrategyConfig();
    stConfig.setCapitalMode(true) //全局大寫命名
        .setDbColumnUnderline(true) // 指定表名 字段名是否使用下劃線
        .setNaming(NamingStrategy.underline_to_camel) // 數(shù)據(jù)庫表映射到實(shí)體的命名策略
        .setTablePrefix("tb_")
        .setInclude(tableName); // 生成的表

    //4. 包名策略配置
    PackageConfig pkConfig = new PackageConfig();
    pkConfig.setParent("com.cun.plus")
        .setMapper("mapper")
        .setService("service")
        .setController("controller")
        .setEntity("entity")
        .setXml("mapper");

    //5. 整合配置
    AutoGenerator ag = new AutoGenerator();
    ag.setGlobalConfig(config)
        .setDataSource(dsConfig)
        .setStrategy(stConfig)
        .setPackageInfo(pkConfig);

    //6. 執(zhí)行
    ag.setTemplateEngine(new FreemarkerTemplateEngine());
    ag.execute();
  }
}

#mybatis-plus
mybatis-plus:
 #xml
 mapper-locations: classpath:/mapper/*Mapper.xml
 #bean
 typeAliasesPackage: com.cun.plus.entity
 global-config:
  # 3:"UUID";
  id-type: 3
  field-strategy: 2
  db-column-underline: true
  key-generator: com.baomidou.mybatisplus.incrementer.OracleKeyGenerator
  logic-delete-value: 1
  logic-not-delete-value: 0
  sql-injector: com.baomidou.mybatisplus.mapper.LogicSqlInjector
 configuration:
  map-underscore-to-camel-case: true
  cache-enabled: false
  #JdbcTypeForNull
  jdbc-type-for-null: 'null'

package com.cun.plus.conf;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Configuration;
@Configuration
@MapperScan("com.cun.plus.mapper")
public class MybatisPlusConfig {
}

/**
 * SQL執(zhí)行效率插件
 */
@Bean
@Profile({"dev","test"})// 設(shè)置 dev test 環(huán)境開啟
public PerformanceInterceptor performanceInterceptor() {
  return new PerformanceInterceptor();
}