Mybatis Generator 反向生成工具（详解）

╰半夏微凉° 2022-03-06 14:58 576阅读 0赞

先看一下结构目录（这里就只看我们能用到的）：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NTM3NTQ2_size_16_color_FFFFFF_t_70][]

GeneratorMain：

public class GeneratorMain {
    	
    	// 请直接修改以下代码调用不同的方法以执行相关生成任务.
    	public static void main(String[] args) throws Exception {
    		GeneratorFacade g = new GeneratorFacade();
    		// g.printAllTableNames(); //打印数据库中的表名称
    		// g.clean(); //删除生成器的输出目录
    		// 系统模块 sys
    		// g.generateByTable("CFG_PLATFORM_SETTING"); 
    		// 通过数据库表生成文件,注意: oracle
    		// 需要指定schema及注意表名的大小写.
    		String addTable[] = { 
    				"data_class","data_entry"
    		};
    		for (String tableName : addTable) {
    			System.out.println("表名：" + tableName);
    			g.generateByTable(tableName);
    		}
    		// 打开文件夹
    		Runtime.getRuntime().exec(//C:\generator
    				"cmd.exe /c start c:\\generator");
    	}
    }

generator.properties：

# The package name
    basepackage=com.cs
    
    namespace=pages
    
    hibernate_id_generator=increment
    
    # The location where the file is generated
    outRoot=c:/generator
    
    # java type mapping
    java_typemapping.java.sql.Date=java.sql.Timestamp
    java_typemapping.java.util.Date=java.sql.Timestamp
    java_typemapping.java.math.BigDecimal=Long
    java_typemapping.java.lang.Byte=Integer
    java_typemapping.java.lang.Short=Integer
    
    # Database account
    jdbc.username=root
    # Database password
    jdbc.password=123456
    
    # only for <<Oracle>> jdbc.schema is required,jdbc.catalog is optional
    jdbc.schema=
    jdbc.catalog=
    
    # <<MySql>>
    #jdbc.driver=oracle.jdbc.driver.OracleDriver
    #jdbc.url=jdbc:oracle:thin:@192.168.0.1:1521:orcl
    
    jdbc.driver=com.mysql.jdbc.Driver
    # Database connection address
    jdbc.url=jdbc:mysql://localhost:3307/xxx?characterEncoding=utf-8
    
    
    #jdbc.driver=com.mysql.jdbc.Driver
    #jdbc.url=jdbc:mysql://localhost:3306/xxx
    
    
    # <<SQLServer2000>>
    #jdbc.url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=[database]
    #jdbc.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
    
    # <<SQLServer2005>>
    #jdbc.url=jdbc:sqlserver://localhost:1433;DatabaseName=[database]
    #jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
    
    # <<JTDs for sqlserver>>
    #jdbc.driver=net.sourceforge.jtds.jdbc.Driver
    #jdbc.url=jdbc:jtds:sqlserver://localhost:1433/[database];tds=8.0;lastupdatecount=true
    
    # <<Oracle>>
    #jdbc.url=jdbc:oracle:thin:@192.168.0.1:1521:orcl
    #jdbc.driver=oracle.jdbc.driver.OracleDriver
    
    # <<PostgreSql>>
    #jdbc.driver=org.postgresql.Driver
    #jdbc.url=jdbc:postgresql://localhost/[database]
    
    # <<Sybase>>
    #jdbc.driver=com.sybase.jdbc.SybDriver
    #jdbc.url=jdbc:sybase:Tds:localhost:5007/[database]
    
    # <<DB2>>
    #jdbc.driver=com.ibm.db2.jdbc.app.DB2Driver
    #jdbc.url=jdbc:db2://localhost:5000/[database]
    
    # <<HsqlDB>>
    #jdbc.url=jdbc:hsqldb:mem:generatorDB
    #jdbc.driver=org.hsqldb.jdbcDriver
    
    # <<Derby>>
    #jdbc.url=jdbc:derby://localhost/databaseName
    #jdbc.driver=org.apache.derby.jdbc.ClientDriver

工具类地址：[https://download.csdn.net/download/qq\_36537546/11044649][https_download.csdn.net_download_qq_36537546_11044649]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NTM3NTQ2_size_16_color_FFFFFF_t_70]: /images/20220302/098742b2342a4bfd9190f4c936e7cce3.png
[https_download.csdn.net_download_qq_36537546_11044649]: https://download.csdn.net/download/qq_36537546/11044649