Mybatis-generator插件使用

1、引入pom相关依赖

 <build>
        <pluginManagement>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.5</version>
                    <dependencies>
                        <dependency>
                            <groupId>org.mybatis.generator</groupId>
                            <artifactId>mybatis-generator-core</artifactId>
                            <version>1.3.5</version>
                        </dependency>
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <version>5.1.41</version>
                        </dependency>
                    </dependencies>
                    <executions>
                        <execution>
                            <id>mybatis-generator</id>
                            <phase>package</phase>
                            <goals>
                                <goal>generate</goal>
                            </goals>
                        </execution>
                    </executions>
                    <configuration>
                        <verbose>true</verbose>
                        <overwrite>true</overwrite>
                        <configurationFile>
                            src/main/resources/mybatis-generator.xml
                        </configurationFile>
                    </configuration>
                </plugin>
            </plugins>
        </pluginManagement>
    </build>

2、编写mybatis-generator.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="common" targetRuntime="MyBatis3">

        <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
            connectionURL="***"
            userId="***"
            password="***" />
        <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer true，把JDBC DECIMAL 和 
            NUMERIC 类型解析为java.math.BigDecimal -->
        <javaTypeResolver>
            <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>
        <!-- model存放目录 -->
         <javaModelGenerator targetPackage="resources/mapper"
                             targetProject = "src/main"/>
        <!-- mapper xml存放目录 -->
        <sqlMapGenerator targetPackage="resources/mapper"
                         targetProject = "src/main"/>
        <!-- mapper接口存放目录 -->
        <javaClientGenerator  targetPackage="resources/mapper"
                              targetProject = "src/main" type="XMLMAPPER" />
        <!-- 配置不生成Exmaple文件 -->
        <table schema="***" tableName="***" domainObjectName="***"
            enableCountByExample="true" enableUpdateByExample="true" 
            enableDeleteByExample="true" enableSelectByExample="true"
            selectByExampleQueryId="true" >
            <generatedKey column="id" sqlStatement="JDBC"/>          
        </table>
    </context>
</generatorConfiguration>

3、在启动项配置相关启动

command line 写

mybatis-generator:generate

4、记录下两个错误

一般项目在dao层放xml配置，这时候需要在系统的根模块pom文件注入配置，否则会报no plugin found 错误

其次，需要注意，在配置

mybatis-generator:generate

的时候，idea中需要选择working directory，这时候需要将working directory 选择到dao目录下，不然会can not resolve path的错误