- 现在pom文件中添加org.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/mybatis-generator/generatorConfig.xml</configurationFile>
<verbose>true</verbose>
<overwrite>true</overwrite>
</configuration>
</plugin>
-
在上述configurationFile标签定义的目录下创建generatorConfig.xml文件
image.png
<?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="${spring.datasource.driverLocation}"/>
<context id="default" targetRuntime="Mybatis3">
<commentGenerator>
<property name="suppressDate" value="true"/>
<property name="suppressAllComments" value="true"/>
</commentGenerator>
<jdbcConnection
driverClass="${spring.datasource.driver-class-name}"
connectionURL="${spring.datasource.url}"
userId="${spring.datasource.username}"
password="${spring.datasource.password}">
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false"/>
</javaTypeResolver>
<javaModelGenerator targetPackage="com.lou.springboot.entity" targetProject="./src/main/java" />
<sqlMapGenerator targetPackage="mapper" targetProject="./src/main/resources/"/>
<javaClientGenerator type="XMLMAPPER" targetPackage="com.lou.springboot.dao" targetProject="./src/main/java"/>
<table tableName="tb_user" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
</context>
</generatorConfiguration>
-
application.properties需要定义generatorConfig.xml中的变量
image.png
mybatis.mapper-locations=classpath:mapper/*Dao.xml
spring.datasource.url=jdbc:mysql://localhost:3306/lou_springboot?useUnicode=true&characterEncoding=utf8&autoReconnect=true&useSSL=false&serverTimezone=UTC
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driverLocation=C:/Users/z2/.m2/repository/mysql/mysql-connector-java/8.0.13/mysql-connector-java-8.0.13.jar
-
最后执行mybatis-generator:generate操作
image.png -
这些都是自动生成的文件
image.png
image.png - 避坑攻略
-
driverLocation定义错误，报错提示：com.mysql.cj.jdbc.Driver
image.png -
spring.datasource.url中没有写时区，报错提示：Could not create connection to database server. Attempted reconnect 3 times. Giving up.，在application.properties的spring.datasource.url定义中需要加上“&serverTimezone=UTC”
image.png
