MBG逆向工程

MBG(MyBatis Generator)：代码生成器
MyBatis官方提供的代码生成器

 

 

 

步骤：

导包

 

 配置

<!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="simple" targetRuntime="MyBatis3Simple">
        <!--连接到哪个数据库-->
        <jdbcConnection
                driverClass="com.mysql.cj.jdbc.Driver"
                connectionURL="jdbc:mysql://localhost:3306/menumanage?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC"
                userId="root"
                password="admin"
        />

        <!--生成POJO
           targetPackage：生成的pojo放在哪个包
           targetProject：放在哪个工程下
        -->
        <javaModelGenerator targetPackage="com.tang.bean" targetProject="./src"/>

        <!--sql映射文件生成器
                   targetPackage：生成的sql映射文件放在哪个包
                   targetProject：放在哪个工程下
        -->
        <sqlMapGenerator targetPackage="com.tang.dao" targetProject="./conf"/>

        <!--生成dao接口
                   targetPackage：生成的sql映射文件放在哪个包
                   targetProject：放在哪个工程下
        -->
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.tang.dao" targetProject="./src"/>

        <!--指定逆向生成哪个表
                   tableName：表名
                   domainObjectName：pojo类名
        -->
        <table tableName="usertb" domainObjectName="User"/>
    </context>
</generatorConfiguration>

 

运行生成代码

package com.tang.test;

import org.junit.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 org.springframework.test.context.TestConstructor;

import java.io.File;
import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class MyTest {
    @Test
    public void mbg() throws InterruptedException, SQLException, IOException, XMLParserException, InvalidConfigurationException {
        List<String> warnings = new ArrayList<String>();
        boolean overwrite = true;
        File configFile = new File("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);
    }
}