Mybatis逆向工程

MyBatis Generator简称 MBG，是⼀个专⻔为 MyBatis 框架开发者定制的代码⽣成器，可⾃动⽣成。MyBatis 框架所需的实体类、Mapper 接⼝、Mapper.xml，⽀持基本的 CRUD 操作，但是⼀些相对复
杂的 SQL 需要开发者⾃⼰来完成。
Maven依赖：

<dependencies>
 <dependency>
 <groupId>org.mybatis</groupId>
 <artifactId>mybatis</artifactId>
 <version>3.4.5</version>
 </dependency>
 <dependency>
 <groupId>mysql</groupId>
 <artifactId>mysql-connector-java</artifactId>
 <version>8.0.11</version>
 </dependency>
 <dependency>
 <groupId>org.mybatis.generator</groupId>
 <artifactId>mybatis-generator-core</artifactId>
 <version>1.3.2</version>
 </dependency>
</dependencies>

创建 MBG 配置⽂件：

<?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="testTables" targetRuntime="MyBatis3">
        <!--jdbcConnection:配置数据库连接信息  driverClass:数据库驱动 connectionURL:连接那个库 userId:账户  password:密码 -->
        <jdbcConnection
                driverClass="com.mysql.cj.jdbc.Driver"
                connectionURL="jdbc:mysql://localhost:3306/mybatis?
useUnicode=true&amp;characterEncoding=UTF-8"
                userId="root"
                password="root"
        ></jdbcConnection>
        <!--javaModelGenerator:配置JavaBean的生成策略  targetPackage:指定存放在的包名  targetProject:指定目标地址-->
        <javaModelGenerator targetPackage="com.leng.entity"
                            targetProject="./src/main/java"></javaModelGenerator>
        <!--sqlMapGenerator:配置SQL映射文件的生成策略 targetPackage:指定存放在的包名  targetProject:指定目标地址-->
        <sqlMapGenerator targetPackage="com.leng.repository"
                         targetProject="./src/main/java"></sqlMapGenerator>
        <!--javaClientGenerator:配置Mapper接口的生成策略  type:指定配置形式   targetPackage:指定存放在的包名 targetProject:指定目标地址-->
        <javaClientGenerator type="XMLMAPPER"
                             targetPackage="com.leng.repository" targetProject="./src/main/java">
        </javaClientGenerator>
        <!--table:配置目标数据库  tableName:表名  domainObjectName:配置Java实体类-->
        <table tableName="mybatis_one" domainObjectName="User"></table>
    </context>
</generatorConfiguration>

创建实现类：

package com.leng.test;
import org.mybatis.generator.api.MyBatisGenerator;
import org.mybatis.generator.config.Configuration;
import org.mybatis.generator.config.xml.ConfigurationParser;
import org.mybatis.generator.exception.InvalidConfigurationException;
import org.mybatis.generator.exception.XMLParserException;
import org.mybatis.generator.internal.DefaultShellCallback;
import sun.applet.Main;
import java.io.File;
import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class test1 {
    public static void main(String[] args) {
        List<String> warings = new ArrayList<String>();
        boolean overwrite = true;
        String genCig = "/generatorConfig.xml";
        File configFile = new File(Main.class.getResource(genCig).getFile());
        ConfigurationParser configurationParser = new
                ConfigurationParser(warings);
        Configuration configuration = null;
        try {
            configuration = configurationParser.parseConfiguration(configFile);
        } catch (IOException e) {
            e.printStackTrace();
        } catch (XMLParserException e) {
            e.printStackTrace();
        }
        DefaultShellCallback callback = new DefaultShellCallback(overwrite);
        MyBatisGenerator myBatisGenerator = null;
        try {
            myBatisGenerator = new
                    MyBatisGenerator(configuration,callback,warings);
        } catch (InvalidConfigurationException e) {
            e.printStackTrace();
        }
        try {
            myBatisGenerator.generate(null);
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        } catch (InterruptedException e) {
            e.printStackTrace();