旅游管理系統(tǒng)課程設(shè)計(jì)報(bào)告-在線瀏覽
2024-09-11 21:27本頁面
【正文】 ）旅游管理系統(tǒng)視圖 用戶查看賬戶預(yù)訂情況CREATE VIEW memberorderASSELECT AS 用戶, AS 性別, AS 路線, AS 預(yù)訂時(shí)間, AS 是否支付, AS 折扣前金額, AS 電話, AS 郵箱FROM line INNER JOIN member ON = INNER JOINtravelplanorder ON = 管理員查看旅游計(jì)劃的預(yù)訂情況CREATE VIEW operatorCheckorderASSELECT AS 線路, AS 用戶, AS 預(yù)定時(shí)間, AS 是否支付, AS 支付時(shí)間, AS 折扣前金額, AS 實(shí)際支付金額FROM line INNER JOIN member ON = INNER JOIN travelplan ON = INNER JOINtravelplanorder ON = AND = 查看旅游線路所包含的景點(diǎn)信息CREATE VIEW line_spot_viewASSELECT AS 線路名, AS 景點(diǎn)名, AS 旅游時(shí)間, AS 所在地, , AS 景點(diǎn)介紹FROM line INNER JOIN line_spot ON = INNER JOIN spot ON = 查看景點(diǎn)所在地區(qū)CREATE VIEW [dbo].[spot_area]ASSELECT AS 編號(hào), AS 景點(diǎn)名, AS 價(jià)格, AS 地區(qū), AS 介紹, FROM INNER JOIN ON = （三）設(shè)計(jì)編程對(duì)象 1) 刪除會(huì)員的同時(shí)，刪除會(huì)員的旅游線路訂單create trigger member_deleteon memberfor updateasDELETE FROM travelplanorderWHERE (travelplanorder. memberids= (select ids from deleted))2) 刪除旅游計(jì)劃的同時(shí)，刪除該旅游計(jì)劃的訂單create trigger traveplan_deleteon travelplanfor updateasDELETE FROM travelplanorder WHERE ( = (select ids from deleted))3) 刪除旅游路線的同時(shí)，刪除與該旅游路線相關(guān)的旅游景點(diǎn)關(guān)聯(lián)和旅游計(jì)劃create trigger line_deleteon linefor updateasDELETE FROM travelplanWHERE ( = (select ids from deleted))DELETE FROM line_spotWHERE ( = (select ids from deleted))4) 刪除旅游景點(diǎn)的同時(shí)，刪除該旅游景點(diǎn)與旅游線路
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1