MyBatis的逆向工程生成mapper,bean文件（简化开发步骤，快速生成数据库表的实体类）

MyBatis的逆向工程

逆向工程概念：

  逆向工程：先创建数据库表，由框架负责根据数据库表，反向生成如下资源：
Java实体类
Mapper接口
Mapper配置文件

主方法

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 java.io.File;
import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class MBGTest {
    public static void main(String[] args) throws XMLParserException, IOException, InvalidConfigurationException, SQLException, InterruptedException {
        List<String> warnings = new ArrayList<String>();
        boolean overwrite = true;
        File configFile = new File("D:\\Desktop\\IdeaProjects\\ssm_sys\\src\\main\\resources\\mbg.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);
    }
}

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>
<!--            注释生成，当设置问true时，不生成英文注释-->
            <property name="suppressAllComments" value="true" />
        </commentGenerator>
        <jdbcConnection
                        driverClass="com.mysql.cj.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost:3307/ssm_sys?serverTimezone=UTC"
                        userId="root"
                        password="123456"
        />
<!--        指定JavaBean生成的位置-->
        <javaModelGenerator targetPackage="com.Drake.SSM_sys.bean" targetProject=".\src/main/java"/>
<!--        指定sql映射文件生成的位置-->
        <sqlMapGenerator targetPackage="mapper" targetProject=".\src/main/resources">
            <property name="enableSubPackages" value="true"/>
        </sqlMapGenerator>
<!--        指定dao接口生成的位置-mapper接口 -->
        <javaClientGenerator targetPackage="com.Drake.SSM_sys.dao" targetProject=".\src/main/java" type="XMLMAPPER"/>
<!--        table生成策略-->
        <table tableName="tb_emp" domainObjectName="Employee"/>
        <table tableName="tb_dept" domainObjectName="Department"/>
    </context>
</generatorConfiguration>

官网链接：

https://mybatis.org/generator/running/runningWithJava.html

jar依赖：

    <dependency>
      <groupId>org.mybatis.generator</groupId>
      <artifactId>mybatis-generator-core</artifactId>
      <version>1.3.5</version>
    </dependency>