SpringBoot3.2 整合 MyBatisFlex

代码自动生成

一个基础的maven java项目

public class Main {
    public static void main(String[] args) {
        //配置数据源
        HikariDataSource dataSource = new HikariDataSource();
        dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf-8");
        dataSource.setUsername("root");
        dataSource.setPassword("root");

        //创建配置内容
        GlobalConfig globalConfig = createGlobalConfigUseStyle1();
        //通过 datasource 和 globalConfig 创建代码生成器
        Generator generator = new Generator(dataSource, globalConfig);

        //生成代码
        generator.generate();
    }

    public static GlobalConfig createGlobalConfigUseStyle1() {
        //创建配置内容
        GlobalConfig globalConfig = new GlobalConfig();

        //设置根包
        globalConfig.setBasePackage("com.yunduo.server");
        //设置地址/java
        globalConfig.setSourceDir("D:\\xxxx\\server\\src\\main\\java");

        //设置表前缀和只生成哪些表
        globalConfig.setTablePrefix("t_");
        globalConfig.setGenerateTable("t_file","t_user");

        //设置生成 entity 并启用 Lombok
        globalConfig.setEntityGenerateEnable(true);
        globalConfig.setEntityWithLombok(true);

        //设置生成service
        globalConfig.setServiceGenerateEnable(true);
        //设置生成impl
        globalConfig.setServiceImplGenerateEnable(true);
        //生成controller
        globalConfig.setControllerGenerateEnable(true);
        //生成Tabledef
        globalConfig.setTableDefGenerateEnable(true);
        //生成xml
        globalConfig.setMapperXmlGenerateEnable(true);
        //配置xml路径
        globalConfig.setMapperXmlPath("D:\\xxxx\\server\\src\\main\\java\\com\\yunduo\\server\\mapper\\xml");
        //设置生成 mapper
        globalConfig.setMapperGenerateEnable(true);

        //可以单独配置某个列
        ColumnConfig columnConfig = new ColumnConfig();
        columnConfig.setColumnName("tenant_id");
        columnConfig.setLarge(true);
        columnConfig.setVersion(true);
        globalConfig.setColumnConfig("tb_account", columnConfig);
        return globalConfig;
    }
}

代码自动生成依赖

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.example</groupId>
    <artifactId>flex-code-auto</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>21</maven.compiler.source>
        <maven.compiler.target>21</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>
    <dependencies>
        <dependency>
            <groupId>com.mybatis-flex</groupId>
            <artifactId>mybatis-flex-codegen</artifactId>
            <version>1.7.5</version>
        </dependency>
        <dependency>
            <groupId>com.zaxxer</groupId>
            <artifactId>HikariCP</artifactId>
            <version>4.0.3</version>
        </dependency>

        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <version>8.0.32</version>
        </dependency>
    </dependencies>
</project>

SpringBoot整合MyBatis

• application.yml

spring:
#配置数据源
datasource:
  driver-class-name: com.mysql.cj.jdbc.Driver
  url: jdbc:mysql://localhost:3306/test
  username: root
  password: root
#配置xml寻找路径
mybatis-flex:
mapper-locations: "classpath*:com/yunduo/server/mapper/**/*.xml"

• pom依赖

<?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>3.2.0</version>
  	<relativePath/> <!-- lookup parent from repository -->
  </parent>

  <groupId>com.yunduo</groupId>
  <artifactId>server</artifactId>
  <version>1.0</version>

  <packaging>jar</packaging>

  <properties>
  	<java.version>21</java.version>
  </properties>
  <dependencies>
  	<dependency>
  		<groupId>org.springframework.boot</groupId>
  		<artifactId>spring-boot-starter-aop</artifactId>
  	</dependency>

  	<dependency>
  		<groupId>org.springframework.boot</groupId>
  		<artifactId>spring-boot-starter-web</artifactId>
  	</dependency>

  	<dependency>
  		<groupId>org.springframework.boot</groupId>
  		<artifactId>spring-boot-starter-mail</artifactId>
  	</dependency>

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

  	<!--MyBatis-Flex-->
  	<dependency>
  		<groupId>com.mybatis-flex</groupId>
  		<artifactId>mybatis-flex-spring-boot-starter</artifactId>
  		<version>1.7.5</version>
  		<!--	自带的mybatis-spring版本过低		-->
  		<exclusions>
  			<exclusion>
  				<groupId>org.mybatis</groupId>
  				<artifactId>mybatis-spring</artifactId>
  			</exclusion>
  		</exclusions>
  	</dependency>
  	<!-- 添加已适配 springboot 3.2 的 mybatis-spring 依赖-->
  	<dependency>
  		<groupId>org.mybatis</groupId>
  		<artifactId>mybatis-spring</artifactId>
  		<version>3.0.3</version>
  	</dependency>
  	<dependency>
  		<groupId>com.mybatis-flex</groupId>
  		<artifactId>mybatis-flex-processor</artifactId>
  		<version>1.7.5</version>
  		<scope>provided</scope>
  	</dependency>
  	<!-- 数据库连接池-->
  	<dependency>
  		<groupId>com.zaxxer</groupId>
  		<artifactId>HikariCP</artifactId>
  		<version>5.0.1</version>
  	</dependency>
  	<!--MySQL8-->
  	<dependency>
  		<groupId>mysql</groupId>
  		<artifactId>mysql-connector-java</artifactId>
  		<version>8.0.28</version>
  	</dependency>
  </dependencies>
  <build>
  	<resources>
  		<resource>
  			<directory>src/main/resources</directory>
  			<filtering>true</filtering>
  		</resource>
  		<resource>
  			<directory>src/main/java</directory>
  			<includes>
  				<include>**/*.xml</include>
  			</includes>
  		</resource>
  	</resources>
  	<plugins>
  		<plugin>
  			<groupId>org.springframework.boot</groupId>
  			<artifactId>spring-boot-maven-plugin</artifactId>
  		</plugin>
  	</plugins>
  </build>

</project>

ps: 搜了半天都看不到这种，只好写一篇了>_<