SpringBoot中使用mybatis-generator自动生成器

冷不防 2022-03-17 02:18 366阅读 0赞

# SpringBoot中使用mybatis-generator自动生成器 #

## 1,使用Spring Initializr创建如下目录结构 ##

![img][]

## 2,在`pom.xml`文件下中添加 如下代码 ##

<plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.5</version>
                <dependencies>
                    
                    <dependency>
                        <groupId>org.mybatis.generator</groupId>
                        <artifactId>mybatis-generator-core</artifactId>
                        <version>1.3.5</version>
                    </dependency>
                    
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>5.1.30</version>
                    </dependency>
                </dependencies>
                <executions>
                    <execution>
                        <id>mybatis generator</id>
                        <phase>package</phase>
                        <goals>
                            <goal>generate</goal>
                        </goals>
                    </execution>
                </executions>
                <configuration>
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>
                    
                    <configurationFile>src/main/resources/mybatis-generator.xml</configurationFile>
                </configuration>
            </plugin>

**在`application.properties`里做如下配置**

mybatis.mapper-locations=classpath:mapping/*.xml

## 3,在`mybatis-generator.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>
    
        <context id="DB2Tables" targetRuntime="MyBatis3">
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                            connectionURL="jdbc:mysql://localhost:3306/miaosha"
                            userId="root"
                            password="123456">
            </jdbcConnection>
    
            
            
            
    
            
            <javaModelGenerator targetPackage="com.wust.miaoshaproject.dataobject" targetProject="src/main/java">
                <property name="enableSubPackages" value="true" />
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="mapping"  targetProject="src/main/resources">
                <property name="enableSubPackages" value="true" />
            </sqlMapGenerator>
    
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.wust.miaoshaproject.dao"  targetProject="src/main/java">
                <property name="enableSubPackages" value="true" />
            </javaClientGenerator>
    
            
            <table tableName="user_info" domainObjectName="UserDO"></table>
            <table tableName="user_password" domainObjectName="UserPasswordDO"></table>
        </context>
    </generatorConfiguration>

## 4,在MySQL数据库里创建如下字段 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjE5NDA2MA_size_16_color_FFFFFF_t_70]

## 5,创建maven工程mybatis-generator ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjE5NDA2MA_size_16_color_FFFFFF_t_70 1]

***切记!要使用左上角+号搜索maven,然后创建项目启动即可自动生成代码***

**启动mybatis-generator**

在这里插入图片描述

在连接数据库时出现如下错误

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjE5NDA2MA_size_16_color_FFFFFF_t_70 2]

**这是在使用MySQL 8.0以上版本（MySQL连接驱动和版本都是8.0以上）的时候出现的问题错误，我们需要在访问数据库的Url后面加上以下的语句即可：**

spring.datasource.url=jdbc:mysql://localhost:3306/miaosha?serverTimezone=GMT%2B8

**修改过后运行成功,目录如下**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjE5NDA2MA_size_16_color_FFFFFF_t_70 3]

**测试成功!**

[img]: /images/20220317/39f7bde070a84b4ea40b99f260d57c1c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjE5NDA2MA_size_16_color_FFFFFF_t_70]: /images/20220317/91d4201afade4ea495a1ea5169a13c87.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjE5NDA2MA_size_16_color_FFFFFF_t_70 1]: /images/20220317/cc6e615ef8cd4e32b63da505334079e9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjE5NDA2MA_size_16_color_FFFFFF_t_70 2]: /images/20220317/35de22c2036546ff9260a77f8542ec56.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjE5NDA2MA_size_16_color_FFFFFF_t_70 3]: /images/20220317/761472cf79d34189853760ec6f22f8eb.png