mybatis逆向生成配置文件（mbg.xml）

旧城等待， 2022-02-12 15:25 291阅读 0赞

引入相关jar包  
        
    <dependency>  
        <groupId>org.mybatis.generator</groupId>  
        <artifactId>mybatis-generator-core</artifactId>  
        <version>1.3.5</version>  
    </dependency>

<?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="suppressDate" value="true" />
    			<property name="suppressAllComments" value="true" />
    		</commentGenerator>
    		<jdbcConnection driverClass="com.mysql.jdbc.Driver"
    			connectionURL="jdbc:mysql://localhost/zzdy_system" userId="root"
    			password="zzdy.">
    		</jdbcConnection>
    
    		<javaTypeResolver>
    			<property name="forceBigDecimals" value="false" />
    		</javaTypeResolver>
    
    		
    		<javaModelGenerator targetPackage="com.db.crud.bean"
    			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.db.crud.dao" targetProject=".\src\main\java">
    			<property name="enableSubPackages" value="true" />
    		</javaClientGenerator>
    		
    		<table tableName="lv_mc_meter" domainObjectName="lv_mc_meter"
    			enableCountByExample="false" enableUpdateByExample="false"
    			enableDeleteByExample="false" enableSelectByExample="false"
    			selectByExampleQueryId="false"></table>
    			
    		<table tableName="lv_ls_pole_power" domainObjectName="lv_ls_pole_power"
    			enableCountByExample="false" enableUpdateByExample="false"
    			enableDeleteByExample="false" enableSelectByExample="false"
    		
    		
    												
    	</context>
    </generatorConfiguration>

通过测试类逆向生成表对应的实体类

public class MBGTest \{  
    public static void main(String\[\] args) throws IOException, Exception \{  
         List<String> warnings = new ArrayList<String>();  
           boolean overwrite = true;  
           File configFile = new File("mbg.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);  
    \}  
\}