spring.datasource.druid.master.url= jdbc:postgresql://localhost:5432/test1?useUnicode=true&characterEncoding=UTF-8spring.datasource.druid.master.username =postgres spring.datasource.druid.master.password= 123456spring.datasource.druid.master.driver-class-name =org.postgresql.Driver spring.datasource.druid...
spring.datasource.druid.testWhileIdle=true spring.datasource.druid.testOnBorrow=false spring.datasource.druid.testOnReturn=false spring.datasource.druid.webStatFilter.enabled=true spring.datasource.druid.statViewServlet.enabled=true spring.datasource.druid.statViewServlet.allow= spring.datasource.druid.statV...
DruidDataSource dataSource = new DruidDataSource(); dataSource.setUrl(dataSourceProperties.get("url")); dataSource.setUsername(dataSourceProperties.get("username")); dataSource.setPassword(dataSourceProperties.get("password")); dataSource.setDriverClassName(dataSourceProperties.get("driver-class-name...
username: root password:123456#从库数据源slave:#名称可以自定义,但是要记得代码里保持一致enabled:true#这属性不是必须的,但是建议加上,方便切换url: jdbc:mysql://localhost:3306/db username: root password:123456 2.在DataSourceType类添加数据源枚举 publicenumDataSourceType { MASTER, SLAVE//和druid.yml文...
String sql = "select id,name,age from user"; // 数据库连接 DruidDataSource druidDataSource = JDBCUtils.getDruidDataSource(ds); JdbcTemplate jdbcTemplate = new JdbcTemplate(druidDataSource); List<Map<String, Object>> select = jdbcTemplate.queryForList(sql); 2、 JDBCUtils package com.guor....
spring.datasource.druid.master.driver-class-name=com.mysql.jdbc.Driver spring.datasource.druid.master.url=jdbc:mysql://localhost/product_master?useSSL=falsespring.datasource.druid.master.port=3306spring.datasource.druid.master.username=root
<artifactId>druid-spring-boot-starter</artifactId> <version>1.1.10</version> </dependency> 2、 配置文件: 1.spring.datasource.dynamic前缀,是baomidou源码里固定的; 2.first、second是自定义的名称,可以更改; # 多数据源配置,默认master spring.datasource.dynamic.primary = first ...
*/MASTER,/** * slave */SLAVE} 创建com.zhlab.demo.config.properties包,并创建DruidProperties.java类,用来获取连接池属性,并设置到数据源中 packagecom.zhlab.demo.config.properties;importcom.alibaba.druid.pool.DruidDataSource;importorg.springframework.beans.factory.annotation.Value;importorg.springframework...
spring:datasource:druid:initial-size:10max-active:100min-idle:3max-wait:5000pool-prepared-statements:truemax-pool-prepared-statement-per-connection-size:100dynamic:primary:master #设置默认的数据源或者数据源组,默认值即为master strict:false#设置严格模式,默认false不启动.启动后在未匹配到指定数据源时候会...
spring: application: name: share datasource: dynamic: primary: db1 # 配置默认...