使用mybatis-generator自动生成dao、model和mapper

谁借莪１个温暖的怀抱￠ 2022-06-10 09:46 204阅读 0赞

### 在数据库设计完成之后，如果手动配置dao、model和mapper，工作量巨大，mybatis-generator能帮助我们自动生成上面的配置 ###

#### 具体步骤如下： ####

#### 准备：mybatis-generator-core-1.3.5.jar包 ####

1.配置generetor.properties文件：

project = C:/Users/hasee/Desktop/myPro/src/main/java
    resource = C:/Users/hasee/Desktop/myPro/src/main/resources
    classPath=E:/working/java/maven/repository/mysql/mysql-connector-java/5.1.30/mysql-connector-java-5.1.30.jar
    jdbc_driver=com.mysql.jdbc.Driver
    jdbc_url=jdbc:mysql://127.0.0.1:3306/invoice?useUnicode=true&characterEncoding=UTF-8
    jdbc_user=root
    jdbc_password=

2.配置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="generator.properties"/>
    
        
        <classPathEntry location="${classPath}" />
    
        
        <context id="infoGuardian" targetRuntime="MyBatis3">
            
            <commentGenerator >
                <property name="suppressAllComments" value="true"/>
                <property name="suppressDate" value="true" /> 
            </commentGenerator>
    
            
            <jdbcConnection driverClass="${jdbc_driver}" connectionURL="${jdbc_url}" userId="${jdbc_user}" password="${jdbc_password}" />
    
            
            <javaTypeResolver>
                
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
                
            <javaModelGenerator targetPackage="com.puhua.model" targetProject="${project}" >
                
                <property name="enableSubPackages" value="false"/>
                
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="mapper" targetProject="${resource}" >
                
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
    
              
            <javaClientGenerator targetPackage="com.puhua.dao" targetProject="${project}" type="XMLMAPPER" >
                
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
    
                
            <table schema="invoice" tableName="taxpp_users" domainObjectName="Users" enableCountByExample="false" enableDeleteByExample="false" enableSelectByExample="false" enableUpdateByExample="false">
                
    
                
                
            </table>
    
        </context>
    </generatorConfiguration>

3.编写GeneratorMain类：

package com.puhua.util;
    
    import java.io.File;
    import java.io.IOException;
    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.exception.XMLParserException;
    import org.mybatis.generator.internal.DefaultShellCallback;
    
    public class GeneratorMain {
    
        public static void main(String[] args) {
            List<String> warnings = new ArrayList<String>(); 
            boolean overwrite = true; 
            //读取配置文件  
            File configFile = new File("src/main/resources/generatorConfig.xml"); 
            ConfigurationParser cp = new ConfigurationParser(warnings); 
            Configuration config; 
            try {  
                config = cp.parseConfiguration(configFile); 
    
                DefaultShellCallback callback = new DefaultShellCallback(overwrite); 
                MyBatisGenerator myBatisGenerator; 
                try {  
                    myBatisGenerator = new MyBatisGenerator(config, callback,  
                            warnings); 
                    myBatisGenerator.generate(null); 
    
                    //打印结果  
                    for(String str : warnings){  
                        System.out.println(str); 
                    }  
                } catch (Exception e) {  
                    e.printStackTrace(); 
                }  
    
            } catch (IOException e) {  
                e.printStackTrace(); 
            } catch (XMLParserException e) {  
                e.printStackTrace(); 
            }  
        }
    }

4.执行该类，便会生成你在配置文件中配置的表所生成的dao接口、对应model以及mapper。