maven管理下mybatis逆向生成文件

逃离我推掉我的手 2022-11-04 08:50 126阅读 0赞

mybatis generators 是用于逆向生成文件的，适用于数据库较大，而我们需要编写很多的实体类与mapper接口以及xml文件的情况  
博主的项目中使用了maven管理，而生成逆向工程则需要相应的jar包  
[mybatis generator 文档][mybatis generator]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70_pic_center]  
我们找到maven的管理网站搜索相应的jar包引入写法  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70]  
接下来，我们需要在创建好数据库后，根据数据库生成相应的bean mapper接口  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 1]  
**msg.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>
      
    
      <context id="DB2Tables" targetRuntime="MyBatis3">
      
      <commentGenerator>
      <property name="suppressAllComments" value="true" />
    </commentGenerator>
      
        <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/blog" userId="root" password="px980305">
        </jdbcConnection>
    
        <javaTypeResolver >
          <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>
    
        <javaModelGenerator targetPackage="com.ssm.beans" targetProject=".\src\main\java">
          <property name="enableSubPackages" value="true" />
          <property name="trimStrings" value="true" />
        </javaModelGenerator>
    
        <sqlMapGenerator targetPackage="mapper" targetProject=".\src\main\resources">
          <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
    
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.ssm.dao" targetProject=".\src\main\java">
          <property name="enableSubPackages" value="true" />
        </javaClientGenerator>
    
        
        <table tableName="user" domainObjectName="USer"></table>
    	<table tableName="dept" domainObjectName="Department"></table>
      </context>
    </generatorConfiguration>

mybatis generator的配置文件即msg.xml  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 2]  
而如何生成调用该方法呢使用Java方法即可  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 3]

package com.ssm.test;
    
    import java.io.File;
    import java.io.IOException;
    import java.util.*;
    
    import org.mybatis.generator.api.MyBatisGenerator;
    import org.mybatis.generator.config.Configuration;
    import org.mybatis.generator.config.xml.ConfigurationParser;
    import org.mybatis.generator.exception.XMLParserException;
    import org.mybatis.generator.internal.DefaultShellCallback;
    
    public class MybatisGenerator { 
    
    	public static void main(String[] args) throws Exception{ 
    		// TODO Auto-generated method stub
    		   List<String> warnings = new ArrayList<String>();
    		   boolean overwrite = true;
    		   File configFile = new File("msg.xml");
    		   ConfigurationParser cp = new ConfigurationParser(warnings);
    		   Configuration config = cp.parseConfiguration(configFile);
    		   DefaultShellCallback callback = new DefaultShellCallback(overwrite);
    		   MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
    		   myBatisGenerator.generate(null);
    	}
    
    }

运行就可以了，这时候发现项目中相关的实体类，mapper接口以及xml文件就生成在相应的位置了。  
我们看一下他帮我们自动生成的mapper.xml文件  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 4]

![在这里插入图片描述][20210302154618828.png_pic_center]

以上便是实现mybatis generator生成逆向工程的过程了，码字不易，给个赞呗！

[mybatis generator]: http://mybatis.org/generator/quickstart.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70_pic_center]: /images/20221023/9940868d8c4c4f64b957ed0f26f16606.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70]: /images/20221023/a441466efab14b6abb440cc8a97f4bd5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 1]: /images/20221023/3113092c8f6f4a97bd64ed53afac1835.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 2]: /images/20221023/ce7ee51cff5a48708a8486b9a8a4fdbe.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 3]: /images/20221023/0d165c63d9784951b4efdfc94601ec2a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 4]: /images/20221023/51b5a8befccd410e8be0f513b6c94538.png
[20210302154618828.png_pic_center]: /images/20221023/01d9421738b94c7781abd6325fa3e2ac.png