mybatis-plus引入及其代碼生成器

• maven依賴

  		<dependency>
              <groupId>com.baomidou</groupId>
              <artifactId>mybatis-plus-generator</artifactId>
              <version>3.3.2</version>
          </dependency>
  
          <!--mybatis-plus-->
          <!-- freemarker模板 -->
          <dependency>
              <groupId>org.freemarker</groupId>
              <artifactId>freemarker</artifactId>
              <version>2.3.30</version>
          </dependency>
          <dependency>
              <groupId>com.baomidou</groupId>
              <artifactId>mybatis-plus-boot-starter</artifactId>
              <version>3.4.3.1</version>
          </dependency>
  
          <dependency>
              <groupId>mysql</groupId>
              <artifactId>mysql-connector-java</artifactId>
              <version>8.0.13</version>
          </dependency>
  

• 代碼生成器

  package com.authine.cloudpivot.ext.util;
  import com.baomidou.mybatisplus.generator.AutoGenerator;
  import com.baomidou.mybatisplus.generator.config.*;
  import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
  import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;
  
  /**
   * @author yf
   * @version 1.0  2021/11/3
   */
  public class MyBatisPlusGenerator {
      static String packageName = "com.authine.cloudpivot.ext"; // 當前包名
      static String author = "yf"; // 作者
      static String sqlUrl = "mysql://127.0.0.1:3306/"; // 數(shù)據(jù)庫類型及地址
      static String sqlDb = "cloudpivot"; // 數(shù)據(jù)庫名
      static String sqlUser = "root";
      static String sqlPassword = "test123456";
      static String table = "iavz8_manufacturing_subsidiary,iavz8_reviewer"; // 表，用逗號隔開
      static String prefix = "iavz8_"; //表名前綴  生成代碼類名去除該前綴
  
      public static void main(String[] args) {
          // 代碼生成器
          AutoGenerator mpg = new AutoGenerator();
  
          // 全局配置
          GlobalConfig gc = new GlobalConfig();
          gc.setOutputDir(System.getProperty("user.dir") + "/src/main/java"); //項目路徑
          gc.setAuthor(author);
          gc.setOpen(false);
          gc.setServiceName("%sService");
          gc.setFileOverride(true); //覆蓋原有文件
          mpg.setGlobalConfig(gc);
  
          // 數(shù)據(jù)源配置
          DataSourceConfig dsc = new DataSourceConfig();
          dsc.setUrl("jdbc:" + sqlUrl + sqlDb + "?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&allowPublicKeyRetrieval=true&useSSL=false");
          dsc.setDriverName("com.mysql.cj.jdbc.Driver");
          dsc.setUsername(sqlUser);
          dsc.setPassword(sqlPassword);
          mpg.setDataSource(dsc);
  
          // 包配置
          PackageConfig pc = new PackageConfig();
          pc.setParent(packageName);
          //pc.setEntity("entity");
          mpg.setPackageInfo(pc);
  
          // 配置模板
          TemplateConfig templateConfig = new TemplateConfig();
          //templateConfig.setXml(null); // 不生成MapperXML
          templateConfig.setController(null);
          mpg.setTemplate(templateConfig);
  
          // 策略配置
          StrategyConfig strategy = new StrategyConfig();
          strategy.setNaming(NamingStrategy.underline_to_camel);
          strategy.setColumnNaming(NamingStrategy.underline_to_camel);
          strategy.setRestControllerStyle(true);
          strategy.setEntityTableFieldAnnotationEnable(true);
          strategy.setEntityLombokModel(true);    //開啟lombok支持
  
          strategy.setInclude(table.split(","));
          strategy.setControllerMappingHyphenStyle(true);
          strategy.setTablePrefix(prefix); // 表前綴，如t_user，沒有就注釋掉此行
          mpg.setStrategy(strategy);
          mpg.setTemplateEngine(new FreemarkerTemplateEngine());
          mpg.execute();
      }
  }
  
  

• mybatis-plus yml配置

  mybatis-plus:
    configuration:
      map-underscore-to-camel-case: true
      auto-mapping-behavior: full
      log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    mapper-locations: classpath*:mapper/*Mapper.xml