事务的隔离级别
事务类型
Spring事务管理
具体文件组成
applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.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">
<!--====================================================-->
<!--what:事务管理器的配置-->
<bean id="txmanager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="datasource"></property>
</bean>
<!--when:事务增强的时机-->
<tx:advice transaction-manager="txmanager" id="txadvice">
<tx:attributes>
<tx:method name="trans"/>
</tx:attributes>
</tx:advice>
<!--在哪些包下的哪些类进行增强-->
<aop:config>
<!--切入点-->
<aop:pointcut id="txpoint" expression="execution(* account.service.*service.*(..))"></aop:pointcut>
<!--关联-->
<aop:advisor advice-ref="txadvice" pointcut-ref="txpoint"></aop:advisor>
</aop:config>
<!--====================================================-->
<!--dao的配置-->
<bean id="accountdao" class="account.dao.impl.accountdaoimpl">
<property name="dataSource" ref="datasource"></property>
</bean>
<bean id="service" class="account.service.impl.accountserviceimpl">
<property name="dao" ref="accountdao"></property>
</bean>
<context:annotation-config></context:annotation-config>
<!--扫描包-->
<context:component-scan base-package="account"></context:component-scan>
<!--AOP自动代理-->
<aop:aspectj-autoproxy></aop:aspectj-autoproxy>
<context:property-placeholder location="classpath:db.properties"></context:property-placeholder>
<!--配置连接池-->
<bean id="datasource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<property name="driverClassName" value="${jdbc.driverClassName}"></property>
<property name="url" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
<property name="maxActive" value="${jdbc.maxActive}"></property>
</bean>
</beans>
db.properties
#key=value
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/springjdbc?rewriteBatchedStatements=true
jdbc.username=root
jdbc.password=123456
jdbc.maxActive=5
account类
package account.domain;
public class account {
Long id;
Integer money;
public account(Long id, Integer money) {
this.id = id;
this.money = money;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public Integer getMoney() {
return money;
}
public void setMoney(Integer money) {
this.money = money;
}
}
accountdao接口
package account.dao;
public interface accountdao {
/**
* 给指定用户存入多少钱
* @param Inid
* @param inmoney
*/
void transIn(Long Inid,Integer inmoney);
/**
* 给指定用户转出多少钱
* @param Outid
* @param outmoney
*/
void transOut(Long Outid,Integer outmoney);
}
accountdaoimpl实现类
package account.dao.impl;
import account.dao.accountdao;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
public class accountdaoimpl extends JdbcDaoSupport implements accountdao {
@Override
public void transIn(Long Inid, Integer inmoney) {
super.getJdbcTemplate().update("UPDATE account SET money=money+? WHERE id=?",inmoney,Inid);
}
@Override
public void transOut(Long Outid, Integer outmoney) {
super.getJdbcTemplate().update("UPDATE account SET money=money-? WHERE id=?",outmoney,Outid);
}
}
accountservice接口
package account.service;
public interface accountservice {
void trans(Long outid,Long inid,Integer money);
}
accountserviceimpl实现类
package account.service.impl;
import account.dao.accountdao;
import account.service.accountservice;
import org.springframework.beans.factory.annotation.Autowired;
public class accountserviceimpl implements accountservice {
private accountdao dao;
public accountdao getDao() {
return dao;
}
public void setDao(accountdao dao) {
this.dao = dao;
}
@Override
public void trans(Long outid, Long inid, Integer money) {
dao.transOut(outid,money);
int a=10/0;
dao.transIn(inid,money);
}
}
test测试方法
package account.test;
import account.service.accountservice;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class test {
@Autowired
@Qualifier("service")
private accountservice service;
@Test
public void test(){
service.trans(11086L,10100L,1000);
}
}
测试结果(当出现错误时,不会进行)
接下来注解方式的配置:
具体文件组成
applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.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">
<context:annotation-config></context:annotation-config>
<!--扫描包-->
<context:component-scan base-package="accountregis"></context:component-scan>
<!--AOP自动代理-->
<aop:aspectj-autoproxy></aop:aspectj-autoproxy>
<context:property-placeholder location="classpath:db.properties"></context:property-placeholder>
<!--事务注解解析器 必须得更改transaction-manager="txmanager",否则会默认为一个固定的名字-->
<tx:annotation-driven transaction-manager="txmanager"></tx:annotation-driven>
<!--事务管理器的配置-->
<bean id="txmanager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="datasource"></property>
</bean>
<!--配置连接池-->
<bean id="datasource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<property name="driverClassName" value="${jdbc.driverClassName}"></property>
<property name="url" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
<property name="maxActive" value="${jdbc.maxActive}"></property>
</bean>
</beans>
db.properties
#key=value
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/springjdbc?rewriteBatchedStatements=true
jdbc.username=root
jdbc.password=123456
jdbc.maxActive=5
account类
package accountregis.domain;
public class account {
Long id;
Integer money;
public account(Long id, Integer money) {
this.id = id;
this.money = money;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public Integer getMoney() {
return money;
}
public void setMoney(Integer money) {
this.money = money;
}
}
accountdao接口
package accountregis.dao;
public interface accountdao {
void transIn(Long Inid,Integer money);
void transOut(Long Outid,Integer money);
}
accountdaoimpl实现类
package accountregis.dao.impl;
import accountregis.dao.accountdao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
import javax.sql.DataSource;
@Repository("dao")
public class accountdaoimpl implements accountdao {
private JdbcTemplate jdbcTemplate;
@Autowired
public void setDataSource(DataSource dataSource) {
this.jdbcTemplate = new JdbcTemplate(dataSource);
}
@Override
public void transIn(Long Inid, Integer money) {
jdbcTemplate.update("UPDATE account SET money=money+? WHERE id=?",money,Inid);
}
@Override
public void transOut(Long Outid, Integer money) {
jdbcTemplate.update("UPDATE account SET money=money-? WHERE id=?",money,Outid);
}
}
accountservice接口
package accountregis.service;
public interface accountservice {
void trans(Long outid,Long inid,Integer money);
}
accountserviceimpl实现类
package accountregis.service.impl;
import accountregis.dao.accountdao;
import accountregis.service.accountservice;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
//事务是配置在service方法上的
@Service("service")
@Transactional //针对类中的所有方法使用同一种配置
public class accountserviceimpl implements accountservice {
@Autowired
private accountdao dao;
@Override
@Transactional//针对当前方法使用特殊配置如查询方法(readOnly=true)
public void trans(Long outid, Long inid, Integer money) {
dao.transIn(inid,money);
int a=10/0;
dao.transOut(outid,money);
}
}
test测试方法
package accountregis.test;
import accountregis.service.accountservice;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class test {
@Autowired
private accountservice service;
@Test
public void test(){
service.trans(11086L,10100L,10);
}
}
测试结果(当出现错误时,不会进行)