两个数据库实例，一个负责读，一个负责写。
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
datasource-reader: type: com.alibaba.druid.pool.druiddatasource url: jdbc:mysql://192.168.43.61:3306/test?useunicode=true&characterencoding=utf8&autoreconnect=true&usessl=false username: icbc password: icbc driver-class-name: com.mysql.jdbc.driver continue-on-error: false sql-script-encoding: utf-8datasource-writer: type: com.alibaba.druid.pool.druiddatasource url: jdbc:mysql://192.168.43.61:3306/hdfs?useunicode=true&characterencoding=utf8&autoreconnect=true&usessl=false username: icbc password: icbc driver-class-name: com.mysql.jdbc.driver continue-on-error: false sql-script-encoding: utf-8 |
读数据库配置
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
@configuration@enabletransactionmanagement@enablejparepositories(entitymanagerfactoryref = "entitymanagerfactoryprimary", transactionmanagerref = "transactionmanagerprimary", basepackages = { "cn.cib.repository.read"})public class repositoryprimaryconfig { @autowired @qualifier("r_ds") private datasource r_ds; @bean(destroymethod = "", name = "entitymanagerprimary") @primary public entitymanager entitymanager() { return entitymanagerfactoryprimary().getobject().createentitymanager(); } @bean(destroymethod = "", name = "entitymanagerfactoryprimary") @primary public localcontainerentitymanagerfactorybean entitymanagerfactoryprimary() { hibernatejpavendoradapter jpavendoradapter = new hibernatejpavendoradapter(); localcontainerentitymanagerfactorybean factorybean = new localcontainerentitymanagerfactorybean(); factorybean.setdatasource(r_ds); factorybean.setjpavendoradapter(jpavendoradapter); factorybean.setjpaproperties(hibernatepropertiesbuilder.hibernateproperties()); factorybean.setpackagestoscan("cn.cib.repository.read", "cn.cib.entity.read"); factorybean.setpersistenceunitname("read"); return factorybean; } @bean(destroymethod = "", name = "transactionmanagerprimary") @primary platformtransactionmanager transactionmanagerprimary() { return new jpatransactionmanager(entitymanagerfactoryprimary().getobject()); }} |
写数据库配置
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
@configuration@enabletransactionmanagement@enablejparepositories(entitymanagerfactoryref = "entitymanagerfactorysecondary", transactionmanagerref = "transactionmanagersecondary", basepackages = { "cn.cib.repository.write"})public class repositorysecondaryconfig { @autowired @qualifier("w_ds") private datasource w_ds; @bean(destroymethod = "", name = "entitymanagersecondary") public entitymanager entitymanager() { return entitymanagerfactorysecondary().getobject().createentitymanager(); } @bean(destroymethod = "", name = "entitymanagerfactorysecondary") public localcontainerentitymanagerfactorybean entitymanagerfactorysecondary() { hibernatejpavendoradapter jpavendoradapter = new hibernatejpavendoradapter(); localcontainerentitymanagerfactorybean factorybean = new localcontainerentitymanagerfactorybean(); factorybean.setdatasource(w_ds); factorybean.setjpavendoradapter(jpavendoradapter); factorybean.setjpaproperties(hibernatepropertiesbuilder.hibernateproperties()); factorybean.setpackagestoscan("cn.cib.repository.write","cn.cib.entity.write"); factorybean.setpersistenceunitname("write"); return factorybean; } @bean(destroymethod = "", name = "transactionmanagersecondary") platformtransactionmanager transactionmanagersecondary() { return new jpatransactionmanager(entitymanagerfactorysecondary().getobject()); }} |
hibernate相关属性配置
|
1
2
3
4
5
6
7
8
9
10
|
public class hibernatepropertiesbuilder { public static properties hibernateproperties() { final properties hibernateproperties = new properties(); hibernateproperties.setproperty("hibernate.dialect", "org.hibernate.dialect.mysql5dialect"); hibernateproperties.setproperty("hibernate.hbm2ddl.auto", "update"); hibernateproperties.setproperty("hibernate.show_sql", "true"); hibernateproperties.setproperty("hibernate.format_sql", "true"); return hibernateproperties; }} |
总结
以上所述是小编给大家介绍的spring boot 2.0多数据源配置方法实例详解，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对服务器之家网站的支持！
原文链接：https://blog.csdn.net/kangkanglou/article/details/82683177
