springboot2.0配置多数据源

最新推荐文章于 2023-07-18 20:24:31 发布

赴前尘

最新推荐文章于 2023-07-18 20:24:31 发布

阅读量206

点赞数

分类专栏： Spring 文章标签： springboot mysql 多数据源

本文链接：https://blog.csdn.net/qq_36940806/article/details/91136889

版权

Spring 专栏收录该内容

9 篇文章 1 订阅

订阅专栏

一.mysql数据库测试脚本

CREATE DATABASE test01;
use  test01;
set password for root@localhost = password('a');

CREATE TABLE USER (
    id int PRIMARY KEY AUTO_INCREMENT,
    name varchar(20) NOT NULL,
    age int
    );
select * from user;


 CREATE DATABASE test02;
use  test02;
set password for root@localhost = password('a');

CREATE TABLE USER (
    id int PRIMARY KEY AUTO_INCREMENT,
    name varchar(20) NOT NULL,
    age int
    );
select * from user;

二.创建maven项目，命名以及项目目录结构如下图

三.项目源码

pom.xml依赖：

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>com.springboot</groupId>
	<artifactId>springboot-multipledatasources</artifactId>
	<version>0.0.1-SNAPSHOT</version>

	<!-- spring-boot-starter-parent 整合常用第三方框架依赖信息 -->
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.0.0.RELEASE</version>
	</parent>
	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter</artifactId>
			<!-- 这里省略了版本号，是因为在parent里面封装好了版本号 -->
		</dependency>
		<!-- 测试 -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<!-- 这里省略了版本号，是因为在parent里面封装好了版本号 -->
		</dependency>
		<!-- mybatis依赖 -->
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.1.1</version>
		</dependency>
		<!-- mysql依赖 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<!-- 这里省略了版本号，是因为在parent里面封装好了版本号 -->
		</dependency>
		<!-- springboot - web组件 -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
			<!-- 这里省略了版本号，是因为在parent里面封装好了版本号 -->
		</dependency>
		<!-- lombok插件 (注意:eclipse需要集成lombok插件，可自行百度) -->
		<dependency>
			<groupId>org.projectlombok</groupId>
			<artifactId>lombok</artifactId>
		</dependency>
	</dependencies>
</project>

application.properties文件内容：

###datasource1
spring.datasource.test01.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.test01.jdbc-url=jdbc:mysql://localhost:3306/test01
spring.datasource.test01.username=root
spring.datasource.test01.password=a


###datasource2
spring.datasource.test02.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.test02.jdbc-url=jdbc:mysql://localhost:3306/test02
spring.datasource.test02.username=root
spring.datasource.test02.password=a

MyBatisMultipleDataSourceController 类：

package com.springboot.controller;

/**
 * 多数据源测试
 */
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.springboot.entity.User;
import com.springboot.test01.service.UserServiceTest01;
import com.springboot.test02.service.UserServiceTest02;

@RestController
public class MyBatisMultipleDataSourceController {

	@Autowired
	private UserServiceTest01 userServiceTest01;
	@Autowired
	private UserServiceTest02 userServiceTest02;

	@RequestMapping("findByNameOfTest01")
	public User findByNameOfTest01(String name) {
		return userServiceTest01.findByName(name);

	}

	@RequestMapping("insertOfTest01")
	public int insertOfTest01(String name, Integer age) {
		return userServiceTest01.insert(name, age);
	}

	@RequestMapping("findByNameOfTest02")
	public User findByNameOfTest02(String name) {
		return userServiceTest02.findByName(name);

	}

	@RequestMapping("insertOfTest02")
	public int insertOfTest02(String name, Integer age) {
		return userServiceTest02.insert(name, age);
	}
}

DataSource1Config类：

package com.springboot.datasource;

/**
 * 读取datasource1数据源
 * 
 */
import javax.sql.DataSource;

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.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.datasource.DataSourceTransactionManager;

@Configuration // 注冊到sprign容器中
@MapperScan(basePackages = { "com.springboot.test01" }, sqlSessionFactoryRef = "test01SqlSessionFactory")
public class DataSource1Config {

	/**
	 * 配置test01数据库
	 * 
	 * @return
	 */
	@Bean(name = "test01DataSource")
	@ConfigurationProperties(prefix = "spring.datasource.test01") // 读取aplication.properties中的对应属性值
	@Primary
	public DataSource testDataSource() {
		return DataSourceBuilder.create().build();
	}

	/**
	 * 配置创建SqlSession实例的工厂
	 * 
	 * @param dataSource
	 * @return
	 * @throws Exception
	 */
	@Bean(name = "test01SqlSessionFactory")
	@Primary
	public SqlSessionFactory testSqlSessionFactory(@Qualifier("test01DataSource") DataSource dataSource)
			throws Exception {
		SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
		bean.setDataSource(dataSource);
		return bean.getObject();
	}

	/**
	 * 配置事务管理
	 * 
	 * @param dataSource
	 * @return
	 * @throws Exception
	 */
	@Bean(name = "test01TransactionManager")
	@Primary
	public DataSourceTransactionManager testTransactionManager(@Qualifier("test01DataSource") DataSource dataSource)
			throws Exception {
		return new DataSourceTransactionManager(dataSource);
	}

	/**
	 * MyBatis提供的持久层访问模板化的工具，线程安全，可通过构造参数或依赖注入SqlSessionFactory实例
	 * 
	 * @param testSessionFactory
	 * @return
	 * @throws Exception
	 */
	@Bean(name = "test01SqlSessionTemplate")
	@Primary
	public SqlSessionTemplate testSqlSessionTemplate(
			@Qualifier("test01SqlSessionFactory") SqlSessionFactory testSessionFactory) throws Exception {
		return new SqlSessionTemplate(testSessionFactory);
	}
}

