1.spring中的TransactionManager接口
DateSourceTransactionManager 用于JDBC的事务管理
HibernateTransactionManager用于Hibernate的事务管理
JpaTransactionManager 用于Jpa的事物管理
2.spring中TransactionManager接口的定义(源码)
事务的属性介绍:这里定义了传播行为、隔离级别、超时时间、是否只读
3.转账案例
(1)项目结构
(2)导入jar
(3)建立数据库测试数据
CREATE DATABASE springjdbc
USE springjdbc
CREATE TABLE `ar_account` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`money` double(255,0) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ar_account
-- ----------------------------
INSERT INTO `ar_account` VALUES ('1', '张三', '60');
INSERT INTO `ar_account` VALUES ('2', '李四', '40');
(4)建立日志配置(log4j.properties)
# Global logging configuration
log4j.rootLogger=info, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
(5)建立数据库配置(db.properties)
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/springjdbc
jdbc.username=root
jdbc.password=root
(6)建立接口 AccountDao类与实现AccountDaoImpl类
package com.linxin.spring.dao;
public interface AccountDao {
//加钱
void addMoney(Integer id,Double money);
//减钱
void subMoney(Integer id,Double money);
}
package com.linxin.spring.dao;
import javax.annotation.Resource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
@Repository("accountDao")
public class AccountDaoImpl implements AccountDao {
@Resource(name="jdbctemplate")
private JdbcTemplate jt;
@Override
public void addMoney(Integer id, Double money) {
String sql= "update ar_account set money = money + ? where id= ?";
jt.update(sql,money,id);
}
@Override
public void subMoney(Integer id, Double money) {
String sql= "update ar_account set money = money - ? where id= ?";
jt.update(sql,money,id);
}
}
(7)创建AccountService接口类与实现类AccountServiceImpl
package com.linxin.spring.service;
public interface AccountService {
void transfer(Integer from, Integer to,Double money);
}
package com.linxin.spring.service;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import com.linxin.spring.dao.AccountDao;
@Service("accountService")
public class AccountServiceImpl implements AccountService {
@Resource(name="accountDao")
private AccountDao accountDao;
@Override
public void transfer(Integer from, Integer to, Double money) {
accountDao.addMoney(to, money);
int a=1/0;
accountDao.subMoney(from, money);
}
}
(8)创建spring配置文件application.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:centext="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.2.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.2.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.2.xsd ">
<!-- 加入扫描 -->
<centext:component-scan base-package="com.linxin.spring.dao"></centext:component-scan>
<centext:component-scan base-package="com.linxin.spring.service"></centext:component-scan>
<!-- 加载文件 -->
<centext:property-placeholder location="classpath:db.properties"/>
<!-- spring管理c3p0数据源 -->
<bean name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}"></property>
<property name="jdbcUrl" value="${jdbc.url}"></property>
<property name="user" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
</bean>
<!-- Jdbctemplate -->
<bean name="jdbctemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 事务管理 -->
<bean name="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<!-- 数据源 -->
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 通知 -->
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<!-- 传播行为 -->
<!-- 支持当前事务,如果不存在,就新建一个 -->
<tx:method name="transfer" propagation="REQUIRED"/>
</tx:attributes>
</tx:advice>
<!-- 切面(将通知织入切入点) -->
<aop:config>
<!-- 切入点 -->
<aop:pointcut expression="execution(* com.linxin.spring.service..*.*(..))" id="txPointcut"/>
<aop:advisor advice-ref="txAdvice" pointcut-ref="txPointcut"/>
</aop:config>
</beans>
(9)测试类
package com.linxin.spring.Testtx;
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;
import com.linxin.spring.service.AccountService;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class TestTx {
@Resource(name="accountService")
private AccountService accountService;
@Test
public void testTransfer() {
accountService.transfer(2, 1, 30.0);
}
}