利用MyBatis Generator进行数据层代码自动生成

矫情吗；* 2023-10-07 12:32 8阅读 0赞

### 1. 新建maven工程 ###

> 导入如下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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>com.zxl</groupId>
        <artifactId>MyBatisGeneratorDemo</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        <dependencies>
            <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.3.7</version>
                <scope>provided</scope>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.7</version>
    
                    <configuration>
                        <configurationFile>src/main/resources/mybatis-generator.xml</configurationFile>
                        <overwrite>true</overwrite>
                    </configuration>
    
                    <dependencies>
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <version>8.0.19</version>
                        </dependency>
                    </dependencies>
                </plugin>
            </plugins>
        </build>
    
    
    
    </project>

### 2. 编写mybatis-generator.xml配置文件 ###

> 内容如下

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
            PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    <generatorConfiguration>
    
        <context id="MySql" defaultModelType="flat">
    
            <plugin type="org.mybatis.generator.plugins.SerializablePlugin" />
    
            <jdbcConnection
                    driverClass="com.mysql.jdbc.Driver"
                    connectionURL="jdbc:mysql://ip:3306/数据库名称"
                    userId="数据库用户"
                    password="数据库密码" />
    
            <javaModelGenerator targetPackage="cn.zxl.springbt_mybatis_generator.entity" targetProject="src/main/java"></javaModelGenerator>
    
            <sqlMapGenerator targetPackage="mapper"  targetProject="src/main/resources"></sqlMapGenerator>
    
            <javaClientGenerator targetPackage="cn.zxl.springbt_mybatis_generator.mapper" targetProject="src/main/java" type="XMLMAPPER"></javaClientGenerator>
    
            <table tableName="users">
                <property name="modelOnly" value="false"/>
            </table>
            <table tableName="chat_msg">
                <property name="modelOnly" value="false"/>
            </table>
            <table tableName="friends_request">
                <property name="modelOnly" value="false"/>
            </table>
            <table tableName="my_friends">
                <property name="modelOnly" value="false"/>
            </table>
    
        </context>
    
    </generatorConfiguration>

> 上面 xml中几个关键的配置简介如下：

< jdbcConnection /> 数据库连接配置，至关重要
    <javaModelGenerator /> 指定自动生成的 POJO置于哪个包下
    <sqlMapGenerator /> 指定自动生成的 mapper.xml置于哪个包下
    <javaClientGenerator /> 指定自动生成的 DAO接口置于哪个包下
    <table /> 指定数据表名，可以使用_和%通配符

### 3. 双击maven视图中的指定插件运行 ###

> 生成结果

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk_size_16_color_FFFFFF_t_70]

> 官方文档：http://mybatis.org/generator/

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200413174512446.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk=,size_16,color_FFFFFF,t_70