IDEA执行mysql的逆向工程

谁践踏了优雅 2022-05-26 00:46 385阅读 0赞

### IDEA执行mysql的逆向工程步骤： ###

1.把项目相应的依赖导入：

<dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>${mybatis.version}</version>
    </dependency>
    
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.0</version>
    </dependency>
    
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>${mysql-driver.version}</version>
    </dependency>

在build中写入插件

<plugin>
      <groupId>org.mybatis.generator</groupId>
      <artifactId>mybatis-generator-maven-plugin</artifactId>
      <version>1.3.2</version>
      <configuration>
        <verbose>true</verbose>
        <overwrite>true</overwrite>
      </configuration>
    </plugin>

2.编写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="E:\dormitory\dormitory_maven\mysql\mysql-connector-java\5.1.38\mysql-connector-java-5.1.38.jar"/>
               <context id="context1">
                  <commentGenerator>
                  
                  <property name="suppressAllComments" value="true"/>
                  </commentGenerator>
                  <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/mydb?characterEncoding=utf-8" userId="root" password="123456">
                  </jdbcConnection>
                     
                     <javaModelGenerator targetPackage="st.personal.entity" targetProject="src/main/java"></javaModelGenerator>
                     
                     <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"></sqlMapGenerator>
                     
                     <javaClientGenerator targetPackage="st.personal.dao" type="XMLMAPPER" targetProject="src/main/java"></javaClientGenerator>
                     
                     
                     <table tableName="userinfo" enableCountByExample="false" enableSelectByExample="false"
                               enableDeleteByExample="false" enableUpdateByExample="false" selectByExampleQueryId="false"></table>
                   <table tableName="collection" enableCountByExample="false" enableSelectByExample="false"
                               enableDeleteByExample="false" enableUpdateByExample="false" selectByExampleQueryId="false"></table>
               </context>
            </generatorConfiguration>

写好配置文件之后，配置运行：点击edit configurations

![70][]

打开之后在左边的+号添加maven-->填写配置信息：command line(命令行）：

mybatis-generator:generate -e

![70 1][]

配置完后点击OK，再运行该配置文件就可以了。

![70 2][]

[70]: /images/20220526/f8286f5a8d0449a48f1ce5fa04592565.png
[70 1]: /images/20220526/1df8208a01d240078e440240007a0c63.png
[70 2]: /images/20220526/3c5b4b24bea946dc982a9018f40efd20.png