事务

mybatis开启事务

1
2
3
4
5
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@78f3fadc] from current transaction
==> Preparing: INSERT INTO usercenter.user_account (user_name,id,user_id) VALUE (?,?,?)
==> Parameters: fzz(String), 4(String), 1001(String)
<== Updates: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@78f3fadc]

mybatis没有开启事务

1
2
3
4
5
6
7
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7562231a] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1777293548 wrapping com.mysql.jdbc.JDBC4Connection@65d83289] will not be managed by Spring
==> Preparing: INSERT INTO usercenter.user_account (user_name,id,user_id) VALUE (?,?,?)
==> Parameters: fzz(String), 4(String), 1001(String)
<== Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7562231a]

By default, MySQL runs with autocommit mode enabled. This means that as soon as you execute a statement that updates (modifies) a table, MySQL stores the update on disk to make it permanent. The change cannot be rolled back.

文章链接 https://fangzongzhou.github.io/2018/08/20/计算机/技术栈/MYSQL/事务/