SpringBoot项目的mybatis逆向工程

偏执的太偏执、 2022-01-13 15:27 293阅读 0赞

在pom.xml中配置

<groupId>org.mybatis.spring.boot</groupId>

<artifactId>mybatis-spring-boot-starter</artifactId>

</dependency>

<groupId>tk.mybatis</groupId>

<artifactId>mapper-spring-boot-starter</artifactId>

</dependency>

<groupId>com.github.pagehelper</groupId>

<artifactId>pagehelper-spring-boot-starter</artifactId>

</dependency>

<groupId>org.mybatis.generator</groupId>

<artifactId>mybatis-generator-core</artifactId>

<scope>compile</scope>

</dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

</dependencies>

<build>

<plug×××>

<groupId>org.mybatis.generator</groupId>

<artifactId>mybatis-generator-maven-plugin</artifactId>

<configurationFile>src/main/resources/generator/generatorConfig.xml</configurationFile>

</configuration>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

<groupId>tk.mybatis</groupId>

<artifactId>mapper-generator</artifactId>

</dependency>

</dependencies>

</plugin>

</plug×××>

</build>

以上配置包含以下内容，需要在相应的位置创建generatorConfig.xml

![20190528095916634.png][]

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">

<!-- 自动识别数据库关键字，默认false，如果设置为true，根据SqlReservedWords中定义的关键字列表；

一般保留默认值，遇到数据库关键字（Java关键字），使用columnOverride覆盖 -->

</plugin>

</commentGenerator>

<jdbcConnection driverClass="$\{spring.datasource.driver-class-name\}"

connectionURL="$\{spring.datasource.url\}"

userId="$\{spring.datasource.username\}"

password="$\{spring.datasource.password\}">

</jdbcConnection>

</javaTypeResolver>

<javaModelGenerator targetPackage="com.pzg.code.one.entity"

targetProject="src/main/java">

</javaModelGenerator>

<sqlMapGenerator targetPackage="mapper"

targetProject="src/main/resources">

</sqlMapGenerator>

<javaClientGenerator targetPackage="com.pzg.code.one.mapper"

targetProject="src/main/java"

type="XMLMAPPER">

</javaClientGenerator>

<table tableName="user"

domainObjectName="User"

enableCountByExample="true"

enableUpdateByExample="true"

enableDeleteByExample="true"

enableSelectByExample="true"

selectByExampleQueryId="true">

</table>

</context>

</generatorConfiguration>

generatorConfig.xml内容中的数据库连接是引用的配置文件

![20190528095636453.png][]

![20190528095702496.png][]

引用的db.properties文件内容如下

![20190528100115345.png][]

数据库连接也可以无需引用，直接配置，如下图

![20190528100709121.png][]

generatorConfig.xml中的baseMap

![20190528101701702.png][]

可在相应的位置创建MyMapper.java，如下

![watermark,type\_ZmFuZ3poZW5naGVpdGk,shadow\_10,text\_aHR0cHM6Ly9waW5nemhlbmdndW8uYmxvZy5jc2RuLm5ldA==,size\_16,color\_FFFFFF,t\_70][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9waW5nemhlbmdndW8uYmxvZy5jc2RuLm5ldA_size_16_color_FFFFFF_t_70]

最后调出右侧maven，如下，双击蓝色阴影部分，自动生成相关代码

转载于:https://blog.51cto.com/14393737/2409110

[20190528095916634.png]: /images/20220113/9eae1026779f4e87b096700057e52876.png
[20190528095636453.png]: /images/20220113/2b002c36164b4e588bf910697d8a2309.png
[20190528095702496.png]: /images/20220113/5a7e6ea0e4e8447089bc9e9ee68b3ea9.png
[20190528100115345.png]: /images/20220113/83c82ff2a4244040b118d6fa9aba54a0.png
[20190528100709121.png]: /images/20220113/0a645d782bd84e589dbf07c0f5ffc27d.png
[20190528101701702.png]: /images/20220113/1846d906860e46baa176a12f5c090b3c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9waW5nemhlbmdndW8uYmxvZy5jc2RuLm5ldA_size_16_color_FFFFFF_t_70]: /images/20220113/a2489fb9bde74f8f960bf4cbbcf2dc96.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9waW5nemhlbmdndW8uYmxvZy5jc2RuLm5ldA_size_16_color_FFFFFF_t_70 1]: /images/20220113/b4a94d98c2154a459085d7d7ae9191ec.png