package com.icil.report.config;

import javax.sql.DataSource;

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;

@Configuration

public class DataSourceConfig {

    @Bean(name = "primaryDataSource")

    @Qualifier("primaryDataSource")//原博主这里加上@Qualify 没有必要 删了也没有影响

    @ConfigurationProperties("jdbc.datasource.edi")

    public DataSource primaryDataSource() {

        return DataSourceBuilder.create().build();

    }

//    @Primary

    @Bean(name = "secondaryDataSource")

    @Qualifier("secondaryDataSource") //原博主这里加上@Qualify 没有必要 删了也没有影响

    @ConfigurationProperties("jdbc.datasource.booking")

    public DataSource secondaryDataSource() {

        return DataSourceBuilder.create().build();

    }

    /**

     * @param dataSource

     * @return

     * @Bean明确地指示了一种方法，什么方法呢——产生一个bean的方法， 并且交给Spring容器管理；从这我们就明白了为啥@Bean是放在方法的注释上了，

     * 因为它很明确地告诉被注释的方法，你给我产生一个Bean，然后交给Spring容器，

     * 实现依赖注入

     */

    @Bean(name = "primaryJdbcTemplate")

    public JdbcTemplate primaryTemplate(@Qualifier("primaryDataSource") DataSource dataSource) {

        return new JdbcTemplate(dataSource);

    }

    @Bean(name = "secondaryJdbcTemplate")

    public JdbcTemplate secondaryTemplate(@Qualifier("secondaryDataSource") DataSource dataSource) {

        return new JdbcTemplate(dataSource);

    }

}

### database EDI configure

jdbc.datasource.edi.jdbc-url=jdbc:mysql:///EDI

jdbc.datasource.edi.driverClassName=com.mysql.cj.jdbc.Driver

jdbc.datasource.edi.username=root

jdbc.datasource.edi.password=hhaa

jdbc.datasource.edi.sql-script-encoding=UTF-

### database booking configure

jdbc.datasource.booking.jdbc-url=jdbc:mysql:///booking

jdbc.datasource.booking.driverClassName=com.mysql.cj.jdbc.Driver

jdbc.datasource.booking.username=root

jdbc.datasource.booking.password=hahahaha

jdbc.datasource.booking.sql-script-encoding=UTF-

package top.zekk.twodatasource;

import org.junit.Assert;

import org.junit.Before;

import org.junit.Test;

import org.junit.runner.RunWith;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.beans.factory.annotation.Qualifier;

import org.springframework.boot.test.context.SpringBootTest;

import org.springframework.context.annotation.Bean;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.test.context.junit4.SpringRunner;

@RunWith(SpringRunner.class)

@SpringBootTest

public class TwoDatasourceApplicationTests {

    @Autowired

    /*@Qualify 多个同类型bean?存在时  Spring不知道应该绑定哪个实现类

    指定绑定的类名@Bean(name="**")

    */

    @Qualifier("primaryJdbcTemplate")

    protected JdbcTemplate jdbcTemplate1;

    @Autowired

    //@Qualify 多个同类型bean?存在时 指定绑定的类名@Bean(name="**")

    @Qualifier("secondaryJdbcTemplate")

    protected JdbcTemplate jdbcTemplate2;

    @Before //首先执行清空数据库操作

    public void setUp(){

        jdbcTemplate1.update("DELETE FROM USER ");

        jdbcTemplate2.update("DELETE FROM USER ");

    }

    @Test

    public void test(){

        jdbcTemplate1.update

                ("INSERT INTO USER (id,name,age) VALUES (?,?,?)",,"aaa",);

        jdbcTemplate2.update

                ("INSERT INTO USER (id,name,age) VALUES (?,?,?)",,"bbb",);

        jdbcTemplate2.update

                ("INSERT INTO USER (id,name,age) VALUES (?,?,?)",,"bbb",);

        Assert.assertEquals("",jdbcTemplate1.queryForObject("select count(1) from user",String.class));

        Assert.assertEquals("",jdbcTemplate2.queryForObject("select count(1) from user",String.class));

    }

}