mybatis-generator自动生成实体类模型，mapper接口，以及mapper.xml文件

水深无声 2022-04-12 11:42 247阅读 0赞

1、创建一个新的MAVEN项目，例如：mybatis-generator

2、修改pom.xml文件，按照如下设置：

<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.wangphGit</groupId>
      <artifactId>mybatis-generator</artifactId>
      <version>0.0.1-SNAPSHOT</version>
      <name>mybatis-generator</name>
      
      <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.13</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.3.7</version>
            </dependency>
        </dependencies>
        <build>
            <pluginManagement>
                <plugins>
                    <plugin>
                        <groupId>org.apache.maven.plugins</groupId>
                        <artifactId>maven-compiler-plugin</artifactId>
                        <configuration>
                            <source>1.7</source>
                            <target>1.7</target>
                        </configuration>
                        <version>3.3</version>
                    </plugin>
                    <plugin>
                        <groupId>org.mybatis.generator</groupId>
                        <artifactId>mybatis-generator-maven-plugin</artifactId>
                        <version>1.3.7</version>
                        <dependencies>
                            <dependency>
                                <groupId>mysql</groupId>
                                <artifactId>mysql-connector-java</artifactId>
                                <version>8.0.13</version>
                            </dependency>
                        </dependencies>
                        <configuration>
                             
                             <configurationFile>${basedir}/src/main/resources/generatorConfig.xml</configurationFile> 
                            <overwrite>true</overwrite>
                        </configuration>
                    </plugin>
                </plugins>
            </pluginManagement>
        </build>
    </project>

3、resources目录下创建generatorConfig.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" targetRuntime="MyBatis3">
        
        
            <plugin type="org.mybatis.generator.plugins.SerializablePlugin"></plugin> 
               	
            <commentGenerator>
                
                
                <property name="suppressDate" value="true" />
                
                <property name="suppressAllComments" value="true" />
                
        		<property name="javaFileEncoding" value="UTF-8"/>
            </commentGenerator>
           
            
            <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
                connectionURL="jdbc:mysql://localhost:3306/数据库名?characterEncoding=utf-8&serverTimezone=UTC" userId="数据库名" password="密码">
                </jdbcConnection>
           
            <javaTypeResolver>
                 
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
            
            
            <javaModelGenerator targetPackage="com.dto"
                targetProject="target">
                <property name="enableSubPackages" value="true" />
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="com.mapping"
                targetProject="target">
                <property name="enableSubPackages" value="true" />
            </sqlMapGenerator>
            
            
            <javaClientGenerator type="XMLMAPPER"
                targetPackage="com.dao" implementationPackage="com.dao" targetProject="target">
                <property name="enableSubPackages" value="true" />
            </javaClientGenerator>     
            
            
            
            <table tableName="t_dep" domainObjectName="dep"
                enableCountByExample="false" enableUpdateByExample="false"
                enableDeleteByExample="false" enableSelectByExample="false"
                selectByExampleQueryId="false">
            </table>
            <table tableName="t_user" domainObjectName="user"
                enableCountByExample="false" enableUpdateByExample="false"
                enableDeleteByExample="false" enableSelectByExample="false"
                selectByExampleQueryId="false">
            </table>
        </context>
    </generatorConfiguration>

4、选中项目->>右键->>Run As->>Maven build->>Goals:输入： mybatis-generator:generate->>点击Run按钮，控制台提示success，表示已经完成。然后再选中项目->>右键->>Run As->>Refresh，或者直接按F5刷新，即可看到生成的文件

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjMxNTYwMA_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjMxNTYwMA_size_16_color_FFFFFF_t_70]: /images/20220412/c739e528202145e292ad9b93976eedd8.png