java代码mybatis代码生成器插件

￡神魔★判官ぃ 2023-05-31 10:16 39阅读 0赞

# 引言 #

mybatis-generator-maven-plugin、MyBatisPlus 对比。

1、mybatis-generator-maven-plugin插件深度更深，对mybatis提供的操作更仔细，不仅有简单的增删改查，还可以动态的使用where语句来操作。

2、MyBatisPlus插件主要提供了一些模板来操作，主要的模板有：velocity 模板引擎, 默认、freemarker 模板引擎、beetl 模板引擎等。生成一些常用的基于sql自动生成domain、controller、service、dao、mapper，只是框架模型，具体操作很少。

# **mybatis-generator-maven-plugin** #

官方文档：[http://www.mybatis.org/generator/index.html][http_www.mybatis.org_generator_index.html]

**1、pom.xml中要引入的jar包**

<dependency>
            <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.1</version>
            </dependency>    
    
            <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.3.7</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.7</version>
                    <configuration>
                        <configurationFile>${basedir}/src/main/resources/generatorConfig.xml</configurationFile>
                        
                        <overwrite>true</overwrite>
                        
                        <verbose>true</verbose>
                    </configuration>
                    <dependencies>
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <version>5.1.6</version>
                        </dependency>
                        
                        <dependency>
                            <groupId>tk.mybatis</groupId>
                            <artifactId>mapper</artifactId>
                            <version>4.1.5</version>
                        </dependency>
                    </dependencies>
                </plugin>
    
            </plugins>
        </build>

**2.配置默认文件 [generatorConfig.xml][http_www.mybatis.org_generator_index.html] 此文件放置在 src/main/resources 下**

<?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>
        
       
    
        
        
    
        
        <classPathEntry  location="C:\Users\Administrator\.m2\repository\mysql\mysql-connector-java\5.1.46\mysql-connector-java-5.1.46.jar"/>
        <context id="DB2Tables"  targetRuntime="MyBatis3">
    
    
    
            
            <property name="autoDelimitKeywords" value="false"/>
            
            <property name="javaFileEncoding" value="UTF-8"/>
            
            <property name="javaFormatter" value="org.mybatis.generator.api.dom.DefaultJavaFormatter"/>
            
            <property name="xmlFormatter" value="org.mybatis.generator.api.dom.DefaultXmlFormatter"/>
    
           
    
            
            <plugin type="org.mybatis.generator.plugins.SerializablePlugin"/>
            
            <plugin type="org.mybatis.generator.plugins.EqualsHashCodePlugin"/>
            
            <plugin type="org.mybatis.generator.plugins.ToStringPlugin"/>
            
            <plugin type="org.mybatis.generator.plugins.MapperAnnotationPlugin"/>
            
            <plugin type="org.mybatis.generator.plugins.RowBoundsPlugin"/>
    
    
           
           
           
           
            
            
            
            
            
            
    
    
            <plugin type="org.mybatis.generator.plugins.RenameExampleClassPlugin">
                <property name="searchString" value="Example$" />
                <property name="replaceString" value="Criteria" />
            </plugin>
    
            <commentGenerator>
                
                <property name="addRemarkComments" value="true"/>
                
                <property name="suppressDate" value="true"/>
                
                <property name="suppressAllComments" value="false"/>
            </commentGenerator>
    
            
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://192.168.0.18/meter_basis" userId="root" password="root"></jdbcConnection>
           
    
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="com.kmnfsw.generator.domain" targetProject="src/main/java">
            
                <property name="enableSubPackages" value="true"/>
                
                <property name="trimStrings" value="true"/>
                
                <property name="constructorBased" value="false"/>
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="generator/mapper" targetProject="src/main/resources">
                <property name="enableSubPackages" value="true"/>
            </sqlMapGenerator>
    
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.kmnfsw.generator.dao" targetProject="src/main/java">
                <property name="enableSubPackages" value="true"/>
            </javaClientGenerator>
    
            
            
            <table tableName="channel_early_warning_type" domainObjectName="ChannelEarlyWarningtType" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>
            <table tableName="channel_info" domainObjectName="ChannelInfo" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>
            <table tableName="channel_link_notice" domainObjectName="ChannelLinkNotice" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>
            <table tableName="channel_range_early_warning" domainObjectName="ChannelRangeEarlyWarning" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>
            <table tableName="channel_switch_early_warning" domainObjectName="ChannelSwitchEarlyWarning" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>
            <table tableName="channel_value_early_warning" domainObjectName="ChannelValueEarlyWarning" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>
            <table tableName="device_info" domainObjectName="DeviceInfo" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>
            <table tableName="equipment_info" domainObjectName="EquipmentInfo" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>
            <table tableName="group_link_notice" domainObjectName="GroupLinkNotice" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>
            <table tableName="inform_person_group_info" domainObjectName="InformPersonGroupInfo" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>
            <table tableName="meter_info" domainObjectName="MeterInfo" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>
            <table tableName="tag_group_info" domainObjectName="TagGroupInfo" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>
        </context>
    </generatorConfiguration>

**4、在mevn中直接执行即可**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MjI3ODk2_size_16_color_FFFFFF_t_70][]

# **MyBatisPlus ** #

这个插件的使用直接看这些篇博客即可，已测试，可以生成。

[https://www.cnblogs.com/douJiangYouTiao888/p/9266727.html][https_www.cnblogs.com_douJiangYouTiao888_p_9266727.html]

[https://blog.csdn.net/Neal\_/article/details/86030791][https_blog.csdn.net_Neal_article_details_86030791]

官方文档：[https://mp.baomidou.com/config/generator-config.html][https_mp.baomidou.com_config_generator-config.html]

[http_www.mybatis.org_generator_index.html]: http://www.mybatis.org/generator/index.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MjI3ODk2_size_16_color_FFFFFF_t_70]: /images/20230531/ce70067398f14165aa2347278a2a80b6.png
[https_www.cnblogs.com_douJiangYouTiao888_p_9266727.html]: https://www.cnblogs.com/douJiangYouTiao888/p/9266727.html
[https_blog.csdn.net_Neal_article_details_86030791]: https://blog.csdn.net/Neal_/article/details/86030791
[https_mp.baomidou.com_config_generator-config.html]: https://mp.baomidou.com/config/generator-config.html