ThinkPHP5.1数据库连接Model,Db,db事务提交回滚测试
super
2021-06-08 17:02
![views](/static/super/images/icon/evaluate-9a.png)
db()→startTrans();
1)回滚
![](/uploads/article/20210608/6d2043735d6793f325be734982be3f14.png)
2)回滚
![](/uploads/article/20210608/fbef6539054b817cb6cb2b645a8bbd2a.png)
![](/uploads/article/20210608/1fcacb41c21c4b0faf27c1e2a801cd68.png)
3)回滚
![](/uploads/article/20210608/42376f8898824917b412c6a206864052.png)
![](/uploads/article/20210608/4a5d837aa16e60538365016be1226959.png)
DB::startTrans();
1)不回滚
![](/uploads/article/20210608/58aea9e91ba4c6fbdcf52129488b94bb.png)
2)回滚
![](/uploads/article/20210608/da9ab67d71c861ee0af68682297789e5.png)
![](/uploads/article/20210608/1fcacb41c21c4b0faf27c1e2a801cd68.png)
3)回滚
![](/uploads/article/20210608/ccb4245a71a2492f948a5f5f8172b508.png)
![](/uploads/article/20210608/4a5d837aa16e60538365016be1226959.png)
Model()→startTrans();
1)不回滚
![](/uploads/article/20210608/d3d3c34d3c006fad4b639badf969eacb.png)
2)回滚
![](/uploads/article/20210608/4f24c6456cff6fc0a706a057526e99e7.png)
----------------------------------------------------------------
1)每次运行查看数据库,并truncate清空表。
2)Db::name() 引入方式为 use think\Db;
3)经测试发现,如果使用Db或者Model开启事务,中间使用db插入数据,db查询的数据将不会回滚。
db() : 别瞎勾八搞,除了db()->startTrans() 谁都别想拦住劳资╰(‵□′)╯ (不知道think\facade\Db大哥能不能拦住,回头再看吧…)
0 条讨论