MyBatis - MyBatis Generator的搭建和使用

Love The Way You Lie 2022-03-17 08:53 183阅读 0赞

#### 一、在pom.xml中加入MyBatis Generator插件 ####

<build>
    	<plugins>
    		
    		<plugin>
    			<groupId>org.mybatis.generator</groupId>
    			<artifactId>mybatis-generator-maven-plugin</artifactId>
    			<version>1.3.2</version>
    			<configuration>
    				<verbose>true</verbose>
    				<overwrite>true</overwrite>
    				<configurationFile>src/main/resources/generator/generator.xml</configurationFile>
    			</configuration>
    		</plugin>
    	</plugins>
    </build>

#### 二、在resources/generator目录下创建generator.properties和generator.xml ####

**generator.properties内容如下**

#数据库驱动jar 
    drive.class.path=F:/shapiya/shapiya-system/system/lib/mysql-connector-java-5.1.29.jar
    
    # 数据库连接参数 
    jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=<数据库地址>
    jdbc.username=<用户名>
    jdbc.password=<密码>
    
    #包路径配置
    model.package=com.shapiya.system.model
    dao.package=com.shapiya.system.dao
    xml.mapper.package=resources\mappers
    target.project=src/main/java
    
    # 生成的表名
    table.name=t_app

**创建generator.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/generator.properties" />
    	
    	<classPathEntry location="${drive.class.path}" />
    	<context id="MySQLTables" targetRuntime="MyBatis3">
    		
    		<commentGenerator>
    			<property name="suppressDate" value="true" />
    		</commentGenerator>
    		
    		<jdbcConnection driverClass="${jdbc.driver}" connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}">
    		</jdbcConnection>
    		
    		<javaModelGenerator targetPackage="${model.package}" targetProject="${target.project}">
    			<property name="enableSubPackages" value="ture" />
    			<property name="trimStrings" value="true" />
    		</javaModelGenerator>
    		
    		<sqlMapGenerator targetPackage="mappers" targetProject="src/main/resources">
    			<property name="enableSubPackages" value="ture" />
    		</sqlMapGenerator>
    		
    		<javaClientGenerator type="XMLMAPPER" targetPackage="${dao.package}" targetProject="${target.project}">
    			<property name="enableSubPackages" value="ture" />
    		</javaClientGenerator>
    		
    		<table tableName="${table.name}">
    		</table>
    	</context>
    </generatorConfiguration>

#### 三、运行 ####

运行maven build  
Base directory选择配置了mybatis generator的项目  
goals处输入mybatis-generator:generate  
run即可

#### 其它设置 ####

**1、不生成Example**

2、关闭所有注释

3、插入语句返回自增主键

`column`：表示自增列的列名  
自增后的值会保存在parameterType的id属性中。  
注意：这可能要求所有的表的主键列名都为ID