2023-03-13  阅读(1)
原文作者:青花鱼罐头 原文地址:https://blog.csdn.net/qq_32782279/article/details/107826317

1. 概述

MyBatis 对数据库中的事务进行了抽象,其自身提供了相应的事务接口和简单实现。

在很多场景中,MyBatis 会与 Spring 框架集成,并由 Spring 框架管理事务

2. Transaction

org.apache.ibatis.transaction.Transaction ,事务接口。代码如下:

    public interface Transaction {
    
      /**
       * Retrieve inner database connection.
       * @return DataBase connection
       * @throws SQLException
       *           the SQL exception
       */
      Connection getConnection() throws SQLException;
    
      /**
       * Commit inner database connection.
       * @throws SQLException
       *           the SQL exception
       */
      void commit() throws SQLException;
    
      /**
       * Rollback inner database connection.
       * @throws SQLException
       *           the SQL exception
       */
      void rollback() throws SQLException;
    
      /**
       * Close inner database connection.
       * @throws SQLException
       *           the SQL exception
       */
      void close() throws SQLException;
    
      /**
       * Get transaction timeout if set.
       *
       * @return the timeout
       * @throws SQLException
       *           the SQL exception
       */
      Integer getTimeout() throws SQLException;
    
    }

2.1 JdbcTransaction

org.apache.ibatis.transaction.jdbc.JdbcTransaction ,实现 Transaction 接口,基于 JDBC 的事务实现类。代码如下:

    // JdbcTransaction.java
    
    public class JdbcTransaction implements Transaction {
    
        private static final Log log = LogFactory.getLog(JdbcTransaction.class);
    
        /**
         * Connection 对象
         */
        protected Connection connection;
        /**
         * DataSource 对象
         */
        protected DataSource dataSource;
        /**
         * 事务隔离级别
         */
        protected TransactionIsolationLevel level;
        /**
         * 是否自动提交
         */
        protected boolean autoCommit;
    
        public JdbcTransaction(DataSource ds, TransactionIsolationLevel desiredLevel, boolean desiredAutoCommit) {
            dataSource = ds;
            level = desiredLevel;
            autoCommit = desiredAutoCommit;
        }
    
        public JdbcTransaction(Connection connection) {
            this.connection = connection;
        }
    
        @Override
        public Connection getConnection() throws SQLException {
            // 连接为空,进行创建
            if (connection == null) {
                openConnection();
            }
            return connection;
        }
    
        @Override
        public void commit() throws SQLException {
            // 非自动提交,则执行提交事务
            if (connection != null && !connection.getAutoCommit()) {
                if (log.isDebugEnabled()) {
                    log.debug("Committing JDBC Connection [" + connection + "]");
                }
                connection.commit();
            }
        }
    
        @Override
        public void rollback() throws SQLException {
            // 非自动提交。则回滚事务
            if (connection != null && !connection.getAutoCommit()) {
                if (log.isDebugEnabled()) {
                    log.debug("Rolling back JDBC Connection [" + connection + "]");
                }
                connection.rollback();
            }
        }
    
        @Override
        public void close() throws SQLException {
            if (connection != null) {
                // 重置连接为自动提交
                resetAutoCommit();
                if (log.isDebugEnabled()) {
                    log.debug("Closing JDBC Connection [" + connection + "]");
                }
                // 关闭连接
                connection.close();
            }
        }
    
        /**
         * 设置指定的 autoCommit 属性
         *
         * @param desiredAutoCommit 指定的 autoCommit 属性
         */
        protected void setDesiredAutoCommit(boolean desiredAutoCommit) {
            try {
                if (connection.getAutoCommit() != desiredAutoCommit) {
                    if (log.isDebugEnabled()) {
                        log.debug("Setting autocommit to " + desiredAutoCommit + " on JDBC Connection [" + connection + "]");
                    }
                    connection.setAutoCommit(desiredAutoCommit);
                }
            } catch (SQLException e) {
                // Only a very poorly implemented driver would fail here,
                // and there's not much we can do about that.
                throw new TransactionException("Error configuring AutoCommit.  "
                        + "Your driver may not support getAutoCommit() or setAutoCommit(). "
                        + "Requested setting: " + desiredAutoCommit + ".  Cause: " + e, e);
            }
        }
    
        /**
         * 重置 autoCommit 属性
         */
        protected void resetAutoCommit() {
            try {
                if (!connection.getAutoCommit()) {
                    // MyBatis does not call commit/rollback on a connection if just selects were performed.
                    // Some databases start transactions with select statements
                    // and they mandate a commit/rollback before closing the connection.
                    // A workaround is setting the autocommit to true before closing the connection.
                    // Sybase throws an exception here.
                    if (log.isDebugEnabled()) {
                        log.debug("Resetting autocommit to true on JDBC Connection [" + connection + "]");
                    }
                    connection.setAutoCommit(true);
                }
            } catch (SQLException e) {
                if (log.isDebugEnabled()) {
                    log.debug("Error resetting autocommit to true "
                            + "before closing the connection.  Cause: " + e);
                }
            }
        }
    
        /**
         * 获得 Connection 对象
         *
         * @throws SQLException 获得失败
         */
        protected void openConnection() throws SQLException {
            if (log.isDebugEnabled()) {
                log.debug("Opening JDBC Connection");
            }
            // 获得连接
            connection = dataSource.getConnection();
            // 设置隔离级别
            if (level != null) {
                connection.setTransactionIsolation(level.getLevel());
            }
            // 设置 autoCommit 属性
            setDesiredAutoCommit(autoCommit);
        }
    
        @Override
        public Integer getTimeout() throws SQLException {
            return null;
        }
    
    }
