使用mybatis genetator 根据数据库生成映射文件

末蓝、 2022-07-16 00:14 135阅读 0赞

#### 1.准备好jar包，我这里是读取mysql，所以准备了mybatis-generator-core-1.3.5.jar 和 mysql-connector-java-5.1.39.jar 两个包 ####

需要的jar包可以这里下载

[http://central.maven.org/maven2/org/mybatis/generator/mybatis-generator-core/1.3.5/mybatis-generator-core-1.3.5.jar][http_central.maven.org_maven2_org_mybatis_generator_mybatis-generator-core_1.3.5_mybatis-generator-core-1.3.5.jar]

[http://central.maven.org/maven2/mysql/mysql-connector-java/5.1.39/mysql-connector-java-5.1.39.jar][http_central.maven.org_maven2_mysql_mysql-connector-java_5.1.39_mysql-connector-java-5.1.39.jar]

--------------------

#### 2.准备好配置文件 ####

如下所示

<?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>
        
    
        
       <classPathEntry location="mysql-connector-java-5.1.39.jar" />
    
    
        
        <context id="mysql" defaultModelType="hierarchical" targetRuntime="MyBatis3Simple" >
    
            
            <property name="autoDelimitKeywords" value="false"/>
            
            <property name="javaFileEncoding" value="UTF-8"/>
            
            <property name="javaFormatter" value="org.mybatis.generator.api.dom.DefaultJavaFormatter"/>
            
            <property name="xmlFormatter" value="org.mybatis.generator.api.dom.DefaultXmlFormatter"/>
    
            
            <property name="beginningDelimiter" value="`"/>
            <property name="endingDelimiter" value="`"/>
    
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://10.20.0.188:3306/pay" userId="root" password="">
                
            </jdbcConnection>
    
            
            <javaTypeResolver type="org.mybatis.generator.internal.types.JavaTypeResolverDefaultImpl">
                
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
    
            
            <javaModelGenerator targetPackage="mark.entity" targetProject="src/main/java">
                
                <property name="constructorBased" value="false"/>
    
                
                <property name="enableSubPackages" value="true"/>
    
                
                <property name="immutable" value="false"/>
    
                
                
    
                
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
    
    
            
            <sqlMapGenerator targetPackage="mark.mapper" targetProject="src/main/resources">
                
                <property name="enableSubPackages" value="true"/>
            </sqlMapGenerator>
    
    
            
            <javaClientGenerator targetPackage="mark.mapper" type="ANNOTATEDMAPPER" targetProject="src/main/java">
                
                <property name="enableSubPackages" value="true"/>
    
                
            </javaClientGenerator>
    
            
            <table tableName="pay" domainObjectName="Pay">
    
                
                <property name="constructorBased" value="false"/>
    
                
                <property name="ignoreQualifiersAtRuntime" value="false"/>
    
                
                <property name="immutable" value="false"/>
    
                
                <property name="modelOnly" value="false"/>
    
                
    
                
    
                
    
                
    
                
    
                
                <property name="selectAllOrderByClause" value="age desc,username asc"/>
    
                
                <property name="useActualColumnNames" value="false"/>
    
    
                
    
                
    
    
                
                <columnOverride column="username">
                    
                    <property name="property" value="userName"/>
    
                    
    
                    
    
                    
    
                    
                </columnOverride>
    
                
            </table>
    
        </context>
    
    </generatorConfiguration>

--------------------

3.在jar包所在的目录，新增src/main/java 子文件，这是为准备生成的映射文件准备的。然后运行

java -jar mybatis-generator-core-1.3.5.jar  -configfile generatorConfig.xml -overwrite

生成映射文件

[http_central.maven.org_maven2_org_mybatis_generator_mybatis-generator-core_1.3.5_mybatis-generator-core-1.3.5.jar]: http://central.maven.org/maven2/org/mybatis/generator/mybatis-generator-core/1.3.5/mybatis-generator-core-1.3.5.jar
[http_central.maven.org_maven2_mysql_mysql-connector-java_5.1.39_mysql-connector-java-5.1.39.jar]: http://central.maven.org/maven2/mysql/mysql-connector-java/5.1.39/mysql-connector-java-5.1.39.jar