MyBatis Transaction Management Explained

1 year ago
Noah Thompson
1 minute

In MyBatis, there are two methods available for creating transactions:

  1. Programming-based transaction management: By manually controlling the submission and rollback of transactions through writing code, you can use the commit() and rollback() methods of SqlSession to control the submission and rollback of transactions.
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
    // 执行数据库操作
    sqlSession.insert("insertUser", user);
    sqlSession.update("updateUser", user);
    
    // 提交事务
    sqlSession.commit();
} catch (Exception e) {
    // 回滚事务
    sqlSession.rollback();
} finally {
    sqlSession.close();
}
  1. Declarative transaction management: Configuring Spring’s transaction manager allows for declarative transaction management, where transaction propagation behavior, isolation level, and other parameters can be declared in the configuration file. Transactions can then be enabled by adding the @Transactional annotation to methods or classes.
@Service
@Transactional
public class UserServiceImpl implements UserService {
    
    @Autowired
    private UserMapper userMapper;
    
    @Override
    public void addUser(User user) {
        userMapper.insertUser(user);
        userMapper.updateUser(user);
    }
}

Transaction management in MyBatis can be achieved using any method. With programmatic transaction management, manual handling of transaction commits and rollbacks is required. On the other hand, declarative transaction management is more convenient, as you only need to add the @Transactional annotation to the method or class where transaction management is needed.

bannerAds