反向生成工具

1.工具下载地址

mybatis-generator生成工具
参考官网地址:
http://www.mybatis.org/generator/index.html
目的:
根据表结构,反向生成model,Mapper接口,Mapper.xml文件

2.步骤

1.引入maven插件,下载该工具
    <project ...>
         ...
         <build>
           ...
           <plugins>
            ...
            <plugin>
              <groupId>org.mybatis.generator</groupId>
              <artifactId>mybatis-generator-maven-plugin</artifactId>
              <version>1.3.7</version>
              <executions>
                <execution>
                  <id>Generate MyBatis Artifacts</id>
                  <goals>
                    <goal>generate</goal>
                  </goals>
                </execution>
              </executions>
            </plugin>
            ...
          </plugins>
          ...
        </build>
        ...
      </project>

2.在resoures目录中配置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="C:/SYIT/apache-maven-3.6.0/repo/mysql/mysql-connector-java/5.1.40/mysql-connector-java-5.1.40.jar" />

    <context id="MYSQL" targetRuntime="MyBatis3">
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql:///javaee"
                        userId="root"
                        password="tiger">
        </jdbcConnection>

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

        <!--返向生成model-->
        <javaModelGenerator targetPackage="model" targetProject="C:/project/generator">
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="true" />
        </javaModelGenerator>
        <!--返向生成mapper接口-->
        <sqlMapGenerator targetPackage="dao"  targetProject="C:/project/generator">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
        <!--返向生成mapper.xml-->
        <javaClientGenerator type="XMLMAPPER" targetPackage="dao"  targetProject="C:/project/generator">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>


        <!--表结构-->
        <table schema="javaee" tableName="USER" domainObjectName="User"></table>

    </context>
</generatorConfiguration>

3.测试

 public static void main(String[] args) {

        UserService service = new UserService();
        UserExample example = new UserExample();
        UserExample.Criteria criteria = example.createCriteria();
        //封装where条件
        //criteria.andIdEqualTo(1);
        criteria.andIdGreaterThan(1);

        List<User> list = service.findByExample(example);

    }