关于spring boot项目中整合Mybatis Plus代码生成器的全流程

关于spring boot项目中整合Mybatis Plus代码生成器的全流程

mybatis plus官方网站：https://baomidou.com/

第一步：首先引入相关pom

 <dependencies>
<!--       JDBC  -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jdbc</artifactId>
        </dependency>
<!--        Mysql -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.29</version>
        </dependency>
<!--      Mybatis   -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.1</version>
        </dependency>

        <dependency>
            <groupId>com.h2database</groupId>
            <artifactId>h2</artifactId>
            <scope>runtime</scope>
        </dependency>

<!--        代码生成器-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
            <version>3.5.1</version>
        </dependency>

<dependency>
            <groupId>org.freemarker</groupId>
                <artifactId>freemarker</artifactId>
            <version>2.3.31</version> <!-- 使用适合你项目的版本 -->
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>

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

第三步，检查配置application

mybatis.mapper-locations=classpath:mappers/*xml
mybatis.type-aliases-package=com.example.kg_two3.mapper
server.port=8888


spring.datasource.url=jdbc:mysql://localhost:3306/mqtt-list?useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true
spring.datasource.username=*** #您数据库的账号
spring.datasource.password=***	#您数据库的密码
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

第二步：创建代码生成器类

CodeGeneration.java

package com.feituixia.feituixiaadmin.generator;


import com.baomidou.mybatisplus.generator.FastAutoGenerator;
import com.baomidou.mybatisplus.generator.config.OutputFile;
import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;

import java.util.Collections;

public class CodeGeneration {
    public static void main(String[] args) {

        FastAutoGenerator.create("jdbc:mysql://localhost:3306/kg_one?seUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8","wendao","123456Hxk").globalConfig(builder -> {
           builder.author("XKG") //设置作者
                   .outputDir("D:\\System_data\\下载\\Spring-Security-Demo-master\\feituixia-admin\\src\\main\\java");
        })
                .packageConfig(builder -> {
                    builder.parent("com.feituixia.feituixiaadmin")//设置父保包名
                            .pathInfo(Collections.singletonMap(OutputFile.mapperXml,"com/feituixia/feituixiaadmin"));//设置mapperXml生成路径
                })
                .strategyConfig(builder -> {
                    builder.addInclude("errand");//需要生成的表名
//                            .addTablePrefix("t_","c_");  //设置过滤表前缀
                })
                .templateEngine(new FreemarkerTemplateEngine())//使用Freemarker引擎模板，默认的是Velocity引擎模板
                .execute();
    }

}

单击Main方法执行，执行成功后，我们的文件夹会多出四个文件

到这里，Mbatis Plus代码生成器就搞定了，接下来就是写一个controller测试一下了。

最后一步，回到我们项目的启动类，添加注解，扫描mapper文件夹

@MapperScan("com.feituixia.feituixiaadmin.mapper")

完整启动类代码如下

package com.feituixia.feituixiaadmin;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.feituixia.feituixiaadmin.mapper")
public class FeituixiaAdminApplication {

    public static void main(String[] args) {
        SpringApplication.run(FeituixiaAdminApplication.class, args);
    }

}

接下来我们就可以访问刚定义的接口进行访问了
不出意外的话，你会得到你请求的数据，至此，恭喜您，已完结。