SpringBoot学习之MyBatis多数据源

配置application.properties文件

spring.datasource.one.jdbcUrl=jdbc:mysql://localhost:3306/test?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=UTF-8
spring.datasource.one.username=root
spring.datasource.one.password=123456

spring.datasource.two.jdbcUrl=jdbc:mysql://localhost:3306/test01?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=UTF-8
spring.datasource.two.username=root
spring.datasource.two.password=123456

新建实体类User

package org.hx.springboot_mybatismuitl_demo28.model;

public class User {
    private Integer id;
    private String name;
    private String passwd;

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

    public Integer getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPasswd() {
        return passwd;
    }

    public void setPasswd(String passwd) {
        this.passwd = passwd;
    }
}

新建数据源配置类DataSourceConfig

package org.hx.springboot_mybatismuitl_demo28.config;

import com.zaxxer.hikari.HikariDataSource;
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 dataSourceOne(){
        return new HikariDataSource();
    }
    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.two")
    DataSource dataSourceTwo(){
        return new HikariDataSource();
    }
}

新建数据源一的配置类MyBatisConfigOne

package org.hx.springboot_mybatismuitl_demo28.config;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;

@Configuration

@MapperScan(basePackages = "org.hx.springboot_mybatismuitl_demo28.mapper1",sqlSessionFactoryRef = "sqlSessionFactory1",sqlSessionTemplateRef = "sqlSessionTemplate1")
public class MyBatisConfigOne {
    @Autowired
    @Qualifier("dataSourceOne")
    DataSource dataSource;
    @Bean
    SqlSessionFactory sqlSessionFactory1(){
        SqlSessionFactory sqlSessionFactory = null;
        try {
            SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
            sqlSessionFactoryBean.setDataSource(dataSource);
            sqlSessionFactory=sqlSessionFactoryBean.getObject();
            return sqlSessionFactory;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return sqlSessionFactory;
    }
    @Bean
    SqlSessionTemplate sqlSessionTemplate1(){
        return new SqlSessionTemplate(sqlSessionFactory1());
    }
}

新建数据源二的配置类MyBatisConfigTwo

package org.hx.springboot_mybatismuitl_demo28.config;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;

@Configuration
@MapperScan(basePackages = "org.hx.springboot_mybatismuitl_demo28.mapper2",sqlSessionFactoryRef = "sqlSessionFactory2",sqlSessionTemplateRef = "sqlSessionTemplate2")
public class MyBatisConfigTwo {
    @Autowired
    @Qualifier("dataSourceTwo")
    DataSource dataSource;
    @Bean
    SqlSessionFactory sqlSessionFactory2(){
        SqlSessionFactory sqlSessionFactory = null;
        try {
            SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
            sqlSessionFactoryBean.setDataSource(dataSource);
            sqlSessionFactory=sqlSessionFactoryBean.getObject();
            return sqlSessionFactory;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return sqlSessionFactory;
    }
    @Bean
    SqlSessionTemplate sqlSessionTemplate2(){
        return new SqlSessionTemplate(sqlSessionFactory2());
    }
}

新建UserMapper1接口和UserMapper1.xml

package org.hx.springboot_mybatismuitl_demo28.mapper1;

import org.apache.ibatis.annotations.Mapper;
import org.hx.springboot_mybatismuitl_demo28.model.User;

import java.util.List;

public interface UserMapper1 {
    List<User> getAllUsers();

}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.hx.springboot_mybatismuitl_demo28.mapper1.UserMapper1">
    <select id="getAllUsers" resultType="org.hx.springboot_mybatismuitl_demo28.model.User">
        select * from t1;
    </select>
</mapper>

新建UserMapper2接口和UserMapper2.xml文件

package org.hx.springboot_mybatismuitl_demo28.mapper2;

import org.apache.ibatis.annotations.Mapper;
import org.hx.springboot_mybatismuitl_demo28.model.User;

import java.util.List;
public interface UserMapper2 {
    List<User> getAllUsers();

}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.hx.springboot_mybatismuitl_demo28.mapper2.UserMapper2">
    <select id="getAllUsers" resultType="org.hx.springboot_mybatismuitl_demo28.model.User">
        select * from user;
    </select>
</mapper>

在pom.xml文件中配置，使项目运行时能扫描到src/main/java下的xml文件

<build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
            </resource>
        </resources>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

在测试类中进行测试

package org.hx.springboot_mybatismuitl_demo28;

import org.hx.springboot_mybatismuitl_demo28.mapper1.UserMapper1;
import org.hx.springboot_mybatismuitl_demo28.mapper2.UserMapper2;
import org.hx.springboot_mybatismuitl_demo28.model.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;

@SpringBootTest
class SpringbootMybatismuitlDemo28ApplicationTests {

    @Autowired
    UserMapper1 userMapper1;

    @Autowired
    UserMapper2 userMapper2;
    @Test
    void contextLoads() {
        System.out.println(userMapper1.getAllUsers());
        System.out.println(userMapper2.getAllUsers());
    }

}