Spring配置事务

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       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"
       xsi:schemaLocation="
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/tx  http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/context  http://www.springframework.org/schema/context/spring-context.xsd
">
<!--00.识别jdbc.properties文件-->
<context:property-placeholder location="jdbc.properties"></context:property-placeholder>


<!--01.建立数据源  ${} Spring 内置的一个数据源 DriverManager-->
<!--<bean id="dataSoure" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="${driver}"></property>
    <property name="url" value="${url}"></property>
    <property name="username" value="${user}"></property>
    <property name="password" value="${password}"></property>
</bean>-->

<!-- c3p0
 <bean id="dataSoure" class="com.mchange.v2.c3p0.ComboPooledDataSource">
     <property name="driverClass" value="${driver}"></property>
     <property name="jdbcUrl" value="${url}"></property>
     <property name="user" value="${user}"></property>
     <property name="password" value="${password}"></property>
 </bean>-->

<!--dpcb-->
<!--<bean id="dataSoure" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="${driver}"></property>
    <property name="url" value="${url}"></property>
    <property name="username" value="${user}"></property>
    <property name="password" value="${password}"></property>
</bean>-->

<!--alibaba -->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
    <property name="driverClassName" value="${driver}"></property>
    <property name="url" value="${url}"></property>
    <property name="username" value="${user}"></property>
    <property name="password" value="${password}"></property>
</bean>



<!-- <!–02.jdbcTemplate 配置–>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
    <property name="dataSource" ref="dataSoure"></property>

</bean>-->


<!--03.dao配置-->
<bean id="account" class="cn.springJDBC_tx.cn.cn.dao.ShowAccont">
    <property name="dataSource" ref="dataSource"></property>
</bean>

<bean id="stock" class="cn.springJDBC_tx.cn.cn.dao.ShowStock">
    <property name="dataSource" ref="dataSource"></property>
</bean>

<!--04.cn.cn.service   bookService-->
<bean id="show" class="cn.springJDBC_tx.cn.cn.service.ShowServiceAccount">
    <property name="accDao" ref="account"></property>
    <property name="stockDao" ref="stock"></property>
</bean>

<!--事务管理器-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource"></property>
</bean>

<!--配置事务 拦截方法-->
<!--<bean id="serviceProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">

    <!–目标类型–>
    <property name="target" ref="show"></property>
    <property name="transactionManager" ref="transactionManager"></property>
    <!–增强–>
    <property name="transactionAttributes">
        <props>
            <prop key="buy*">ISOLATION_DEFAULT,PROPAGATION_REQUIRED,-ShockException
            </prop>
        </props>
    </property>
</bean>-->

<!--用注解 配置事务-->
<!-- <tx:annotation-driven transaction-manager="transactionManager"/>-->


<!--第三种  用Aspect -->
<tx:advice id="txAdvice" transaction-manager="transactionManager">
    <tx:attributes>
        <tx:method name="buy*" isolation="DEFAULT" propagation="REQUIRED" rollback-for="ShockException"/>
    </tx:attributes>
</tx:advice>
<aop:config>
    <!--配置切点-->
    <aop:pointcut id="mypoint" expression="execution(* *..cn.cn.service.*.*(..))"></aop:pointcut>
    <!--顾问-->
    <aop:advisor advice-ref="txAdvice" pointcut-ref="mypoint"></aop:advisor>
</aop:config>




</beans>

public interface IAccount {

    public  boolean updateAccount(int id,double money,boolean isBuy);
}

public interface IStock {
    public  boolean updateStock(int id,int money,boolean isBuy);
}

public class ShowAccont extends JdbcDaoSupport implements IAccount {
    public boolean updateAccount(int id, double money, boolean isBuy) {
        boolean flag=false;
        String sql=null;
        if (isBuy){
            sql="update account set balace=balace-? where aid=?";
        }else {
            sql="update account set balace=balace+? where aid=?";
        }
        int count = this.getJdbcTemplate().update(sql, money, id);
        if(count>0){
            flag=true;
        }
        return flag;
    }
}

public class ShowStock extends JdbcDaoSupport implements  IStock {
    public boolean updateStock(int id, int money, boolean isBuy) {
        boolean flag=false;
        String sql=null;
        if (isBuy){
            sql="update stock set count=count+? where sid=?";
        }else {
            sql="update stock set count=count-? where sid=?";
        }
        int count = this.getJdbcTemplate().update(sql, money, id);
        if(count>0){
            flag=true;
        }
        return flag;
    }
}

 // 测试 JDBC  连接
    //测试 事务
    @Test
    public  void  jdbc(){
        ApplicationContext ctx=new ClassPathXmlApplicationContext("applicationContext11JDBCj.xml");
        IServiceAccount serviceAccount = (IServiceAccount)ctx.getBean("show");
        try {
           serviceAccount.buyStock1(1,10,1,1000);
        } catch (ShockException e) {
            e.printStackTrace();
        }
    }