1. SpringBoot uses MyBatisPlus configuration

1. baomidou dynamic data source (@DS)

Thinking:

1. Introducing dependencies

2. Modify Application.yml to configure multiple data source information

3. Use @DS to switch data sources

1.1, import dependencies

com.baomidoudynamic-datasource-spring-boot-starter3.2.1

1.2, configuration file

spring:# Data source configuration itemsautoconfigure:exclude:- com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # Exclude Druid's automatic configuration, use dynamic-datasource-spring-boot-starter to configure multiple data sourcesdatasource:druid: # Druid [monitoring] related global configurationweb-stat-filter:enabled: truestat-view-servlet:enabled: trueallow: # Set a whitelist, if not filled, all access is allowedurl-pattern: /druid/*login-username: # Console management username and passwordlogin-password:filter:stat:enabled: truelog-slow-sql: true # slow SQL loggingslow-sql-millis: 100merge-sql: truewall:config:multi-statement-allow: truedynamic: # Multiple data source configurationdruid: # Druid [connection pool] related global configurationinitial-size: 5 # initial number of connectionsmin-idle: 10 # Minimum number of connection poolsmax-active: 20 # maximum number of connection poolsmax-wait: 600000 # Configure the timeout time for obtaining a connection, in millisecondstime-between-eviction-runs-millis: 60000 # Configure how long the interval is to be checked to detect idle connections that need to be closed, unit: millisecondsmin-evictable-idle-time-millis: 300000 # Configure the minimum lifetime of a connection in the pool, in millisecondsmax-evictable-idle-time-millis: 900000 # Configure the maximum lifetime of a connection in the pool, in milliseconds# validation-query: SELECT 1 FROM DUAL # Configure to check whether the connection is validtest-while-idle: truetest-on-borrow: falsetest-on-return: false# Set the default data source or data source group, the default value is masterprimary: masterdatasource:# main data sourcemaster:name: lc_mono_camasurl: jdbc:mysql://10.1.102.24:3306/${spring.datasource.dynamic.datasource.master.name}?useSSL=false&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=CTTdriver-class-name: com.mysql.jdbc.Driverusername: lc_mono_camaspassword: [email protected]_1706cmds_finger:name: cmds_finger# url: jdbc:sqlite:lib/tidefinger/cms_finger.db?date_string_format=yyyy-MM-dd HH:mm:ssurl: jdbc:sqlite:D:/lcProject/lc-mono-camas-java/lc-camas/lib/cms_finger.db?date_string_format=yyyy-MM-dd HH:mm:ssdriver-class-name: org.sqlite.JDBCusername:password:

1.3. Use @DS to switch data sources

 @DS("cmds_finger")public List selectAll(JSONObject reqJson) {return tideTideMapper.selectAll(reqJson);}

2, @DS annotation description

Usage of @DS

@DS can annotate on methods, classes, interfaces, and enumerations.

FAQ:When it comes to switching data sources,

1. Transactions cannot be used, otherwise the data source will not be switched, and the data source loaded for the first time is still used.

Delete the @Transactional() annotation on the method or class or interface that operates multiple data sources.

2. After the data source loaded for the first time, operate other data sources for the second time (third time...), if the data source does not exist, use the data source loaded for the first time

3. The data source name should not contain a glide line, and the data source of the glide line cannot be switched

Second, bean configuration