一、事务类型
在 MyBatis 中有两种类型的事务管理器(也就是 type=”[JDBC|MANAGED]”)
- JDBC – 这个配置就是直接使用了 JDBC 的提交和回滚设置,它依赖于从数据源得到的连接来管理事务作用域。
- MANAGED – 这个配置几乎没做什么。它从来不提交或回滚一个连接,而是让容器来管理事务的整个过程
二、手动事务
1、示例
@Override
public void saveUserManual(User user) {
SqlSession sqlSession = SqlSessionKit.openSession();
sqlSession.insert("test.save", user);
sqlSession.commit();
sqlSession.close();
}
2、演示
@Test
public void testJdbcManual() {
UserDaoImpl userDao = new UserDaoImpl();
User user = new User();
user.setUsername("JDBC");
user.setAddress("手动");
userDao.saveUser(user);
}
DEBUG [main] - Created connection 2066892165.
DEBUG [main] - Setting autocommit to false on JDBC Connection
[com.mysql.cj.jdbc.ConnectionImpl@7b324585]
DEBUG [main] - > Preparing: insert into user(username, birthday, sex, address) values(?, ?,
?, ?)
DEBUG [main] - ==> Parameters: JDBC(String), null, null, 默认(String)
DEBUG [main] - < Updates: 1
DEBUG [main] - Committing JDBC Connection
[com.mysql.cj.jdbc.ConnectionImpl@7b324585]
DEBUG [main] - Resetting autocommit to true on JDBC Connection
[com.mysql.cj.jdbc.ConnectionImpl@7b324585]
DEBUG [main] - Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@7b324585]
DEBUG [main] - Returned connection 2066892165 to pool.
Disconnected from the target VM, address: '127.0.0.1:57598', transport: 'socket'
三、自动事务
1、示例
@Override
public void saveUserAuto(User user) {
SqlSession sqlSession = SqlSessionKit.openSession(true);
sqlSession.insert("test.save", user);
sqlSession.close();
}
2、演示
public void testJdbcAuto() {
UserDaoImpl userDao = new UserDaoImpl();
User user = new User();
user.setUsername("JDBC");
user.setAddress("自动");
userDao.saveUserAuto(user);
}
DEBUG [main] - Created connection 2066892165.
DEBUG [main] - > Preparing: insert into user(username, birthday, sex, address) values(?, ?,
?, ?)
DEBUG [main] - ==> Parameters: JDBC(String), null, null, 自动(String)
DEBUG [main] - < Updates: 1
DEBUG [main] - Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@7b324585]
DEBUG [main] - Returned connection 2066892165 to pool.
Disconnected from the target VM, address: '127.0.0.1:58840', transport: 'socket'
3、注意
- 自动提交事务没有提交事务的日志打印