IntelliJ IDEA下使用 mybatis-generator-maven-plugin插件完成Mybatis逆向工程

梦里梦外; 2022-06-06 03:07 180阅读 0赞

#### 1.要有一个maven工程,推荐自己新搭建一个,不要放在主项目下,因为一般最终都只是要获取pojo、mapper接口及映射文件,把这些复制粘贴出去就完事了.,这个工程与主项目关联不大,可以用完即删或者留着以后用,到时修改一下配置就好. ####

结构如下:

![Center][]

#### 2.在pom.xml中添加mybatis-generator-maven-plugin插件,其中configurationFile根据配置文件generationConfig.xml路径自行修改 ####

<build>
            <plugins>
                <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>
                </plugin>
            </plugins>
        </build>

#### 3.添加generationConfig.xml文件到src/main/resources目录下,这里需要个人配置的有 ####

1.数据库连接的信息  
2.指定数据库表,以及pojo类,映射文件,mapper接口的生成位置(一般pojo类单独放,mapper映射文件和接口放一起)

3.指定特定数据库的jbdc驱动jar包的位置(没有指定会报错Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2:generate (default-cli) on project mybatis-generator: Execution default-cli of goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2:generate failed: **Exception getting JDBC Driver**: com.mysql.jdbc.Driver -> \[Help 1\])

另外,还有一点需要注意:http://mybatis.org/dtd/mybatis-generator-config\_1\_0.dtd已经链接不了,会报红:URI is not registered (Settings | Languages & Frameworks | Schemas and DTD),这个只要你文件没写错就没关系的,去Settings | Languages & Frameworks | Schemas and DTD下把http://mybatis.org/dtd/mybatis-generator-config\_1\_0.dtd添加到Ignored Schemas and DTD就行.

<?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:mysql-connector-java-5.1.8-bin.jar" />
    	<context id="testTables" targetRuntime="MyBatis3">
    		<commentGenerator>
    			
    			<property name="suppressAllComments" value="true" />
    		</commentGenerator>
    		
    		<jdbcConnection driverClass="com.mysql.jdbc.Driver"
    			connectionURL="jdbc:mysql://localhost:3306/testbase" userId="root"
    			password="root">
    		</jdbcConnection>
    		
    		<javaTypeResolver>
    			<property name="forceBigDecimals" value="false" />
    		</javaTypeResolver>
    
    		
    		<javaModelGenerator targetPackage="com.test.pojo"
    			targetProject=".\src\main\java">
    			
    			<property name="enableSubPackages" value="false" />
    			
    			<property name="trimStrings" value="true" />
    		</javaModelGenerator>
            
    		<sqlMapGenerator targetPackage="com.test.mapper" 
    			targetProject=".\src\main\java">
    			
    			<property name="enableSubPackages" value="false" />
    		</sqlMapGenerator>
    		
    		<javaClientGenerator type="XMLMAPPER"
    			targetPackage="com.test.mapper" 
    			targetProject=".\src\main\java">
    			
    			<property name="enableSubPackages" value="false" />
    		</javaClientGenerator>
    		
    		<table schema="" tableName="table1"></table>
    		<table schema="" tableName="table2"></table>
    		<table schema="" tableName="table3"></table>
    
    	</context>
    </generatorConfiguration>

#### 4.执行,run ####

![Center 1][]

#### 5,大功告成!其实没有,还要拷贝到其他项目 ####

pojo的拷贝通常不会有什么问题,但是要注意mapper是依赖pojo的.工具会帮你管理依赖,但是还是会出现Cannot resolve symbol 'Param,这个时候我们发现

import org.apache.ibatis.annotations.Param;是灰色的,提示Unused import statement,这个时候就需要我们手动到pom.xml添加以下依赖了

<dependency>
         <groupId>org.apache.ibatis</groupId>
         <artifactId>ibatis-core</artifactId>
         <version>3.0</version>
    </dependency>

[Center]: /images/20220606/37d7176185e1495d8b3feca1dc232df6.png
[Center 1]: /images/20220606/ddaeb832d8304ee18de59c26445960c6.png