idea 通过 mybatis-generator 生成实体类、mapper.xml、mapper接口

Myth丶恋晨 2022-02-04 12:25 365阅读 0赞

首先需要新建一个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>
        <properties resource="jdbc.properties"/>
        
        <classPathEntry location="D:\apache-maven-3.5.3\repository\mysql\mysql-connector-java\5.1.34\mysql-connector-java-5.1.34.jar" />
        <context id="DB2Tables" targetRuntime="MyBatis3">
            <commentGenerator>
                <property name="suppressDate" value="true" />
                
                
            </commentGenerator>
            
            <jdbcConnection driverClass="${jdbc.driver}"
                            connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}">
            </jdbcConnection>
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
            
            <javaModelGenerator targetPackage="com.windf.module.tag.entity"
                                targetProject="src/main/java">
                
                <property name="enableSubPackages" value="true" />
                
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="config.module.tag.database.sqlmap"
                             targetProject="src/main/resources">
                <property name="enableSubPackages" value="true" />
            </sqlMapGenerator>
            
            <javaClientGenerator type="XMLMAPPER"
                                 targetPackage="com.windf.module.tag.dao" targetProject="src/main/java">
                <property name="enableSubPackages" value="true" />
            </javaClientGenerator>
            
            
             
            <table tableName="tag"
                   domainObjectName="Tag"
                   enableCountByExample="false"
                   enableUpdateByExample="false"
                   enableDeleteByExample="false"
                   enableSelectByExample="false"
                   selectByExampleQueryId="false"></table>
            <table tableName="tag_category" domainObjectName="TagCategory"
                   enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false"
                   selectByExampleQueryId="false"></table>
            <table tableName="tag_entity" domainObjectName="TagEntity"
                   enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false"
                   selectByExampleQueryId="false"></table>
        </context>
    </generatorConfiguration>

文件内容根据具体项目进行修改

说明：

文件中的

注释掉了，是因为生成之后的mapper.xml存在id重复现象，所以去掉了。

jdbc.properties

jdbc.url=***
    jdbc.username=***
    jdbc.password=***
    jdbc.driver=***

在项目的pom文件中添加配置

<plugin>
                    
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.2</version>
                    <configuration>
                        
                        <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
                        <verbose>true</verbose>
                        <overwrite>true</overwrite>
                    </configuration>
                    <executions>
                        <execution>
                            <id>Generate MyBatis Artifacts</id>
                            <goals>
                                <goal>generate</goal>
                            </goals>
                        </execution>
                    </executions>
                    <dependencies>
                        <dependency>
                            <groupId>org.mybatis.generator</groupId>
                            <artifactId>mybatis-generator-core</artifactId>
                            <version>1.3.2</version>
                        </dependency>
                    </dependencies>
                </plugin>

然后按步骤打开Run Configurations,添加一个maven的配置，在Common line输入

mybatis-generator:generate -e

在右侧可以看到一个可执行的命令，点击执行

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1lJU0hFTkdZT1VOSTk1_size_16_color_FFFFFF_t_70][]

![20190507190242592.png][]

![20190507190515682.png][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1lJU0hFTkdZT1VOSTk1_size_16_color_FFFFFF_t_70]: /images/20220204/1687ab14ee3b40e7af3198d6e19a8351.png
[20190507190242592.png]: /images/20220204/99d030cbe84f481a9305d53da2b66915.png
[20190507190515682.png]: /images/20220204/c962dc50893b4199b614f7448e9d481d.png