使用IDEA工具采用MyBatis逆向工程生成

左手的ㄟ右手 2023-08-17 16:14 55阅读 0赞

**首先使用Spring Initializr快速创建方式，如图所示：**

![1496987-20190919223502334-1085319641.png][]

![1496987-20190919223540477-557173569.png][]

![1496987-20190919223809481-1478027211.png][]

![1496987-20190919223848840-1532392343.png][]

第二步，在src下创建MBG.xml配置文件

![1496987-20190919223956065-1033970280.png][]

** MBG.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">
     <commentGenerator>
     <property name="suppressAllComments" value="true" />
     </commentGenerator>
    
     <jdbcConnection
     driverClass="com.mysql.jdbc.Driver"
     connectionURL="jdbc:mysql://localhost:3306/pinpin"
     userId="root"
     password="root">
     </jdbcConnection>
    
     <javaTypeResolver >
     <property name="forceBigDecimals" value="false" />
     </javaTypeResolver>
    
     
     <javaModelGenerator targetPackage="com.api.pinpin.bean" targetProject=".\src\main\java">
     <property name="enableSubPackages" value="true" />
     <property name="trimStrings" value="true" />
     </javaModelGenerator>
    
     
     <sqlMapGenerator targetPackage="com.api.pinpin.mapper" targetProject=".\src\main\resources">
     <property name="enableSubPackages" value="true" />
     </sqlMapGenerator>
    
     
     <javaClientGenerator type="XMLMAPPER" targetPackage="com.api.pinpin.dao" targetProject=".\src\main\java">
     <property name="enableSubPackages" value="true" />
     </javaClientGenerator>
    
     
    
     <table tableName="admin_group" domainObjectName="admin_group"></table>
     <table tableName="admin_log" domainObjectName="admin_log"></table>
     <table tableName="category" domainObjectName="category"></table>
     <table tableName="coupon" domainObjectName="coupon"></table>
     <table tableName="coupon_accept" domainObjectName="coupon_accept"></table>
     <table tableName="deliver" domainObjectName="deliver"></table>
     <table tableName="deliver_lincense" domainObjectName="deliver_lincense"></table>
     <table tableName="deliver_task" domainObjectName="deliver_task"></table>
     <table tableName="food" domainObjectName="food"></table>
     <table tableName="food_category" domainObjectName="food_category"></table>
     <table tableName="mysite" domainObjectName="mysite"></table>
     <table tableName="notice" domainObjectName="notice"></table>
     <table tableName="order" domainObjectName="order"></table>
     <table tableName="order_comment" domainObjectName="order_comment"></table>
     <table tableName="order_detail" domainObjectName="order_detail"></table>
     <table tableName="order_food" domainObjectName="order_food"></table>
     <table tableName="order_process" domainObjectName="order_process"></table>
    
     <table tableName="order_refund" domainObjectName="order_refund"></table>
     <table tableName="pay" domainObjectName="pay"></table>
     <table tableName="shop" domainObjectName="shop"></table>
     <table tableName="shop_activity" domainObjectName="shop_activity"></table>
     <table tableName="shop_collect" domainObjectName="shop_collect"></table>
     <table tableName="shop_info" domainObjectName="shop_info"></table>
     <table tableName="shop_license" domainObjectName="shop_license"></table>
    
     <table tableName="shop_log" domainObjectName="shop_log"></table>
     <table tableName="user" domainObjectName="user"></table>
     <table tableName="user_address" domainObjectName="user_address"></table>
    
    
    
    
     </context>
    
    </generatorConfiguration>
    
    对应自己创建的数据库表：

![1496987-20190919224249082-254642343.png][]

