idea使用mybatis-generator逆向工程生成文件

野性酷女 2023-10-18 16:59 121阅读 0赞

1.在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>
    
        
        <classPathEntry location="C:\Users\liqiye\.m2\repository\mysql\mysql-connector-java\5.1.6\mysql-connector-java-5.1.6.jar"/>
    
        <context id="mysqlgenerator" targetRuntime="MyBatis3">
    
            
            <commentGenerator>
                <property name="suppressAllComments" value="true" />
            </commentGenerator>
    
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                            connectionURL="jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=UTF-8"
                            userId="root"
                            password="123" />
    
            
            <javaModelGenerator targetPackage="com.liqiye.springbootdemo.entity" targetProject="src/main/java" />
    
            
            <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources" />
    
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.liqiye.springbootdemo.mapper" targetProject="src/main/java" />
    
            
            <table tableName="teacher" domainObjectName="Teacher"/>
                  
    
        </context>
    
    </generatorConfiguration>

2.在pom.xml文件加上以下插件

<plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.5</version>
                </plugin>

加了这两个依赖，可以看到idea的右边maven里面多了一个插件

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjEzMjE0Mw_size_16_color_FFFFFF_t_70][]

双击它，没报错则生成代码成功

注意：配置文件那里需要手动引入本地mysql的连接驱动，在maven 那里引入了也不行

若是不想生成的文件带上example，在配置文件的<table> 标签里面加上属性

enableCountByExample="false"
    enableUpdateByExample="false"
    enableDeleteByExample="false"
    enableSelectByExample="false"
    selectByExampleQueryId="false"

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