spring-boot+mybatis 插件配置多个数据源实现读写分离

SpringBoot使用注解整合Mybatis配置多个数据源实现读写分离

• 数据库【mysql】
• 数据源【Druid】阿里开源

1. maven引入依赖jar

   <dependency>
   			<groupId>mysql</groupId>
   			<artifactId>mysql-connector-java</artifactId>
   		</dependency>
   
   		<dependency>
   			<groupId>org.mybatis.spring.boot</groupId>
   			<artifactId>mybatis-spring-boot-starter</artifactId>
   			<version>2.1.1</version>
   		</dependency>
   		<dependency>
   			<groupId>com.alibaba</groupId>
   			<artifactId>druid</artifactId>
   			<version>1.1.9</version>
   		</dependency>

    

2. 多个数据源配置

   @Configuration
   public class StudyConfiguration {
   	
   	@Bean(name = "readDataSouce")
   	@ConfigurationProperties(prefix = "spring.primary.druid")
   	public DataSource readDataSouce() {
   		return new DruidDataSource();
   	}
   	
   	@Bean(name = "writeDataSouce")
   	@ConfigurationProperties(prefix = "spring.secondary.druid")
   	public DataSource writeDataSouce() {
   		return new DruidDataSource();
   	}
   	
   }

    

3. 属性文件配置applicatin.properties

   spring.primary.druid.url=jdbc:mysql://localhost:3306/database?useUnicode=true&characterEncoding=utf8
   spring.primary.druid.driverClassName=com.mysql.jdbc.D