mybatis自动生成mapper.xml文件，model文件

小鱼儿 2021-11-11 15:22 681阅读 0赞

1. 首先我们新建一个genneratorConfigMysql.xml文件, 把里面的数据库，用户名，数据库表都进行相应的替换，

domainObjectName是要生成的model文件名称

tableName 数据库表名

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<?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="MySqlContext" targetRuntime="MyBatis3Simple" defaultModelType="flat">
            <property name="beginingDelimiter" value="`"/>
            <property name="endingDelimiter" value="`"/>
            <commentGenerator>
                <property name="supressDate" value="true"/>
                <property name="addRemarkComments" value="true"/>
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                connectionURL="jdbc:mysql://xxxx?characterEncoding=utf8" userId="xxxx"
                password="xxxx" >
            </jdbcConnection>
            <javaModelGenerator targetPackage="test.qa.model" targetProject="src/main/java">
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
            <sqlMapGenerator targetPackage="mybatis" targetProject="src/main/resources/"/>
            <javaClientGenerator type="XMLMAPPER" targetPackage="test.ke.dao" targetProject="src/main/java"/>
            <table tableName="xxxx"  domainObjectName="xxxx"/>
        </context>
    </generatorConfiguration>

2. 新建一个java文件，如下所示，运行即可生成对应的mapper.xml文件，model文件. 需要生成其他的数据库表的时候，只要替换genneratorConfigMysql.xml文件中的数据库表名和要生成的model文件名即可

package test.util;
    
    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;
    
    import java.io.InputStream;
    import java.util.ArrayList;
    import java.util.List;
    
    /**
     * 生成model文件和xml文件。 需要修改generatorConfigMySql.xml文件中的表和数据库
     */
    public class Generator {
        public static void main(String[] args) throws Exception{
            List<String> warnings = new ArrayList<>();
            boolean overwrite = true;
            InputStream is = Generator.class.getResourceAsStream("/generatorConfigMySql.xml");
            if(is == null){
                System.out.println("null");
            }
            ConfigurationParser cp = new ConfigurationParser(warnings);
            Configuration config = cp.parseConfiguration(is);
            is.close();
            DefaultShellCallback callback = new DefaultShellCallback(overwrite);
            MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
            myBatisGenerator.generate(null);
            for(String warning : warnings){
                System.out.println(warning);
            }
    
        }
    }

转载于:https://www.cnblogs.com/leavescy/p/11240445.html

[ContractedBlock.gif]: https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif
[ExpandedBlockStart.gif]: /images/20211109/babf916c3eb84a89842090024b4bf577.png