Spring 事务管理（基于xml方式和注解方式）

一。创建数据库

二。建立OrderDao OrderService 和测试类

package springcount;import org.springframework.transaction.annotation.Transactional;import c3p0.UserDao;public class OrderService {private OrderDao orderDao;public OrderDao getOrderDao() {return orderDao;}public void setOrderDao(OrderDao orderDao) {this.orderDao = orderDao;}public void count(){//小明账户减少orderDao.lessmoney();int i=10/0;//小李账户增加orderDao.moremoney();}}

package springcount;import org.springframework.jdbc.core.JdbcTemplate;public class OrderDao {private JdbcTemplate jdbcTemplate;public JdbcTemplate getJdbcTemplate() {return jdbcTemplate;}public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {this.jdbcTemplate = jdbcTemplate;}public void lessmoney(){String sql="update test3 set sarlary=sarlary-? where username=?";jdbcTemplate.update(sql,"1000","xiaowang");}public void moremoney(){String sql="update test3 set sarlary=sarlary+? where username=?";jdbcTemplate.update(sql,"1000","xiaoli");}}

package springcount;import org.junit.Test;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;public class TestCount {@Testpublic void testCount(){ApplicationContext context=new ClassPathXmlApplicationContext("applicationContext2.xml");OrderService orderService=(OrderService)context.getBean("orderService");orderService.count();}}

三。写applicationContext2.xml文件（基于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:tx="http://www.springframework.org/schema/tx"xmlns:aop="http://www.springframework.org/schema/aop"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd  http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd"><!-- 配置c3po连接池 --><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="driverClass" value="com.mysql.jdbc.Driver"></property><property name="jdbcUrl" value="jdbc:mysql://120.27.104.36:3306/test"></property><property name="user" value="hpn"></property><property name="password" value="hpn2017"></property></bean><!--第一步，配置事务管理器  --><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><!--注入dataSource  --><property name="dataSource" ref="dataSource"></property></bean><!--第二步，配置事务增强  --> <tx:advice id="txadvice" transaction-manager="transactionManager"><tx:attributes><tx:method name="count"/></tx:attributes></tx:advice><!--第三步，配置切面  --> <aop:config><aop:pointcut expression="execution(* springcount.OrderService.*(..))" id="pointcut1"/><aop:advisor advice-ref="txadvice" pointcut-ref="pointcut1"/></aop:config><bean id="orderDao" class="springcount.OrderDao"><property name="jdbcTemplate" ref="jdbcTemplate"></property></bean><bean id="orderService" class="springcount.OrderService"><!-- 注入dao对象 --><property name="orderDao" ref="orderDao"></property></bean><!-- 创建jdbcTemplate对象 --><bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"><property name="dataSource" ref="dataSource"></property></bean></beans>

基于注解方式：

<?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:tx="http://www.springframework.org/schema/tx"xmlns:aop="http://www.springframework.org/schema/aop"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd  http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd"><!-- 配置c3po连接池 --><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="driverClass" value="com.mysql.jdbc.Driver"></property><property name="jdbcUrl" value="jdbc:mysql://120.27.104.36:3306/test"></property><property name="user" value="hpn"></property><property name="password" value="hpn2017"></property></bean><!--第一步，配置事务管理器  --><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><!--注入dataSource  --><property name="dataSource" ref="dataSource"></property></bean><tx:annotation-driven transaction-manager="transactionManager"/><!--第二步，配置事务增强  --> <!-- <tx:advice id="txadvice" transaction-manager="transactionManager"> --><!-- <tx:attributes> --><!-- <tx:method name="count"/> --><!-- </tx:attributes> --><!-- </tx:advice> --><!--第三步，配置切面  --> <!-- <aop:config> --><!-- <aop:pointcut expression="execution(* springcount.OrderService.*(..))" id="pointcut1"/> --><!-- <aop:advisor advice-ref="txadvice" pointcut-ref="pointcut1"/> --><!-- </aop:config> --><bean id="orderDao" class="springcount.OrderDao"><property name="jdbcTemplate" ref="jdbcTemplate"></property></bean><bean id="orderService" class="springcount.OrderService"><!-- 注入dao对象 --><property name="orderDao" ref="orderDao"></property></bean><!-- 创建jdbcTemplate对象 --><bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"><property name="dataSource" ref="dataSource"></property></bean></beans>

另外还需要在OrderService类前加注释@

@Transactionalpublic class OrderService {private OrderDao orderDao;public OrderDao getOrderDao() {return orderDao;}public void setOrderDao(OrderDao orderDao) {this.orderDao = orderDao;}public void count(){//小明账户减少orderDao.lessmoney();int i=10/0;//小李账户增加orderDao.moremoney();}}