mybatis-generator-maven-plugin使用

前提说明

• 数据库：MYSQL57
• Mybatis : http://mybatis.org/generator/index.html

操作说明

引入插件

<plugins>
            
            <plugin>
                <groupId>org.mybatis.generatorgroupId>
                <artifactId>mybatis-generator-maven-pluginartifactId>
                <dependencies>
                    <dependency>
                        <groupId>mysqlgroupId>
                        <artifactId>mysql-connector-javaartifactId>
                        <version>${mysql-connector-java.version}version>
                    dependency>
                dependencies>
                <executions>
                    <execution>
                        <id>Generate MyBatis Artifactsid>
                        <phase>packagephase>
                        <goals>
                            <goal>generategoal>
                        goals>
                    execution>
                executions>
                <configuration>
                    
                    <verbose>trueverbose>
                    
                    <overwrite>trueoverwrite>
                    
                    <configurationFile>src/test/resources/config/generator-config.xmlconfigurationFile>
                configuration>
            plugin>
        plugins>
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

创建 generator 的配置文件

注意：配置文件名要为：application.properties ，同时要放在 resources/config/application.properties，想要修改请详见下面的配置xml信息。

db:
  driverLocation: D:_toolsmaven_resprositymysqlmysql-connector-java8.0.15mysql-connector-java-8.0.15.jar
generator:
  maper:
    sqlMap-targetPackage: src/main/resources
  mapper: cn.com.bsfit.mapper
  pojo: cn.com.bsfit.pojo
  targetProject: src/main/java
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    druid:
      StatViewServlet:
        loginPassword: druid
        loginUsername: druid
      WebStatFilter:
        exclusions: '*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*'
      initialSize: 5
      maxActive: 30
      minIdle: 5
    maxWait: 60000
    password: 123456
    type: com.alibaba.druid.pool.DruidDataSource
    url: jdbc:mysql://192.168.2.11:3306/mytest?useUnicode=true&characterEncoding=utf-8&useSSL=false&rewriteBatchedStatements=true
    username: root

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

逆向配置模板信息

注意：
  其他的信息可以不变，但是我们要修改 table 标签，添加我们要逆向的数据表。

DOCTYPE generatorConfiguration
        PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">

<generatorConfiguration>
    
    <properties resource="./config/application.yml"/>

    
    <classPathEntry location="${db.driverLocation}" />

    
    
    
    <context id="default" targetRuntime="MyBatis3">
        
        <plugin type="org.mybatis.generator.plugins.UnmergeableXmlMappersPlugin" />
        
        <commentGenerator>
            <property name="suppressDate" value="true" />
            
            <property name="suppressAllComments" value="true" />

        commentGenerator>

        
        <jdbcConnection
                driverClass="${spring.datasource.driver-class-name}"
                connectionURL="${spring.datasource.url}"
                userId="${spring.datasource.username}"
                password="${spring.datasource.password}">
        jdbcConnection>


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

        
        
        <javaModelGenerator targetPackage="${generator.pojo}"
                            targetProject="${generator.targetProject}">
            
            
            <property name="enableSubPackages" value="false" />
            
            <property name="constructorBased" value="true" />
            
            <property name="trimStrings" value="true" />
            
            <property name="immutable" value="false" />
        javaModelGenerator>

        
        <sqlMapGenerator targetPackage="mapper"
                         targetProject="${generator.maper.sqlMap-targetPackage}">
            
            <property name="enableSubPackages" value="false" />
        sqlMapGenerator>

        
        <javaClientGenerator type="XMLMAPPER"
                             targetPackage="${generator.mapper}"
                             targetProject="${generator.targetProject}">
            
            <property name="enableSubPackages" value="false" />
        javaClientGenerator>

        
        
        <table tableName="test_01"
               domainObjectName="Course"
               enableCountByExample="false"
               enableUpdateByExample="false"
               enableDeleteByExample="false"
               enableSelectByExample="false"
               selectByExampleQueryId="false">
            
            <generatedKey column="id" sqlStatement="JDBC">generatedKey>
        table>

    context>
generatorConfiguration>

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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98

逆向生产

自此生成了我们需要的表的 pojo 、 mapper.xml 、mapper.java