网站和新媒体建设管理办法,有没有免费的企业邮箱,电商网站项目,黄页网站推广效果怎么样又参加了一个新的项目#xff0c;虽然是去年做的项目#xff0c;拿来复用改造#xff0c;但是也学到了很多。这个项目会用到其他项目的数据#xff0c;如果调用他们的接口取数据#xff0c;我还是觉得太麻烦了。打算直接配置多数据源。
然后去另一个数据库系统中取出数据…又参加了一个新的项目虽然是去年做的项目拿来复用改造但是也学到了很多。这个项目会用到其他项目的数据如果调用他们的接口取数据我还是觉得太麻烦了。打算直接配置多数据源。
然后去另一个数据库系统中取出数据。
所以就去了解和学习了一下
druid和dynamic配合的多数据源用起来还是挺简单的
?xml version1.0 encodingUTF-8?
project xmlnshttp://maven.apache.org/POM/4.0.0xmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsdmodelVersion4.0.0/modelVersiongroupIdorg.example/groupIdartifactIddsjyTest/artifactIdversion1.0-SNAPSHOT/versionparentgroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-parent/artifactIdversion2.7.8/versionrelativePath//parentdependenciesdependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus-boot-starter/artifactIdversion3.5.3.1/version/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter/artifactId/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId/dependency!-- druid连接池 --dependencygroupIdcom.alibaba/groupIdartifactIddruid-spring-boot-starter/artifactIdversion1.1.22/version/dependency!-- mysql驱动--dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.29/version/dependency!-- dynamic多数据源 --dependencygroupIdcom.baomidou/groupIdartifactIddynamic-datasource-spring-boot-starter/artifactIdversion3.1.1/version/dependencydependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdversion1.18.30/version/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactIdversion2.7.17/version/dependency/dependenciespropertiesmaven.compiler.source8/maven.compiler.sourcemaven.compiler.target8/maven.compiler.targetproject.build.sourceEncodingUTF-8/project.build.sourceEncoding/properties/project
v
然后就是写application
spring:datasource:dynamic:#默认主库平时默认查询这个库primary: masterstrict: falsedatasource:#数据源名称1master:type: com.alibaba.druid.pool.DruidDataSourcedriver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://192.168.126.153:3306/dsjy?useUnicodetruecharacterEncodingutf-8useSSLtrueserverTimezoneUTCusername: rootpassword: 123456#数据源名称2device:type: com.alibaba.druid.pool.DruidDataSourcedriver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://127.0.0.1:3306/test?useUnicodetruecharacterEncodingutf-8useSSLtrueserverTimezoneUTCusername: rootpassword: 123456就是配置两个数据库信息后续使用DS(数据源名称)
将数据源配置到bean中
package com.dsjy.config;import javax.annotation.Resource;
import javax.sql.DataSource;import org.springframework.boot.SpringBootConfiguration;
import org.springframework.boot.autoconfigure.AutoConfigureBefore;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;import com.baomidou.dynamic.datasource.DynamicRoutingDataSource;
import com.baomidou.dynamic.datasource.provider.DynamicDataSourceProvider;
import com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceAutoConfiguration;
import com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceProperties;/*** 动态数据源配置** author admin*/
Configuration
AutoConfigureBefore({DynamicDataSourceAutoConfiguration.class, SpringBootConfiguration.class})
public class DataSourceConfiguration {Resourceprivate DynamicDataSourceProperties properties;/*** 将动态数据源设置为首选的* 当spring存在多个数据源时, 自动注入的是首选的对象*/PrimaryBeanpublic DataSource dataSource(DynamicDataSourceProvider dynamicDataSourceProvider) {DynamicRoutingDataSource dataSource new DynamicRoutingDataSource();dataSource.setPrimary(properties.getPrimary());dataSource.setStrict(properties.getStrict());dataSource.setStrategy(properties.getStrategy());dataSource.setProvider(dynamicDataSourceProvider);dataSource.setP6spy(properties.getP6spy());dataSource.setSeata(properties.getSeata());return dataSource;}}
druid监控页面配置
package com.dsjy.config;import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;import javax.sql.DataSource;
import java.util.Arrays;
import java.util.HashMap;
import java.util.Map;Configuration
public class DruidConfig {/*** 配置Druid的监控* 配置一个管理后台的Servlet* return*/Beanpublic ServletRegistrationBean statViewServlet(){ServletRegistrationBean bean new ServletRegistrationBean(new StatViewServlet(), /druid/*);MapString, String initParams new HashMap(4);//配置druid页面监控的账户密码initParams.put(loginUsername, sh);initParams.put(loginPassword,123456);bean.setInitParameters(initParams);return bean;}/*** 配置一个web监控的filter* return*/Beanpublic FilterRegistrationBean webStatFilter(){FilterRegistrationBean bean new FilterRegistrationBean();bean.setFilter(new WebStatFilter());MapString, String initParams new HashMap(16);initParams.put(exclusions,*.js,*.css,/druid/*);bean.setInitParameters(initParams);bean.setUrlPatterns(Arrays.asList(/*));return bean;}
}配置了druid之后项目运行起来就能访问,http://127.0.0.1:8080/druid,可以看见有两个数据源可以使用。 package com.dsjy.mapper;import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dsjy.entity.UserEntity;/*** program: springBoot* author: quxiao* create: 2024-06-12 15:36**/
public interface UserMapper extends BaseMapperUserEntity {DS(master)String selectNumber1();DS(device)String selectNumber2();
}使用DS(数据源名称) 就能指定使用某一个数据源。还可以使用
