关于Mybatis的逆向工程生成pojo和mapper

谁借莪１个温暖的怀抱￠ 2022-07-13 13:06 216阅读 0赞

# **一.项目结构：** #

# **![Center][]** #

GeneratorSqlmap.java

/**
     * 作用: mybatis 逆向工程映射出实体pojo和mapper
     * @author xwp
     * @date 2017年1月6日
     */
    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();
    		}
    		
    	}
    
    }

log4j.properties

log4j.rootLogger=DEBUG, Console
    #Console
    log4j.appender.Console=org.apache.log4j.ConsoleAppender
    log4j.appender.Console.layout=org.apache.log4j.PatternLayout
    log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
    log4j.logger.java.sql.ResultSet=INFO
    log4j.logger.org.apache=INFO
    log4j.logger.java.sql.Connection=DEBUG
    log4j.logger.java.sql.Statement=DEBUG
    log4j.logger.java.sql.PreparedStatement=DEBUG

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/taotao" userId="root"
    			password="root">
    		</jdbcConnection>
    		
    		<javaTypeResolver>
    			<property name="forceBigDecimals" value="false" />
    		</javaTypeResolver>
    
    		
    		<javaModelGenerator targetPackage="com.taotao.pojo"
    			targetProject=".\src">
    			
    			<property name="enableSubPackages" value="false" />
    			
    			<property name="trimStrings" value="true" />
    		</javaModelGenerator>
            
    		<sqlMapGenerator targetPackage="com.taotao.mapper" 
    			targetProject=".\src">
    			
    			<property name="enableSubPackages" value="false" />
    		</sqlMapGenerator>
    		
    		<javaClientGenerator type="XMLMAPPER"
    			targetPackage="com.taotao.mapper" 
    			targetProject=".\src">
    			
    			<property name="enableSubPackages" value="false" />
    		</javaClientGenerator>
    		
    		<table schema="" tableName="tb_content"></table>
    		<table schema="" tableName="tb_content_category"></table>
    		<table schema="" tableName="tb_item"></table>
    		<table schema="" tableName="tb_item_cat"></table>
    		<table schema="" tableName="tb_item_desc"></table>
    		<table schema="" tableName="tb_item_param"></table>
    		<table schema="" tableName="tb_item_param_item"></table>
    		<table schema="" tableName="tb_order"></table>
    		<table schema="" tableName="tb_order_item"></table>
    		<table schema="" tableName="tb_order_shipping"></table>
    		<table schema="" tableName="tb_user"></table>
    
    	</context>
    </generatorConfiguration>

[Center]: /images/20220713/fcac2ba2ee6c4c899118485e29a6247f.png