2020 (详细)在idea Maven中使用逆向工程Mybatis Generator生成代码

不念不忘少年蓝@ 2022-12-18 06:54 126阅读 0赞

### 在idea Maven中使用逆向工程Mybatis Generator生成代码 ###

**1、在你的idea中新建个Maven项目或使用已有的ssm项目**

**重**：一定要在java文件夹下建好包名  
![在这里插入图片描述][20201026000850305.png_pic_center]  
**建好这3个**

**2、pom.xml文件**

<dependency>
          <groupId>org.mybatis.generator</groupId>
          <artifactId>mybatis-generator-core</artifactId>
          <version>1.3.5</version>
        </dependency>
        <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis</artifactId>
          <version>${ mybatis.version}</version>
        </dependency>
        
        <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis-spring</artifactId>
          <version>2.0.1</version>
        </dependency>
    
    <build>
    		<plugins>
    			<plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <configuration>
                  <configurationFile>${ basedir}/src/main/resources/generatior-config.xml</configurationFile>
                  <verbose>true</verbose>
                  <overwrite>true</overwrite>
                </configuration>
                </plugin>
    		</plugins>
    </build>

**注意：**  
![在这里插入图片描述][20201025235609477.png_pic_center]  
**这里红框对应下面步骤你建的位置**

**3、建一个generatior-config.xml文件在resources下**  
![在这里插入图片描述][20201025235202123.png_pic_center]  
**代码**

<?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:/apache-maven-3.6.3/repository/mysql/mysql-connector-java/5.1.6/mysql-connector-java-5.1.6.jar"/>
    	
    	<context id="testTables" targetRuntime="MyBatis3">
    		<commentGenerator>
    			<property name="suppressDate" value="true" />
    			
    			<property name="suppressAllComments" value="true" />
    		</commentGenerator>
    		
    		<jdbcConnection driverClass="com.mysql.jdbc.Driver"
    			connectionURL="jdbc:mysql://localhost/networkbusinessdb" userId="root" password="123456">
    		</jdbcConnection>
    		
    		
    		<javaTypeResolver>
    			<property name="forceBigDecimals" value="false" />
    		</javaTypeResolver>
    		
    		<javaModelGenerator targetPackage="com.lin.sys.entity"
    			targetProject="src/main/java">
    			<property name="enableSubPackages" value="true" />
    			 
    			<property name="trimStrings" value="true" />
    		</javaModelGenerator>
    		
    		<sqlMapGenerator targetPackage="mappers.sys"
    			targetProject="src/main/resources">
    			
    			<property name="enableSubPackages" value="true" />
    		</sqlMapGenerator>
    		
    		<javaClientGenerator type="XMLMAPPER"
    			targetPackage="com.lin.sys.dao" targetProject="src/main/java">
    			
    			<property name="enableSubPackages" value="true" />
    		</javaClientGenerator>
    		
    		<table tableName="sys_user" domainObjectName="User"
    			enableCountByExample="false" enableUpdateByExample="false"
    			enableDeleteByExample="false" enableSelectByExample="false"
    			selectByExampleQueryId="false">
            </table>
    	</context>
    </generatorConfiguration>

**注意：里面要对应你的文件位置，适当修改**

**4、**![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDEyNDU3Nw_size_16_color_FFFFFF_t_70_pic_center]  
**5、**  
![在这里插入图片描述][20201026000047757.png_pic_center]  
**6、**![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDEyNDU3Nw_size_16_color_FFFFFF_t_70_pic_center 1]  
**写上**

mybatis-generator:generate -e

**7、两种方式都可运行**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDEyNDU3Nw_size_16_color_FFFFFF_t_70_pic_center 2]  
**8、成功运行，刷新点开文件查看**

推荐  
[Java使用工具类Md5加密、及Spring自带DigestUtils在SSM项目登录模块判断、转换][Java_Md5_Spring_DigestUtils_SSM]

[J2SE Java基础面试题（一）][J2SE Java]

[Oracle、mysql经典例题二(如何把学生成绩竖着排列)][Oracle_mysql]

[20201026000850305.png_pic_center]: /images/20221122/59b0987e0d894b6f8163e2469a7f0319.png
[20201025235609477.png_pic_center]: /images/20221122/06dfecb49b004875a92190cd6c7f51ae.png
[20201025235202123.png_pic_center]: /images/20221122/6528dc93c70d445a8b79438cb6d842f3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDEyNDU3Nw_size_16_color_FFFFFF_t_70_pic_center]: /images/20221122/d62e5566ca1b4bd5ab407f117b28ffa2.png
[20201026000047757.png_pic_center]: /images/20221122/3058e6dd6843419daf809fab4e89dbbe.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDEyNDU3Nw_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221122/d9db381ad1284245b90dfe5702598348.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDEyNDU3Nw_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20221122/1f45fc3a5b204b159f06e3106a15ef16.png
[Java_Md5_Spring_DigestUtils_SSM]: https://blog.csdn.net/weixin_44124577/article/details/109270244
[J2SE Java]: https://blog.csdn.net/weixin_44124577/article/details/109252046
[Oracle_mysql]: https://blog.csdn.net/weixin_44124577/article/details/109256764