Spring Boot,Spring Data JPA多数据源支持配置

1.配置文件

#mysql
#主库参数primary
spring.primary.datasource.url=jdbc:mysql://101.200.152.192:3307/ovuola?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false
spring.primary.datasource.username=ovuola
spring.primary.datasource.password=_MIYOU=PasswdSuccess110110=MIYOU_.
spring.primary.datasource.driverClassName=com.mysql.jdbc.Driver
spring.primary.datasource.maxActive=100
spring.primary.datasource.minIdle=2
spring.primary.datasource.initialSize=30
spring.primary.datasource.maxWait=2000
spring.primary.datasource.removeAbandoned=true
spring.primary.datasource.removeAbandonedTimeout=180
spring.primary.datasource.useGlobalDataSourceStat=true


#从库参数secondary
spring.secondary.datasource.url=jdbc:mysql://101.200.152.192:3308/ovuola?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false
spring.secondary.datasource.username=ovuola
spring.secondary.datasource.password=_MIYOU=PasswdSuccess110110=MIYOU_.
spring.secondary.datasource.driverClassName=com.mysql.jdbc.Driver
spring.secondary.datasource.maxActive=300
spring.secondary.datasource.minIdle=2
spring.secondary.datasource.initialSize=30
spring.secondary.datasource.maxWait=2000
spring.secondary.datasource.removeAbandoned=true
spring.secondary.datasource.removeAbandonedTimeout=180
spring.secondary.datasource.useGlobalDataSourceStat=true

2.datasource配置

第一个数据源

package springboot.testSpringBoot.dao.mysql;


import javax.sql.DataSource;


import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;


@Configuration
public class DataSourcePrimaryConfig {
@Bean(name = "primaryDS")
@Qualifier("primaryDS")
@Primary
@ConfigurationProperties(prefix = "spring.primary.datasource")
public DataSource primaryDataSource() {
return DataSourceBuilder.create().build();
}


}

第二个数据源

package springboot.testSpringBoot.dao.mysql;


import javax.sql.DataSource;


import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;


@Configuration
public class DataSourceSecondaryConfig {


@Bean(name = "secondaryDS")
@Qualifier("secondaryDS")
@ConfigurationProperties(prefix = "spring.secondary.datasource")
public DataSource secondaryDataSource() {
return DataSourceBuilder.create().build();
}
}

3 实体管理器及事务管理器配置

第一个数据源

package springboot.testSpringBoot.dao.mysql;


import java.util.Map;


import javax.persistence.EntityManager;
import javax.sql.DataSource;


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.orm.jpa.JpaProperties;
import org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;


/**
 * 实体管理器及事务管理器配置 第一个数据源
 * 
 * @author lhh
 *
 */
@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(entityManagerFactoryRef = "entityManagerFactoryPrimary", transactionManagerRef = "transactionManagerPrimary", basePackages = { "springboot.testSpringBoot.dao.repository" })
public class RepositoryPrimaryConfig {
@Autowired
private JpaProperties jpaProperties;


@Autowired
@Qualifier("primaryDS")
private DataSource primaryDS;


@Bean(name = "entityManagerPrimary")
@Primary
public EntityManager entityManager(EntityManagerFactoryBuilder builder) {
return entityManagerFactoryPrimary(builder).getObject()
.createEntityManager();
}


@Bean(name = "entityManagerFactoryPrimary")
@Primary
public LocalContainerEntityManagerFactoryBean entityManagerFactoryPrimary(
EntityManagerFactoryBuilder builder) {
return builder.dataSource(primaryDS)
.properties(getVendorProperties(primaryDS))
.packages("springboot.testSpringBoot.entity") // 设置实体类所在位置
.persistenceUnit("primaryPersistenceUnit").build();
}


private Map<String, String> getVendorProperties(DataSource dataSource) {
return jpaProperties.getHibernateProperties(dataSource);
}


@Bean(name = "transactionManagerPrimary")
@Primary
PlatformTransactionManager transactionManagerPrimary(
EntityManagerFactoryBuilder builder) {
return new JpaTransactionManager(entityManagerFactoryPrimary(builder)
.getObject());
}
}

第二个数据源

package springboot.testSpringBoot.dao.mysql;


import java.util.Map;


import javax.persistence.EntityManager;
import javax.sql.DataSource;


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.orm.jpa.JpaProperties;
import org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;


/**
 * 第二个数据源
 * 
 * @author lhh
 *
 */
@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(entityManagerFactoryRef = "entityManagerFactoryPrimary", transactionManagerRef = "transactionManagerPrimary", basePackages = { "springboot.testSpringBoot.dao.repository" })
public class RepositorySecondaryConfig {


@Autowired
private JpaProperties jpaProperties;


@Autowired
@Qualifier("secondaryDS")
private DataSource secondaryDS;


@Bean(name = "entityManagerSecondary")
public EntityManager entityManager(EntityManagerFactoryBuilder builder) {
return entityManagerFactorySecondary(builder).getObject()
.createEntityManager();
}


@Bean(name = "entityManagerFactorySecondary")
public LocalContainerEntityManagerFactoryBean entityManagerFactorySecondary(
EntityManagerFactoryBuilder builder) {
return builder.dataSource(secondaryDS)
.properties(getVendorProperties(secondaryDS))
.packages("springboot.testSpringBoot.entity")
.persistenceUnit("secondaryPersistenceUnit").build();
}


private Map<String, String> getVendorProperties(DataSource dataSource) {
return jpaProperties.getHibernateProperties(dataSource);
}


@Bean(name = "transactionManagerSecondary")
PlatformTransactionManager transactionManagerSecondary(
EntityManagerFactoryBuilder builder) {
return new JpaTransactionManager(entityManagerFactorySecondary(builder)
.getObject());
}


}

4. spring unit test测试

package springboot.testSpringBoot;


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


import springboot.testSpringBoot.dao.repository.UserRepository;
import springboot.testSpringBoot.entity.UserDo;


public class UserRepositoryTest extends SpringBootJunitConfig {
@Autowired
private UserRepository userRepository;


@Test
public void get() {
// UserDo user = userRepository.findOne(3);
// System.out.println(user.getNickName() + "\t" + user.getUserName());
// System.out.println("=======修改后===========");
// user.setNickName("张飞");
// userRepository.save(user);
// System.out.println(user.getNickName() + "\t" + user.getUserName());
UserDo user = userRepository.findByUserName("13212345678");
System.out.println(user.getNickName() + "\t");
if ("http://47.93.116.44:88/group1/M00/00/00/L110LFlTUMyAAnApAALlNKAh_ZI55.jpeg"
.equals(user.getHeadImage()))
System.out.println("==相等===");
}
}

以上代码经过本人在项目中测试可行，故贴出来分享，后面还有主从数据库读写分离，故障修复等可以逐步增加实现，实现类似mycat的功能