idea中mybatis自动生成工具及用法

た入场券 2022-05-15 09:44 659阅读 0赞

*   *   *  [在maven工程中的resource中创建generatorConfigxml][maven_resource_generatorConfigxml]
         *  [配置generatorConfigxml的][generatorConfigxml]
     *  [配置pomxml][pomxml]
     *  [生成对象的两种方式][Link 1]
        
         *  [方式一使用idea的maven插件直接快速生成][idea_maven]
         *  [方式二在Intellij IDEA添加一个Run运行选项使用maven运行mybatis-generator-maven-plugin插件 ][Intellij IDEA_Run_maven_mybatis-generator-maven-plugin_]
            
             *  [Step1选择配置edit configuration][Step1_edit configuration]
             *  [Step2创建maven运行项][Step2_maven]
             *  [Step3配置命令 mybatis-generatorgenerate -e][Step3_ mybatis-generatorgenerate -e]
             *  [Step4运行][Step4]

### 1.在maven工程中的resource中创建generatorConfig.xml ###

![这里写图片描述][20160529230948104]

### 配置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="D:/mysql-connector-java-5.1.20-bin.jar" />
       <context id="testTables" targetRuntime="MyBatis3">
          <commentGenerator>
             
             <property name="suppressAllComments" value="true" />
          </commentGenerator>
          
          <jdbcConnection driverClass="com.mysql.jdbc.Driver"
             connectionURL="jdbc:mysql://localhost:3306/ecps" userId="root"
             password="root">
          </jdbcConnection>
          
          <javaTypeResolver>
             <property name="forceBigDecimals" value="false" />
          </javaTypeResolver>
    
          
          <javaModelGenerator targetPackage="com.ecps.seckill.pojo"
             targetProject="src/main/java">
             
             <property name="enableSubPackages" value="false" />
             
             <property name="trimStrings" value="true" />
          </javaModelGenerator>
            
          <sqlMapGenerator targetPackage="com.ecps.seckill.mapper"
             targetProject="src/main/java">
             
             <property name="enableSubPackages" value="false" />
          </sqlMapGenerator>
          
          <javaClientGenerator type="XMLMAPPER"
             targetPackage="com.ecps.seckill.mapper"
             targetProject="src/main/java">
             
             <property name="enableSubPackages" value="false" />
          </javaClientGenerator>
          
          <table schema="" tableName="seckill"></table>
          <table schema="" tableName="success_killed"></table>   
       </context>
    </generatorConfiguration>

## 配置pom.xml ##

在pom.xml中位置mybatis-generator的插件

<build>
        <plugins>
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <configuration>
                     <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
                    <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>

## 生成对象的两种方式 ##

### 方式一：使用idea的maven插件直接快速生成 ###

在完成以上两步之后。就会在idea中看到：直接点击mybatis-generator:generate就可生成。  
![这里写图片描述][20160529231256888]

### 方式二：在Intellij IDEA添加一个“Run运行”选项，使用maven运行mybatis-generator-maven-plugin插件 ： ###

Step1：选择配置edit configuration

![这里写图片描述][20160529231421438]

Step2:创建maven运行项

![这里写图片描述][20160529231456311]

Step3:配置命令 mybatis-generator:generate -e

![这里写图片描述][20160529231527439]

Step4:运行

![这里写图片描述][20160529231601096]  
做完以上几步。就可以看到运行的选项。点击运行即可。

转载自：[https://blog.csdn.net/liudongdong0909/article/details/51534735][https_blog.csdn.net_liudongdong0909_article_details_51534735]

[maven_resource_generatorConfigxml]: https://blog.csdn.net/liudongdong0909/article/details/51534735#1%E5%9C%A8maven%E5%B7%A5%E7%A8%8B%E4%B8%AD%E7%9A%84resource%E4%B8%AD%E5%88%9B%E5%BB%BAgeneratorconfigxml
[generatorConfigxml]: https://blog.csdn.net/liudongdong0909/article/details/51534735#%E9%85%8D%E7%BD%AEgeneratorconfigxml%E7%9A%84
[pomxml]: https://blog.csdn.net/liudongdong0909/article/details/51534735#%E9%85%8D%E7%BD%AEpomxml
[Link 1]: https://blog.csdn.net/liudongdong0909/article/details/51534735#%E7%94%9F%E6%88%90%E5%AF%B9%E8%B1%A1%E7%9A%84%E4%B8%A4%E7%A7%8D%E6%96%B9%E5%BC%8F
[idea_maven]: https://blog.csdn.net/liudongdong0909/article/details/51534735#%E6%96%B9%E5%BC%8F%E4%B8%80%E4%BD%BF%E7%94%A8idea%E7%9A%84maven%E6%8F%92%E4%BB%B6%E7%9B%B4%E6%8E%A5%E5%BF%AB%E9%80%9F%E7%94%9F%E6%88%90
[Intellij IDEA_Run_maven_mybatis-generator-maven-plugin_]: https://blog.csdn.net/liudongdong0909/article/details/51534735#%E6%96%B9%E5%BC%8F%E4%BA%8C%E5%9C%A8intellij-idea%E6%B7%BB%E5%8A%A0%E4%B8%80%E4%B8%AArun%E8%BF%90%E8%A1%8C%E9%80%89%E9%A1%B9%E4%BD%BF%E7%94%A8maven%E8%BF%90%E8%A1%8Cmybatis-generator-maven-plugin%E6%8F%92%E4%BB%B6
[Step1_edit configuration]: https://blog.csdn.net/liudongdong0909/article/details/51534735#step1%E9%80%89%E6%8B%A9%E9%85%8D%E7%BD%AEedit-configuration
[Step2_maven]: https://blog.csdn.net/liudongdong0909/article/details/51534735#step2%E5%88%9B%E5%BB%BAmaven%E8%BF%90%E8%A1%8C%E9%A1%B9
[Step3_ mybatis-generatorgenerate -e]: https://blog.csdn.net/liudongdong0909/article/details/51534735#step3%E9%85%8D%E7%BD%AE%E5%91%BD%E4%BB%A4-mybatis-generatorgenerate-e
[Step4]: https://blog.csdn.net/liudongdong0909/article/details/51534735#step4%E8%BF%90%E8%A1%8C
[20160529230948104]: /images/20220515/21893bf66b1b4fe88bc00f0dbc188567.png
[20160529231256888]: /images/20220515/5dffe7e4091445238d4f0fb7fbc406ca.png
[20160529231421438]: /images/20220515/4c7a7ca6855847deab7840ebd0245a4f.png
[20160529231456311]: /images/20220515/ccb60174fc0548ffab424efae4436eb9.png
[20160529231527439]: /images/20220515/65e7afa9b8be473cb005c737751bb4f7.png
[20160529231601096]: /images/20220515/205f5d71c14441cfb025433a5f4581b1.png
[https_blog.csdn.net_liudongdong0909_article_details_51534735]: https://blog.csdn.net/liudongdong0909/article/details/51534735