mybatis自动生成dao,mapper，entity的插件xml

迈不过友情╰ 2023-06-27 03:28 12阅读 0赞

mybatis自动生成实体，mapper,dao的配置文件：

将文件放到该目录下：（注意：默认文件名称为：generatorConfig.xml）

![20200103095026849.png][]

文件内容：

<?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="E:\work/mysql-connector-java-5.1.47.jar"/>
    
        <context id="DB2Tables1" targetRuntime="MyBatis3">
    
            
            <plugin type="org.mybatis.generator.plugins.SerializablePlugin" />
            <commentGenerator>
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
    
            <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/shop"
                            userId="root" password="123456"/>
    
            <javaTypeResolver type="">
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
            <javaModelGenerator targetPackage="com.eva.cn.pojo" targetProject="src/main/java">
                <property name="enableSubPackages" value="true"/>
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
    
            <sqlMapGenerator targetPackage="mybatis" targetProject="src/main/resources">
                <property name="enableSuzbPackages" value="true"/>
            </sqlMapGenerator>
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.eva.cn.dao"
                                 targetProject="src/main/java">
                <property name="enableSubPackages" value="true"/>
            </javaClientGenerator>
    
            <table tableName="user" domainObjectName="User"
                   enableSelectByExample="false"
                   enableCountByExample="false"
                   enableUpdateByExample="false"
                   enableDeleteByExample="false">
                <generatedKey column="id" sqlStatement="MySql" identity="true"/>
            </table>
        </context>
    
    </generatorConfiguration>

**xml文件说明：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NvV2hhdFdvcmxk_size_16_color_FFFFFF_t_70][]

**标注1 是需要下载一个mysql连接到本地的文件夹内，location指向该jar包。**

**标注2是你需要生成表所在数据库的用户名和密码**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NvV2hhdFdvcmxk_size_16_color_FFFFFF_t_70 1][]

**标注 3 4 5生成的文件存放的目录**

**标注6是表名以及生成的实体名。**

**然后再pom文件中添加自动生成的插件**

<plugin>
              <groupId>org.mybatis.generator</groupId>
              <artifactId>mybatis-generator-maven-plugin</artifactId>
              <version>1.3.2</version>
         </plugin>

添加之后，idea编辑器会自动识别，显示该插件，使用的时候直接点击就行。（如果没有识别，请去掉插件的父类标签PluginManagement）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NvV2hhdFdvcmxk_size_16_color_FFFFFF_t_70 2][]

[20200103095026849.png]: https://img-blog.csdnimg.cn/20200103095026849.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NvV2hhdFdvcmxk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200102181829243.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NvV2hhdFdvcmxk,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NvV2hhdFdvcmxk_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200102182107691.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NvV2hhdFdvcmxk,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NvV2hhdFdvcmxk_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200103090354997.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NvV2hhdFdvcmxk,size_16,color_FFFFFF,t_70