一.加入maven插件的依赖地址并配置好generatorConfig.xml文件路径及相关依赖:
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<version>2.0.4.RELEASE</version>
</plugin>
<!-- mybatis generator 自动生成代码插件 -->
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.7</version>
<configuration>
<configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
<overwrite>true</overwrite>
<verbose>true</verbose>
</configuration>
</plugin>
</plugins>
二.添加generatorConfig.xml配置文件(注意pom.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="application.properties"/>
<classPathEntry location="D:/repository/com/oracle/ojdbc6/11.2.0.1.0/ojdbc6-11.2.0.1.0.jar" />
-->
<classPathEntry
location="/Users/用户名/.m2/repository/mysql/mysql-connector-java/8.0.11/mysql-
connector-java-8.0.11.jar"/>
<context id="mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat">
<!-- 生成的pojo,将implements Serializable-->
<plugin type="org.mybatis.generator.plugins.SerializablePlugin"></plugin>
<!-- 去掉注释-->
<commentGenerator >
<property name="suppressDate" value="true"/>
<property name="suppressAllComments" value="true"/>
</commentGenerator>
<!-- 注意,如果mysql是6版本以上,驱动是cj,连接串需要加上时区,如果报找不到主键,可添加以下参数,useSSL=false&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true-->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/test?serverTimezone=Asia/Shanghai"
userId="test"
password="test">
</jdbcConnection>
<javaModelGenerator targetPackage="com.test.dao.model" targetProject="src/main/java"/>
<sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"/>
<javaClientGenerator targetPackage="com.test.dao.mapper" targetProject="src/main/java" type="XMLMAPPER"/>
<table tableName="t_test" domainObjectName="Test">
<!--% 表示全部表-->
<!--mysql 配置-->
<generatedKey column="id" sqlStatement="Mysql" identity="true"/>
<!--oracle 配置-->
<!-- <generatedKey column="id" sqlStatement="select SEQ_{1}.nextval from dual" identity="false" type="pre"/> -->
</table>
</context>
</generatorConfiguration>
nullCatalogMeansCurrent参数在mysql6以前默认是true,6以后是false
注意配置好生成的文件路径和生成的名称。
三.配置配好后,就可以生成代码了:
1.如果是IDE生成,即可通过右击项目,Run as------>maven build------->输入命令:mybatis-generator:generate
对于idea则有:
添加完之后就能看到:
对于eclipse:
然后:
即可生成对应的实体及配置文件。
至此,代码生成了。
2.如果是命令生成,需要到该项目的目录下,执行命令:mvn mybatis-generator:generate即可完成代码的生成。
如果找不到plugin,配置以下:
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
<!-- 自动生成代码插件 -->
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.0</version>
<configuration>
<configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
<overwrite>true</overwrite>
<verbose>true</verbose>
</configuration>
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
</dependency>
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.1</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</build>