IDEA使用MybatisGenerator逆向工程

1.新建Maven工程

 

 pom.xml文件中加入逆向插件：

<plugin>
          <groupId>org.mybatis.generator</groupId>
          <artifactId>mybatis-generator-maven-plugin</artifactId>
          <version>1.3.7</version>
          <configuration>
            <configurationFile>${basedir}/src/main/resources/MybatisGenerator.xml</configurationFile>
            <verbose>true</verbose>
            <overwrite>false</overwrite>
          </configuration>
</plugin>

 

2.maven项目resource目录下新建MybatisGenerator.xml

 

 MybatisGenerator.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="D:\MavenLocalRepository\mysql\mysql-connector-java\5.1.48\mysql-connector-java-5.1.48.jar" />

    <context id="Mybatis3Context" targetRuntime="MyBatis3">
        <property name="javaFileEncoding" value="UTF-8"/>
        <commentGenerator>
            <!-- 去掉生成日期那行注释 -->
            <property name="suppressDate" value="true"/>
            <!-- 是否去除自动生成所有的注释 true：是 ： false:否 -->
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>

        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost:3306/test?useLegacyDatetimeCode=false&amp;serverTimezone=UTC&amp;nullCatalogMeansCurrent=true"
                        userId="root"
                        password="">
        </jdbcConnection>

        <javaTypeResolver>
            <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>

        <!-- 模型的包名和位置-->
        <javaModelGenerator targetPackage="model" targetProject="C:/MyJavaDevelopment/IDEA_WORKSPACE/JavaDemo/mybatis-dao-demo/src/main/java">
            <property name="enableSubPackages" value="true"/>
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>

        <!-- 映射文件的包名和位置-->
        <sqlMapGenerator targetPackage="mapperxml" targetProject="C:/MyJavaDevelopment/IDEA_WORKSPACE/JavaDemo/mybatis-dao-demo/src/main/resources">
            <property name="enableSubPackages" value="true"/>
        </sqlMapGenerator>

        <!-- DAO的包名和位置-->
        <javaClientGenerator type="XMLMAPPER" targetPackage="mapper" targetProject="C:/MyJavaDevelopment/IDEA_WORKSPACE/JavaDemo/mybatis-dao-demo/src/main/java">
            <property name="enableSubPackages" value="true"/>
        </javaClientGenerator>

        <table tableName="tb_stu" domainObjectName="Student" enableCountByExample="false"
               enableDeleteByExample="false" enableUpdateByExample="false" enableSelectByExample="false">
        </table>
    </context>
    
</generatorConfiguration>

3.Run --> Edit Configuration... --> 点击“+” --> 选择添加Maven命令

 Command line处填入固定格式：mybatis-generator:generate -e

4.点击运行

 5.查看结果：