Springboot中mybatis-plus插件用代码自动生成文件

比眉伴天荒 2023-05-30 04:58 26阅读 0赞

***推荐去Mybatis-plus官网浏览  [https://mp.baomidou.com/][https_mp.baomidou.com]***

一、初始项目结构图

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDQ5OTM5NA_size_16_color_FFFFFF_t_70][]

二，关于pom.xml文件的配置

我用的freemaker模板配置  数据库用的mysql

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.2.0.RELEASE</version>
            <relativePath/> 
        </parent>
        <groupId>com.plus</groupId>
        <artifactId>mybatis-plus2</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>mybatis-plus2</name>
        <description>Demo project for Spring Boot</description>
    
        <properties>
            <java.version>1.8</java.version>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter</artifactId>
            </dependency>
    
            <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>com.baomidou</groupId>
                <artifactId>mybatis-plus-generator</artifactId>
                <version>3.2.0</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-core</artifactId>
                <version>4.3.20.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
    
            <dependency>
                <groupId>org.freemarker</groupId>
                <artifactId>freemarker</artifactId>
                <version>2.3.29</version>
            </dependency>
    
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
                <exclusions>
                    <exclusion>
                        <groupId>org.junit.vintage</groupId>
                        <artifactId>junit-vintage-engine</artifactId>
                    </exclusion>
                </exclusions>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    </project>

三、application.properties文件

server.port=8081
    server.context.path=/
    
    #配置数据库
    spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT
    spring.datasource.username=root
    spring.datasource.password=root
    spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
    
    #指定HttpServletRequest的属性是否可以覆盖controller的model的同名项
    spring.freemarker.allow-request-override=false
    #req访问request
    spring.freemarker.request-context-attribute=req
    #后缀名freemarker默认后缀为.ftl，当然你也可以改成自己习惯的.html
    spring.freemarker.suffix=.ftl
    #设置响应的内容类型
    spring.freemarker.content-type=text/html;charset=utf-8
    #是否允许mvc使用freemarker
    spring.freemarker.enabled=true
    #是否开启template caching
    spring.freemarker.cache=false
    #设定模板的加载路径，多个以逗号分隔，默认: [“classpath:/templates/”]
    spring.freemarker.template-loader-path=classpath:/templates/
    #设定Template的编码
    spring.freemarker.charset=UTF-8
    #数字格式化，无小数点
    spring.freemarker.number_format=0.##
    
    #打印mybatis的注解sql语句
    mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
    #使用xml写sql语句就需要加上这行注解,第一个xml为文件夹的名字
    mybatis.mapper-locations=classpath:xml/*.xml

四、自动生成类CodeGenerator

package com.plus.util;
    
    import com.baomidou.mybatisplus.core.exceptions.MybatisPlusException;
    import com.baomidou.mybatisplus.core.toolkit.StringPool;
    import com.baomidou.mybatisplus.core.toolkit.StringUtils;
    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.TableInfo;
    import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
    import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;
    
    import java.util.ArrayList;
    import java.util.List;
    import java.util.Scanner;
    
    public class CodeGenerator {
    
        /**
         * 读取控制台内容
         */
    
        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) {
            AutoGenerator mpg=new AutoGenerator();
    
            //全局配置
            GlobalConfig gc=new GlobalConfig();
            //获得项目文件生成路径
            String projectPath = System.getProperty("user.dir");
            gc.setOutputDir(projectPath+"/mybatis-plus2/src/main/java");
            gc.setAuthor("zefan");
            gc.setOpen(false);
            mpg.setGlobalConfig(gc);
            System.out.println(gc.toString());
    
    
            //数据源配置
            DataSourceConfig dsc=new DataSourceConfig();
            dsc.setUrl("jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT");
            dsc.setDriverName("com.mysql.jdbc.Driver");
            dsc.setUsername("root");
            dsc.setPassword("1234");
            mpg.setDataSource(dsc);
    
    
            //包配置
            PackageConfig pc=new PackageConfig();
            pc.setModuleName(scanner("模块名"));
            System.out.println(pc.getModuleName());
            pc.setParent("com.plus");
            mpg.setPackageInfo(pc);
    
    
            //自定义配置
            InjectionConfig cfg=new InjectionConfig() {
                @Override
                public void initMap() {
    
                }
            };
            //  freemarker模板引擎
            String templatePath = "/templates/mapper.xml.ftl";
            //自定义输出配置
            List<FileOutConfig> focList=new ArrayList<>();
            //自定义配置会被优先输出
            focList.add(new FileOutConfig(templatePath) {
                @Override
                public String outputFile(TableInfo tableInfo) {
                    //自定义输出文件名
                    return projectPath + "/mybatis-plus2/src/main/resources/mapper/" + pc.getModuleName() + "/" + tableInfo.getEntityName()+ "Mapper" + StringPool.DOT_XML;
                }
            });
    
            cfg.setFileOutConfigList(focList);
            mpg.setCfg(cfg);
    
            //配置模板
            TemplateConfig templateConfig=new TemplateConfig();
            templateConfig.setXml(null);
            mpg.setTemplate(templateConfig);
    
            //策略配置
            StrategyConfig strategy=new StrategyConfig();
            strategy.setNaming(NamingStrategy.underline_to_camel);
            strategy.setColumnNaming(NamingStrategy.underline_to_camel);
            //strategy.setSuperEntityClass("com.plus.commom.BaseEntity");
            strategy.setEntityLombokModel(false);
            strategy.setRestControllerStyle(true);
            //公共父类
            //strategy.setSuperControllerClass("com.plus.common.BaseController");
            //写于父类中的公共字段
            strategy.setSuperEntityColumns("id");
            strategy.setInclude(scanner("表名，多个英文逗号分割").split(","));
            strategy.setControllerMappingHyphenStyle(true);
            strategy.setTablePrefix(pc.getModuleName()+"_");
            mpg.setStrategy(strategy);
            mpg.setTemplateEngine(new FreemarkerTemplateEngine());
    
    
            mpg.execute();
    
    
        }
    
    
    }

五、自动生成的结构图

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDQ5OTM5NA_size_16_color_FFFFFF_t_70 1][]

六、sql脚本

DROP TABLE IF EXISTS `user`;
    
    CREATE TABLE `user` (
      `id` bigint(20) NOT NULL COMMENT '用户ID',
      `name` varchar(50) DEFAULT NULL COMMENT '用户名',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';
    
    /*Data for the table `user` */
    
    insert  into `user`(`id`,`name`) values (1,'张三');
    
    insert  into `user`(`id`,`name`) values(2,'李四');
    
    insert  into `user`(`id`,`name`) values(3,'王五');

[https_mp.baomidou.com]: https://mp.baomidou.com/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDQ5OTM5NA_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191107150707875.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDQ5OTM5NA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDQ5OTM5NA_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191107150840469.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDQ5OTM5NA==,size_16,color_FFFFFF,t_70