當前位置：首頁 > 编程资源 > 编程问答 >内容正文

编程问答

springboot简易集成mybatisPlus+多数据源

發布時間：2025/3/21 编程问答 20 豆豆

生活随笔收集整理的這篇文章主要介紹了 springboot简易集成mybatisPlus+多数据源小編覺得挺不錯的,現在分享給大家,幫大家做個參考.

該項目主要實現mybatisplus、多數據源、lombok、druid的集成
主要參考?https://mp.baomidou.com/guide/quick-start.html
項目地址：https://github.com/Blankwhiter/mybatisplus-springboot?release1.0
項目結構：

一、創建表以及測試數據

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');

二、引入項目依賴，加入配置，修改啟動類，編寫實體類和mapper對象（讀者可以根據自動生成工具生成這塊代碼）

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/> </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}) 無法生效datasource:dynamic:primary: master #設置默認的數據源或者數據源組,默認值即為master，如果讀者只是單數據源只需要注釋掉slave相關配置即可，這里為了方便演示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 需要填上時區username: rootpassword: 111111driverClassName: com.mysql.cj.jdbc.Driverslave:url: jdbc:mysql://localhost:3306/test?serverTimezone=Hongkong&allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&useSSL=false # serverTimezone=Hongkong 需要填上時區username: rootpassword: 111111driverClassName: com.mysql.cj.jdbc.Driverinitial-size: 10 # 以下是連接池配置max-active: 100min-idle: 10max-wait: 60000pool-prepared-statements: truemax-pool-prepared-statement-per-connection-size: 20time-between-eviction-runs-millis: 60000min-evictable-idle-time-millis: 300000#validation-query: SELECT 1test-while-idle: truetest-on-borrow: falsetest-on-return: falsestat-view-servlet:enabled: trueurl-pattern: /druid/*login-username: druidlogin-password: 123456filter:stat:log-slow-sql: trueslow-sql-millis: 1000merge-sql: falsewall:config:multi-statement-allow: true#mybatis plus mybatis-plus:mapper-locations: classpath:mapper/**/*.xml#實體掃描，多個package用逗號或者分號分隔typeAliasesPackage: com.example.mybatisplus.entitycheck-config-location: trueconfiguration:#是否開啟自動駝峰命名規則（camel case）映射map-underscore-to-camel-case: true#全局地開啟或關閉配置文件中的所有映射器已經配置的任何緩存cache-enabled: falsecall-setters-on-nulls: true#配置JdbcTypeForNull, oracle數據庫必須配置jdbc-type-for-null: 'null'#MyBatis 自動映射時未知列或未知屬性處理策略 NONE：不做任何處理 (默認值), WARNING：以日志的形式打印相關警告信息, FAILING：當作映射失敗處理，并拋出異常和詳細信息auto-mapping-unknown-column-behavior: warningglobal-config:banner: falsedb-config:#主鍵類型 0:"數據庫ID自增", 1:"未設置主鍵類型",2:"用戶輸入ID (該類型可以通過自己注冊自動填充插件進行填充)", 3:"全局唯一ID (idWorker), 4:全局唯一ID (UUID), 5:字符串全局唯一ID (idWorker 的字符串表示)";id-type: UUID#字段驗證策略 IGNORED:"忽略判斷", NOT_NULL:"非NULL判斷", NOT_EMPTY:"非空判斷", DEFAULT 默認的,一般只用于注解里(1. 在全局里代表 NOT_NULL,2. 在注解里代表跟隨全局)field-strategy: NOT_EMPTY#數據庫大寫下劃線轉換capital-mode: true#邏輯刪除值logic-delete-value: 0#邏輯未刪除值logic-not-delete-value: 1server:port: 7000

3.修改啟動類

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 默認的數據源配置 @MapperScan("com.example.mybatisplus.mapper") //掃描mapper的包，或者讀者可以在對應的mapper上加上@Mapper的注解 public class MybatisplusSpringbootApplication {public static void main(String[] args) {SpringApplication.run(MybatisplusSpringbootApplication.class, args);}}

4.編寫實體

4.1?user.java

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

注：讀者請自行在開發工具安裝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") //這里是配置數據源注解，默認是master public interface UserMapper extends BaseMapper<User> { }

三、編寫測試用例

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;/*** 簡單的測試增刪改查*/ @RunWith(SpringRunner.class) @SpringBootTest public class MybatisplusSpringbootApplicationTests {@Autowiredprivate UserMapper userMapper;@Testpublic void addUser() {User user = new User();user.setAge(200);user.setEmail("belonghuang@outlook.com");user.setName("belongHuang");userMapper.insert(user);}@Testpublic 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("修改失敗");}}@Testpublic void deleteUser() {int i = userMapper.deleteById(1);if (i>0) {System.out.println("刪除成功");}else {System.out.println("刪除失敗");}}@Testpublic void selectUser() {List<User> users = userMapper.selectList(null);users.stream().map(User::getName).forEach(System.out::println);//打印出所用用戶名字}}

本文側重點于集成，更多功能移步至官網。

總結

以上是生活随笔為你收集整理的springboot简易集成mybatisPlus+多数据源的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。

上一篇： tensorflow之过拟合问题实战
下一篇：孙正义看未来30年：投资趋势，永远不会错