Lugick Wang's Blog
0%

mybatis generator 使用

发表于 Disqus：

前言

学习 SSM 的过程中，mybatis 逆向工程，自动生成代码。

步骤

  1. 新建一个 maven 工程

  2. 修改 pom.xml

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    <?xml version="1.0" encoding="UTF-8"?>
    <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>com.my.mybatisReverse</groupId>
        <artifactId>mybatisReverse</artifactId>
        <version>1.0-SNAPSHOT</version>

        <build>
            <plugins>
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.7</version>
                </plugin>
            </plugins>
        </build>

        <dependencies>
            <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.3.7</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.15</version>
            </dependency>
        </dependencies>
    </project>

  3. pom.xml 同级目录下新建 generatorConfig.xml

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    <?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="mysqlTables" targetRuntime="MyBatis3">
            <!--链接 mysql-->
            <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
                            connectionURL="jdbc:mysql://localhost:3306/maven?characterEncoding=utf-8"
                            userId="root"
                            password="sqlpassword">
            </jdbcConnection>

            <javaTypeResolver >
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>

            <javaModelGenerator targetPackage="pojo" targetProject="./src/main/java">
                <property name="enableSubPackages" value="false" />
                <property name="trimStrings" value="true" />
            </javaModelGenerator>

            <sqlMapGenerator targetPackage="mapper"  targetProject="./src/main/java">
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>

            <javaClientGenerator type="XMLMAPPER" targetPackage="mapper"  targetProject="./src/main/java">
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>

    		<!--mysql 中的表名-->
            <table schema="maven" tableName="product"></table>
            <table schema="maven" tableName="product_category"></table>

        </context>
    </generatorConfiguration>

  4. src/main/java 下新建 MybatisReverse.java

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    import java.io.File;
    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.internal.DefaultShellCallback;

    public class MybatisReverse {
        public static void main(String[] args) {

            try {
                MybatisReverse mybatisReverse = new MybatisReverse();
                mybatisReverse.reverse();
            } catch (Exception e) {
                e.printStackTrace();
            }

        }

        public void reverse() 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);
        }
    }

  5. 此时项目目录为

    before

  6. 运行 MybatisReverse.java ，生成相关文件

    after