SpringBoot集成通用Mapper

SpringBoot集成通用Mapper

官方地址 https://github.com/abel533/Mapper

1.引入通用Mapper依赖

<dependency>
   <groupid>tk.mybatis</groupid>
   <artifactid>mapper-spring-boot-starter</artifactid>
  <version>2.1.5</version>
</dependency>

2.在启动类添加注解

//扫描mybatis哪些包里面的接口
@MapperScan("com.thyme")
@SpringBootApplication
public class UserCenterApplication {

    public static void main(String[] args) {
        SpringApplication.run(UserCenterApplication.class, args);
    }

}

3.在pom文件添加插件

<plugin>
   <groupid>org.mybatis.generator</groupid>
   <artifactid>mybatis-generator-maven-plugin</artifactid>
   <version>1.3.6</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>8.0.16</version>
      </dependency>
      <dependency>
         <groupid>tk.mybatis</groupid>
         <artifactid>mapper</artifactid>
         <version>4.1.5</version>
      </dependency>
   </dependencies>
</plugin>

4.新添generator目录以及配置文件至resources目录下

generatorConfig.xml文件内容

<generatorconfiguration>
    <properties resource="generator/config.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="tk.mybatis.mapper.common.Mapper">
            <property name="caseSensitive" value="true">
        </property></property></plugin>

        <jdbcconnection driverclass="${jdbc.driverClass}" connectionurl="${jdbc.url}" userid="${jdbc.user}" password="${jdbc.password}">
        </jdbcconnection>

        <!--实体-->
        <javamodelgenerator targetpackage="com.thyme.usercenter.domain.entity.${moduleName}" targetproject="src/main/java">

        <!--mapper.xml-->
        <sqlmapgenerator targetpackage="com.thyme.usercenter.dao.${moduleName}" targetproject="src/main/resources">

        <!--mapper接口-->
        <javaclientgenerator targetpackage="com.thyme.usercenter.dao.${moduleName}" targetproject="src/main/java" type="XMLMAPPER">
        <!--为哪张表生成-->
        <generatedkey column="id" sqlstatement="JDBC">
        </generatedkey><table tablename="${tableName}">
            </table>
    </javaclientgenerator></sqlmapgenerator></javamodelgenerator></property></property></context>
</properties></generatorconfiguration>

config.properties 文件

# 数据库驱动
jdbc.driverClass=com.mysql.cj.jdbc.Driver
#数据库url
jdbc.url=jdbc:mysql://127.0.0.1:3306/user_center?characterEncoding=utf-8&useSSL=false&serverTimezone=UTC&nullCatalogMeansCurrent=true
#数据库用户
jdbc.user=root
#数据库密码
jdbc.password=root
#模块名称
moduleName=user
#表名
tableName=user

5.运行插件