快捷導(dǎo)航

springboot集成mybatisPlus+多數(shù)據(jù)源的實(shí)現(xiàn)示例

更新時(shí)間：2020年12月25日 16:58:17 作者：做最會(huì)吹牛的程序猿

這篇文章主要介紹了springboot集成mybatisPlus+多數(shù)據(jù)源的實(shí)現(xiàn)示例，文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧

該項(xiàng)目主要實(shí)現(xiàn)mybatisplus、多數(shù)據(jù)源、lombok、druid的集成

主要參考 https://mp.baomidou.com/guide/quick-start.html
項(xiàng)目地址：https://github.com/Blankwhiter/mybatisplus-springboot release1.0

項(xiàng)目結(jié)構(gòu)：

在這里插入圖片描述

一、創(chuàng)建表以及測(cè)試數(shù)據(jù)

CREATE TABLE user
(
	id VARCHAR(32) NOT NULL COMMENT '主鍵ID',
	name VARCHAR(30) NULL DEFAULT NULL COMMENT '姓名',
	age INT(11) NULL DEFAULT NULL COMMENT '年齡',
	email VARCHAR(50) NULL DEFAULT NULL COMMENT '郵箱',
	PRIMARY KEY (id)
);


INSERT INTO user (id, name, age, email) VALUES
(1, 'Jone', 18, 'test1@baomidou.com'),
(2, 'Jack', 20, 'test2@baomidou.com'),
(3, 'Tom', 28, 'test3@baomidou.com'),
(4, 'Sandy', 21, 'test4@baomidou.com'),
(5, 'Billie', 24, 'test5@baomidou.com');

二、引入項(xiàng)目依賴，加入配置，修改啟動(dòng)類，編寫實(shí)體類和mapper對(duì)象（讀者可以根據(jù)自動(dòng)生成工具生成這塊代碼）

