Springboot通用mapper和mybatis-generator代碼示例

更新時間：2020年12月04日 09:19:54 作者：人間有妖氣

這篇文章主要介紹了Springboot通用mapper和mybatis-generator代碼示例,文中通過示例代碼介紹的非常詳細，對大家的學習或者工作具有一定的參考學習價值,需要的朋友可以參考下

實現(xiàn)功能：根據(jù)數(shù)據(jù)庫中的表，自動生成model、dao和對應的xml文件。xml中實現(xiàn)通用mapper中CURD功能

1、引入依賴

  <properties>
    <mybatis.generator.version>1.3.7</mybatis.generator.version>
    <tk.mybatis.version>4.1.5</tk.mybatis.version>
  </properties>

  <dependencies>
    <!--mybatis-->
    <dependency>
      <groupId>org.mybatis.spring.boot</groupId>
      <artifactId>mybatis-spring-boot-starter</artifactId>
      <version>2.1.3</version>
    </dependency>
    <!--通用mapper-->
    <dependency>
      <groupId>tk.mybatis</groupId>
      <artifactId>mapper</artifactId>
      <version>${tk.mybatis.version}</version>
    </dependency>
    <!--mybatis-generator-->
    <dependency>
      <groupId>org.mybatis.generator</groupId>
      <artifactId>mybatis-generator-core</artifactId>
      <version>${mybatis.generator.version}</version>
    </dependency>

   <!--mysql數(shù)據(jù)庫-->
   <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
    </dependency>
   <!--druid數(shù)據(jù)源-->   
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid-spring-boot-starter</artifactId>
      <version>1.1.10</version>
    </dependency>
  <dependencies>

   <build>
    <plugins>

      <!--配置Maven中 mybatis-generator 插件-->
      <!--加入tk.mybatis的依賴-->
      <plugin>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-maven-plugin</artifactId>
        <version>${mybatis.generator.version}</version>
        <configuration>
          <!--可移動-->
          <verbose>true</verbose>
          <!--可覆蓋-->
          <overwrite>true</overwrite>
        </configuration>
        <dependencies>
          <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper</artifactId>
            <version>${tk.mybatis.version}</version>
          </dependency>
        </dependencies>
      </plugin>

    </plugins>
  </build>

2、配置通用mapper

方式1：配置要掃描的mapper

@SpringBootApplication
@MapperScan(basePackages = "com.liang.mapper")
public class MyappApplication {
  public static void main(String[] args) {
    SpringApplication.run(MyappApplication.class, args);
  }

}

方式2：掃描的mapper

@Configuration
public class MybatisConfig {
  @Bean(name = "mapperScannerConfigurer")
  public MapperScannerConfigurer MapperScannerConfigurer1() {
    MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
    mapperScannerConfigurer.setBasePackage("com.liang.mapper");
    Properties properties = new Properties();
    properties.setProperty("notEmpty", "false");
    properties.setProperty("IDENTITY", "MYSQL");
    properties.setProperty("mappers", Mapper.class.getName());
    mapperScannerConfigurer.setSqlSessionFactoryBeanName("sqlSessionFactory");
    mapperScannerConfigurer.setProperties(properties);
    return mapperScannerConfigurer;
  }
}

3、application.yaml中配置mybatis

#Mybatis（注意不是 mybatis.config-location 這個配置）
mybatis:
 mapper-locations: classpath:mapper/*.xml
 type-aliases-package: com.liang.pojo
 configuration-properties: {
  notEmpty: false,
  IDENTITY: 'MYSQL',
  mappers: "tk.mybatis.mapper.common.Mapper"
 }

4、添加generatorConfig.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>
  <!-- 數(shù)據(jù)庫驅(qū)動-->
  <classPathEntry location="E:\ideaMaven\MavenRepository\mysql\mysql-connector-java\8.0.22\mysql-connector-java-8.0.22.jar" />

  <context id="DB2Tables" targetRuntime="MyBatis3Simple">

    <!--beginningDelimiter和endingDelimiter：指明數(shù)據(jù)庫的用于標記數(shù)據(jù)庫對象名的符號，比如ORACLE就是雙引號，MYSQL默認是`反引號； -->
    <property name="beginningDelimiter" value="`"></property>
    <property name="endingDelimiter" value="`"></property>

    <!-- 生成的Java文件的編碼 -->
    <property name="javaFileEncoding" value="utf-8"/>

    <!--添加Tk-mapper插件-->
    <plugin type="tk.mybatis.mapper.generator.MapperPlugin" >
      <property name="mappers" value="tk.mybatis.mapper.common.Mapper"/>
    </plugin>

    <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
            connectionURL="jdbc:mysql://localhost:3306/temp_db?serverTimezone=Asia/Shanghai&amp;characterEncoding=utf-8&amp;useUnicode=true&amp;useSSL=false"
            userId="root"
            password="123456">
    </jdbcConnection>

    <!-- java類型處理器 用于處理DB中的類型到Java中的類型，默認使用JavaTypeResolverDefaultImpl； 注意一點，默認會先嘗試使用Integer，Long，Short等來對應DECIMAL和 NUMERIC數(shù)據(jù)類型； -->
    <javaTypeResolver >
      <property name="forceBigDecimals" value="false" />
    </javaTypeResolver>

    <!--生成entity類存放位置-->
    <javaModelGenerator targetPackage="com.liang.pojo" targetProject="src/main/java">
      <property name="enableSubPackages" value="false" />
      <property name="trimStrings" value="true" />
    </javaModelGenerator>

    <!--生成映射文件存放位置 -->
    <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources">
      <property name="enableSubPackages" value="true" />
    </sqlMapGenerator>

    <!--生成Dao類存放位置-->
    <javaClientGenerator type="XMLMAPPER" targetPackage="com.liang.mapper" targetProject="src/main/java">
      <property name="enableSubPackages" value="true" />
    </javaClientGenerator>

    <!--要生成的Table,注意不同的數(shù)據(jù)庫，sqlStatement-->
    <!--sqlStatement 不同的數(shù)據(jù)庫配置 http://mybatis.org/generator/configreference/generatedKey.html-->
    <table domainObjectName="School2" tableName="t_school">
      <!--<generatedKey column="id" sqlStatement="MySql" identity="true" />-->
      <generatedKey column="id" sqlStatement="SELECT LAST_INSERT_ID() AS id" identity="true" />
    </table>
  </context>
</generatorConfiguration>

5、完成