1 jdbc.driver=oracle.jdbc.driver.OracleDriver2 jdbc.url=jdbc\:oracle\:thin\:@localhost\:1521\:orcl3 jdbc.user=zym4 jdbc.password=zymm

 1 <?xml version="1.0" encoding="UTF-8"?> 2 <beans xmlns="http://www.springframework.org/schema/beans" 3     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 4     xmlns:aop="http://www.springframework.org/schema/aop" 5     xmlns:tx="http://www.springframework.org/schema/tx" 6     xsi:schemaLocation=" 7         http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd 8         http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd 9         http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd10         ">11     <!--01. Database connection settings spring内置 数据库连接设置-->12     <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">13         14         <!-- 驱动类 -->15         <property name="driverClassName" value=http://www.mamicode.com/"oracle.jdbc.driver.OracleDriver"></property>16         <!-- url地址 -->17         <property name="url" value=http://www.mamicode.com/"jdbc:oracle:thin:@localhost:1521:orcl"></property>18         <property name="username" value=http://www.mamicode.com/"zym"></property>19         <property name="password" value=http://www.mamicode.com/"zymm"></property>20     </bean>21     22     23     24     <!-- 02.dbcp 配置数据源 -->25      <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">26         <property name="driverClassName" value=http://www.mamicode.com/"oracle.jdbc.driver.OracleDriver"></property>27         <property name="url" value=http://www.mamicode.com/"jdbc:oracle:thin:@localhost:1521:orcl"></property>28         <property name="username" value=http://www.mamicode.com/"zym"></property>29         <property name="password" value=http://www.mamicode.com/"zymm"></property>30     </bean>31     32     <!-- 03.c3p0 配置数据源 -->33     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">34         <property name="driverClass" value=http://www.mamicode.com/"${jdbc.driver}"></property>35         <property name="jdbcUrl" value=http://www.mamicode.com/"${jdbc.url}"></property>36         <property name="user" value=http://www.mamicode.com/"${jdbc.user}"></property>37         <property name="password" value=http://www.mamicode.com/"${jdbc.password}"></property>38     </bean>39     40     41     42     <bean id="MyjdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">43         <property name="dataSource" ref="dataSource"></property>44     </bean>45     <bean id="empDao" class="zym.jdbctemplate.dao.impl.EmpDaoImpl">46         <property name="jdbcTemplate" ref="MyjdbcTemplate"></property>47     </bean>48     49     <bean id="empService" class="zym.jdbctemplate.service.impl.IEmpServiceImpl">50         <property name="dao" ref="empDao"></property>51     </bean>52         53     <!-- 让Spring去寻找jdbc.properties -->54     <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">55         <property name="location" value=http://www.mamicode.com/"classpath:jdbc.properties"></property>56     </bean>57 </beans>