- IDEA中创建spring boot项目或者maven项目(相信你3秒就完成了)
- 在maven或者springboot项目中的pom.xml文件中,添加mysql-connector-java依赖以及mybatis-generator-maven-plugin插件,代码如下:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.21</version>
</dependency>
<build>
<plugins>
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.7</version>
<configuration>
<verbose>true</verbose>
<overwrite>true</overwrite>
</configuration>
</plugin>
</plugins>
</build>
- 在resources文件夹下创建generatorConfig.xml文件 并 复制下面这段代码(按需修改即可)
<!DOCTYPE generatorConfiguration
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<!--suppress MybatisGenerateCustomPluginInspection -->
<generatorConfiguration>
<!-- 配置文件的位置,主要是为了下面jdbcConnection配置更简单些-->
<properties resource="application.properties"/>
<!-- mysql-connector-java-8.0.21.jar 包的绝对路径,按需修改成自己的-->
<classPathEntry location="D:/Program Files/apache-maven-3.6.3/maven-repo/mysql/mysql-connector-java/8.0.21/mysql-connector-java-8.0.21.jar"/>
<context id="mbg" targetRuntime="MyBatis3DynamicSQL">
<!-- 注释生成器-->
<commentGenerator>
<property name="suppressAllComments" value="false"/>
<property name="addRemarkComments" value="true"/>
</commentGenerator>
<!-- jdbc连接配置,上面properties配置文件如果正确,这里无需修改-->
<jdbcConnection driverClass="${spring.datasource.driver-class-name}"
connectionURL="${spring.datasource.url}"
userId="${spring.datasource.username}"
password="${spring.datasource.password}">
</jdbcConnection>
<!-- java实体类生成器, targetPackage按需修改-->
<javaModelGenerator targetPackage="com.hao.mybatisdynamicsql.model"
targetProject="src/main/java">
<property name="enableSubPackages" value="false"/>
<property name="trimStrings" value="true"/>
</javaModelGenerator>
<!-- Java代理生成器 targetPackage按需修改-->
<javaClientGenerator type="ANNOTATEDMAPPER"
targetPackage="com.hao.mybatisdynamicsql.mapper"
targetProject="src/main/java">
<property name="enableSubPackages" value="false"/>
</javaClientGenerator>
<!-- 数据表进行生成操作 schema:相当于库名; tableName:表名; domainObjectName:对应的DO -->
<!-- 如果有多个表 ,就多复制几个table代码段 -->
<table schema="mybatis" tableName="simpletable" domainObjectName="simpletable"
enableCountByExample="false" enableUpdateByExample="false"
enableDeleteByExample="false" enableSelectByExample="false"
selectByExampleQueryId="false">
</table>
</context>
</generatorConfiguration>
-
配置完毕,开始生成—— 点击下图中的Run Maven Build
-
生成的mapper文件和model文件如下: