先配置数据库
spring:
#数据源和jpa配置
datasource:
purchase:
driver-class-name: com.mysql.cj.jdbc.Driver
jdbc-url: jdbc:mysql://10.90.0.72:3306/smart_ebc?characterEncoding=utf-8&allowMultiQueries=true&autoReconnect=true&serverTimezone=GMT%2B8
username:
password:
oms:
driver-class-name: com.mysql.cj.jdbc.Driver
jdbc-url: jdbc:mysql://127.0.0.1:12308/wzc_oms?characterEncoding=utf-8&allowMultiQueries=true&autoReconnect=true&serverTimezone=GMT%2B8
username:
password:
saimasy:
driver-class-name: com.mysql.cj.jdbc.Driver
jdbc-url: jdbc:mysql://localhost:12309/saimasy?characterEncoding=utf-8&allowMultiQueries=true&autoReconnect=true&serverTimezone=GMT%2B8
username:
password:
jpa:
show-sql: false
properties:
hibernate:
dialect: org.hibernate.dialect.MySQL5Dialect
ddl-auto: update # DDL 级别(create, create-drop, validate, update)
jdbc:
lob:
non_contextual_creation: true
hibernate:
naming:
physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
其次写DataSourceConfig
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 javax.sql.DataSource;
import java.util.HashMap;
import java.util.Map;
@Configuration
public class DataSourceConfig {
@Bean(name = "purchaseDataSource")
@Qualifier("purchaseDataSource")
@ConfigurationProperties(prefix = "spring.datasource.purchase")
@Primary
public DataSource purchaseDataSource() {
return DataSourceBuilder.create().build();
}
@Bean(name = "omsDataSource")
@Qualifier("omsDataSource")
@ConfigurationProperties(prefix = "spring.datasource.oms")
public DataSource omsDataSource() {
return DataSourceBuilder.create().build();
}
@Bean(name = "saimasyDataSource")
@Qualifier("saimasyDataSource")
@ConfigurationProperties(prefix = "spring.datasource.saimasy")
public DataSource saimasyDataSource() {
return DataSourceBuilder.create().build();
}
}
最后为每个数据源写单独的config,换一下路径
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.orm.jpa.HibernateProperties;
import org.springframework.boot.autoconfigure.orm.jpa.HibernateSettings;
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;
import javax.persistence.EntityManager;
import javax.sql.DataSource;
import java.util.Map;
import java.util.Objects;
@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(entityManagerFactoryRef = "entityManagerFactoryPurchase",
transactionManagerRef = "transactionManagerPurchase",
basePackages = {"com.allintechinc.purchase.repository.purchase"})
public class PurchaseConfig {
@Autowired
@Qualifier("purchaseDataSource")
private DataSource purchaseDataSource;
@Autowired
private HibernateProperties hibernateProperties;
@Autowired
private JpaProperties jpaProperties;
@Primary
@Bean(name = "entityManagerPurchase")
public EntityManager entityManager(EntityManagerFactoryBuilder builder) {
return Objects.requireNonNull(entityManagerFactoryPurchase(builder).getObject()).createEntityManager();
}
@Primary
@Bean(name = "entityManagerFactoryPurchase")
public LocalContainerEntityManagerFactoryBean entityManagerFactoryPurchase(EntityManagerFactoryBuilder builder) {
return builder.dataSource(purchaseDataSource)
.properties(getHibernateProperties())
//换成你自己的实体类所在位置
.packages("com.allintechinc.purchase.entity.purchase")
.persistenceUnit("PurchasePersistenceUnit")
.build();
}
@Primary
@Bean(name = "transactionManagerPurchase")
public PlatformTransactionManager transactionManager(EntityManagerFactoryBuilder builder) {
return new JpaTransactionManager(Objects.requireNonNull(entityManagerFactoryPurchase(builder).getObject()));
}
private Map<String, Object> getHibernateProperties() {
return hibernateProperties.determineHibernateProperties(jpaProperties.getProperties(), new HibernateSettings());
}
}
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.orm.jpa.HibernateProperties;
import org.springframework.boot.autoconfigure.orm.jpa.HibernateSettings;
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;
import javax.persistence.EntityManager;
import javax.sql.DataSource;
import java.util.Map;
import java.util.Objects;
@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(entityManagerFactoryRef = "entityManagerFactoryOms",
transactionManagerRef = "transactionManagerOms",
basePackages = {"com.allintechinc.purchase.repository.oms"})
public class OmsConfig {
@Autowired
@Qualifier("omsDataSource")
private DataSource omsDataSource;
@Autowired
private HibernateProperties hibernateProperties;
@Autowired
private JpaProperties jpaProperties;
@Bean(name = "entityManagerOms")
public EntityManager entityManager(EntityManagerFactoryBuilder builder) {
return Objects.requireNonNull(entityManagerFactoryOms(builder).getObject()).createEntityManager();
}
@Bean(name = "entityManagerFactoryOms")
public LocalContainerEntityManagerFactoryBean entityManagerFactoryOms(EntityManagerFactoryBuilder builder) {
return builder.dataSource(omsDataSource)
.properties(getHibernateProperties())
//换成你自己的实体类所在位置
.packages("com.allintechinc.purchase.entity.oms")
.persistenceUnit("primaryPersistenceUnit")
.build();
}
@Bean(name = "transactionManagerOms")
public PlatformTransactionManager transactionManager(EntityManagerFactoryBuilder builder) {
return new JpaTransactionManager(Objects.requireNonNull(entityManagerFactoryOms(builder).getObject()));
}
private Map<String, Object> getHibernateProperties() {
return hibernateProperties.determineHibernateProperties(jpaProperties.getProperties(), new HibernateSettings());
}
}