MyBatis数据库逆向生成工具mybatis-generator

冷不防 2023-05-22 08:49 31阅读 0赞

初始项目结构如下：  
![在这里插入图片描述][20200416225506641.png]

*  pom中引入逆向生成工具

<dependency>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-core</artifactId>
        <version>1.3.2</version>
        <scope>compile</scope>
        <optional>true</optional>
    </dependency>

*  引入MyMapper接口类

import tk.mybatis.mapper.common.Mapper;
    import tk.mybatis.mapper.common.MySqlMapper;
    
    /**
     * 继承自己的MyMapper
     */
    public interface MyMapper<T> extends Mapper<T>, MySqlMapper<T> {
    }

*  启动类

import org.mybatis.generator.api.MyBatisGenerator;
    import org.mybatis.generator.config.Configuration;
    import org.mybatis.generator.config.xml.ConfigurationParser;
    import org.mybatis.generator.internal.DefaultShellCallback;
    
    import java.io.File;
    import java.util.ArrayList;
    import java.util.List;
    
    
    public class GeneratorDisplay {
    
    	public void generator() throws Exception {
    
    		List<String> warnings = new ArrayList<String>();
    		boolean overwrite = true;
    		//指定 逆向工程配置文件
    		File configFile = new File("generatorConfig.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);
    
    	} 
    	
    	public static void main(String[] args) throws Exception {
    		try {
    			GeneratorDisplay generatorSqlmap = new GeneratorDisplay();
    			generatorSqlmap.generator();
    		} catch (Exception e) {
    			e.printStackTrace();
    		}
    		
    	}
    }

*  配置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="MysqlContext" targetRuntime="MyBatis3Simple" defaultModelType="flat">
            <property name="beginningDelimiter" value="`"/>
            <property name="endingDelimiter" value="`"/>
    
            
            <plugin type="tk.mybatis.mapper.generator.MapperPlugin">
                <property name="mappers" value="com.xxx.my.mapper.MyMapper"/>
            </plugin>
    
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                            connectionURL="jdbc:mysql://localhost:3306/db"
                            userId="root"
                            password="root">
            </jdbcConnection>
    
            
            <javaModelGenerator targetPackage="com.xxx.pojo" targetProject="src/main/java"/>
    
    		
            <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"/>
    
    		
            <javaClientGenerator targetPackage="com.xxx.mapper" targetProject="src/main/java" type="XMLMAPPER"/>
    
            
    		<table tableName="xxxx"></table>
    		<table tableName="xxxx"></table>
    		<table tableName="xxxx"></table>
    
        </context>
    </generatorConfiguration>

例如我要生成以下三张表的对应mapper文件  
![在这里插入图片描述][2020041622515876.png]  
则在xml内配置

<table tableName="carousel"/>
    <table tableName="category"/>
    <table tableName="items"/>

然后运行启动类，可以看到生成了对应的mapper文件，POJO类以及mapper.xml文件  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x0MzI2MDMwNDM0_size_16_color_FFFFFF_t_70]

[20200416225506641.png]: /images/20230521/9170ed477a6948daaffa69f7b10c0cbf.png
[2020041622515876.png]: /images/20230521/cce6334dcd0c4f2b851ad85020778a98.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x0MzI2MDMwNDM0_size_16_color_FFFFFF_t_70]: /images/20230521/2cd5573123704808a3cc7f6cdb2e6640.png