Spring事务

购买股票案例来

两个实体类

package Springtx.entity;public class Account {private int aid; //private String aname; //private double balance; //public int getAid(){return aid;}public void setAid(int aid){this.aid=aid;}public String getAname(){return aname;}public void setAname(String aname){this.aname=aname;}public double getBalance(){return balance;}public void setBalance(double balance){this.balance=balance;}}

package Springtx.entity;public class Stock {    private int sid;    private String sname;    private int count;public int getSid(){return sid;}public void setSid(int sid){this.sid=sid;}public String getSname(){return sname;}public void setSname(String sname){this.sname=sname;}public int getCount(){return count;}public void setCount(int count){this.count=count;}}

DAO     和实现    

package cn.happy.spring21tx.cn.happy.dao;

import cn.happy.spring21tx.cn.happy.entity.Account;

/**
 * Created by Happy on 2017-08-04.
 * 账户类
 */
public interface IAccountDAO {
    //开户的方法
    public boolean addAccount(Account account);
    //修改账户余额  金额减少true
    public boolean updateAccount(int aid,double money,boolean isBuy);
}
实现

package cn.happy.spring21tx.cn.happy.dao;

import cn.happy.spring21tx.cn.happy.entity.Account;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

/**
 * Created by Happy on 2017-08-04.
 */
public class AccountDAOImpl extends JdbcDaoSupport implements IAccountDAO {

    public boolean addAccount(Account account) {
        return false;
    }

    public boolean updateAccount(int aid, double money, boolean isBuy) {
        boolean flag=false;
        String sql=null;
        if (isBuy){  //购买股票
            sql="update account set balance=balance-? where aid=?";
        }else{
             sql="update account set balance=balance+? where aid=?";
        }
        int count = this.getJdbcTemplate().update(sql, money, aid);
        if (count>0){
            flag=true;
        }
        return flag;
    }
}

DAO    实现

package cn.happy.spring21tx.cn.happy.dao;

import cn.happy.spring21tx.cn.happy.entity.Stock;

/**
 * Created by Happy on 2017-08-04.
 */
public interface IStockDAO {
    public boolean addStock(Stock stock);
    public boolean updateStock(int sid,int count,boolean isBuy);
}


实现

package cn.happy.spring21tx.cn.happy.dao;

import cn.happy.spring21tx.cn.happy.entity.Stock;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

/**
 * Created by Happy on 2017-08-04.
 */
public class StockDAOImpl extends JdbcDaoSupport implements IStockDAO {

    public boolean addStock(Stock stock) {
        return false;
    }

    public boolean updateStock(int sid, int count, 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 str = this.getJdbcTemplate().update(sql, count, sid);
        if (str>0){
            flag=true;
        }
        return flag;
    }
}



写一个类   来模拟错误  

package cn.happy.spring21tx.cn.happy.entity;

/**
 * Created by Happy on 2017-08-04.
 * StockException 异常
 * 编译时 编译时
 *
 * 依据：
 */
public class StockException extends Exception {
    public StockException() {
        super();
    }

    public StockException(String message) {
        super(message);
    }
}

service层

package cn.happy.spring21tx.cn.happy.service;

import cn.happy.spring21tx.cn.happy.entity.Account;
import cn.happy.spring21tx.cn.happy.entity.Stock;
import cn.happy.spring21tx.cn.happy.entity.StockException;

/**
 * Created by Happy on 2017-08-04.
 */
public interface IAccountService {
    //开户的方法
    public boolean addAccount(Account account);
    //股票初始化的方法
    public boolean addStock(Stock account);
    //購買股票的方法

    /**
     * @param sid  股票代號
     * @param count  購買股數
     * @param aid    賬戶代號
     * @param money  賬戶支出金額
     */
    public void buyStock(int sid,int count,int aid,double money) throws StockException;

}

service实现

package cn.happy.spring21tx.cn.happy.service;

import cn.happy.spring21tx.cn.happy.dao.IAccountDAO;
import cn.happy.spring21tx.cn.happy.dao.IStockDAO;
import cn.happy.spring21tx.cn.happy.entity.Account;
import cn.happy.spring21tx.cn.happy.entity.Stock;
import cn.happy.spring21tx.cn.happy.entity.StockException;

/**
 * Created by Happy on 2017-08-04.
 */
public class AccountServiceImpl implements IAccountService {

    //植入AccountDao對象
    private IAccountDAO accountDAO;
    //植入StockDAO對象
    private IStockDAO  stockDAO;

    public boolean addAccount(Account account) {
        return false;
    }

    public boolean addStock(Stock account) {
        return false;
    }

    //
    public void buyStock(int sid, int count, int aid, double money) throws StockException {
        //默认是购买股票
        boolean isBuy=true;

         //01.賬戶
         accountDAO.updateAccount(aid,money,isBuy);

            //编译时异常  SPring处理 方式
            //编译时 SPring事务自动提交

            //运行时   SPring 自动回滚
           if(1==1) {
               throw new StockException();
           }
        //02.股票表
        stockDAO.updateStock(sid,count,isBuy);
    }

    public IAccountDAO getAccountDAO() {
        return accountDAO;
    }

    public void setAccountDAO(IAccountDAO accountDAO) {
        this.accountDAO = accountDAO;
    }

    public IStockDAO getStockDAO() {
        return stockDAO;
    }

    public void setStockDAO(IStockDAO stockDAO) {
        this.stockDAO = stockDAO;
    }
}
jdbc.properties

jdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql:///testjdbc.user=rootjdbc.password=rootSpringtx.xml 

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"       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"       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/context  http://www.springframework.org/schema/context/spring-context.xsd">    <context:property-placeholder location="jdbc.properties"></context:property-placeholder>    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">        <property name="driverClassName" value="${jdbc.driverClassName}"></property>        <property name="url" value="${jdbc.url}"></property>        <property name="username" value="${jdbc.user}"/>        <property name="password" value="${jdbc.password}"/>    </bean>    <bean id="accountDao" class="Springtx.dao.AccountDAOImpl">        <property name="dataSource" ref="dataSource"/>    </bean>    <bean id="stockDao" class="Springtx.dao.StockDAOImpl">        <property name="dataSource" ref="dataSource"></property>    </bean>    <bean id="accountService" class="Springtx.service.AccountServiceImpl">        <property name="accountDAO" ref="accountDao"></property>        <property name="stockDAO" ref="stockDao"/>    </bean>    <!--事务管理器 -->    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource"></property>    </bean><!--     配置事务 拦截 业务方法    <bean id="accountSerciceProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">        -目标 类型        <property name="target" ref="accountService"></property>        <property name="transactionManager" ref="transactionManager"></property>        增强        <property name="transactionAttributes">            <props>                <prop key="buy*">ISOLATION_DEFAULT,PROPAGATION_REQUIRED,-StockException</prop>            </props>        </property>    </bean>    增强--></beans>

单侧

@Test// 01.jdbctemplatepublic void test02() {    ApplicationContext ctx = new ClassPathXmlApplicationContext("Springtx.xml");    IAccountService service = (IAccountService) ctx.getBean("accountService");    try {        service.buyStock(1,2,1,1000);    } catch (Exception e) {        e.printStackTrace();    }}

POM层

    <dependency>        <groupId>org.springframework</groupId>        <artifactId>spring-beans</artifactId>        <version>4.2.2.RELEASE</version>    </dependency>    <!--Spring-Context架包-->    <dependency>        <groupId>org.springframework</groupId>        <artifactId>spring-context</artifactId>        <version>4.2.2.RELEASE</version>    </dependency>    <dependency>        <groupId>junit</groupId>        <artifactId>junit</artifactId>        <version>4.12</version>    </dependency>    <dependency>        <groupId> org.aspectj</groupId >        <artifactId> aspectjweaver</artifactId >        <version> 1.8.7</version>    </dependency>    <dependency>        <groupId>org.springframework</groupId>        <artifactId>spring-jdbc</artifactId>        <version>4.3.9.RELEASE</version>    </dependency>    <dependency>        <groupId>mysql</groupId>        <artifactId>mysql-connector-java</artifactId>        <version>5.1.38</version>    </dependency></dependencies><build>    <resources>        <resource>            <directory>src/main/java</directory>            <includes>                <include>**/*.xml</include>            </includes>        </resource>    </resources></build>

编译时异常

：exceptio     Spring 的处理方式：自动提交

运行时异常：

Runtime    Spring 的处理方式：自动回滚

事务管理器就是个bean

properties 继承 Hashtable  继承 Dictionory

数据库四种隔离级别
1.读未提交  Read_Uncommitted
2.读已经提交 Read_committed
3.可重复读  Repeatable_read
4.串行化    Serializable