• 使用Java代码配置MyBatis Generator


      使用MyBatis Generator生成器时,有时候没办法使用xml形式的配置文件,比如将Maven项目设置成pom打包方式(<packaging>pom</packaging>)!由于Maven的工作机制对于打包方式为pom的项目是不会输出jar包或war包和resources内容,所以放在resources目录下或放在源码目录下的xml文件就没法读取了,就算你在pom.xml文件中明确有如下配置也没有用的:

        <build>
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.yml</include>
                        <include>**/*.xml</include>
                    </includes>
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.yml</include>
                        <include>**/*.xml</include>
                    </includes>
                </resource>
            </resources>
        </build>

      这个时候就会用到纯Java代码的MyBatis Generator配置,直接贴配置代码:

    import org.mybatis.generator.config.*;
    
    /**
     * 基于Java代码的MBG配置
     * Maven打包方式为POM的项目或模块(<packaging>pom</packaging>),resources目录的内容不会输出到类路径下,所以可以选择直接使用Java代码配置!
     *
     * @author 707669522@qq.com
     * @since 2020-06-13
     */
    public class GeneratorConfig {
        public static Configuration getGeneratorConfig() {
            Context context = new Context(ModelType.CONDITIONAL);
            context.setId("simple");
            context.setTargetRuntime("MyBatis3Simple");
    
            /*添加属性*/
            context.addProperty("javaFileEncoding", "UTF-8");
    
            /*插件配置,这个是我自己的插件,没有自定义插件的同学可以不配这一节,删除即可*/
            PluginConfiguration pluginConfig = new PluginConfiguration();
            pluginConfig.setConfigurationType("com.xgclassroom.generator.GeneratorPlugin"); 
            context.addPluginConfiguration(pluginConfig);
    
            /*注释生成器配置*/
            CommentGeneratorConfiguration commentGeneratorConfig = new CommentGeneratorConfiguration();
            commentGeneratorConfig.addProperty("suppressAllComments", "true");
            context.setCommentGeneratorConfiguration(commentGeneratorConfig);
    
            /*JDBC连接信息配置*/
            JDBCConnectionConfiguration jdbcConnectionConfig = new JDBCConnectionConfiguration();
            jdbcConnectionConfig.setDriverClass("com.mysql.cj.jdbc.Driver");
            //注意代码配置中JDBC连接字符串中的参数分隔符不需要再像xml配置文件中那样使用转义符
            jdbcConnectionConfig.setConnectionURL("jdbc:mysql://localhost:3306/permission_center?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false");
            jdbcConnectionConfig.setUserId("xurm");
            jdbcConnectionConfig.setPassword("1qaz@WSX");
            jdbcConnectionConfig.addProperty("nullCatalogMeansCurrent", "true");//MySQL无法识别table标签中schema类的配置,所以在URL上指明目标数据库,并追加nullCatalogMeansCurrent属性为true
            jdbcConnectionConfig.addProperty("remarksReporting", "true");//针对oracle数据库无法读取表和字段备注
            jdbcConnectionConfig.addProperty("useInformationSchema", "true");//针对mysql数据库无法读取表和字段备注
            context.setJdbcConnectionConfiguration(jdbcConnectionConfig);
    
            /*Model生成器配置*/
            JavaModelGeneratorConfiguration javaModelGeneratorConfig = new JavaModelGeneratorConfiguration();
            javaModelGeneratorConfig.setTargetProject("permission/src/main/java");//目标项目(源码主路径)
            javaModelGeneratorConfig.setTargetPackage("com.xgclassroom.model");//目标包(Model类文件存放包)
            context.setJavaModelGeneratorConfiguration(javaModelGeneratorConfig);
    
            /*SqlMapper生成器配置(*Mapper.xml类文件),要javaClient生成器类型配合*/
            SqlMapGeneratorConfiguration sqlMapGeneratorConfig = new SqlMapGeneratorConfiguration();
            sqlMapGeneratorConfig.setTargetProject("permission/src/main/java");//目标项目(源码主路径)
            sqlMapGeneratorConfig.setTargetPackage("com.xgclassroom.mapper");//目标包(*Mapper.xml类文件存放包)
            context.setSqlMapGeneratorConfiguration(sqlMapGeneratorConfig);
    
            /*JavaClient生成器配置(*Mapper.java类文件)*/
            JavaClientGeneratorConfiguration javaClientGeneratorConfig = new JavaClientGeneratorConfiguration();
            javaClientGeneratorConfig.setConfigurationType("XMLMAPPER");//JavaClient生成器类型(主要有ANNOTATEDMAPPER、MIXEDMAPPER、XMLMAPPER,要Context的TargetRuntime配合)
            javaClientGeneratorConfig.setTargetProject("permission/src/main/java");//目标项目(源码主路径)
            javaClientGeneratorConfig.setTargetPackage("com.xgclassroom.mapper");//目标包(*Mapper.java类文件存放包)
            context.setJavaClientGeneratorConfiguration(javaClientGeneratorConfig);
    
            /*表生成配置*/
            TableConfiguration tableConfig = new TableConfiguration(context);
            tableConfig.setTableName("%");
            GeneratedKey generatedKey = new GeneratedKey("id", "JDBC", true, null);//设置主键列和生成方式
            tableConfig.setGeneratedKey(generatedKey);
            context.addTableConfiguration(tableConfig);
    
            Configuration config = new Configuration();
            config.addContext(context);
    
            return config;
        }
    }

      然后就是把MyBatis Generator调用过程中原本读取xml配置文件的地方换掉就可以了:

    import org.mybatis.generator.api.MyBatisGenerator;
    import org.mybatis.generator.config.Configuration;
    import org.mybatis.generator.internal.DefaultShellCallback;
    
    import java.util.ArrayList;
    import java.util.List;
    
    /**
     * MyBatisGenerator代码生成器Java调用程序
     *
     * @author 707669522@qq.com
     * @since 2020-06-13
     */
    public class GeneratorRunner {
        public static void main(String[] args) {
            try {
                List<String> warnings = new ArrayList<String>();
                Configuration config;
                //使用xml配置文件的方式
                /*File configFile = new File(GeneratorRunner.class.getClassLoader().getResource("generatorConfig.xml").getPath());
                ConfigurationParser cp = new ConfigurationParser(warnings);
                config = cp.parseConfiguration(configFile);*/
                //使用纯Java代码配置的方式
                config = GeneratorConfig.getGeneratorConfig();
                DefaultShellCallback callback = new DefaultShellCallback(true);
                MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
                myBatisGenerator.generate(null);
            } catch (Exception e) {
                System.out.println(e.getMessage());
                e.printStackTrace();
            }
        }
    }

       

      最后把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="simple" targetRuntime="MyBatis3Simple">
            <property name="javaFileEncoding" value="UTF-8"/>
            <plugin type="com.xgclassroom.generator.GeneratorPlugin"></plugin>
            <commentGenerator>
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
            <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
                            connectionURL="jdbc:mysql://localhost:3306/customer_center?useUnicode=true&amp;characterEncoding=utf8&amp;serverTimezone=GMT%2B8&amp;useSSL=false"
                            userId="xurm" password="1qaz@WSX">
                <!--MySQL无法识别table标签中schema类的配置,所以在URL上指明目标数据库,并追加nullCatalogMeansCurrent属性为true-->
                <property name="nullCatalogMeansCurrent" value="true"></property>
                <!-- /*针对oracle数据库无法读取表和字段备注*/ -->
                <property name="remarksReporting" value="true"></property>
                <!-- /*针对mysql数据库无法读取表和字段备注*/ -->
                <property name="useInformationSchema" value="true"></property>
            </jdbcConnection>
    
            <javaModelGenerator targetPackage="com.xgclassroom.model" targetProject="customer/src/main/java"/>
    
            <sqlMapGenerator targetPackage="com.xgclassroom.mapper" targetProject="customer/src/main/java"></sqlMapGenerator>
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.xgclassroom.mapper"
                                 targetProject="customer/src/main/java"/>
            <!--对于MySQL不要加schema和catalog,会生成{catalog}..{table}的SQL语句,表名填%是表示生成目标库的所有表-->
            <table tableName="%">
                <!--指定生成主键列相关的设置-->
                <generatedKey column="id" sqlStatement="JDBC"/>
            </table>
        </context>
    </generatorConfiguration>

      如果对你有帮助,请记得点个【推荐】!

      Talk is cheap, show me the code! Bye.

  • 相关阅读:
    【BZOJ 3090】 树形DP
    【BZOJ 2323】 2323: [ZJOI2011]细胞 (DP+矩阵乘法+快速幂*)
    【BZOJ 1019】 1019: [SHOI2008]汉诺塔 (DP?)
    【BZOJ 3294】 3294: [Cqoi2011]放棋子 (DP+组合数学+容斥原理)
    【BZOJ 3566】 3566: [SHOI2014]概率充电器 (概率树形DP)
    【BZOJ 2121】 (字符串DP,区间DP)
    【BZOJ 4305】 4305: 数列的GCD (数论)
    【UOJ 179】 #179. 线性规划 (单纯形法)
    【BZOJ 4568】 4568: [Scoi2016]幸运数字 (线性基+树链剖分+线段树)
    【BZOJ 4027】 4027: [HEOI2015]兔子与樱花 (贪心)
  • 原文地址:https://www.cnblogs.com/xuruiming/p/13124609.html
Copyright © 2020-2023  润新知