利用MyBatis Generator Core 逆向生成数据库表和映射类

墨蓝 2022-01-30 03:55 262阅读 0赞

建立Maven工程

工程目录如下

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NhbXJ0aWFu_size_16_color_FFFFFF_t_70][]

pom.xml配置如下

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
      <modelVersion>4.0.0</modelVersion>
    
      <groupId>genData</groupId>
      <artifactId>genData</artifactId>
      <version>0.0.1-SNAPSHOT</version>
      <packaging>jar</packaging>
    
      <name>genData</name>
      <url>http://maven.apache.org</url>
    
      <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
      </properties>
    
      <dependencies>
        
    	<dependency>
    	    <groupId>junit</groupId>
    	    <artifactId>junit</artifactId>
    	    <version>4.12</version>
    	    <scope>test</scope>
    	</dependency>
    
    	
    	<dependency>
    	    <groupId>org.mybatis.generator</groupId>
    	    <artifactId>mybatis-generator-core</artifactId>
    	    <version>1.3.7</version>
    	</dependency>
    	
    	<dependency>
    	    <groupId>javax.xml.bind</groupId>
    	    <artifactId>com.springsource.javax.xml.bind</artifactId>
    	    <version>2.2.0</version>
    	    <scope>provided</scope>
    	</dependency>
    		
    	<dependency>
    	    <groupId>org.apache.logging.log4j</groupId>
    	    <artifactId>log4j-core</artifactId>
    	    <version>2.11.2</version>
    	</dependency>
    	
    	
    	
      </dependencies>
    </project>

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>
        
        <properties resource="db.properties"/>
    
        
        
        <context id="sqlserver" targetRuntime="MyBatis3Simple" defaultModelType="flat">
            
            <property name="autoDelimitKeywords" value="true" />
            
            <property name="javaFileEncoding" value="utf-8" />
            
            <property name="beginningDelimiter" value="`" />
            <property name="endingDelimiter" value="`" />
    
            
            <property name="javaFormatter" value="org.mybatis.generator.api.dom.DefaultJavaFormatter"/>
            
            <property name="xmlFormatter" value="org.mybatis.generator.api.dom.DefaultXmlFormatter"/>
            <plugin type="org.mybatis.generator.plugins.SerializablePlugin" />
    
            <plugin type="org.mybatis.generator.plugins.ToStringPlugin" />
    
            
            <commentGenerator >
                <property name="suppressAllComments" value="true"/>
                <property name="suppressDate" value="false" /> 
            </commentGenerator>
    
            
            <jdbcConnection driverClass="${jdbc.driver}" 
            				connectionURL="${jdbc.connect}" 
            				userId="${jdbc.username}" 
            				password="${jdbc.password}" />
            				
            
            <javaTypeResolver>
                
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="com.samrtian.po" targetProject="src/main/java" >
                <property name="enableSubPackages" value="false"/>
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
            
            
            <sqlMapGenerator targetPackage="com.samrtian.mapper" targetProject="src/main/java" >
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
            
            
            <javaClientGenerator targetPackage="com.samrtian.mapper" targetProject="src/main/java" type="XMLMAPPER" >
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
                  
            
            <table schema="" 
            	   tableName="goods"
            	   enableCountByExample="true"
            	   enableUpdateByExample="true"
            	   enableSelectByExample="true"
            	   selectByExampleQueryId="true"
            	   >
                <property name="constructorBased" value="false" />
                
                <generatedKey column="GoodsId" sqlStatement="JDBC"/>
            </table>
            
        </context>
    </generatorConfiguration>

生成代码如下gen.java

package main;
    
    import java.io.File;
    import java.io.IOException;
    import java.sql.SQLException;
    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.exception.InvalidConfigurationException;
    import org.mybatis.generator.exception.XMLParserException;
    import org.mybatis.generator.internal.DefaultShellCallback;
    
    
    
    public class gen {
    
    	public static void main(String[] args)  {
    		// TODO Auto-generated method stub
    		 List<String> warnings = new ArrayList<String>();
    		 boolean overwrite = true;
    		 File configFile = new File("generatorConfig.xml");
    		 ConfigurationParser cp = new ConfigurationParser(warnings);
    		 Configuration config = null;
    		try {
    			config = cp.parseConfiguration(configFile);
    		} catch (IOException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (XMLParserException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		DefaultShellCallback callback = new DefaultShellCallback(overwrite);
    		MyBatisGenerator myBatisGenerator = null;
    		try {
    			myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
    		} catch (InvalidConfigurationException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		try {
    			myBatisGenerator.generate(null);
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (IOException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (InterruptedException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    	}
    
    }

log4j2.xml配置如下

<?xml version="1.0" encoding="UTF-8"?>  
    <Configuration status="DEBUG">  
      <Appenders>  
        <Console name="Console" target="SYSTEM_OUT">  
          <PatternLayout pattern="%d{HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n"/>  
        </Console>  
      </Appenders>  
      <Loggers>  
        <Root level="ALL">  
          <AppenderRef ref="Console"/>  
        </Root>  
      </Loggers>  
    </Configuration>

db.properties配置如下

jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
    jdbc.connect=jdbc:sqlserver://ip:1433;databaseName=数据库
    jdbc.username=xx
    jdbc.password=xx

运行代码即可

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NhbXJ0aWFu_size_16_color_FFFFFF_t_70]: /images/20220130/f4fe66602d834543a7674472ab090ed6.png