2021-07-19Mybatis-Plus自动生成器Oracle和Mysql

Oracle的（能生成，有bug）

• 配置

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

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
            <version>3.3.2</version>
        </dependency>

• GeneratorTest代码

package com.demo;
import com.baomidou.mybatisplus.annotation.DbType;
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.NamingStrategy;
    public class GenerateTest {
            public static void main(String[] args) {
                //创建generator对象
                AutoGenerator autoGenerator = new AutoGenerator();
                //数据源
                DataSourceConfig dataSourceConfig = new DataSourceConfig();
                dataSourceConfig.setDbType(DbType.ORACLE);
                dataSourceConfig.setDriverName("oracle.jdbc.driver.OracleDriver");
                dataSourceConfig.setUsername("SCOTT");
                dataSourceConfig.setPassword("Hamj4247");
                dataSourceConfig.setUrl("jdbc:oracle:thin:@127.0.0.1:1521:orcl");
                autoGenerator.setDataSource(dataSourceConfig);
                //全局配置
                GlobalConfig globalConfig = new GlobalConfig();
                globalConfig.setOutputDir(System.getProperty("user.dir")+"/src/main/java");
                globalConfig.setAuthor("admin");
                globalConfig.setOpen(true);
                globalConfig.setServiceName("%sService");
                autoGenerator.setGlobalConfig(globalConfig);
                //包信息
                PackageConfig packageConfig = new PackageConfig();
                packageConfig.setParent("com.lcj");
                packageConfig.setEntity("entity");
                packageConfig.setMapper("mapper");
                packageConfig.setService("service");
                packageConfig.setServiceImpl("service.impl");
                packageConfig.setController("controller");
                autoGenerator.setPackageInfo(packageConfig);
                //策略配置
                StrategyConfig strategyConfig = new StrategyConfig();
                strategyConfig.setInclude("FRUIT");
                strategyConfig.setNaming(NamingStrategy.underline_to_camel);
                strategyConfig.setColumnNaming(NamingStrategy.underline_to_camel);
                strategyConfig.setEntityLombokModel(true);
                autoGenerator.setStrategy(strategyConfig);
                //运行
                autoGenerator.execute();
            }
        }

Mysql的差不多

• GeneratorTest

import com.baomidou.mybatisplus.annotation.DbType;
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.NamingStrategy;

public class GenerateTest {
    public static void main(String[] args) {
        //创建generator对象
        AutoGenerator autoGenerator = new AutoGenerator();
        //数据源
        DataSourceConfig dataSourceConfig = new DataSourceConfig();
        dataSourceConfig.setDbType(DbType.MYSQL);
        dataSourceConfig.setDriverName("com.mysql.cj.jdbc.Driver");
        dataSourceConfig.setUsername("root");
        dataSourceConfig.setPassword("123456");
        dataSourceConfig.setUrl("jdbc:mysql://localhost:3306/test11");
        autoGenerator.setDataSource(dataSourceConfig);
        //全局配置
        GlobalConfig globalConfig = new GlobalConfig();
        globalConfig.setOutputDir(System.getProperty("user.dir")+"/src/main/java");
        globalConfig.setAuthor("admin");
        globalConfig.setOpen(false);
        globalConfig.setServiceName("%sService");
        autoGenerator.setGlobalConfig(globalConfig);
        //包信息
        PackageConfig packageConfig = new PackageConfig();
        packageConfig.setParent("com.southwind");
        packageConfig.setEntity("entity");
        packageConfig.setMapper("mapper");
        packageConfig.setService("service");
        packageConfig.setServiceImpl("service.impl");
        packageConfig.setController("controller");
        autoGenerator.setPackageInfo(packageConfig);
        //策略配置
        StrategyConfig strategyConfig = new StrategyConfig();
        strategyConfig.setInclude("fruit");
        strategyConfig.setNaming(NamingStrategy.underline_to_camel);
        strategyConfig.setColumnNaming(NamingStrategy.underline_to_camel);
        strategyConfig.setEntityLombokModel(true);
        autoGenerator.setStrategy(strategyConfig);
        //运行
        autoGenerator.execute();
    }
}