** 在pom.xml文件配置：**

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
     <modelVersion>4.0.0</modelVersion>
     <parent>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-parent</artifactId>
     <version>1.5.21.RELEASE</version>
     <relativePath/> 
     </parent>
     <groupId>com.example</groupId>
     <artifactId>demo</artifactId>
     <version>0.0.1-SNAPSHOT</version>
     <packaging>war</packaging>
     <name>demo</name>
     <description>Demo project for Spring Boot</description>
    
     <properties>
     <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
     <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
     <java.version>1.8</java.version>
     <mybatisplus.version>2.2.0</mybatisplus.version>
     <mybatisplus-spring-boot-starter.version>1.0.5</mybatisplus-spring-boot-starter.version>
     </properties>
    
     <dependencies>
     <dependency>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-web</artifactId>
     </dependency>
    
     
     <dependency>
     <groupId>org.projectlombok</groupId>
     <artifactId>lombok</artifactId>
     </dependency>
    
     
     <dependency>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-data-jpa</artifactId>
     </dependency>
    
     <dependency>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-tomcat</artifactId>
     <scope>provided</scope>
     </dependency>
     <dependency>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-devtools</artifactId>
     </dependency>
     <dependency>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-test</artifactId>
     <scope>test</scope>
     </dependency>
     
     
     <dependency>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-actuator</artifactId>
     <version>1.5.7.RELEASE</version>
     </dependency>
    
     
     <dependency>
     <groupId>com.baomidou</groupId>
     <artifactId>mybatisplus-spring-boot-starter</artifactId>
     <version>${mybatisplus-spring-boot-starter.version}</version>
     </dependency>
     <dependency>
     <groupId>com.baomidou</groupId>
     <artifactId>mybatis-plus</artifactId>
     <version>${mybatisplus.version}</version>
     </dependency>
    
     
     <dependency>
     <groupId>mysql</groupId>
     <artifactId>mysql-connector-java</artifactId>
     <scope>runtime</scope>
     </dependency>
    
     
     <dependency>
     <groupId>com.alibaba</groupId>
     <artifactId>druid</artifactId>
     <version>1.1.9</version>
     </dependency>
     
     <dependency>
     <groupId>mysql</groupId>
     <artifactId>mysql-connector-java</artifactId>
     <version>5.0.5</version>
     </dependency>
    
     
     <dependency>
     <groupId>org.mybatis.generator</groupId>
     <artifactId>mybatis-generator-core</artifactId>
     <version>1.3.5</version>
     </dependency>
     <dependency>
     <groupId>org.junit.jupiter</groupId>
     <artifactId>junit-jupiter</artifactId>
     <version>RELEASE</version>
     <scope>test</scope>
     </dependency>
    
    
     </dependencies>
    
     <build>
     <plugins>
     <plugin>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-maven-plugin</artifactId>
     </plugin>
    
     
     
     <plugin>
     <groupId>org.mybatis.generator</groupId>
     <artifactId>mybatis-generator-maven-plugin</artifactId>
     <version>1.3.2</version>
     <configuration>
     <verbose>true</verbose>
     <overwrite>true</overwrite>
     </configuration>
     </plugin>
    
     </plugins>
     </build>
    
    </project>

![1496987-20190919224525607-494089126.png][]

**编写测试类：MbgTes**

public class MbgTest { 
     public static void main(String args[]) throws Exception{ 
     List<String> warnings = new ArrayList<String>();
    
     boolean overwrite = true;
     File configFile = new File("src/MBG.xml");
     ConfigurationParser cp = new ConfigurationParser(warnings);
     Configuration config = cp.parseConfiguration(configFile);
     DefaultShellCallback callback = new DefaultShellCallback(overwrite);
     MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
     myBatisGenerator.generate(null);
    
     }

![1496987-20190919224634958-1439331376.png][]

**最后启动MbgTes类就可以生成！如图：**

![1496987-20190919225314614-242153286.png][]

转载于:https://www.cnblogs.com/studygithub5208868/p/11553147.html

[1496987-20190919223502334-1085319641.png]: /images/20230810/36b7d54d3c4d41769406f6a779c853be.png
[1496987-20190919223540477-557173569.png]: /images/20230810/22af302d514d4b2dbe0d6450dc7ad754.png
[1496987-20190919223809481-1478027211.png]: /images/20230810/54f1950d3f994a4b90ed557b9f40a55a.png
[1496987-20190919223848840-1532392343.png]: /images/20230810/300b3ca46a6242c3909ca430d6d285e6.png
[1496987-20190919223956065-1033970280.png]: /images/20230810/e024e2bc67cc4898add5ce59595909f3.png
[1496987-20190919224249082-254642343.png]: /images/20230810/fc3f58ce9b054d25aad1d8ac2ef84ef4.png
[1496987-20190919224525607-494089126.png]: /images/20230810/1c8aa7a3dfaa46c3a1da493bcbc37f30.png
[1496987-20190919224634958-1439331376.png]: /images/20230810/de714e38e484408ca8b52a0204bc554a.png
[1496987-20190919225314614-242153286.png]: /images/20230810/7a35b6b1e43d4f8b87419531c79fd6a1.png