mybatis逆向工程使用案例详解

创建项目

pom.xml文件添加依赖

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>org.example</groupId>
    <artifactId>Demo</artifactId>
    <version>1.0-SNAPSHOT</version>
<dependencies>
    <!-- 整合mybatis框架 -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.2.8</version>
    </dependency>
    <!-- mysql驱动 -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.32</version>
    </dependency>
    <!--逆向工程以来-->
    <dependency>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-maven-plugin</artifactId>
        <version>1.4.0</version>
    </dependency>
</dependencies>
<build>
    <plugins>
        <plugin>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-maven-plugin</artifactId>
            <configuration>
                <verbose>true</verbose><!--运行时显示详细的信息 -->
                <overwrite>true</overwrite><!-- 每次覆盖自动生成的文件 -->
            </configuration>
            <executions>
                <execution>
                    <id>Generate MyBatis Artifacts</id>
                    <goals>
                        <goal>generate</goal>
                    </goals>
                </execution>
            </executions>
            <dependencies>
                <dependency><!-- 配置连接依赖后，generatorConfig.xml不需要再配置本地驱动 -->
                    <groupId>mysql</groupId>
                    <artifactId>mysql-connector-java</artifactId>
                    <version>5.1.32</version>
                </dependency>
            </dependencies>
            <!--指定配置文件的路径-->
            <!--<configuration>
              <configurationFile>src/main/resources/mybatis/mgb.xml</configurationFile>
              <overwrite>true</overwrite>
            </configuration>-->
        </plugin>
    </plugins>
</build>
</project>

类路径下创建mgb.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>
    <!--MyBatis3Simple:简单版的-->
    <context id="DB2Tables" targetRuntime="MyBatis3Simple">
        <!--去掉生成的注释-->
        <commentGenerator>
            <!--注释是否包含生成时间 一般设置true 不生成-->
            <property name="suppressDate" value="true"/>
            <!--去掉注释-->
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>
        <!--数据库配置-->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost:3306/chunmeng?serverTimezone=UTC&amp;
                        allowMultiQueries=true&amp;characterEncoding=utf8"
                        userId="root" password="root"/>
        <!--java类型的解析器-->
        <javaTypeResolver >
            <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>
        <!--指定javabean生成策略
            targetPackage：指定目标包名：生成实体类的位置
            targetProject：目标工程 .\src:标识当前项目
          -->
        <javaModelGenerator targetPackage="com.demo.pojo"
                            targetProject="D:\JAVAproject\changgou\demo\src\main\java">
            <property name="enableSubPackages" value="true"/>
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>
        <!--SQL映射器-->
        <sqlMapGenerator targetPackage="com.demo.dao"
                         targetProject="D:\JAVAproject\changgou\demo\src\main\java">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.demo.dao"
                             targetProject="D:\JAVAproject\changgou\demo\src\main\java">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>
        <!--指定要逆向分些那些表 根据这边创建Javabean
         domainObjectName:指定生成类的名字
         -->
        <table tableName="all_else" domainObjectName="AllElsePojo"/>
        <table tableName="fixation" domainObjectName="FixationPojo" />
        <table tableName="jcb" domainObjectName="JcbPojo" />
        <table tableName="network_loan" domainObjectName="NetworkLoanPojo" />
        <table tableName="profile" domainObjectName="ProfilePojo" />
    </context>
</generatorConfiguration>

mgb.xml注意事项

创建数据库的表并添加字段

创建Main方法，内容如下

public class Main {
    public static void main(String[] args) throws Exception {
        List<String> warnings = new ArrayList<String>();
        boolean overwrite = true;
        //mgb.xml文件的全路径
        File configFile = new File("D:\\JAVAproject\\changgou\\demo\\src\\main\\resources\\mgb.xml");
        ConfigurationParser cp = new ConfigurationParser(warnings);
        Configuration config = cp.parseConfiguration(configFile);
        DefaultShellCallback callback = new DefaultShellCallback(overwrite);
        MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
        myBatisGenerator.generate(null);
    }
}

运行结果