JDBC 的 applicationContext.XML配置

<?xml version="1.0" encoding="UTF-8"?>
-<beans xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.springframework.org/schema/beans">
<!-- 加载jdbc配置文件 -->
<context:property-placeholder location="classpath:jdbc.properties"/>
<!-- 数据源 -->
-<bean destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource" id="dataSource">
<!-- 驱动 -->
<property value="${driverClassName}" name="driverClassName"/>
<!-- URL -->
<property value="${url}" name="url"/>
<!-- 用户名 -->
<property value="${username}" name="username"/>
<!-- 密码 -->
<property value="${password}" name="password"/>
<!-- 连接池的初始大小 -->
<property value="${initialSize}" name="initialSize"/>
<!-- 最大连接数 -->
<property value="${maxActive}" name="maxActive"/>
<!-- 最大空闲连接数 -->
<property value="${maxIdle}" name="maxIdle"/>
<!-- 最小空闲连接数 -->
<property value="${minIdle}" name="minIdle"/>
<!-- 是否在自动回收超时连接的时候打印连接的超时错误 -->
<property value="${logAbandoned}" name="logAbandoned"/>
<!-- 是否自动回收超时连接 -->
<property value="${removeAbandoned}" name="removeAbandoned"/>
<!-- 超时时间(以秒数为单位) -->
<property value="${removeAbandonedTimeout}" name="removeAbandonedTimeout"/>
<!-- 超时等待时间(以毫秒为单位) -->
<property value="${maxWait}" name="maxWait"/></bean>
<!-- simpleJdbcTemplate -->
-<bean class="org.springframework.jdbc.core.simple.SimpleJdbcTemplate" id="simpleJdbcTemplate"><constructor-arg ref="dataSource"/></bean>
<!-- 自动扫描 -->
<context:component-scan base-package="com.dg11185.dgListerner"/>
<!-- 事务 -->


<!-- 事务配置 -->
-<bean class="org.springframework.jdbc.datasource.DataSourceTransactionManager" id="transactionManager"><property name="dataSource" ref="dataSource"/></bean>-<tx:advice id="tx" transaction-manager="transactionManager">-<tx:attributes><tx:method name="add*" propagation="REQUIRED"/><tx:method name="save*" propagation="REQUIRED"/><tx:method name="delete*" propagation="REQUIRED"/><tx:method name="update*" propagation="REQUIRED"/><tx:method name="get*" propagation="NOT_SUPPORTED"/><tx:method name="load*" propagation="NOT_SUPPORTED"/><tx:method name="find*" propagation="NOT_SUPPORTED"/><tx:method name="*" propagation="NOT_SUPPORTED"/></tx:attributes></tx:advice>-<aop:config><aop:pointcut id="pt" expression="execution(* com.dg11185.dgListerner.service..*.*(..))"/><aop:advisor pointcut-ref="pt" advice-ref="tx"/></aop:config></beans>