2.2 ManagedTransaction

org.apache.ibatis.transaction.managed.ManagedTransaction ,实现 Transaction 接口,基于容器管理的事务实现类。代码如下:

    public class ManagedTransaction implements Transaction {
    
        private static final Log log = LogFactory.getLog(ManagedTransaction.class);
    
        /**
         * Connection 对象
         */
        private Connection connection;
        /**
         * DataSource 对象
         */
        private DataSource dataSource;
        /**
         * 事务隔离级别
         */
        private TransactionIsolationLevel level;
        /**
         * 是否关闭连接
         *
         * 这个属性是和 {@link org.apache.ibatis.transaction.jdbc.JdbcTransaction} 不同的
         */
        private final boolean closeConnection;
    
        public ManagedTransaction(Connection connection, boolean closeConnection) {
            this.connection = connection;
            this.closeConnection = closeConnection;
        }
    
        public ManagedTransaction(DataSource ds, TransactionIsolationLevel level, boolean closeConnection) {
            this.dataSource = ds;
            this.level = level;
            this.closeConnection = closeConnection;
        }
    
        @Override
        public Connection getConnection() throws SQLException {
            // 连接为空,进行创建
            if (this.connection == null) {
                openConnection();
            }
            return this.connection;
        }
    
        @Override
        public void commit() throws SQLException {
            // Does nothing
        }
    
        @Override
        public void rollback() throws SQLException {
            // Does nothing
        }
    
        @Override
        public void close() throws SQLException {
            // 如果开启关闭连接功能,则关闭连接
            if (this.closeConnection && this.connection != null) {
                if (log.isDebugEnabled()) {
                    log.debug("Closing JDBC Connection [" + this.connection + "]");
                }
                this.connection.close();
            }
        }
    
        protected void openConnection() throws SQLException {
            if (log.isDebugEnabled()) {
                log.debug("Opening JDBC Connection");
            }
            // 获得连接
            this.connection = this.dataSource.getConnection();
            // 设置隔离级别
            if (this.level != null) {
                this.connection.setTransactionIsolation(this.level.getLevel());
            }
        }
    
        @Override
        public Integer getTimeout() throws SQLException {
            return null;
        }
    
    }

3. TransactionFactory

org.apache.ibatis.transaction.TransactionFactory ,Transaction 工厂接口。代码如下:

    public interface TransactionFactory {
    
        /**
         * Sets transaction factory custom properties.
         *
         * 设置工厂的属性
         *
         * @param props 属性
         */
        void setProperties(Properties props);
    
        /**
         * Creates a {@link Transaction} out of an existing connection.
         *
         * 创建 Transaction 事务
         *
         * @param conn Existing database connection
         * @return Transaction
         * @since 3.1.0
         */
        Transaction newTransaction(Connection conn);
    
        /**
         * Creates a {@link Transaction} out of a datasource.
         *
         * 创建 Transaction 事务
         *
         * @param dataSource DataSource to take the connection from
         * @param level      Desired isolation level
         * @param autoCommit Desired autocommit
         * @return Transaction
         * @since 3.1.0
         */
        Transaction newTransaction(DataSource dataSource, TransactionIsolationLevel level, boolean autoCommit);
    
    }
