spring多数据源配置.doc

PAGE \* MERGEFORMAT PAGE \* MERGEFORMAT 2 PAGE \* MERGEFORMAT PAGE \* MERGEFORMAT 1 技术分享 文档更改记录表 日期 文档版本 修订说明 作者 2015.06.19 V1.00 Spring多数据源与动态切换配置 曾隐祥 第一章 引言 1.编写目的 此次通过 nghq项目，做出的技术学习与分享，使团队成员拓展技术知识点，快速有效提高团队的 凝聚力、战斗了 第二章 spring多数据源 Spring多数据源的配置可以用于mysql数据库主从分离、项目多库的应用场景，并用事物切面动态切换当前数据库，下面简单介绍配置步骤 1.数据库连接配置proxool-conf.xml ?xml version=1.0 encoding=utf-8? something-else-entirely proxool aliasng1/alias driver-urljdbc:mysql://6/ng1?characterEncoding=UTF-8/driver-url driver-classcom.mysql.jdbc.Driver/driver-class driver-properties property name=user value=root / property name=password value=123456 / /driver-properties house-keeping-sleep-time30000/house-keeping-sleep-time maximum-connection-count500/maximum-connection-count minimum-connection-count10/minimum-connection-count maximum-new-connections20/maximum-new-connections prototype-count5/prototype-count test-before-usetrue/test-before-use simultaneous-build-throttle20/simultaneous-build-throttle house-keeping-test-sqlselect 100 + 1000 from dual/house-keeping-test-sql /proxool proxool aliasng2/alias driver-urljdbc:mysql://6/ng2?characterEncoding=UTF-8/driver-url driver-classcom.mysql.jdbc.Driver/driver-class driver-properties property name=user value=root / property name=password value=123456 / /driver-properties house-keeping-sleep-time30000/house-keeping-sleep-time maximum-connection-count500/maximum-connection-count minimum-connection-count10/minimum-connection-count maximum-new-connections20/maximum-new-connections prototype-count5/prototype-count test-before-usetrue/test-before-use simultaneous-build-throttle20/simultaneous-build-throttle house-keeping-test-sqlselect 100 + 1000 from dual/house-keeping-test-sql /proxool /something-else-entirely 以上配置，说明项目将要对ng1，ng2两个数据库进行连接 spring数据源配置spirng-datasource.xml !--加载数据库ng1配置-- bean id=ng1 class=org.springframework.jdbc.datasource.DriverManagerDataSource property name=driverCla