DB_Config的连接

最新推荐文章于 2021-03-25 17:00:15 发布

allenVSpgj

最新推荐文章于 2021-03-25 17:00:15 发布

阅读量858

点赞数

本文链接：https://blog.csdn.net/pengguojun117/article/details/8555828

版权

一、DB_Config.xml配置

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="http://www.springframework.org/schema/beans
   http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">

   <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
       <property name="locations">
           <list>
               <value>classpath:jdbczxd.properties</value>
           </list>
       </property>
   </bean>

   <bean id="parentDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
      <property name="driverClassName" value="${jdbc.driverClassName}"></property>
   </bean>

   
     <bean id="defalutdataSource" parent="parentDataSource">
       <property name="url" value="${jdbc.url}"></property>
       <property name="username" value="${jdbc.username}"></property>
       <property name="password" value="${jdbc.password}"></property>
   </bean>

   <bean id="dataSource" class="com.zxd.autocontrol.common.dbchange.service.impl.DynamicDataSource">
      <property name="targetDataSources">
          <map key-type="java.lang.String">
              
              <entry key="default" value-ref="defalutdataSource"></entry>
          </map>
      </property>
      <property name="defaultTargetDataSource" ref="defalutdataSource"></property>
   </bean>

   <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
       <property name="dataSource">
           <ref local="dataSource" />
       </property>
   </bean>
</beans>

二、jdbczxd.properties属性文件

# Properties file with JDBC-related settings.
# Applied by PropertyPlaceholderConfigurer from "dataAccessContext-local.xml".
# Targeted at system administrators, to avoid touching the context XML files.

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
################开发##########################zxdfk_risk_control_dvlp
jdbc.url=jdbc:oracle:thin:@192.168.18.99:1521:zxdoradb
jdbc.username=zxdfk_risk_control_dvlp
jdbc.password=zxdfk_risk_control_dvlp

#jdbc.url=jdbc:oracle:thin:@192.168.18.101:1521:zxdoradb101
#jdbc.username=zxd_pabx_fkfs_dongguan
#jdbc.password=zxd_pabx_fkfs_dongguan

#jdbc.url=jdbc:oracle:thin:@192.168.18.101:1521:zxdoradb101
#jdbc.username=zxd_pabx_fkfs_gd_foshan
#jdbc.password=zxd_pabx_fkfs_gd_foshan

################生产##########################
#jdbc.url=jdbc:oracle:thin:@192.168.18.101:1521:zxdoradb101
#jdbc.username=zxdconnt
#jdbc.password=zxdconnt