DataSource2Config类：

package com.springboot.datasource;

/**
 * 读取datasource2数据源
 * 
 */
import javax.sql.DataSource;

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.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.jdbc.datasource.DataSourceTransactionManager;

@Configuration // 注冊到sprign容器中
@MapperScan(basePackages = { "com.springboot.test02" }, sqlSessionFactoryRef = "test02SqlSessionFactory")
public class DataSource2Config {

	/**
	 * 配置test02数据库
	 * 
	 * @return
	 */
	@Bean(name = "test02DataSource")
	@ConfigurationProperties(prefix = "spring.datasource.test02") // 读取aplication.properties中的对应属性值
	public DataSource testDataSource() {
		return DataSourceBuilder.create().build();
	}

	/**
	 * 配置创建SqlSession实例的工厂
	 * 
	 * @param dataSource
	 * @return
	 * @throws Exception
	 */
	@Bean(name = "test02SqlSessionFactory")
	public SqlSessionFactory testSqlSessionFactory(@Qualifier("test02DataSource") DataSource dataSource)
			throws Exception {
		SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
		bean.setDataSource(dataSource);
		return bean.getObject();
	}

	/**
	 * 配置事务管理
	 * 
	 * @param dataSource
	 * @return
	 * @throws Exception
	 */
	@Bean(name = "test02TransactionManager")
	public DataSourceTransactionManager testTransactionManager(@Qualifier("test02DataSource") DataSource dataSource)
			throws Exception {
		return new DataSourceTransactionManager(dataSource);
	}

	/**
	 * MyBatis提供的持久层访问模板化的工具，线程安全，可通过构造参数或依赖注入SqlSessionFactory实例
	 * 
	 * @param testSessionFactory
	 * @return
	 * @throws Exception
	 */
	@Bean(name = "test02SqlSessionTemplate")
	public SqlSessionTemplate testSqlSessionTemplate(
			@Qualifier("test02SqlSessionFactory") SqlSessionFactory testSessionFactory) throws Exception {
		return new SqlSessionTemplate(testSessionFactory);
	}
}

User类：

package com.springboot.entity;

/**
 * 实体类
 */
import lombok.Data;

@Data // 集成了lombok之后，可自动生成get,set方法
public class User {

	private Integer id;
	private String name;
	private Integer age;

}

UserMapperTest01类：

package com.springboot.test01.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.springboot.entity.User;

public interface UserMapperTest01 {

	// 查询
	@Select("select * from user where name=#{name}")
	User findByName(@Param("name") String name);

	// 添加
	@Insert("insert into user(name,age) values(#{name},#{age})")
	int insert(@Param("name") String name, @Param("age") Integer age);

}

UserServiceTest01类：

package com.springboot.test01.service;

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

import com.springboot.entity.User;
import com.springboot.test01.mapper.UserMapperTest01;

import lombok.extern.slf4j.Slf4j;

@Service
@Slf4j // 等同于private Logger logger = LoggerFactory.getLogger(this.getClass());
public class UserServiceTest01 {

	@Autowired
	private UserMapperTest01 userMapperTest01;

	public User findByName(String name) {
		User user = userMapperTest01.findByName(name);
		log.info("查询结果：" + user.toString());
		return user;

	}

	public int insert(String name, Integer age) {
		int result = userMapperTest01.insert(name, age);
		log.info("插入结果：" + result);
		return result;
	}
}

UserMapperTest02类：

package com.springboot.test02.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.springboot.entity.User;

public interface UserMapperTest02 {

	// 查询
	@Select("select * from user where name=#{name}")
	User findByName(@Param("name") String name);

	// 添加
	@Insert("insert into user(name,age) values(#{name},#{age})")
	int insert(@Param("name") String name, @Param("age") Integer age);

}

UserServiceTest02类：

package com.springboot.test02.service;

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

import com.springboot.entity.User;
import com.springboot.test02.mapper.UserMapperTest02;

import lombok.extern.slf4j.Slf4j;

@Service
@Slf4j // 等同于private Logger logger = LoggerFactory.getLogger(this.getClass());
public class UserServiceTest02 {

	@Autowired
	private UserMapperTest02 userMapperTest02;

	public User findByName(String name) {
		User user = userMapperTest02.findByName(name);
		log.info("查询结果：" + user.toString());
		return user;

	}

	public int insert(String name, Integer age) {
		int result = userMapperTest02.insert(name, age);
		log.info("插入结果：" + result);
		return result;
	}
}

App类：

package com.springboot;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

/**
 * 将启动的代码抽取出来，单独运行
 *
 * @author vean
 *
 */
@SpringBootApplication // 等同于@EnableAutoConfiguration+@ComponentScan（只扫描同级包<包含子包>和当前包）
@MapperScan(basePackages = { "com.springboot" }) // 扫描映射文件。
// 注意：mybatis启东时候，在mapper层可以不加mapper注解，但是一定要在启动类上加@mapperScan注解
// 也可以在mybatis接口上(xxxMapper)加上@Mapper来注入mybatis容器，就不需要在启动类的时候加上@mapperscan
public class App {
	public static void main(String[] args) {
		// 整个程序的入口，启动springboot项目，创建内置tomcat服务器，使用tomcat加载springmvc 注解启动类
		SpringApplication.run(App.class, args);
	}
}

四.项目演示

向test01数据库添加一条信息：