微人事第五天：springboot整合JdbcTemplate多数据源

之前用JdbcTemplate对一个数据库中的一张表进行crud操作，现在需要连接两个数据库对两个数据库中的表进行crud操作。
1.创建springboot项目
这里和操作一张表的做法是一样的：修改mysql版本，增加连接池依赖等等…

2.创建实体类user
确保数据库中的字段和类中的属性名保持一致。

package org.javaboy.jdbctemplate2.bean;

public class User {
    private Integer id;
    private String username;
    private String address;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", address='" + address + '\'' +
                '}';
    }
}

3.数据库连接信息
因为这里要连接两个数据库所以要用one和two来区分

spring.datasource.one.url=jdbc:mysql://127.0.0.1:3306/javaboy?characterEncoding=UTF-8
spring.datasource.one.username=root
spring.datasource.one.password=root
spring.datasource.one.driver-class-name=com.mysql.jdbc.Driver

spring.datasource.two.url=jdbc:mysql://127.0.0.1:3306/javaboy2?characterEncoding=UTF-8
spring.datasource.two.username=root
spring.datasource.two.password=root
spring.datasource.two.driver-class-name=com.mysql.jdbc.Driver

4.DataSource和JdbcTemplate配置
因为连接数据库信息是自定义配置的，所以springboot自动为我们配置的DataSource和JdbcTemplate就失效了，所以现在要来配置这两项

package org.javaboy.jdbctemplate2.config;

import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;


@Configuration
public class DataSourceConfig {

    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.one")
    DataSource dsOne() {
        return  DruidDataSourceBuilder.create().build();
    }

    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.two")
    DataSource dsTwo() {
        return  DruidDataSourceBuilder.create().build();
    }
}

package org.javaboy.jdbctemplate2.config;

import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.core.JdbcTemplate;

import javax.sql.DataSource;

//配置JdbcTemplate
@Configuration
public class JdbcTemplateConfig {

    @Bean
    JdbcTemplate jdbcTemplateOne(@Qualifier("dsOne") DataSource dsOne) {
        return new JdbcTemplate(dsOne);
    }

    @Bean
    JdbcTemplate jdbcTemplateTwo(@Qualifier("dsTwo") DataSource dsTwo) {
        return new JdbcTemplate(dsTwo);
    }
}

5.测试类

package org.javaboy.jdbctemplate2;

import org.javaboy.jdbctemplate2.bean.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

import javax.annotation.Resource;
import java.util.List;

@SpringBootTest
class Jdbctemplate2ApplicationTests {

    @Autowired
    @Qualifier("jdbcTemplateOne")
    JdbcTemplate jdbcTemplateOne;

    @Resource(name = "jdbcTemplateTwo")
    JdbcTemplate jdbcTemplateTwo;

    @Test
    void contextLoads() {
        List<User> query = jdbcTemplateOne.query("select * from user", new BeanPropertyRowMapper<>(User.class));
        for (User user : query) {
            System.out.println(user);
        }

        List<User> query2 = jdbcTemplateTwo.query("select * from user", new BeanPropertyRowMapper<>(User.class));
        for (User user : query2) {
            System.out.println(user);
        }
    }

}

查询成功