springboot开发笔记(7.mybatis-generator自动生成entiy、dao、mapper)

太过爱你忘了你带给我的痛 2022-05-28 00:55 151阅读 0赞

### 1.前言 ###

有新的表之后，使用mybatis-generator工具生成entity、dao和mapper.xml还是挺方便的。

### 2.代码 ###

（1）mysql创建xm\_product库和表product（库和表与下面xml中配置的一样就好）  
（2）pom.xml添加内容,最下边添加plugin

<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>
                    <executions>
                        <execution>
                            <id>Generate MyBatis Artifacts</id>
                            <goals>
                                <goal>generate</goal>
                            </goals>
                        </execution>
                    </executions>
                    <dependencies>
                        <dependency>
                            <groupId>org.mybatis.generator</groupId>
                            <artifactId>mybatis-generator-core</artifactId>
                            <version>1.3.2</version>
                        </dependency>
                    </dependencies>
                </plugin>
            </plugins>
        </build>

（3）添加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>
    
      
      <classPathEntry location="F:\repository\mysql\mysql-connector-java\5.1.44\mysql-connector-java-5.1.44.jar"/>
    
      <context id="context" targetRuntime="MyBatis3">
        <commentGenerator>
          <property name="suppressAllComments" value="true"/>
          <property name="suppressDate" value="true"/>
        </commentGenerator>
    
        
        <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://127.0.0.1:3306/xm_product?useUnicode=true&characterEncoding=utf-8" userId="root" password="root"/>
    
        <javaTypeResolver>
          <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>
    
        
        <javaModelGenerator targetPackage="xm.service.product.entity" targetProject="src/main/java">
          <property name="enableSubPackages" value="false"/>
          <property name="trimStrings" value="true"/>
        </javaModelGenerator>
    
        
        <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources">
          <property name="enableSubPackages" value="false"/>
        </sqlMapGenerator>
    
        
        
        <javaClientGenerator targetPackage="xm.service.product.persistence.dao" targetProject="src/main/java" type="XMLMAPPER">
          <property name="enableSubPackages" value="false"/>
        </javaClientGenerator>
    
        
        <table tableName="product" enableCountByExample="false" enableDeleteByExample="false" enableSelectByExample="false" enableUpdateByExample="false"/>
      </context>
    </generatorConfiguration>

（4）运行maven生成文件，idea右侧窗口，如下图，点击一下就好。  
![这里写图片描述][70]

[70]: /images/20220528/b50a434336144cd4bb7f344db4ea7d87.png