mybatis逆向工程---MyBatis Generator

MyBatis Generator (MBG) is a code generator for MyBatis。

mybatis源码下载地址：https://github.com/mybatis/mybatis-3/releases

maven项目实操：
1、引入jar（mybatis-generator-maven-plugin、mysql-connector-java）

	<build>
        <plugins>
            <plugin>
                <dependencies>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>5.1.46</version>
                    </dependency>
                </dependencies>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.6</version>
            </plugin>
        </plugins>
    </build>

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>
    <context id="DB2Tables" targetRuntime="MyBatis3">
        <!-- 取消注释-->
        <commentGenerator>
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>
        <!-- 连接数据库-->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost:3306/数据库表名"
                        userId="账号" password="密码">
        </jdbcConnection>

        <javaTypeResolver >
            <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>
        <!-- 生成实体类存放包名及位置 -->
        <javaModelGenerator targetPackage="com.mybatis.test.pojo" targetProject="src/main/java">
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="true" />
        </javaModelGenerator>
        <!-- 生成mapper.xml文件存放包名及位置 -->
        <sqlMapGenerator targetPackage="com.mybatis.test.mapper"  targetProject="src/main/resources">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
        <!-- 生成mapper接口存放包名及位置 -->
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.mybatis.test.mapper"  targetProject="src/main/java">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>
        <!-- 需要逆向工程的数据库表 -->
        <!-- tableName为表名，domainObjectName为生成的实体类名 -->
        <table tableName="user" domainObjectName="User" >

        </table>
    </context>
</generatorConfiguration>

3、执行

双击执行即可生成对应的文件。