使用IDEA springboot 如何通过mybatis-generator自动生成代码

旧城等待， 2022-03-29 17:37 224阅读 0赞

第一步：在maven工程当中的resource下面，创建generatorConfig.xml文件。

![1237300-20181011181010757-2072873535.png][]

务必注意创建的位置！！！

<table> 
 <tbody> 
 <tr> 
 <td> 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 </td> 
 <td>&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;!DOCTYPE generatorConfiguration &nbsp; &nbsp; &nbsp; &nbsp; PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" &nbsp; &nbsp; &nbsp; &nbsp; "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"&gt; &lt;generatorConfiguration&gt; &nbsp; &nbsp; &lt;!--数据库驱动--&gt; &nbsp; &nbsp; &lt;classPathEntry &nbsp; &nbsp;location="E:\develop\repository311\mysql\mysql-connector-java\5.1.46\mysql-connector-java-5.1.46.jar"/&gt; &nbsp; &nbsp; &lt;context id="DB2Tables" &nbsp; &nbsp;targetRuntime="MyBatis3"&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;commentGenerator&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;property name="suppressDate" value="true"/&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;property name="suppressAllComments" value="true"/&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/commentGenerator&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;!--数据库链接地址账号密码--&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://106.13.40.159:3306/village" userId="root" password="shuai0429"&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/jdbcConnection&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;javaTypeResolver&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;property name="forceBigDecimals" value="false"/&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/javaTypeResolver&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;!--生成Model类存放位置--&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;javaModelGenerator targetPackage="com.miss.vilage.model" targetProject="src/main/java"&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;property name="enableSubPackages" value="true"/&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;property name="trimStrings" value="true"/&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/javaModelGenerator&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;!--生成映射文件存放位置--&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;sqlMapGenerator targetPackage="mapping" targetProject="src/main/resources"&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;property name="enableSubPackages" value="true"/&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/sqlMapGenerator&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;!--生成Dao类存放位置--&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;javaClientGenerator type="XMLMAPPER" targetPackage="com.miss.vilage.mapper" targetProject="src/main/java"&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;property name="enableSubPackages" value="true"/&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/javaClientGenerator&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;!--对应的数据库表及model中生成的类名--&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;table tableName="user" domainObjectName="User" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"&gt;&lt;/table&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;table tableName="blog" domainObjectName="Blog" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;columnOverride column="content" javaType="java.lang.String" jdbcType="VARCHAR" /&gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt; &nbsp; &nbsp; &lt;/context&gt; &lt;/generatorConfiguration&gt;</td> 
 </tr> 
 </tbody> 
</table>

这里需要注意的几个问题：

1.location="E:\\develop\\repository311\\mysql\\mysql-connector-java\\5.1.46\\mysql-connector-java-5.1.46.jar"

需要的是连接数据库的jar包。一般在maven的工程下面的扩展包

![1237300-20181011180952450-634207118.png][]

第二步 配置pom文件，在plugins节点下面增加这个plugin节点内容。

![1237300-20181011181355468-1136703358.png][]

![复制代码][copycode.gif]

<plugin>
 <groupId>org.mybatis.generator</groupId>
 <artifactId>mybatis-generator-maven-plugin</artifactId>
 <version>1.3.7</version>
 <configuration>
 
 <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
 <verbose>true</verbose>
 <overwrite>true</overwrite>
 </configuration>
 <executions>
 <execution>
 <id>Generate MyBatis Artifacts</id>
 <goals>
 <goal>generate</goal>
 </goals>
 </execution>
 </executions>
 <dependencies>
 <dependency>
 <groupId>org.mybatis.generator</groupId>
 <artifactId>mybatis-generator-core</artifactId>
 <version>1.3.7</version>
 </dependency>
 </dependencies>
 </plugin>

![复制代码][copycode.gif]

第三步，配置好插件即可在右侧打开maven工程

![1237300-20181011181529548-214858145.png][]

单击即可生成。结果如下

![1237300-20181011181556690-628464390.png][]

![1237300-20181011181613883-990608981.png][]

[1237300-20181011181010757-2072873535.png]: /images/20220329/4294bcf7478a48f3853ff834a11a6836.png
[1237300-20181011180952450-634207118.png]: /images/20220329/a2fa1195bcf0461db236a5b9aa832dca.png
[1237300-20181011181355468-1136703358.png]: /images/20220329/179ff0ef41444dc49d25783cd2498232.png
[copycode.gif]: /images/20220329/2654908ec46d4622966dc07ebe67e858.png
[1237300-20181011181529548-214858145.png]: /images/20220329/3ceb3ebbccda463aa911d78dde4d7c7c.png
[1237300-20181011181556690-628464390.png]: /images/20220329/8e5c9bd99b9e4b1bbc117089487b5b8c.png
[1237300-20181011181613883-990608981.png]: /images/20220329/08c9db4383e94acdabb381fc831ab0a5.png