create table std(sno int pkey,sname char(9),sage int pkey);
create table std2(sno int pkey,sname char(9),sage int pkey);
create table sc(sno int pkey,cno int pkey);
create table sc(sno1 int pkey,cno1 int pkey,csname char(9));
insert into std values(1,lBei,43)
insert into std values(2,gYu,41)
insert into std values(3,zhFei,42)
insert into std3 values(1,lBei,43);
insert into std3 values(2,zhYun,39);
insert into std3 values(3,zhGeL,34);
insert into std values(4,zhYun,39)
insert into std values(5,zhGeL,34)
insert into std values(6,cCao,33)
insert into std values(7,dWei,56)
insert into std values(8,zhLiao,23)
insert into std values(9,lDian,67)
insert into std values(10,zhLiao,12)
insert into std values(11,sQuan,76)
insert into sc values(1,3);
insert into sc values(2,8);
insert into sc values(5,9);
insert into sc values(8,2)
insert into sc values(9,1)
insert into sc values(11,7)
insert into userlist values(1,lBei,2,4)
insert into userlist values(2,gYu,3,4)
insert into userlist values(3,zhFei,2,4)
insert into userlist values(4,zhYun,2,4)
insert into userlist values(5,zhGeL,3,4)
insert into userlist values(6,cCao,3,4)
insert into userlist values(7,dWei,3,4)
insert into userlist values(8,zhLiao,3,4)
insert into userlist values(9,lDian,6,4)
insert into userlist values(10,zhLiao,1,4)
insert into userlist values(11,sQuan,7,4)
select * from userlist;
insert into userlist values(2,xiaox,2,123)
insert into userlist values(3,cp,3,123)
insert into userlist values(4,lgao,3,123)
delete from userlist where name =cp;
create table count (id int pkey,name char(9) ,money int )
insert into count values(1,lBei,100)
insert into count values(2,gYu,900)
insert into count values(3,zhFei,400)
insert into count values(4,zhYun,200)
insert into count values(5,zhGeL,100)
insert into count values(6,cCao,9000)
insert into count values(7,dWei,42)
delete from count where name = dWei;
insert into count values(6,qqqqqqqqqqqq,9000)
并发控制
run task A
select * from count
where name = lBei;
update count
set money=money + 200
where name = zhFei;
end
run task B
update count
set money=money - 400
where name = lBei;
update count
set money=money + 200
where name = zhFei;
end
日志恢复
run task d
select * from count
where name = lBei;
update count
set money=money - 200
where name = zhFei;
int //模拟日志还未写完
run task e
update count
set money=money + 400
where name = lBei;
update count
set money=money - 200
where name = zhFei;
end //写完日志，可完全执行，
c++ dbms模拟 （104个子文件） 
AlterTable.asp 0B DBMS_DDL.bmarks 594B DBMS_DDL.cbp 3KB count 1KB count_id 896B SelectTable.cpp 31KB SetOperate.cpp 7KB Gloab.cpp 7KB main.cpp 6KB UpdateTable.cpp 6KB Task.cpp 5KB Index.cpp 4KB InsertTable.cpp 4KB CreateTable.cpp 4KB Recovery.cpp 3KB DeleteRecord.cpp 3KB PrintMess.cpp 539B CreateView.cpp 65B AlterTable.cpp 45B DropTable.cpp 44B user.cpp 0B ShowTable.cpp 0B cs 1KB cs_id 896B DBMS_DDL.depend 2KB DBMS_DDL.dev 3KB DBMS_DDL.dsp 6KB DBMS_DDL.dsw 541B
DBMS_DDL.exe 256KB SelectTable.h 1KB CreateTable.h 675B Index.h 529B Gloab.h 435B UpdateTable.h 278B Recovery.h 172B user.h 157B Task.h 72B DeleteRecord.h 34B InsertTable.h 33B SetOperate.h 28B DropTable.h 25B PrintMess.h 25B CreateView.h 24B AlterTable.h 24B main.h 0B BuildLog.htm 5KB vc90.idb 491KB DBMS_DDL.layout 465B log 197B log 0B DBMS_DDL.exe.embed.manifest 2KB DBMS_DDL.ncb 10.46MB SelectTable.obj 59KB Gloab.obj 45KB main.obj 45KB Task.obj 19KB UpdateTable.obj 18KB CreateTable.obj 16KB SetOperate.obj 16KB InsertTable.obj 13KB Index.obj 12KB DeleteRecord.obj 11KB CreateView.obj 4KB AlterTable.obj 2KB DropTable.obj 2KB user.obj 1KB DBMS_DDL.opt 63KB vc90.pdb 116KB vc60.pdb 92KB DBMS_DDL.plg 250B r_filename 38B r_filename 10B Gloab.sbr 1.78MB main.sbr 1.77MB SelectTable.sbr 135KB UpdateTable.sbr 124KB SetOperate.sbr 118KB Task.sbr 116KB CreateTable.sbr 115KB Index.sbr 115KB DeleteRecord.sbr 88KB InsertTable.sbr 88KB CreateView.sbr 65KB AlterTable.sbr 94B DropTable.sbr 92B user.sbr 54B sc 1KB sc_id 896B DBMS_DDL.sln 881B std 2KB std3 1KB std3_id 896B std4 1KB std4_id 896B std_id 896B DBMS_DDL.suo 19KB
测试数据.txt 3KB DBMS_DDL.vcproj.lxg-PC.lxg.user 1KB userlist 2KB userlist 1KB共 104 条
- 1
- 2
资源评论
href?2019-06-18我也觉得没什么用
pobi63572017-05-03请问怎么打开啊？我用的是vs2015？？求问大神- 小灰灰之怒2011-11-30实现较为全面 但是代码中注释较少 没有相关文档
seraph2012
- 粉丝: 0
- 资源: 1
最新资源
- 拼多多官方_main_main_baidu_sem_dz1_ARM64.apk
- 小米机型小米助手界面检测当前机型 包括 Android 版本、MIUI 版本和固件详细信息
- share6620081042528496742.jpg
- 21英语210405010143罗杰_周霜红 文献综述.doc
- share6329583338574047795.jpg
- ADS-matlab联合仿真包
- 基于yolov5实现火灾图像识别的代码
- 30天自制操作系统 (图灵程序设计丛书)
- 题目源码2024年强网杯全国网络安全挑战赛 PWN题目qroute源码
- 题目源码2024年强网杯全国网络安全挑战赛 Pwn题目chat-with-me源码
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
