import javax.annotation.Resource;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:cn/itcast/d_ts/applicationContext.xml")
public class Demo {
@Resource(name="bs")
private BalanceService bs;
@Test
public void fun1(){
bs.transfer(1,2, 100);
}
}
package cn.itcast.d_ts;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.TransactionDefinition;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.interceptor.DefaultTransactionAttribute;
import org.springframework.transaction.support.DefaultTransactionDefinition;
import org.springframework.transaction.support.TransactionCallback;
import org.springframework.transaction.support.TransactionTemplate;
public class BalanceService {
private BalanceDao bd;
//转账方法
public void transfer(final int id,final int id2,final double money){
bd.deductMoney(id,money);//扣钱
int i = 1/0;
bd.addMoney(id2,money);
}
public BalanceDao getBd() {
return bd;
}
public void setBd(BalanceDao bd) {
this.bd = bd;
}
}
package cn.itcast.d_ts;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
public class BalanceDao extends JdbcDaoSupport {
public void deductMoney(int id, double money) {
getJdbcTemplate().update("update t_balance set money=money-? where id = ? ",money,id);
}
public void addMoney(int id2, double money) {
getJdbcTemplate().update("update t_balance set money=money+? where id = ? ",money,id2);
}
}