配置
application.yml
spring:
datasource:
user:
driver-class-name : com.mysql.cj.jdbc.Driver
jdbc-url: jdbc:mysql://drdshbgadotr2wippublic.drds.aliyuncs.com:3306/user_center?useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true&allowMultiQueries=true&serverTimezone=Asia/Shanghai
username: maoxiaohao
password: VI16bEkQjB0ZHQBs
member:
driver-class-name : com.mysql.cj.jdbc.Driver
jdbc-url: jdbc:mysql://localhost:3306/member_center?useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true&allowMultiQueries=true&serverTimezone=Asia/Shanghai
username: ss
password: ss
config 中将模板加入bean
package com.guming.uuc.provider.move.config;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.jdbc.core.JdbcTemplate;
import javax.sql.DataSource;
@Configuration
public class DateSourceConfig {
@Bean(name = "primaryDataSource")
@Qualifier("primaryDataSource")
@ConfigurationProperties(prefix="spring.datasource.user")
public DataSource primaryDataSource() {
return DataSourceBuilder.create().build();
}
@Bean(name = "secondaryDataSource")
@Qualifier("secondaryDataSource")
@Primary
@ConfigurationProperties(prefix="spring.datasource.member")
public DataSource secondaryDataSource() {
return DataSourceBuilder.create().build();
}
@Bean(name="primaryJdbcTemplate")
public JdbcTemplate primaryJdbcTemplate (
@Qualifier("primaryDataSource") DataSource dataSource ) {
return new JdbcTemplate(dataSource);
}
@Bean(name="secondaryJdbcTemplate")
public JdbcTemplate secondaryJdbcTemplate(
@Qualifier("secondaryDataSource") DataSource dataSource) {
return new JdbcTemplate(dataSource);
}
}
使用jdbc模板
public class test{
@Autowrite
@Qualifier("primaryDataSource")
private JdbcTemplate jdbcTemplate;
public void test2(){
// 查询集合
jdbcTemplate.queryForList(“sql”,user.class);
}
}