• spring事务实现方式有哪些?


    • 编程式事务管理,在代码中调用 commit()、rollback()等事务管理相关的方法

    maven pom.xml文件

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-beans</artifactId>
        <version>4.2.4.RELEASE</version>
    </dependency>
     
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>4.2.4.RELEASE</version>
    </dependency>
     
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</artifactId>
        <version>4.2.4.RELEASE</version>
    </dependency>
     
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>4.2.4.RELEASE</version>
    </dependency>
     
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>4.2.4.RELEASE</version>
    </dependency>
     
    <!-- mysql驱动 -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.18</version>
    </dependency>
     

    编程式事务管理,可以通过 java.sql.Connection 控制事务。spring 配置文件

    <?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:context="http://www.springframework.org/schema/context"
        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">
            
        <bean id="driver" class="com.mysql.jdbc.Driver"></bean>
     
        <bean id="datasource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
            <constructor-arg index="0" name="driver" ref="driver" />
            <constructor-arg index="1">
                <value>jdbc:mysql://localhost:3306/test</value>
            </constructor-arg>
            <constructor-arg index="2">
                <value>root</value>
            </constructor-arg>
            <constructor-arg index="3">
                <value>root</value>
            </constructor-arg>
        </bean>
        
    </beans>

    测试代码

    package constxiong.interview.transaction;
     
    import java.sql.Connection;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
     
    import javax.sql.DataSource;
     
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
     
    public class TransactionTest {
     
        public static void main(String[] args) throws Exception {
            testManualTransaction();//测试函数式控制事务
        }
        
        private static void testManualTransaction() throws SQLException {
            ApplicationContext context = new ClassPathXmlApplicationContext("spring_transaction.xml");
            DataSource ds = (DataSource)context.getBean("datasource");
            Connection conn = ds.getConnection();
            try {
                initTable(conn);//初始化表
                conn.setAutoCommit(false);//设置不自动提交事务
                queryUsers(conn);//查询打印用户表
                deleteUser(conn);//删除 id=1 用户
                conn.rollback();//回滚
                queryUsers(conn);//查询打印用户表
            } finally {
                conn.close();
            }
        }
     
        private static void initTable(Connection conn) throws SQLException {
            conn.createStatement().execute("drop table if exists user");
            conn.createStatement().execute("create table user(id int, username varchar(60)) ENGINE=InnoDB DEFAULT CHARSET=utf8 ");//是否支持事务与数据库引擎有关,此处删除 ENGINE=InnoDB DEFAULT CHARSET=utf8 可能不支持事务
            conn.createStatement().execute("insert into user values(1, 'user1')");
            conn.createStatement().execute("insert into user values(2, 'user2')");
        }
     
        private static void deleteUser(Connection conn) throws SQLException {
            conn.createStatement().execute("delete from user where id = 1");
        }
     
        private static void queryUsers(Connection conn) throws SQLException {
            Statement st = conn.createStatement();
            st.execute("select * from user");
            ResultSet rs = st.getResultSet();
            while (rs.next()) {
                System.out.print(rs.getString("id"));
                System.out.print(" ");
                System.out.print(rs.getString("username"));
                System.out.println();
            }
        }
        
    }

    删除用户语句回滚,打印出两个用户

    1 user1
    2 user2
    1 user1
    2 user2
    • 基于 TransactionProxyFactoryBean 的声明式事务管理

    新增 UserDao 接口

    package constxiong.interview.transaction;
     
    import java.util.List;
    import java.util.Map;
     
    public interface UserDao {
     
        /**
         * 查询用户
         * @return
         */
        public List<Map<String, Object>> getUsers();
        
        /**
         * 删除用户
         * @param id
         * @return
         */
        public int deleteUser(int id);
        
    }

    新增 UserDao 实现

    package constxiong.interview.transaction;
     
    import java.util.List;
    import java.util.Map;
     
    import org.springframework.jdbc.core.support.JdbcDaoSupport;
     
    public class UserDaoImpl extends JdbcDaoSupport implements UserDao {
        
        /**
         * 查询用户
         * @return
         */
        public List<Map<String, Object>> getUsers() {
            String sql = "select * from user";
            return this.getJdbcTemplate().queryForList(sql);
        }
        
        /**
         * 删除用户
         * @param id
         * @return
         */
        public int deleteUser(int id){
            String sql = "delete from user where id = " + id;
            int result = this.getJdbcTemplate().update(sql);
            if (id == 1) {
                throw new RuntimeException();
            }
            return result;
        }
    }

    修改 spring 配置文件,添加事务管理器 DataSourceTransactionManager 和事务代理类 TransactionProxyFactoryBean

    <?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:context="http://www.springframework.org/schema/context"
        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">
            
        <bean id="driver" class="com.mysql.jdbc.Driver"></bean>
        
        <bean id="datasource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
            <constructor-arg index="0" name="driver" ref="driver" />
            <constructor-arg index="1">
                <value>jdbc:mysql://localhost:3306/test</value>
            </constructor-arg>
            <constructor-arg index="2">
                <value>root</value>
            </constructor-arg>
            <constructor-arg index="3">
                <value>root</value>
            </constructor-arg>
        </bean>
        
        <bean id="userDao" class="constxiong.interview.transaction.UserDaoImpl">
            <property name="dataSource" ref="datasource"></property>
        </bean>
        
        <!-- 事务管理器 -->
        <bean id="tracnsactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="datasource"></property>
        </bean>
        
        <bean id="userProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
            <property name="transactionManager" ref="tracnsactionManager"></property>
            <property name="target" ref="userDao"></property>
            <property name="transactionAttributes">
                <props>
                    <!-- 主要 key 是方法   
                        ISOLATION_DEFAULT  事务的隔离级别
                        PROPAGATION_REQUIRED  传播行为
                    -->
                    <!-- -Exception 表示发生指定异常回滚,+Exception 表示发生指定异常提交 -->
                    <prop key="deleteUser">-java.lang.RuntimeException</prop>
                </props>
            </property>
        </bean>
        
    </beans>

    测试代码

    package constxiong.interview.transaction;
     
    import java.util.Map;
     
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
     
    public class TransactionTest {
     
        static ApplicationContext context = new ClassPathXmlApplicationContext("spring_transaction.xml");
        
        public static void main(String[] args) throws Exception {
            testUseTransactionProxy(); //测试使用 spring TransactionProxyFactoryBean
        }
        
        private static void testUseTransactionProxy() {
            final UserDao userDao = (UserDao)context.getBean("userProxy");
            printUsers(userDao);//打印用户
            userDao.deleteUser(1);//删除 id=1 用户
        }
     
        private static void printUsers(UserDao userDao) {
            for (Map<String, Object> user : userDao.getUsers()) {
                System.out.println(user);
            }
        }
     
    }

     结果输出

    {id=1, username=user1}
    {id=2, username=user2}
    Exception in thread "main" java.lang.RuntimeException
        at constxiong.interview.transaction.UserDaoImpl.deleteUser(UserDaoImpl.java:28)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
        at com.sun.proxy.$Proxy3.deleteUser(Unknown Source)
        at constxiong.interview.transaction.TransactionTest.testUseTransactionProxy(TransactionTest.java:32)
        at constxiong.interview.transaction.TransactionTest.main(TransactionTest.java:13)

    • 基于注解 @Transactional 的声明式事务管理

    UserDaoImpl 删除用户方法添加注解 @Transactional(rollbackFor=RuntimeException.class) 出现 RuntimeException 回滚

    package constxiong.interview.transaction;
     
    import java.util.List;
    import java.util.Map;
     
    import org.springframework.jdbc.core.support.JdbcDaoSupport;
    import org.springframework.transaction.annotation.Transactional;
     
    public class UserDaoImpl extends JdbcDaoSupport implements UserDao {
        
        /**
         * 查询用户
         * @return
         */
        public List<Map<String, Object>> getUsers() {
            String sql = "select * from user";
            return this.getJdbcTemplate().queryForList(sql);
        }
        
        /**
         * 删除用户
         * @param id
         * @return
         */
        @Transactional(rollbackFor=RuntimeException.class)
        public int deleteUser(int id){
            String sql = "delete from user where id = " + id;
            int result = this.getJdbcTemplate().update(sql);
            if (id == 1) {
                throw new RuntimeException();
            }
            return result;
        }
    }

    修改 spring 配置文件,开启 spring 的事务注解能力

    <?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:context="http://www.springframework.org/schema/context"
        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/tx
            http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context.xsd">
            
        <bean id="driver" class="com.mysql.jdbc.Driver"></bean>
        
        <bean id="datasource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
            <constructor-arg index="0" name="driver" ref="driver" />
            <constructor-arg index="1">
                <value>jdbc:mysql://localhost:3306/test</value>
            </constructor-arg>
            <constructor-arg index="2">
                <value>root</value>
            </constructor-arg>
            <constructor-arg index="3">
                <value>root</value>
            </constructor-arg>
        </bean>
        
        <bean id="userDao" class="constxiong.interview.transaction.UserDaoImpl">
            <property name="dataSource" ref="datasource"></property>
        </bean>
        
        <!-- 事务管理器 -->
        <bean id="tracnsactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="datasource"></property>
        </bean>
        
        <!-- 启用事务注解 -->
        <tx:annotation-driven transaction-manager="tracnsactionManager"/>
        
    </beans>

    测试代码

    package constxiong.interview.transaction;
     
    import java.util.Map;
     
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
     
    public class TransactionTest {
     
        static ApplicationContext context = new ClassPathXmlApplicationContext("spring_transaction.xml");
        
        public static void main(String[] args) throws Exception {
            testAnnotationTransaction();
        }
        
        
        private static void testAnnotationTransaction() {
            UserDao userDao = (UserDao)context.getBean("userDao");
            printUsers(userDao);
            userDao.deleteUser(1);
        }
     
     
        private static void printUsers(UserDao userDao) {
            for (Map<String, Object> user : userDao.getUsers()) {
                System.out.println(user);
            }
        }
     
    }

    输出结果

    {id=1, username=user1}
    {id=2, username=user2}
    Exception in thread "main" java.lang.RuntimeException
        at constxiong.interview.transaction.UserDaoImpl.deleteUser(UserDaoImpl.java:30)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
        at com.sun.proxy.$Proxy5.deleteUser(Unknown Source)
        at constxiong.interview.transaction.TransactionTest.testAnnotationTransaction(TransactionTest.java:20)
        at constxiong.interview.transaction.TransactionTest.main(TransactionTest.java:13)

    • 基于 Aspectj AOP 配置(注解)事务

    maven pom.xml 添加 Aspectj 的支持

    <dependency>
        <groupId>org.aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>1.8.13</version>
    </dependency>

    去除 UserDaoImpl 注解@Transactional(rollbackFor=RuntimeException.class)

    package constxiong.interview.transaction;
     
    import java.util.List;
    import java.util.Map;
     
    import org.springframework.jdbc.core.support.JdbcDaoSupport;
     
    public class UserDaoImpl extends JdbcDaoSupport implements UserDao {
        
        /**
         * 查询用户
         * @return
         */
        public List<Map<String, Object>> getUsers() {
            String sql = "select * from user";
            return this.getJdbcTemplate().queryForList(sql);
        }
        
        /**
         * 删除用户
         * @param id
         * @return
         */
        public int deleteUser(int id){
            String sql = "delete from user where id = " + id;
            int result = this.getJdbcTemplate().update(sql);
            if (id == 1) {
                throw new RuntimeException();
            }
            return result;
        }
    }

    修改 spring 配置文件,织入切面

    <?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:context="http://www.springframework.org/schema/context"
        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.xsd
            http://www.springframework.org/schema/tx
            http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
            http://www.springframework.org/schema/aop
            http://www.springframework.org/schema/aop/spring-aop.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context.xsd">
            
        <bean id="driver" class="com.mysql.jdbc.Driver"></bean>
        
        <bean id="datasource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
            <constructor-arg index="0" name="driver" ref="driver" />
            <constructor-arg index="1">
                <value>jdbc:mysql://localhost:3306/test</value>
            </constructor-arg>
            <constructor-arg index="2">
                <value>root</value>
            </constructor-arg>
            <constructor-arg index="3">
                <value>root</value>
            </constructor-arg>
        </bean>
        
        <bean id="userDao" class="constxiong.interview.transaction.UserDaoImpl">
            <property name="dataSource" ref="datasource"></property>
        </bean>
        
        <!-- 事务管理器 -->
        <bean id="tracnsactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="datasource"></property>
        </bean>
        
        <tx:advice id="txAdvice" transaction-manager="tracnsactionManager">
            <tx:attributes>
                <!-- 为连接点指定事务属性 -->
                <tx:method name="deleteUser" rollback-for="java.lang.RuntimeException"/>
            </tx:attributes>
        </tx:advice>
        
        <aop:config>
            <!-- 切入点配置 -->
            <aop:pointcut id="point" expression="execution(* *constxiong.interview.transaction.UserDao.deleteUser(..))" />
            <aop:advisor advice-ref="txAdvice" pointcut-ref="point"/>
        </aop:config>
        
    </beans>

    测试代码

    package constxiong.interview.transaction;
     
    import java.util.Map;
     
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
     
    public class TransactionTest {
     
        static ApplicationContext context = new ClassPathXmlApplicationContext("spring_transaction.xml");
        
        public static void main(String[] args) throws Exception {
            testAspectjTransaction();
        }
        
        
        private static void testAspectjTransaction() {
            UserDao userDao = (UserDao)context.getBean("userDao");
            printUsers(userDao);
            userDao.deleteUser(1);
        }
     
     
        private static void printUsers(UserDao userDao) {
            for (Map<String, Object> user : userDao.getUsers()) {
                System.out.println(user);
            }
        }
     
    }

    输出结果

    {id=1, username=user1}
    {id=2, username=user2}
    Exception in thread "main" java.lang.RuntimeException
        at constxiong.interview.transaction.UserDaoImpl.deleteUser(UserDaoImpl.java:28)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
        at com.sun.proxy.$Proxy2.deleteUser(Unknown Source)
        at constxiong.interview.transaction.TransactionTest.testAnnotationTransaction(TransactionTest.java:20)
        at constxiong.interview.transaction.TransactionTest.main(TransactionTest.java:13)

    PS:

    这篇仅用事务回滚为例,了解 spring 事务控制,还需要关注数据库的ACID四种特性、事务传播特性、事务的隔离级别(脏读、不可重复读、幻读)。

    详细可参考:https://blog.csdn.net/chinacr07/article/details/78817449

    spring 事务的源码学习可以参考:


    原文链接
     


     

  • 相关阅读:
    死锁
    Hibernate—01
    POI
    线程 Thread
    SSH页面整合_01
    cnblogs安家了
    漫画:天堂里没有程序员!
    我又愿中国青年都只是向上走,不必理会这冷笑和暗箭!!!!!!!!
    一位信息系统项目管理培训老师写的《论婚姻项目管理》值得看一下!
    程序员保持健康的方法和经验
  • 原文地址:https://www.cnblogs.com/ConstXiong/p/12123299.html
Copyright © 2020-2023  润新知