mybatis逆向工程——maven版

谁践踏了优雅 2023-07-21 06:15 49阅读 0赞

利用mybatis逆向工程生成表对应的mapper接口和对应的sql映射文件还有表对应的bean实体类

#### 在pom 导入maven的jar包依赖 ####

<dependency>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-core</artifactId>
          <version>1.3.5</version>
    </dependency>

#### 在pom导入对应的逆向工程插件 ####

<plugin>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-maven-plugin</artifactId>
        <version>1.3.7</version>
        <configuration>
            <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
            <verbose>true</verbose>
            <overwrite>true</overwrite>
        </configuration>
        <dependencies>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.37</version>
            </dependency>
        </dependencies>
    </plugin>

#### 书写响应的配置文件 ####

在src/main/resources/generatorConfig.xml下书写响应的配置文件/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="testTables" targetRuntime="MyBatis3">
            <commentGenerator>
                
                <property name="suppressAllComments" value="true" />
            </commentGenerator>
    
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/crmpro" userId="root" password="root">
            </jdbcConnection>
    
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    
            
            <javaModelGenerator targetProject=".\src" targetPackage="bean">
                
                <property name="enableSubPackages" value="false" />
                
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetProject=".\src" targetPackage="dao">
                
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
    
            
            <javaClientGenerator type="XMLMAPPER" targetProject=".\src" targetPackage="dao">
                
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
    
    
    
            
            <table tableName="student" domainObjectName="Student"></table>
            <table tableName="teacher" domainObjectName="Teacher"></table>
         
        </context>
    </generatorConfiguration>

#### 执行该插件 ####

在idea中点击如下，执行插件  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dfc2xfY29kZQ_size_16_color_FFFFFF_t_70]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dfc2xfY29kZQ_size_16_color_FFFFFF_t_70]: /images/20230528/a3e3f0c88a38427e8df35f5cb0ca2fae.png