springboot-mybatis-example

    <!--mybatis-->
    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>1.3.1</version>
    </dependency>
    <!--mapper-->
    <dependency>
        <groupId>tk.mybatis</groupId>
        <artifactId>mapper-spring-boot-starter</artifactId>
        <version>2.0.4</version>
    </dependency>
    <!--pagehelper-->
    <dependency>
        <groupId>com.github.pagehelper</groupId>
        <artifactId>pagehelper-spring-boot-starter</artifactId>
        <version>1.2.3</version>
    </dependency>

    <plugin>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-maven-plugin</artifactId>
        <version>1.3.2</version>
        <configuration>
            <configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
            <overwrite>true</overwrite>
            <verbose>true</verbose>
        </configuration>
        <dependencies>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>${mysql.version}</version>
            </dependency>
            <dependency>
                <groupId>tk.mybatis</groupId>
                <artifactId>mapper-generator</artifactId>
                <version>1.0.0</version>
            </dependency>
        </dependencies>
    </plugin>

    <?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>
    
        <!-- 引入配置文件 -->
        <properties resource="mybatisGeneratorinit.properties"/>
    
        <context id="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat">
            <property name="beginningDelimiter" value="`"/>
            <property name="endingDelimiter" value="`"/>
    
            <plugin type="tk.mybatis.mapper.generator.MapperPlugin">
                <property name="mappers" value="com.vanguard.commons.base.BaseMapper"/>
            </plugin>
    
            <!-- jdbc连接 -->
            <jdbcConnection driverClass="${jdbc_driver}"
                            connectionURL="${jdbc_url}"
                            userId="${jdbc_user}"
                            password="${jdbc_password}">
                            
                            
            <!--MySQL 8.x 需要指定服务器的时区-->
            <property name="serverTimezone" value="UTC"/>
            <!--MySQL 不支持 schema 或者 catalog 所以需要添加这个 只生成指定数据库表代码-->
            <!--参考 : http://www.mybatis.org/generator/usage/mysql.html-->
            <property name="nullCatalogMeansCurrent" value="true"/>
            
            </jdbcConnection>
    
            <!-- 生成实体类地址 -->
            <javaModelGenerator targetPackage="com.vanguard.domain" targetProject="src/main/java"/>
    
            <!-- 生成Mapper xml文件 -->
            <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"/>
    
            <!-- 生成Mapper xml对应Mapper接口 -->
            <javaClientGenerator targetPackage="com.vanguard.mapper" targetProject="src/main/java"
                                 type="XMLMAPPER"/>
    
            <!-- table可以有多个,每个数据库中的表都可以写一个table，tableName表示要匹配的数据库表,
            也可以在tableName属性中通过使用%通配符来匹配所有数据库表,只有匹配的表才会自动生成文件 -->
            <table tableName="tb_user" domainObjectName="User">
                <!-- 数据库表主键 -->
                <generatedKey column="id" sqlStatement="Mysql" identity="true"/>
            </table>
    
        </context>
    </generatorConfiguration>

mybatis:
      type-aliases-package: com.vanguard.domain
      #Mybatis的Mapper配置文件路径
      mapper-locations: classpath:mapper/*.xml 
      configuration:
        #开启驼峰式属性和字段映射
        mapUnderscoreToCamelCase: true
        #打印运行的SQL语句到控制台
        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

mapper:
    mappers:
        #指定Mapper的BaseMapper的路径
        - com.vanguard.commons.base.BaseMapper
    notEmpty: true
    identity: MYSQL
    before: false

#分页组件配置
pagehelper:
    helperDialect: mysql
    reasonable: true
    supportMethodsArguments: true
    params: count=countSql