1.引入依賴

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.1.4.RELEASE</version>
    <relativePath/> <!-- lookup parent from repository -->
  </parent>
  <groupId>com.example</groupId>
  <artifactId>mybatisplus-springboot</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <name>mybatisplus-springboot</name>
  <description>Demo project for Spring Boot</description>

  <properties>
    <java.version>1.8</java.version>
    <mysql.version>6.0.6</mysql.version>
    <mybatisplus.boot.version>3.1.0</mybatisplus.boot.version>
    <druid.version>1.1.10</druid.version>
    <dynamic.datasource.boot.version>2.5.4</dynamic.datasource.boot.version>
  </properties>

  <dependencies>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-web</artifactId>
    </dependency>

    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <optional>true</optional>
    </dependency>

    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>${mysql.version}</version>
    </dependency>

    <dependency>
      <groupId>com.baomidou</groupId>
      <artifactId>mybatis-plus-boot-starter</artifactId>
      <version>${mybatisplus.boot.version}</version>
    </dependency>

    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <optional>true</optional>
    </dependency>

    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid-spring-boot-starter</artifactId>
      <version>${druid.version}</version>
    </dependency>

    <dependency>
      <groupId>com.baomidou</groupId>
      <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
      <version>${dynamic.datasource.boot.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-test</artifactId>
      <scope>test</scope>
    </dependency>
  </dependencies>


  <build>
    <plugins>
      <plugin>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-maven-plugin</artifactId>
      </plugin>
    </plugins>
  </build>

</project>

2.編寫配置

application.yml

spring:
 autoconfigure:
  exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 為了某些版本的springboot @SpringBootApplication(exclude= {DataSourceAutoConfiguration.class}) 無(wú)法生效
 datasource:
  dynamic:
   primary: master #設(shè)置默認(rèn)的數(shù)據(jù)源或者數(shù)據(jù)源組,默認(rèn)值即為master，如果讀者只是單數(shù)據(jù)源只需要注釋掉slave相關(guān)配置即可，這里為了方便演示master與slave保持相同
   datasource:
    master:
     url: jdbc:mysql://localhost:3306/test?serverTimezone=Hongkong&allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&useSSL=false # serverTimezone=Hongkong 需要填上時(shí)區(qū)
     username: root
     password: 111111
     driverClassName: com.mysql.cj.jdbc.Driver
    slave:
     url: jdbc:mysql://localhost:3306/test?serverTimezone=Hongkong&allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&useSSL=false # serverTimezone=Hongkong 需要填上時(shí)區(qū)
     username: root
     password: 111111
     driverClassName: com.mysql.cj.jdbc.Driver
   initial-size: 10 # 以下是連接池配置
   max-active: 100
   min-idle: 10
   max-wait: 60000
   pool-prepared-statements: true
   max-pool-prepared-statement-per-connection-size: 20
   time-between-eviction-runs-millis: 60000
   min-evictable-idle-time-millis: 300000
   #validation-query: SELECT 1
   test-while-idle: true
   test-on-borrow: false
   test-on-return: false
   stat-view-servlet:
    enabled: true
    url-pattern: /druid/*
    login-username: druid
    login-password: 123456
   filter:
    stat:
     log-slow-sql: true
     slow-sql-millis: 1000
     merge-sql: false
    wall:
     config:
      multi-statement-allow: true



#mybatis plus
mybatis-plus:
 mapper-locations: classpath:mapper/**/*.xml
 #實(shí)體掃描，多個(gè)package用逗號(hào)或者分號(hào)分隔
 typeAliasesPackage: com.example.mybatisplus.entity
 check-config-location: true
 configuration:
  #是否開啟自動(dòng)駝峰命名規(guī)則（camel case）映射
  map-underscore-to-camel-case: true
  #全局地開啟或關(guān)閉配置文件中的所有映射器已經(jīng)配置的任何緩存
  cache-enabled: false
  call-setters-on-nulls: true
  #配置JdbcTypeForNull, oracle數(shù)據(jù)庫(kù)必須配置
  jdbc-type-for-null: 'null'
  #MyBatis 自動(dòng)映射時(shí)未知列或未知屬性處理策略 NONE：不做任何處理 (默認(rèn)值), WARNING：以日志的形式打印相關(guān)警告信息, FAILING：當(dāng)作映射失敗處理，并拋出異常和詳細(xì)信息
  auto-mapping-unknown-column-behavior: warning
 global-config:
  banner: false
  db-config:
   #主鍵類型 0:"數(shù)據(jù)庫(kù)ID自增", 1:"未設(shè)置主鍵類型",2:"用戶輸入ID (該類型可以通過(guò)自己注冊(cè)自動(dòng)填充插件進(jìn)行填充)", 3:"全局唯一ID (idWorker), 4:全局唯一ID (UUID), 5:字符串全局唯一ID (idWorker 的字符串表示)";
   id-type: UUID
   #字段驗(yàn)證策略 IGNORED:"忽略判斷", NOT_NULL:"非NULL判斷", NOT_EMPTY:"非空判斷", DEFAULT 默認(rèn)的,一般只用于注解里(1. 在全局里代表 NOT_NULL,2. 在注解里代表 跟隨全局)
   field-strategy: NOT_EMPTY
   #數(shù)據(jù)庫(kù)大寫下劃線轉(zhuǎn)換
   capital-mode: true
   #邏輯刪除值
   logic-delete-value: 0
   #邏輯未刪除值
   logic-not-delete-value: 1

server:
 port: 7000

3.修改啟動(dòng)類

MybatisplusSpringbootApplication.java

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;

@SpringBootApplication(exclude= {DataSourceAutoConfiguration.class}) //去掉springboot 默認(rèn)的數(shù)據(jù)源配置
@MapperScan("com.example.mybatisplus.mapper") //掃描mapper的包，或者讀者可以在對(duì)應(yīng)的mapper上加上@Mapper的注解
public class MybatisplusSpringbootApplication {

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

4.編寫實(shí)體

4.1 user.java

import lombok.Data;
/**
 * user 實(shí)體類
 */
@Data
public class User {
  private String id;
  private String name;
  private Integer age;
  private String email;
}

注：讀者請(qǐng)自行在開發(fā)工具安裝lombok插件，或者去掉@data注解換成setter getter方法即可

4.2 UserMapper.java

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.mybatisplus.entity.User;

/**
 * 用戶mapper
 */
@DS("slave") //這里是配置數(shù)據(jù)源注解，默認(rèn)是master
public interface UserMapper extends BaseMapper<User> {
}

三、編寫測(cè)試用例

import com.example.mybatisplus.entity.User;
import com.example.mybatisplus.mapper.UserMapper;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.List;

/**
 * 簡(jiǎn)單的測(cè)試增刪改查
 */
@RunWith(SpringRunner.class)
@SpringBootTest
public class MybatisplusSpringbootApplicationTests {


  @Autowired
  private UserMapper userMapper;

  @Test
  public void addUser() {
    User user = new User();
    user.setAge(200);
    user.setEmail("belonghuang@outlook.com");
    user.setName("belongHuang");
    userMapper.insert(user);
  }

  @Test
  public void updateUser() {
    User user = userMapper.selectById(1);
    user.setAge(300);
    int i = userMapper.updateById(user);
    if (i>0) {
      System.out.println("修改成功");
    }else {
      System.out.println("修改失敗");
    }
  }

  @Test
  public void deleteUser() {
    int i = userMapper.deleteById(1);
    if (i>0) {
      System.out.println("刪除成功");
    }else {
      System.out.println("刪除失敗");
    }
  }
  @Test
  public void selectUser() {
    List<User> users = userMapper.selectList(null);
    users.stream().map(User::getName).forEach(System.out::println);//打印出所用用戶名字
  }
}

本文側(cè)重點(diǎn)于集成，更多功能移步至官網(wǎng)。

到此這篇關(guān)于springboot集成mybatisPlus+多數(shù)據(jù)源的實(shí)現(xiàn)示例的文章就介紹到這了,更多相關(guān)springboot mybatisPlus多數(shù)據(jù)源內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！

您可能感興趣的文章: