ssm多数据源配置

来源：互联网发布：人工智能的上市公司编辑：程序博客网时间：2024/06/02 05:16

配置文件properties的相关代码

master.jdbc.driver=com.mysql.jdbc.Driver
master.jdbc.url=jdbc:mysql://192.168.30.111:3306/myerpdata?useUnicode=true&characterEncoding=utf-8
master.jdbc.username=root
master.jdbc.password=_P96E#5194D#^20

slave.jdbc.driver=com.mysql.jdbc.Driver
slave.jdbc.url=jdbc:mysql://192.168.30.111:3306/mingyars?useUnicode=true&characterEncoding=utf-8
slave.jdbc.username=root
slave.jdbc.password=_P96E#5194D#^20

appicationcontext的代码块

<bean id="slaveDataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">    <property name="driverClassName" value="${slave.jdbc.driver}" />    <property name="url" value="${slave.jdbc.url}" />    <property name="username" value="${slave.jdbc.username}" />    <property name="password" value="${slave.jdbc.password}" />    <property name="maxActive" value="10" />    <property name="minIdle" value="5" /></bean><bean id="dataSource" class="com.mingya.invoicesystem.comm.DynamicDataSourceProxy">    <property name="targetDataSources">        <map>            <entry key="SLAVE" value-ref="slaveDataSource"/>        </map>    </property>    <property name="defaultTargetDataSource" ref="masterDataSource"/></bean>

阅读全文

4 0