數(shù)據(jù)庫課程設(shè)計(jì)論文收費(fèi)停車場管理系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)畢業(yè)論文(參考版)
2025-06-26 23:58本頁面
【正文】 End。Create trigger tri_del_moOn moneynote for deleteAsIf exists(select * From deleted Where moneypay70)RollbackBeginPrint39。禁止無端修改，修改不成功39。RollbackEnd。 and carat=1create procedure sof4asselect count(cwno) 車位總數(shù)from Ffedcreate procedure sof5nom char(10)asselect *from moneynotewhere carno=nomcreate procedure sof6s_carno char(10),s_carsb char(10),s_carcolor char(4)asinsert into carvalues(s_carno,s_carsb,s_carcolor)create procedure sof7s_Cwno char(10),s_Cwpace char(10),s_Cwtype char(4),s_Carno char(10),s_Carname char(10),s_Carsb char(10),s_Carcolor char(4),s_Carpho bit,s_Caradd char(20),s_Cartel char(20),s_Carmon floatasinsert into Ffedvalues(s_Cwno,s_Cwpace,s_Cwtype,s_Carno,s_Carname,s_Carsb,s_Carcolor,s_Carpho,s_Caradd,s_Cartel,s_Carmon)create procedure sof8s_Cwno char(10),s_Carno char(10),s_Carat bit,s_Carin datetime,s_Carout datetime,s_Timetype char(6)asinsert into Stopvalues(s_Cwno,s_Carno,s_Carat,s_Carin,s_Carout,s_Timetype)create procedure sof9s_Cwno char(10),s_Carno char(10),s_Cartime float,s_Moneypay float,s_Piece char(10)asinsert into Moneynotevalues(s_Cwno,s_Carno,s_Cartime,s_Moneypay,s_Piece)create procedure sof10asselect *from Carcreate procedure sof11asselect *from FFEDcreate procedure sof12asselect *from STOPcreate procedure sof13asselect *from MONEYNOTEREATE PROCEDURE sof14s_carno char(10)asdeletefrom moneynotewhere carno=s_carnocreate procedure sof15s_carno char(10)asupdate ffedset carmon=150where carno=s_carnoCreate trigger insert_or_update_carmonOn ffed for insert,updateAsIf exists(select* From ffed Where Carmon120)BeginPrint 39。create procedure sof3asselect 11count() 空閑自由車位from Ffed,stopwhere = and cwtype=39。create procedure sof2asselect count(cwno) 自由車位總數(shù)from Ffedwhere cwtype=39。create procedure sof1asselect count(cwno) 固定車位總數(shù)from Ffedwhere cwtype=39。 and carat=1：create view Carinouttion(車位號,車牌號,進(jìn)入時(shí)間,離開時(shí)間,時(shí)間段)asselect cwno,carno,carin,carout,timetypefrom stop：create view moneytimeasselect *from moneyt：create view Moneytion(總收費(fèi))asselect sum(Moneypay)from moneynote：create view carmoney(車牌號,繳費(fèi)總額)asselect carno,sum(moneypay)from moneynotegroup by carno clustered index Sscwno on Stop(Cwno)。 and carat=1：create view carfreetion(車位號,車牌號,車名,車色)asselect ,from stop,car,ffedwhere = and = and cwtype=39。：create view Carinformation(車位號,車牌號)asselect ,from Stop,Ffedwhere =
化學(xué)相關(guān)推薦
鄂ICP備17016276號-1