3.1 JdbcTransactionFactory

org.apache.ibatis.transaction.jdbc.JdbcTransactionFactory ,实现 TransactionFactory 接口,JdbcTransaction 工厂实现类。代码如下:

    // JdbcTransactionFactory.java
    
    public class JdbcTransactionFactory implements TransactionFactory {
    
        @Override
        public void setProperties(Properties props) {
        }
    
        @Override
        public Transaction newTransaction(Connection conn) {
            // 创建 JdbcTransaction 对象
            return new JdbcTransaction(conn);
        }
    
        @Override
        public Transaction newTransaction(DataSource ds, TransactionIsolationLevel level, boolean autoCommit) {
            // 创建 JdbcTransaction 对象
            return new JdbcTransaction(ds, level, autoCommit);
        }
    
    }
3.2 ManagedTransactionFactory
    public class ManagedTransactionFactory implements TransactionFactory {
    
        /**
         * 是否关闭连接
         */
        private boolean closeConnection = true;
    
        @Override
        public void setProperties(Properties props) {
            // 获得是否关闭连接属性
            if (props != null) {
                String closeConnectionProperty = props.getProperty("closeConnection");
                if (closeConnectionProperty != null) {
                    closeConnection = Boolean.valueOf(closeConnectionProperty);
                }
            }
        }
    
        @Override
        public Transaction newTransaction(Connection conn) {
            // 创建 ManagedTransaction 对象
            return new ManagedTransaction(conn, closeConnection);
        }
    
        @Override
        public Transaction newTransaction(DataSource ds, TransactionIsolationLevel level, boolean autoCommit) {
            // Silently ignores autocommit and isolation level, as managed transactions are entirely
            // controlled by an external manager.  It's silently ignored so that
            // code remains portable between managed and unmanaged configurations.
            // 创建 ManagedTransaction 对象
            return new ManagedTransaction(ds, level, closeConnection);
        }
    
    }

Java 面试宝典是大明哥全力打造的 Java 精品面试题,它是一份靠谱、强大、详细、经典的 Java 后端面试宝典。它不仅仅只是一道道面试题,而是一套完整的 Java 知识体系,一套你 Java 知识点的扫盲贴。

它的内容包括:

  • 大厂真题:Java 面试宝典里面的题目都是最近几年的高频的大厂面试真题。
  • 原创内容:Java 面试宝典内容全部都是大明哥原创,内容全面且通俗易懂,回答部分可以直接作为面试回答内容。
  • 持续更新:一次购买,永久有效。大明哥会持续更新 3+ 年,累计更新 1000+,宝典会不断迭代更新,保证最新、最全面。
  • 覆盖全面:本宝典累计更新 1000+,从 Java 入门到 Java 架构的高频面试题,实现 360° 全覆盖。
  • 不止面试:内容包含面试题解析、内容详解、知识扩展,它不仅仅只是一份面试题,更是一套完整的 Java 知识体系。
  • 宝典详情:https://www.yuque.com/chenssy/sike-java/xvlo920axlp7sf4k
  • 宝典总览:https://www.yuque.com/chenssy/sike-java/yogsehzntzgp4ly1
  • 宝典进展:https://www.yuque.com/chenssy/sike-java/en9ned7loo47z5aw

目前 Java 面试宝典累计更新 400+ 道,总字数 42w+。大明哥还在持续更新中,下图是大明哥在 2024-12 月份的更新情况:

想了解详情的小伙伴,扫描下面二维码加大明哥微信【daming091】咨询

同时,大明哥也整理一套目前市面最常见的热点面试题。微信搜[大明哥聊 Java]或扫描下方二维码关注大明哥的原创公众号[大明哥聊 Java] ,回复【面试题】 即可免费领取。

阅读全文