mybatis.generator的试用

亦凉 2022-07-15 15:51 143阅读 0赞

pom.xml:

<dependencies>
    		<dependency>
    			<groupId>org.mybatis.generator</groupId>
    			<artifactId>mybatis-generator-core</artifactId>
    			<version>1.3.3</version>
    		</dependency>
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis</artifactId>
    			<version>3.2.8</version>
    		</dependency>
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<version>5.1.35</version>
    		</dependency>
    		<dependency>
    			<groupId>log4j</groupId>
    			<artifactId>log4j</artifactId>
    			<version>1.2.16</version>
    		</dependency>
    	</dependencies>

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>
    	<context id="testTables" targetRuntime="MyBatis3">
    		<commentGenerator>
    			
    			<property name="suppressAllComments" value="true" />
    		</commentGenerator>
    		
    		<jdbcConnection driverClass="com.mysql.jdbc.Driver"
    			connectionURL="jdbc:mysql://10.0.4.122:3306/cognos" userId="root"
    			password="123456">
    		</jdbcConnection>
    
    		
    		<javaTypeResolver>
    			<property name="forceBigDecimals" value="false" />
    		</javaTypeResolver>
    
    		
    		<javaModelGenerator targetPackage="com.touna.salaryProgram.bean"
    			targetProject=".\src">
    			
    			<property name="enableSubPackages" value="false" />
    			
    			<property name="trimStrings" value="true" />
    		</javaModelGenerator>
    		
    		<sqlMapGenerator targetPackage="com.touna.salaryProgram.mapper"
    			targetProject=".\src">
    			
    			<property name="enableSubPackages" value="false" />
    		</sqlMapGenerator>
    		
    		<javaClientGenerator type="XMLMAPPER"
    			targetPackage="com.touna.salaryProgram.mapper" targetProject=".\src">
    			
    			<property name="enableSubPackages" value="false" />
    		</javaClientGenerator>
    		
    		<table tableName="tb_salary_teammanagers"></table>
    	</context>
    </generatorConfiguration>

处理类:

**//配置文件和处理类在同一包下:**

package com.tanlei.generate;
    
    import java.io.File;
    import java.net.URL;
    import java.util.ArrayList;
    import java.util.List;
    
    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;
    
    
    public class GenerateFile {
     
        public void generator() throws Exception {
    
            List<String> warnings = new ArrayList<String>();
            boolean overwrite = true;
            // 指定 逆向工程配置文件
            File configFile = new File(getPackagePath("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 String getPackagePath(String filename)  
        {  
            String result=null;  
            URL urlpath=GetPath.class.getResource("");  
            String path=urlpath.toString();  
            if(path.startsWith("file"))  
            {  
                path=path.substring(5);  
            }  
            path.replace("/", File.separator);  
            result=path+filename;  
            return result;  
        }  
    
        public static void main(String[] args) throws Exception {
            try {
                GenerateFile generatorSqlmap = new GenerateFile();
                generatorSqlmap.generator();
            } catch (Exception e) {
                e.printStackTrace();
            }
           
        }
     
     }

只要这3个文件和更改generatorConfig的配置(有注释)，就可以生成对应的文件