mybatis逆向工程操作

傷城~ 2022-06-15 08:08 154阅读 0赞

mybaits需要程序员自己编写sql语句，mybatis官方提供逆向工程 可以针对单表自动生成mybatis执行所需要的代码（mapper.java,mapper.xml、po..）  
官方文档中提供的运行逆向工程的几种方法

Running MyBatis Generator

MyBatis Generator (MBG) can be run in the following ways:

(1)From the command prompt with an XML configuration

(2)As an Ant task with an XML configuration

(3)As a Maven Plugin

(4)From another Java program with an XML configuration

(5)From another Java program with a Java based configuration

(6)还可以通过eclipse的插件生成代码

建议使用java程序方式(From another Java program with an XML configuration)，不依赖开发工具。

## 步骤 ##

创建一个Java工程，目录结构如下，添加相应jar，没有的博客末尾下载去。  
  
![这里写图片描述][SouthEast]  
配置文件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>
        <context id="testTables" targetRuntime="MyBatis3">
            <commentGenerator>
                
                <property name="suppressAllComments" value="true" />
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/mybatis" userId="root" password="123456">
            </jdbcConnection>
            
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
            
            <javaModelGenerator targetPackage="com.hl.ld.po" targetProject=".\src">
                
                <property name="enableSubPackages" value="false" />
                
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="com.hl.ld.mapper" targetProject=".\src">
                
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.hl.ld.mapper" targetProject=".\src">
                
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
            
            <table tableName="items"></table>
            <table tableName="orders"></table>
            <table tableName="orderdetail"></table>
            <table tableName="user"></table>
            
            
        </context>
    </generatorConfiguration>

执行类GeneratorSqlmap.java

这里写代码片package mybatis_generator;
    
    import java.io.File;
    import java.util.ArrayList;
    import java.util.List;
    
    import org.mybatis.generator.api.MyBatisGenerator;
    import org.mybatis.generator.config.Configuration;
    import org.mybatis.generator.config.xml.ConfigurationParser;
    import org.mybatis.generator.internal.DefaultShellCallback;
    
    public class GeneratorSqlmap { 
        public void generator() throws Exception {
            List<String> warnings = new ArrayList<String>();
            boolean overwrite = true;
            // 加载配置文件
            File configFile = new File("generatorConfig.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);
        }
    
        public static void main(String[] args) throws Exception {
            try {
                GeneratorSqlmap generatorSqlmap = new GeneratorSqlmap();
                generatorSqlmap.generator();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }

运行逆向程序  
  
![这里写图片描述][SouthEast 1]  
  
然后就可以把生成的代码拷贝到自己的项目中去。  
  
源码：[http://download.csdn.net/detail/leisure\_life/9854525][http_download.csdn.net_detail_leisure_life_9854525]

[SouthEast]: /images/20220615/420307009b2e48d5807752979b4ce096.png
[SouthEast 1]: /images/20220615/ddd07186a34641ec99ac7d9916a9d87a.png
[http_download.csdn.net_detail_leisure_life_9854525]: http://download.csdn.net/detail/leisure_life/9854525