通过MyBatis Generator插件逆向生成代码,大大节省了自己重复编写数据表对应的entity、dao、mapper文件的时间,使用简单,非常推荐。
一、引入mybatis-generator
依赖
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.5</version>
</dependency>
二、插件配置
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.5</version>
<configuration>
<overwrite>true</overwrite>
<configurationFile> src/main/resources/generator/generatorConfig.xml </configurationFile>
</configuration>
<dependencies>
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<version>8.0.31</version>
</dependency>
</dependencies>
</plugin>
三、创建配置文件generatorConfig.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.yml" />
<context id="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat">
<property name="beginningDelimiter" value="`"/>
<property name="endingDelimiter" value="`"/>
<commentGenerator>
<property name="suppressAllComments" value="true"/>
<property name="suppressDate" value="true"/>
</commentGenerator>
<jdbcConnection driverClass="${driver-class-name}" connectionURL="${url}"
userId="${username}" password="${password}">
<property name="useInformationSchema" value="true" />
</jdbcConnection>
<javaTypeResolver type="org.mybatis.generator.internal.types.JavaTypeResolverDefaultImpl">
<property name="forceBigDecimals" value="false"/>
</javaTypeResolver>
<javaModelGenerator targetPackage="cn.chenxp.rbac.entity" targetProject="src/main/java"/>
<sqlMapGenerator targetPackage="mappers" targetProject="src/main/resources"/>
<javaClientGenerator targetPackage="cn.chenxp.rbac.dao" targetProject="src/main/java" type="XMLMAPPER"/>
<table tableName="bs_user" domainObjectName="User"/>
</context>
</generatorConfiguration>
四、运行插件生成代码