你要惊艳所有人，然后悄悄学java -- mybatis 自动生成

约定不等于承诺〃 2022-12-26 08:14 120阅读 0赞

### **需求**： ###

开发过程中，尤其在开发的初期阶段，需要建立一些表实体、mybatis xml文件、这个时候手敲代码就duck不必了。

下面教给大家一种自动生成 实体、mapper文件、mybatis xml文件的方法。

示例为已经建立好的springboot项目

### **首先**： ###

添加自动生成的jar包

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

**然后配置自动生成文件的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>
    	
    	<properties resource="application-test.yml"/>
    
    	<context id="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat">
    		
    		<property name="beginningDelimiter" value="`"/>
    		<property name="endingDelimiter" value="`"/>
    
    		
    		
    		<plugin type="tk.mybatis.mapper.generator.MapperPlugin">
    			<property name="mappers" value="tk.mybatis.mapper.common.Mapper"/>
    			<property name="lombok" value="Data"/>
    		</plugin>
    
    		
    		<jdbcConnection driverClass="${driver-class-name}"
    						connectionURL="${url}"
    						userId="${username}"
    						password="${password}">
    			<property name="nullCatalogMeansCurrent" value="true"/>
    		</jdbcConnection>
    
    		
    		<javaModelGenerator targetPackage="com.example.cp.entity" targetProject="src/main/java"/>
    		
    		<sqlMapGenerator targetPackage="mybatis.mapper" targetProject="src/main/resources"/>
    		
    		<javaClientGenerator targetPackage="com.example.cp.mapper" targetProject="src/main/java" type="XMLMAPPER"/>
    		
    		<table tableName="sys_role" domainObjectName="SysRole">
    			
    			<generatedKey column="id" sqlStatement="Mysql" identity="true"/>
    		</table>
    
    
    	</context>
    </generatorConfiguration>

### **然后创建一个生成文件的java文件**： ###

package com.example.cp.common.tool;
    
    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.IOException;
    import java.io.InputStream;
    import java.sql.SQLException;
    import java.util.ArrayList;
    import java.util.List;
    
    /**
     * @Description: mybatis 生成entity实体、mapper、xml 工具类
     * @Author: 
     * @Date: 2020-05-28
     */
    public class MybatisGeneratorUtil {
    
        public static void main(String[] args) {
            generateMybatisCode();
        }
    
        public static boolean generateMybatisCode(){
            List<String> warnings = new ArrayList<String>();
            boolean overwrite = false;//是否覆盖
            InputStream inputStream = MybatisGeneratorUtil.class.getClassLoader().getResourceAsStream("mybatis/generatorConfig.xml");
            ConfigurationParser cp = new ConfigurationParser(warnings);
            Configuration config;
            try {
                config = cp.parseConfiguration(inputStream);
                DefaultShellCallback callback = new DefaultShellCallback(overwrite);
                MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
                myBatisGenerator.generate(null);
            } catch (IOException | XMLParserException | InvalidConfigurationException | InterruptedException | SQLException e) {
                e.printStackTrace();
            }
            warnings.forEach(System.out::println);
            System.out.println("代码生成完毕>>>>>>>>>>>>");
            return  true;
        }
    }

### **最后 运行 MybatisGeneratorUtil**： ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5waW5nMTk5Mw_size_16_color_FFFFFF_t_70][]

**大功告成，在对应的位置就生成了我们想要的东西，你开始惊艳所有人了！**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5waW5nMTk5Mw_size_16_color_FFFFFF_t_70 1][]

**当其他人正在两岸猿声啼不住的时候，你已经轻舟已过万重山了。人人都夸你是个深藏blue的编码小能手**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5waW5nMTk5Mw_size_16_color_FFFFFF_t_70 2][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5waW5nMTk5Mw_size_16_color_FFFFFF_t_70]: /images/20221120/2932110114104ea5b54d9b0c05b79d9c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5waW5nMTk5Mw_size_16_color_FFFFFF_t_70 1]: /images/20221120/55dbb34f2af5438db93853abcb245c05.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5waW5nMTk5Mw_size_16_color_FFFFFF_t_70 2]: /images/20221120/90c785885dfc4287bd1b207aadb10c5f.png