jdbcTemplete 模板配合多数据源的使用

配置

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);
	}
}