mybatis-generator自动生成相关代码

落日映苍穹つ 2022-04-05 06:12 294阅读 0赞

**根据数据库表自动生成Mapper、xml、entity三个类，两个配置文件轻松搞定！**

**generatorConfig.xml需要被Spring容器扫描，generator.properties跟generatorConfig.xml放在同级目录即可。**

**maven需要集成mybatis-generator插件**

<plugin>
    	<groupId>org.mybatis.generator</groupId>
    	<artifactId>mybatis-generator-maven-plugin</artifactId>
    	<version>1.3.2</version>
    	<configuration>
    		<verbose>true</verbose>
    		<overwrite>true</overwrite>
    	</configuration>
    </plugin>

**generator.properties**

jdbc.driverLocation=mysql-connector-java-5.1.38.jar的路径地址
    jdbc.driverClass=com.mysql.jdbc.Driver
    jdbc.connectionURL=jdbc:mysql:///table_name
    jdbc.userId=root
    jdbc.password=password

**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"></properties>
    
        
        <classPathEntry location="${jdbc.driverLocation}"/>
    
        <context id="context" targetRuntime="MyBatis3">
            
            <commentGenerator>
                
                <property name="suppressAllComments" value="true"/>
                
                <property name="suppressDate" value="true"/>
            </commentGenerator>
    
            
            <jdbcConnection driverClass="${jdbc.driverClass}" connectionURL="${jdbc.connectionURL}" userId="${jdbc.userId}" password="${jdbc.password}"/>
    
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="com.xxx.entity" targetProject="src/main/java">
                
                <property name="constructorBased" value="true"/>
                <property name="enableSubPackages" value="false"/>
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources">
                <property name="enableSubPackages" value="false"/>
            </sqlMapGenerator>
    
            
            <javaClientGenerator targetPackage="com.xxx.mapper" targetProject="src/main/java" type="XMLMAPPER">
                <property name="enableSubPackages" value="false"/>
            </javaClientGenerator>
    
            
            <table tableName="test_table" domainObjectName="TestTable" enableCountByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
                   enableUpdateByExample="false"/>
        </context>
    </generatorConfiguration>

### **简要说明** ###

**mapper接口路径：src/main/java/com/xxx/mapper/TestTableMapper**

**eneity实体类路径：src/main/java/com/xxx/enetity/****TestTable**

**xml接口映射路径：src/main/resources/mapper/TestTableMapper.xml**

**数据库驱动jar可自行百度下载，也可****点击此处****花费积分下载-->****[mysql-connector-java-5.1.38.jar][]**

### maven执行命令 ###

mvn:mybatis-generator:generate -e

*  \-e：向控制台输入内容

[mysql-connector-java-5.1.38.jar]: https://download.csdn.net/download/wkh___/10842413