MyBatisGenerator逆向生成实体、DAO、以及映射XML

- 日理万妓 2022-03-24 15:24 397阅读 0赞

## 一.引入jar ##

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

## 二.配置生成规则文件generator.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="DB2Tables" targetRuntime="MyBatis3">
      	<commentGenerator>
      		
      		<property name="suppressAllComments" value="true"/>
      	</commentGenerator>
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
            connectionURL="jdbc:mysql://localhost:3306/refectory?characterEncoding=utf-8"
            userId="root"
            password="root">
        </jdbcConnection>
    
        <javaTypeResolver >
          <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>
    
    	
        <javaModelGenerator targetPackage="com.org.refectory.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.org.refectory.dao"  targetProject=".\src\main\java">
          <property name="enableSubPackages" value="true" />
        </javaClientGenerator>
    
    	
        
         
        
    	<table tableName="tbl_admin" domainObjectName="Admin" > </table> 
         
      </context>
    </generatorConfiguration>

## 三.编写生成实现案例方法 ##

public class MyBatisGeneratorHelp {
    	
    	/**逆向将数据表生成实体类对象
    	 * @param args
    	 * @throws IOException
    	 * @throws XMLParserException
    	 * @throws InvalidConfigurationException
    	 * @throws SQLException
    	 * @throws InterruptedException
    	 */
    	public static void main(String[] args) throws IOException, XMLParserException, InvalidConfigurationException, SQLException, InterruptedException {
    		List<String> warnings = new ArrayList<String>();
    		   boolean overwrite = true;
    		   System.out.println("======开始逆向生成实体类！=======");
    		   File configFile = new File("generator.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);
    		   System.out.println("======逆向生成实体类成功！=======");
    
    	}
    }