mybatis-generator逆向工程生成Model與Mapper的筆記

想要嘗試使用Maven插件-mybatis-generator(mybatis自動生成實體與mapper帶增删查改接口代碼的插件)

話不多說上代碼

1.建立一個maven項目

修改pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>com.mybatis</groupId>
	<artifactId>autogenerator</artifactId>
	<packaging>war</packaging>
	<version>0.0.1-SNAPSHOT</version>
	<name>autogenerator Maven Webapp</name>
	<url>http://maven.apache.org</url>
	<dependencies>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>3.8.1</version>
			<scope>test</scope>
		</dependency>
		<!-- 添加依賴開始 -->
		<dependency>
			<groupId>org.mybatis.generator</groupId>
			<artifactId>mybatis-generator-core</artifactId>
			<version>1.3.5</version>
		</dependency>
		<!-- 添加依賴結束 -->
	</dependencies>
	<build>
		<finalName>autogenerator</finalName>
		<!-- 添加插件開始 -->
		<plugins>
		<plugin>
           <groupId>org.mybatis.generator</groupId>
           <artifactId>mybatis-generator-maven-plugin</artifactId>
           <version>1.3.2</version>
           <executions>
              <execution>
                 <id>Generate MyBatis Files</id>
                 <goals>
                    <goal>generate</goal>
                 </goals>
                 <phase>generate</phase>
                 <configuration>
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>
                 </configuration>
              </execution>
           </executions>
           <dependencies>
              <dependency>
                 <groupId>mysql</groupId>
                 <artifactId>mysql-connector-java</artifactId>
                 <version>8.0.13</version>
              </dependency>
              <dependency>
                 <groupId>org.mybatis.generator</groupId>
           <artifactId>mybatis-generator-core</artifactId>
                 <version>1.3.5</version>
              </dependency>
              <dependency>
                 <groupId>org.mybatis</groupId>
                 <artifactId>mybatis</artifactId>
                 <version>3.4.2</version>
              </dependency>
           </dependencies>
        </plugin>
        </plugins>
        <!-- 添加插件結束 -->
	</build>
</project>

           

2.resource檔案夾添加配置檔案

<?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="properties/jdbc.properties" />

	<context id="mysqlTables" targetRuntime="MyBatis3">
		<jdbcConnection driverClass="${jdbc.driver}"
			connectionURL="${jdbc.url}" userId="${jdbc.username}"
			password="${jdbc.password}" />
		<!--指定生成的類型為java類型，避免資料庫中number等類型字段 -->
		<javaTypeResolver>
			<property name="forceBigDecimals" value="false" />
		</javaTypeResolver>

		<!--自動生成的實體的存放包路徑 -->
		<javaModelGenerator
			targetPackage="com.mybatis.generator.entity"
			targetProject="src/main/java">
			<property name="enableSubPackages" value="true" />
			<property name="trimStrings" value="true" />
		</javaModelGenerator>
		<!--自動生成的*Mapper.xml檔案存放路徑 -->
		<sqlMapGenerator
			targetPackage="com.mybatis.generator.mapper"
			targetProject="src/main/java">
			<property name="enableSubPackages" value="true" />
		</sqlMapGenerator>
		<!--自動生成的*Mapper.java存放路徑 -->
		<javaClientGenerator type="XMLMAPPER"
			targetPackage="com.mybatis.generator.mapper"
			targetProject="src/main/java">
			<property name="enableSubPackages" value="true" />
		</javaClientGenerator>
		<table tableName="tb_user" domainObjectName="User"
			enableCountByExample="false" enableUpdateByExample="false"
			enableDeleteByExample="false" enableSelectByExample="false"
			selectByExampleQueryId="false">
			<generatedKey column="id"
				sqlStatement="selectuuid_short()" identity="false" />
		</table>
		<table tableName="tb_customer" domainObjectName="Customer"
			enableCountByExample="false" enableUpdateByExample="false"
			enableDeleteByExample="false" enableSelectByExample="false"
			selectByExampleQueryId="false">
			<generatedKey column="id"
				sqlStatement="select uuid_short()" identity="false" />
		</table>
	</context>
</generatorConfiguration>
           

添加maven運作指令

右鍵項目run as ==》run configrations

這裡需要填寫兩個紅框内的内容（第二個框的内容固定）

點選apply後，點選run

即可生成

項目結構（紅框為生成的包）

項目位址（無添加log4j）無spring

參考位址

https://blog.csdn.net/liyonghong3333/article/details/79590588

官網

http://www.mybatis.org/generator/quickstart.html