使用DBUtil框架实现事务的处理

项目中各类的结构：

1.AccountDao接口：

package com.itheima.dao;

public interface AccountDao {
    /**
     * 转账
     * @param sourceAccountName 转出账户
     * @param targetAccontName 转入账户
     * @param money 交易金额
     */
    void transfer(String sourceAccountName,String targetAccontName,float money);
}

2。AccountDaoImpl类：

package com.itheima.dao.impl;

import java.sql.Connection;
import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;

import com.itheima.dao.AccountDao;
import com.itheima.util.DBCPUtil;
/*
create table account(
    id int primary key auto_increment,
    name varchar(40),
    money float
)character set utf8 collate utf8_general_ci;

insert into account(name,money) values('aaa',1000);
insert into account(name,money) values('bbb',1000);
insert into account(name,money) values('ccc',1000);
 */
public class AccountDaoImpl implements AccountDao {
    private QueryRunner qr = new QueryRunner();
    public void transfer(String sourceAccountName, String targetAccontName,
            float money) {
        Connection conn = null;
        try {
            conn = DBCPUtil.getConnection();
            conn.setAutoCommit(false);//开启事务
            qr.update(conn,"update account set money=money-? where name=?", money,sourceAccountName);
            int i=1/0;
            qr.update(conn,"update account set money=money+? where name=?", money,targetAccontName);
        } catch (Exception e) {
            if(conn!=null){
                try {
                    conn.rollback();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
            }
            e.printStackTrace();
        }finally{
            if(conn!=null){
                try {
                    conn.commit();
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }

    }

}

3.BusinessService接口：

package com.itheima.service;

public interface BusinessService {
    /**
     * 转账
     * @param sourceAccountName 转出账户
     * @param targetAccontName 转入账户
     * @param money 交易金额
     */
    void transfer(String sourceAccountName,String targetAccontName,float money);
}

4.BusinessServiceImpl类：

package com.itheima.service.impl;

import com.itheima.dao.AccountDao;
import com.itheima.dao.impl.AccountDaoImpl;
import com.itheima.service.BusinessService;

public class BusinessServiceImpl implements BusinessService {
    private AccountDao dao = new AccountDaoImpl();
    public void transfer(String sourceAccountName, String targetAccontName,
            float money) {
        dao.transfer(sourceAccountName, targetAccontName, money);
    }

}

5.DBCPUtil类：

package com.itheima.util;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;

import javax.sql.DataSource;

import org.apache.commons.dbcp.BasicDataSourceFactory;

public class DBCPUtil {

    private static DataSource dataSource;
    static{
        try {
            InputStream in = DBCPUtil.class.getClassLoader().getResourceAsStream("dbcpconfig.properties");
            Properties props = new Properties();
            props.load(in);
            dataSource = BasicDataSourceFactory.createDataSource(props);
        } catch (Exception e) {
            throw new ExceptionInInitializerError(e);
        }
    }
    public static DataSource getDataSource(){
        return dataSource;
    }

    public static Connection getConnection(){
        try {
            return dataSource.getConnection();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
}

6.Client类（模拟用户层）：

package com.itheima.view;

import com.itheima.service.BusinessService;
import com.itheima.service.impl.BusinessServiceImpl;

public class Client {

    public static void main(String[] args) {
        BusinessService s = new BusinessServiceImpl();
        s.transfer("aaa", "bbb", 100);
    }

}