IDEA mybatis 逆向生成

╰半橙微兮° 2021-11-11 16:34 417阅读 0赞

### 1.编写generatorConfig.xml（本文中为MBG.xml） ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0Mjc1MjY4_size_16_color_FFFFFF_t_70][]

<?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="druid.properties"/>
      <context id="DB2Tables" targetRuntime="MyBatis3">
       
      	<commentGenerator>
      		<property name="suppressDate" value="true" />
      		<property name="suppressAllComments" value="true"/>
    	</commentGenerator>
    	
        <jdbcConnection driverClass="${driverClassName}"
            connectionURL="${url}"
            userId="${username}"
            password="${password}">
        </jdbcConnection>
        
        <javaTypeResolver >
          <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>
    	
        <javaModelGenerator targetPackage="priv.wjl.generator.pojo" targetProject="src/main/java">
          <property name="enableSubPackages" value="true" />
          <property name="trimStrings" value="true" />
        </javaModelGenerator>
    	
        <sqlMapGenerator targetPackage="priv.wjl.generator.mapper"  targetProject="src/main/java">
          <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
    	
        <javaClientGenerator type="XMLMAPPER" targetPackage="priv.wjl.generator.mapper"  targetProject="src/main/java">
          <property name="enableSubPackages" value="true" />
        </javaClientGenerator>
    	
    	<table tableName="manager"></table>
    	<table tableName="student"></table>
    	<table tableName="score"></table>
    	<table tableName="lesson"></table>
    	<table tableName="sets"></table>
    	<table tableName="question"></table>
    
      </context>
    </generatorConfiguration>

### 2.在pom.xml中添加插件 ###

<plugin>
              <groupId>org.mybatis.generator</groupId>
              <artifactId>mybatis-generator-maven-plugin</artifactId>
              <version>1.3.5</version>
              <configuration>
                <configurationFile>src/main/resources/MBG.xml</configurationFile>
                <verbose>true</verbose>
                <overwrite>true</overwrite>
              </configuration>
              <dependencies>
                <dependency>
                  <groupId>log4j</groupId>
                  <artifactId>log4j</artifactId>
                  <version>1.2.17</version>
                </dependency>
                <dependency>
                  <groupId>mysql</groupId>
                  <artifactId>mysql-connector-java</artifactId>
                  <version>5.1.31</version>
                </dependency>
              </dependencies>
            </plugin>

### 3.依次点击菜单Run，Edit Configurations,'+',maven。 ###

修改command line为mybatis-generator:generate -e ,点ok。如图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0Mjc1MjY4_size_16_color_FFFFFF_t_70 1][]

### 4.在项目右侧maven栏里运行配置。 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0Mjc1MjY4_size_16_color_FFFFFF_t_70 2][]

### 5.成功。 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0Mjc1MjY4_size_16_color_FFFFFF_t_70 3][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0Mjc1MjY4_size_16_color_FFFFFF_t_70]: /images/20211109/efc27c295aab4b88b1e6b1572039d06a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0Mjc1MjY4_size_16_color_FFFFFF_t_70 1]: /images/20211109/2910e05ccb584c52abe98a07bd53485d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0Mjc1MjY4_size_16_color_FFFFFF_t_70 2]: /images/20211109/33aa1ace4d8d4d9585245d72916e0254.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0Mjc1MjY4_size_16_color_FFFFFF_t_70 3]: /images/20211109/fd1e8bae2a444a48b1139718c9190d9c.png