Mybatis generator反向生成（错误及解决方法）

淡淡的烟草味﹌ 2022-06-01 05:36 196阅读 0赞

## 1、打开pom.xml文件 ##

（1）在dependencies中加入以下dependency，即导入反向生成所需要的jar包

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

（2）在build中加入以下plugin，即maven自带的插件

<plugins>
          <plugin>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-maven-plugin</artifactId>
            <version>1.3.5</version>
            <configuration>    
               <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
              <verbose>true</verbose>
              <overwrite>true</overwrite>
            </configuration>
          </plugin>
        </plugins>

## 2、在1-（2）设置的路径下添加相应的配置文件。 ##

<?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\ccc\.m2\repository\mysql\mysql-connector-java\8.0.8-dmr\mysql-connector-java-8.0.8-dmr.jar"/>
        <context id="default" targetRuntime="MyBatis3">
            <commentGenerator>
                
                <property name="suppressAllComments" value="false" />
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/tablename?serverTimezone=UTC" userId="root" password="password">
            </jdbcConnection>
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="cn.edu.bnu.coastal.pojo" targetProject=".\src\main\java">
                
                <property name="constructorBased" value="true"/>
                
                <property name="enableSubPackages" value="false" />
                
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="cn.edu.bnu.coastal.mapper" targetProject=".\src\main\java">
                
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="cn.edu.bnu.coastal.mapper" targetProject=".\src\main\java">
                
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
            
            <table schema="" tableName="table_name"></table>
        </context>
    </generatorConfiguration>

3、添加maven  
![这里写图片描述][SouthEast]  
![这里写图片描述][SouthEast 1]

**Command line中输入 mybatis-generator:generate -e**

![这里写图片描述][SouthEast 2]

最后重新返回执行即可。

## 4、错误总结 ##

（1）Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is`com.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.  
**解决方法：**当使用的mysql connectors的版本较高时，配置文件中classdriver的名称应该设置为“com.mysql.cj.jdbc.Driver”，而不是之前的“com.mysql.jdbc.Driver”。  
（2）java.sql.SQLException: The server time zone value ‘?й???????’ is unrecognized or represents more than **one time zone**. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more **specifc time zone value** if you want to utilize time zone support.  
**解决方法：**将connectionURL加入serverTimezone=UTC，即设置为：设置为”jdbc:mysql://localhost:3306/tablename?serverTimezone=UTC”。  
（3）生成的map.xml文件中只有两个方法：  
int insert(User record)；  
int insertSelective(User record)；  
且在生成的过程中报了**无法找到主键**的警告：  
**解决方法：**换用**低版本**的**mysql-connector.jar**和maven的**mybatis-generator-maven-plugin**。

[SouthEast]: /images/20220601/c6a9262d699948d0b85fe99b8ac6072d.png
[SouthEast 1]: /images/20220601/9420cafd364c4038b0b39f1ff999bba4.png
[SouthEast 2]: /images/20220601/4771ee2b97c14f3ba9e0ae9b25d7dbcc.png