springboot结合mybatis-generator逆向工程

àì夳堔傛蜴生んèń 2023-05-22 06:33 8阅读 0赞

今天搞毕设的时候发现有大量的增删改查着实让人头疼，
    	想起在深圳实习的时候项目中可以自动生成sql语句，这次又去找了下。
    	
    	发现了两种解决方案：
    	1. mybatis-generator插件
    	2. MyBatisCodeHelper-Pro 插件
    	两者都可以根据数据库表自动生成pojo对象，sql语句和dao层
    	区别是前者免费功能简单点，后者付费功能更全。
    	所以我选择前者...

不过这里还是贴一下MyBatisCodeHelper-Pro教程地址，等上班后支持一波

##### https://gejun123456.github.io/MyBatisCodeHelper-Pro/\#/README #####

1.  maven配置mybatis-generator 插件
2.  配置mybatis-generator 配置文件设置逆向工程细节
3.  运行插件即可。

一步一步来：maven配置generator插件

<dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.3.4</version>
            </dependency>
    <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>
                        <configurationFile>src/main/resources/generator/generatorConfig.xml</configurationFile>
                    </configuration>
                    <dependencies>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>8.0.13</version>
                    </dependency>
                    </dependencies>
                </plugin>
            </plugins>
        </build>

configurationFile标签填写的是generator配置文件地址  
还得在插件里添加mysql-connector-java依赖  
注意这里还会有版本问题，我就遇到了：

Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2:generate (default-cli) on project restful-demo: Execution default-cli of goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2:generate failed: Exception getting JDBC Driver

**原因：**  
mybatis-generator-maven-plugin版本为1.3.2  
mysql-connector-java版本为5.1.41  
两个版本不兼容，将mysql-connector-java版本修改为8.0.13等合适版本即可

1.  配置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>
    
    
        <context id="DB2Tables" targetRuntime="MyBatis3">
            
            <plugin type="org.mybatis.generator.plugins.SerializablePlugin" />
            
            <plugin type="org.mybatis.generator.plugins.ToStringPlugin" />
            
            <commentGenerator>
                <property name="suppressDate" value="true"/>
                
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
                            connectionURL="jdbc:mysql://localhost:3306/scm"
                            userId="root"
                            password="123456">
            </jdbcConnection>
            
            <javaTypeResolver >
                
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
            
            <javaModelGenerator targetPackage="com.example.restfuldemo.entities" targetProject="src/main/java">
                
                <property name="enableSubPackages" value="true" />
                
                <property name="constructorBased" value="false"/>
                
                <property name="immutable" value="false"/>
                
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="mybatis.mapper" targetProject="src/main/resources">
                <property name="enableSubPackages" value="true"/>
            </sqlMapGenerator>
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.example.restfuldemo.dao" targetProject="src/main/java">
                <property name="enableSubPackages" value="true"/>
            </javaClientGenerator>
    
            <table schema="general" tableName="order" domainObjectName="order"
                   enableCountByExample="false" enableDeleteByExample="false"
                   enableSelectByExample="false" enableUpdateByExample="false">
            </table>
            <table schema="general" tableName="product" domainObjectName="product"
                   enableCountByExample="false" enableDeleteByExample="false"
                   enableSelectByExample="false" enableUpdateByExample="false">
            </table>
            <table schema="general" tableName="supplier" domainObjectName="supplier"
                   enableCountByExample="false" enableDeleteByExample="false"
                   enableSelectByExample="false" enableUpdateByExample="false">
            </table>
        </context>
    </generatorConfiguration>