Java Mybatis代码自动生成

1、pom文件

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

        <dependency>
            <groupId>org.apache.velocity</groupId>
            <artifactId>velocity-engine-core</artifactId>
            <version>2.1</version>
        </dependency>

        <dependency>
            <groupId>org.freemarker</groupId>
            <artifactId>freemarker</artifactId>
            <version>2.3.29</version>
        </dependency>

        <!-- lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.24</version>
            <scope>provided</scope>
        </dependency>

        <!-- mysql -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.23</version>
        </dependency>

        <!-- sqlserver -->
        <dependency>
            <groupId>com.microsoft.sqlserver</groupId>
            <artifactId>mssql-jdbc</artifactId>
            <version>6.1.0.jre8</version>
            <exclusions>
                <exclusion>
                    <artifactId>slf4j-api</artifactId>
                    <groupId>org.slf4j</groupId>
                </exclusion>
            </exclusions>
        </dependency>

        <!-- sqlite -->
        <dependency>
            <groupId>org.xerial</groupId>
            <artifactId>sqlite-jdbc</artifactId>
            <version>3.23.1</version>
        </dependency>

        <!-- oracle -->
        <dependency>
            <groupId>com.oracle.database.jdbc</groupId>
            <artifactId>ojdbc8</artifactId>
            <version>12.2.0.1</version>
        </dependency>

2、代码自动生成类

package com.nosya;

import com.baomidou.mybatisplus.core.exceptions.MybatisPlusException;
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;
import org.apache.commons.lang3.StringUtils;

import java.util.Scanner;

public class MyBatisCodeGenerator {

    /**
     * <p>
     * 读取控制台内容
     * </p>
     */
    public static String scanner(String tip) {
        Scanner scanner = new Scanner(System.in);
        StringBuilder help = new StringBuilder();
        help.append("请输入").append(tip).append(":");
        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) {
        boolean isMysql = true;

        // 代码生成器
        AutoGenerator mybatisPlusCodeGenerator = new AutoGenerator();

        // 全局配置
        GlobalConfig gc = new GlobalConfig();

        // 先得到当前工程目录
        String projectPath = System.getProperty("user.dir");
        // 是maven项目的结构,就是工程目录 + /src/main/java
        gc.setOutputDir(projectPath + "/src/main/java");

        //gc.setOutputDir("D:\\workspace-sts\\0520adv\\02_mp_springboot/src/main/java");

        // 设置生成文件的作者信息
        gc.setAuthor("nosya");

        //当代码生成完成之后是否打开代码所在的文件夹
        gc.setOpen(true);

        // gc.setSwagger2(true); 实体属性 Swagger2 注解
        //gc.setServiceName("%sService");

        // 将上述的全局配置注入
        mybatisPlusCodeGenerator.setGlobalConfig(gc);

        // 数据源配置
        DataSourceConfig dataSourceConfiguration = new DataSourceConfig();

        if (isMysql) {
            dataSourceConfiguration.setUrl("jdbc:mysql://ip:port/db?useUnicode=true&useSSL=false&characterEncoding=utf8&serverTimezone=UTC");

            // dataSourceConfiguration.setSchemaName("public");
            dataSourceConfiguration.setDriverName("com.mysql.cj.jdbc.Driver");
            dataSourceConfiguration.setUsername("user");
            dataSourceConfiguration.setPassword("password");
        } else {
            dataSourceConfiguration.setUrl("jdbc:oracle:thin:@ip:port:db");
            dataSourceConfiguration.setDriverName("oracle.jdbc.OracleDriver");
            dataSourceConfiguration.setUsername("user");
            dataSourceConfiguration.setPassword("password");
        }

        mybatisPlusCodeGenerator.setDataSource(dataSourceConfiguration);

        // 包配置
        PackageConfig pc = new PackageConfig();

        // 设置父级包名
        pc.setParent("com.nosya");//controller entity service service.impl

//        pc.setModuleName(scanner("模块名"));
        pc.setModuleName("web");

        // 实体类名称
        pc.setEntity("domain");

        // mapper包名称
        pc.setMapper("mapper");

        // mapper对应的映射器xml
        pc.setXml("mapper.xml");

        // 业务包层名称
        pc.setService("service");

        // 业务接口的实现类包
        pc.setServiceImpl("service.impl");

        // 控制器包名称
        pc.setController("controller");

        // 装填包信息对象
        mybatisPlusCodeGenerator.setPackageInfo(pc);

        // 策略配置
        StrategyConfig strategy = new StrategyConfig();

        //设置字段和表名的是否把下划线完成驼峰命名规则
        strategy.setNaming(NamingStrategy.underline_to_camel);

        strategy.setColumnNaming(NamingStrategy.underline_to_camel);

        //设置生成的实体类继承的父类
        //strategy.setSuperEntityClass("com.sxt.BaseEntity");

        //是否启动lombok
        strategy.setEntityLombokModel(true);

        //是否生成resetController
        strategy.setRestControllerStyle(true);

        // 公共父类
        //strategy.setSuperControllerClass("com.sxt.BaseController");

        // 写于父类中的公共字段
        //strategy.setSuperEntityColumns("person_id","person_name");

        //要设置生成哪些表 如果不设置就是生成所有的表
        //strategy.setInclude(scanner("表名,多个英文逗号分割").split(","));

        strategy.setControllerMappingHyphenStyle(true);

        //strategy.setTablePrefix(pc.getModuleName() + "_");
//        strategy.setTablePrefix("sys_");

        mybatisPlusCodeGenerator.setStrategy(strategy);

        mybatisPlusCodeGenerator.execute();
    }
}

 

posted @ 2023-02-06 15:08  都是城市惹的祸  阅读(167)  评论(0)    收藏  举报