Mybatis Generator使用方法

小鱼儿 2023-06-14 12:59 16阅读 0赞

## **Mybatis Generator** ##

用来逆向生成javabean和dao。官方文档[http://mybatis.org/generator/index.html][http_mybatis.org_generator_index.html]

## 使用方法： ##

### 1. 导入maven坐标 ###

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

### 2.在项目下创建配置文件mbg.xml，并修改配置文件 ###

![在这里插入图片描述][20191119202334871.png]  
官方示例[http://mybatis.org/generator/configreference/xmlconfig.html][http_mybatis.org_generator_configreference_xmlconfig.html]  
首先创建目录结构，方便代码生成  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzE1NTg2Ng_size_16_color_FFFFFF_t_70]  
然后将官方示例粘贴到配置文件中

<?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>
                <property name="suppressAllComments" value="true" />
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/数据库名" userId="用户名" password="密码">
            </jdbcConnection>
    
            <javaTypeResolver >
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="com.wf.bean" targetProject="./src/main/java">
                <property name="enableSubPackages" value="true" />
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="mapper" targetProject="./src/main/resources">
                <property name="enableSubPackages" value="true" />
            </sqlMapGenerator>
    
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.wf.dao" targetProject="./src/main/java">
                <property name="enableSubPackages" value="true" />
            </javaClientGenerator>
    
            
            <table tableName="tbl_emp" domainObjectName="Employee"></table>
            <table tableName="tbl_dept" domainObjectName="Department"></table>
    
        </context>
    </generatorConfiguration>

此处需要注意：  
在window系统下目录结构为××\\××  
在liunx系统下目录结构为××/××/××

### 3. 执行生成代码 ###

生成代码官方示例[http://mybatis.org/generator/running/runningWithJava.html][http_mybatis.org_generator_running_runningWithJava.html]  
在test包下新建类MBGTest

package com.wf.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.internal.DefaultShellCallback;
    
    import java.io.File;
    import java.util.ArrayList;
    import java.util.List;
    
    /** * 〈一句话功能简述〉<br> * 〈逆向生成代码〉 */
    public class MBGTest { 
    
        @Test
        public void testMybatisGenerator() throws Exception { 
            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(true);
            MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
            myBatisGenerator.generate(null);
        }
    }

运行此测试代码可以生成dao与bean类  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzE1NTg2Ng_size_16_color_FFFFFF_t_70 1]

[http_mybatis.org_generator_index.html]: http://mybatis.org/generator/index.html
[20191119202334871.png]: https://img-blog.csdnimg.cn/20191119202334871.png
[http_mybatis.org_generator_configreference_xmlconfig.html]: http://mybatis.org/generator/configreference/xmlconfig.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzE1NTg2Ng_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191119202703174.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzE1NTg2Ng==,size_16,color_FFFFFF,t_70
[http_mybatis.org_generator_running_runningWithJava.html]: http://mybatis.org/generator/running/runningWithJava.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzE1NTg2Ng_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191119203327230.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzE1NTg2Ng==,size_16,color_FFFFFF,t_70