項目中用到，學習了一下，記錄下來，先回用，再搞懂原理

架構

springboot+mybatis+mysql連接池（springboot默認的HikariCP）

?配置點

1.就目錄里的DataSourceConfigBackup和DataSourceConfigMaster，以第一個舉例

package com.faith.twodatabase.configuration;import com.zaxxer.hikari.HikariDataSource; import org.apache.ibatis.session.SqlSessionFactory; import org.mybatis.spring.SqlSessionFactoryBean; import org.mybatis.spring.SqlSessionTemplate; import org.mybatis.spring.annotation.MapperScan; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.boot.context.properties.ConfigurationProperties; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.context.annotation.Primary; import org.springframework.core.io.support.PathMatchingResourcePatternResolver;import javax.sql.DataSource;@Configuration @MapperScan(basePackages = {"com.faith.twodatabase.mapper.master"}, sqlSessionFactoryRef = "masterSqlSessionFactory") public class DataSourceConfigMaster {@Primary@ConfigurationProperties(prefix = "spring.datasource.master")@Bean(name = "masterDataSource")public HikariDataSource dataSource() {return new HikariDataSource();}@Primary@Bean(name = "masterSqlSessionFactory")public SqlSessionFactory sqlSessionFactory(@Qualifier("masterDataSource") DataSource dataSource) throws Exception {SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();// 指定這個 mapper 文件的位置sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResource("classpath:mapper/master/ProductConfigMapper.xml"));sqlSessionFactoryBean.setDataSource(dataSource);return sqlSessionFactoryBean.getObject();}/* @Primary@Bean("masterSqlSessionTemplate")public SqlSessionTemplate db1SqlSessionTemplate(@Qualifier("masterSqlSessionFactory") SqlSessionFactory sqlSessionFactory) {return new SqlSessionTemplate(sqlSessionFactory);}*/}

網上帖子說還要配置SqlSessionTemplate，就是注釋掉的部分，其實就是定制化一下此連接池使用的mybatis的SqlSessionTemplate而已，不配置就是Mybatis默認的，我用默認的表示兩個不同的連接池公用一個相同的SqlSessionTemplate，用過了，沒什么問題。

2.yaml配置兩個連接池

# 應用名稱 spring:application:name: twodatabase# 數據庫驅動：datasource:# 數據源名稱master:type: com.zaxxer.hikari.HikariDataSourcejdbc-url: jdbc:mysql://192.168.228.140:3306/mysql?useSSL=false&characterEncoding=utf-8&allowPublicKeyRetrieval=truedriver-class-name: com.mysql.cj.jdbc.Driverusername: rootpassword: rootminimum-idle: 1maximun-pool-size: 5auto-commit: trueidle-timeout: 60000pool-name: mastermax-lifetime: 1800000connection-timeout: 30000connection-test-query: select 1backup:type: com.zaxxer.hikari.HikariDataSourcejdbc-url: jdbc:mysql://192.168.228.132:3307/mysql?useSSL=false&characterEncoding=utf-8&allowPublicKeyRetrieval=truedriver-class-name: com.mysql.cj.jdbc.Driverusername: rootpassword: rootminimum-idle: 1maximun-pool-size: 5auto-commit: trueidle-timeout: 60000pool-name: backupmax-lifetime: 1800000connection-timeout: 30000connection-test-query: select 1 server:port: 8080 mybatis:configuration:map-underscore-to-camel-case: true

3.再service層（有帖子說再Mapper層也可以）配置@DS注解，表明用哪個連接，以MasterService舉例

package com.faith.twodatabase.service;import com.baomidou.dynamic.datasource.annotation.DS; import com.faith.twodatabase.mapper.master.ProductConfigMapper; import com.faith.twodatabase.vo.ProductConfigVO; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;import java.util.List;@Service public class MasterService {@AutowiredProductConfigMapper productConfigMapper;@DS("masterDataSource")public List<ProductConfigVO> loadProductConfigs() {return productConfigMapper.selectALl();} }

DS注解是github上開源的組件，maven引進來就行了

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

分析一下原理

眾所周知，無論什么永久層框架，肯定是封裝的 jdbc 的連接，mybatis 也不能例外，只要是 jdbc，就逃不過這幾部：

1.實例化Driver

Driver driver = (Driver) Class.forName("com.mysql.cj.jdbc.Driver").newInstance();

2.獲取連接

String url = "jdbc:mysql://192.168.228.140:3306/mysql?useUnicode=true&characterEncoding=utf8&autoReconnect=true&useSSL=false";Properties properties = new Properties();properties.setProperty("user", "root");properties.setProperty("password", "root");connection = driver.connect(url, properties);

3.準備?PreparedStatement

PreparedStatement preparedStatement = connection.prepareStatement("select project_id from product_config");

4.執行

ResultSet resultSet = preparedStatement.executeQuery();

5.剩下的就是封裝 resultSet 了。

要切庫，一定是在第二步?driver.connect(url,properties)，根據不同的庫傳進來不同的url和properties，講道理，無論是用aop，asm，動態代理，javassist，肯定是在這里做了動態攔截進行更改了，@DS這個注解肯定是做了這方面的工作了?；仡^研究明白了更新博客。

總結

以上是生活随笔為你收集整理的springboot 配置双mysql数据库的全部內容，希望文章能夠幫你解決所遇到的問題。

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