旅游管理系統(tǒng)課程設(shè)計(jì)報(bào)告(更新版)
【正文】 trigger spot_deleteon spotfor updateasDELETE FROM line_spotWHERE ( = (select ids from deleted) 1) 向member表中插入數(shù)據(jù)create proc memberinsertids int,membername nvarchar(50),passwords nvarchar(50),realname nvarchar(50),sex int,idnum nvarchar(50), nvarchar(50),telephone nvarchar(50)as insert into member(ids,membername,passwords,realname,sex,idnum,telephone) values(ids,membername,passwords,realname,sex,idnum,telephone)2) 查詢(xún)景點(diǎn)所屬地區(qū)create proc areaSelect]asSELECT ids, areaid, nameFROM area3) 查詢(xún)路線信息create proc lineselectasSELECT ids AS 編號(hào), name AS 路線名, price AS 價(jià)格, days AS 旅游時(shí)間, isremended AS 是否推薦, spotnum AS 景點(diǎn)數(shù), updatetime AS 更新時(shí)間, isdeleted AS 是否刪除FROM line4) 插入管理員信息create proc operatorinsertuserid nvarchar(50),username nvarchar(50),passwords nvarchar(50),idnum nvarchar(50),isadmin intasINSERT INTO operator (userid, username, passwords, idnum, isadmin)VALUES (userid,username,passwords,idnum,isadmin)5) 查詢(xún)用戶(hù)信息create proc selecttextas select * from member6) 查詢(xún)景點(diǎn)信息create proc spotinsertasSELECT name, price, area, des, isdeletedFROM spot 1) 查詢(xún)數(shù)據(jù)庫(kù)中是否有此人create function membersex(name nvarchar(50))returns nvarchar(50)asbegin declare a nvarchar(50) if not exists(select sex from member where membername=name) set a=39。 else set a=3
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1