該項(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)：

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)類，編寫(xiě)實(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.編寫(xiě)配置

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 plusmybatis-plus: mapper-locations: classpath:mapper/**/*.xml #實(shí)體掃描，多個(gè)package用逗號(hào)或者分號(hào)分隔 typeAliasesPackage: com.example.mybatisplus.entity check-config-location: true configuration: #是否開(kāi)啟自動(dòng)駝峰命名規(guī)則（camel case）映射 map-underscore-to-camel-case: true #全局地開(kāi)啟或關(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ù)大寫(xiě)下劃線轉(zhuǎn)換 capital-mode: true #邏輯刪除值 logic-delete-value: 0 #邏輯未刪除值 logic-not-delete-value: 1server: 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.編寫(xiě)實(shí)體

4.1 user.java

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

注：讀者請(qǐng)自行在開(kāi)發(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)是masterpublic interface UserMapper extends BaseMapper<User> {}三、編寫(xiě)測(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)@SpringBootTestpublic 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)搜索好吧啦網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持好吧啦網(wǎng)！