学习在IDEA中使用Mybatis（七）逆向工程—Mybatis Generator（MBG）

1.pom.xml中导入jar包

	<?xml version="1.0" encoding="UTF-8"?>
	<project xmlns="http://maven.apache.org/POM/4.0.0"
	         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	    <modelVersion>4.0.0</modelVersion>
	
	    <groupId>MBG</groupId>
	    <artifactId>MBG</artifactId>
	    <version>1.0-SNAPSHOT</version>
	    	
	    <dependencies>
	        <dependency>
	            <groupId>org.mybatis.generator</groupId>
	            <artifactId>mybatis-generator-maven-plugin</artifactId>
	            <version>1.3.5</version>
	        </dependency>
	        <dependency>
	            <groupId>org.mybatis</groupId>
	            <artifactId>mybatis</artifactId>
	            <version>3.4.5</version>
	        </dependency>
	        
	        <dependency>
	            <groupId>junit</groupId>
	            <artifactId>junit</artifactId>
	            <version>4.12</version>
	            <scope>test</scope>
	        </dependency>
	
	        <dependency>
	            <groupId>mysql</groupId>
	            <artifactId>mysql-connector-java</artifactId>
	            <version>8.0.16</version>
	            <scope>runtime</scope>
	        </dependency>
	  </dependencies>
	</project>

2.配置mbg.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>
	
	    <!--
	        targetRuntime="MyBatis3Simple":生成简单版的CRUD
	
	
	     -->
	    <context id="DB2Tables" targetRuntime="MyBatis3">
	        <!-- jdbcConnection：指定如何连接到目标数据库 -->
	
	        <commentGenerator>
	            <property name="suppressAllComments" value="true" />
	        </commentGenerator>
	
	        <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
	                        connectionURL="jdbc:mysql://localhost:3306/mybatis"
	                        userId="root"
	                        password="hejie1994820">
	        </jdbcConnection>
	
	        <!--  -->
	        <javaTypeResolver >
	            <property name="forceBigDecimals" value="false" />
	        </javaTypeResolver>
	
	        <!-- javaModelGenerator：指定javaBean的生成策略
	        targetPackage="test.model"：目标包名
	        targetProject="\MBGTestProject\src"：目标工程
	        -->
	        <javaModelGenerator targetPackage="com.hejie.domain"
	                            targetProject=".\src\main\java">
	            <property name="enableSubPackages" value="true" />
	            <property name="trimStrings" value="true" />
	        </javaModelGenerator>
	
	        <!-- sqlMapGenerator：sql映射生成策略： -->
	        <sqlMapGenerator targetPackage="com.hejie.dao"
	                         targetProject=".\src\main\resource">
	            <property name="enableSubPackages" value="true" />
	        </sqlMapGenerator>
	
	        <!-- javaClientGenerator:指定mapper接口所在的位置 -->
	        <javaClientGenerator type="XMLMAPPER" targetPackage="com.hejie.dao"
	                             targetProject=".\src\main\java">
	            <property name="enableSubPackages" value="true" />
	        </javaClientGenerator>
	
	        <!-- 指定要逆向分析哪些表：根据表要创建javaBean -->
	        <table tableName="tbl_dept" domainObjectName="Department"></table>
	        <table tableName="tbl_employee" domainObjectName="Employee"></table>
	    </context>

3.运行test方法

	public class test {
	
	    @Test
	    public void testMbg() throws Exception {
	        List<String> warnings = new ArrayList<String>();
	        boolean overwrite = true;
	        File configFile = new File("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);
	    }
	}