使用mybatis-generator-core自动生成代码

怼烎@ 2023-05-22 11:27 22阅读 0赞

首先  要使用这东西 自动生成mapper  dao  entity  在pom.xml中加入如下代码

>     <plugin>
>        <groupId>org.mybatis.generator</groupId>
>        <artifactId>mybatis-generator-maven-plugin</artifactId>
>        <version>1.3.2</version>
>        <configuration>
>           
>           <configurationFile>${basedir}/src/main/resources/generator/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>

然后idea右边的这个如果有 如下图标记处  说明引入成功

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTYzNDg4NQ_size_16_color_FFFFFF_t_70][]

**第一个问题来了 如果没有  看下仓库是不是这个包没下下来  把那个lastupdated文件删了  就能重新下了**

然后在resources下新建文件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="G:\myRepository\mysql\mysql-connector-java\5.1.30\mysql-connector-java-5.1.30.jar"/>
>         <context id="DB2Tables"  targetRuntime="MyBatis3">
>             <commentGenerator>
>                 <property name="suppressDate" value="true"/>
>                 
>                 <property name="suppressAllComments" value="true"/>
>             </commentGenerator>
>             
>             <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://172.18.193.185:3306/sonar" userId="sonar" password="sonar">
>             </jdbcConnection>
>             <javaTypeResolver>
>                 <property name="forceBigDecimals" value="false"/>
>             </javaTypeResolver>
>             
>             <javaModelGenerator targetPackage="com.sitech.smartcity.entity" targetProject="src/main/java">
>                 <property name="enableSubPackages" value="true"/>
>                 <property name="trimStrings" value="true"/>
>             </javaModelGenerator>
>             
>             <sqlMapGenerator targetPackage="mybatis/mysql" targetProject="src/main/resources">
>                 <property name="enableSubPackages" value="true"/>
>             </sqlMapGenerator>
>             
>             <javaClientGenerator type="XMLMAPPER" targetPackage="com.sitech.smartcity.mybatis" targetProject="src/main/java">
>                 <property name="enableSubPackages" value="true"/>
>             </javaClientGenerator>
>     
>             
>             <table tableName="tb_rc_tableexpert_info"></table>
>     
>         </context>
>     </generatorConfiguration>

把上面标红的地方改成自己的路径

然后点击下图所示的这个按键即可生成文件

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTYzNDg4NQ_size_16_color_FFFFFF_t_70 1][]

**第二个问题来了 这样子点击生成后的文件会有exmpale之类的文件  如果不想要 修改generatorConfig.xml中的表属性为**

**第三个问题又来了  有的表中字段是xx\_xx这种的  默认驼峰命名 即xxXX  如果想使用原字段 要新增属性 **

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTYzNDg4NQ_size_16_color_FFFFFF_t_70]: /images/20230521/c57368c1b06b46bd8babbc0ac3a92bc9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTYzNDg4NQ_size_16_color_FFFFFF_t_70 1]: /images/20230521/709b2235988a4dbba7c8c83102a1288f.png