mybatis-generator的使用

清疚 2023-08-17 17:47 109阅读 0赞

### mybatis-generator的使用 ###

自动生成代码mybatis-generator官网地址：  
[http://www.mybatis.org/generator/configreference/xmlconfig.html][http_www.mybatis.org_generator_configreference_xmlconfig.html]

**1、新建maven项目并且在pom.xml中添加mybatis-generator的插件**

<build>
        <finalName>ibatisGenerator</finalName>
        <plugins>
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.7</version>
            </plugin>
        </plugins>
    </build>

**2、在resources中添加database.properties的数据库的配置文件,注意路径的/**

db.driverLocation=C:/Users/Administrator/IdeaProjects/MyBatisGenerator/doc/mysql-connector-java-5.1.48.jar
    db.driverClassName=com.mysql.jdbc.Driver
    db.url=jdbc:mysql://127.0.0.1:3306/test1212?characterEncoding=utf-8
    db.username=root
    db.password=root

3、从官网下载generatorConfig.xml放在resources目录下,并且修改内容  
内容详见doc下的generatorConfiguration.xml中的说明  
[http://www.mybatis.org/generator/configreference/xmlconfig.html][http_www.mybatis.org_generator_configreference_xmlconfig.html]  
配置文件的加单配置

<?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="datasource.properties"></properties>
    
        
        <classPathEntry location="${db.driverLocation}" />
    
        
        
        
        <context id="default" targetRuntime="MyBatis3">
            
            <plugin type="org.mybatis.generator.plugins.UnmergeableXmlMappersPlugin" />
            
            <commentGenerator>
                <property name="suppressDate" value="true" />
                
                <property name="suppressAllComments" value="false" />
    
            </commentGenerator>
    
            
            <jdbcConnection driverClass="${db.driverClassName}" connectionURL="${db.url}" userId="${db.username}" password="${db.password}">
            </jdbcConnection>
    
            
            <javaTypeResolver>
                
                
                
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    
            
            
            <javaModelGenerator targetPackage="com.fjh.entity" targetProject=".\src\main\java">
                
                
                <property name="enableSubPackages" value="false" />
                
                <property name="constructorBased" value="true" />
                
                <property name="trimStrings" value="true" />
                
                <property name="immutable" value="false" />
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="mappers" targetProject=".\src\main\resources">
                
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
    
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.fjh.dao" targetProject=".\src\main\java">
                
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
            <table tableName="auto_code" domainObjectName="AutoCode" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false">
                
                <generatedKey column="id" sqlStatement="JDBC"></generatedKey>
            </table>
    
            <table tableName="course" domainObjectName="Course" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false">
                
                <generatedKey column="id" sqlStatement="JDBC"></generatedKey>
            </table>
        </context>
    </generatorConfiguration>

**4、运行mvn 命令 mybatis-generator:generate 或者直接在idea中点击运行该命令**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwODk2OTk3_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwODk2OTk3_size_16_color_FFFFFF_t_70 1]

[http_www.mybatis.org_generator_configreference_xmlconfig.html]: http://www.mybatis.org/generator/configreference/xmlconfig.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwODk2OTk3_size_16_color_FFFFFF_t_70]: /images/20230808/cb21fcf1fafd400cae02fd9c80bbf36f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwODk2OTk3_size_16_color_FFFFFF_t_70 1]: /images/20230808/bba7cd61ea7a44bda51a4e196cc2f03b.png