【正文】 等級： 指導(dǎo)教師： 年 月 日 3 火車訂票管理系統(tǒng) 1 系統(tǒng)總體方案 現(xiàn)在人們更多的使用火車作為出行交通工具，因此車票票務(wù)市場也在快速發(fā)展。 ：列車信息查詢、購票、退票、查看訂單、查看用戶信息、修改登錄密碼。 關(guān)鍵詞： 訂票 管理 ； 火車 訂 票 ； SQL Server 2021 Ordering Tickets Management System Abstract： After a long time observation of booking a train ticket and feasibility research of a online train ticket booking system,i have build a online ticket booking system in the following software cycle:requirement analysis,architecture and detail design,coding and the design phase,i present the system with data follow chart,data dictionary,ER graphic,database logical structure,and typical UML modeling facility such as Class diagram,Activity diagram,Use case diagram and Sequence product is developed in java(the latest jdk ),and the DBMS is sql server 2021 express 39。 課 程 設(shè) 計(jì) 課程名稱 SQL 數(shù)據(jù)庫系統(tǒng)課程設(shè)計(jì) 題目名稱 火車訂票管理系統(tǒng) 專業(yè)班級 學(xué)生姓名 學(xué) 號 指導(dǎo)教師 年月日 火車訂票管理系統(tǒng) 摘要 :本文針對火車站的訂票實(shí)際情況，按照軟件工程的結(jié)構(gòu)化設(shè)計(jì)思想，經(jīng)過項(xiàng)目的可行性研究和需求分析、總體設(shè)計(jì)、詳細(xì)設(shè)計(jì)，以及編碼實(shí)現(xiàn)和調(diào)試等步驟設(shè)計(jì)開發(fā)了火車訂票管理系統(tǒng)。該系統(tǒng)要解決的是火車訂票工作所要解決的問題，可以滿足火車訂票的基本要求，包括用戶查詢、訂票、退票和管理員增加車票等幾個(gè)方面的功能。SQL Server2021 目 錄 蚌埠學(xué)院計(jì)算機(jī)科學(xué)與技術(shù)系課程設(shè)計(jì)任務(wù)書 .............................. 1 蚌埠學(xué)院計(jì)算機(jī)科學(xué)與技術(shù)系本科課程設(shè)計(jì)成績評定表 ....................... 2 1 系統(tǒng)總體方案 ............................................................ 3 開發(fā)背景 .......................................................................................................................3 意義 ...............................................................................................................................3 系統(tǒng)相關(guān)知識介紹 .......................................................................................................3 2 設(shè)計(jì)思路與主要步驟 ..................................................... 5 系 統(tǒng)需求 .......................................................................................................................5 功能需求 .......................................................................................................................5 查詢 ....................................................................................................................5 ...................................................................................................................5 ...................................................................................................................6 數(shù)據(jù)庫邏輯結(jié)構(gòu) ...........................................................................................................6 數(shù)據(jù)庫中的約束 ...........................................................................................................7 主鍵約束 ............................................................................................................7 外鍵約束 ............................................................................................................7 CHICK 約束 ........................................................................................................7 DEFAULT 約束 ....................................................................................................8 長度約束 ............................................................................................................8 3 各功能模塊和流程圖 ...................................................... 9 系統(tǒng)軟件結(jié)構(gòu)設(shè)計(jì) .......................................................................................................9 系統(tǒng)流程圖 ...................................................................................................................9 4 系統(tǒng)的詳細(xì)設(shè)計(jì) ......................................................... 14 登錄界面 ..................................................................................................................... 14 游客模塊 ..................................................................................................................... 14 列車信息查詢 .................................................................................................. 14 網(wǎng)上用戶注冊 .................................................................................................. 15 用戶模塊 ..................................................................................................................... 16 購票 .................................................................................................................. 17 退票 .................................................................................................................. 19 查看用戶信息 .................................................................................................. 21 用戶修改密碼 .................................................................................................. 21 管理員模塊 ................................................................................................................. 22 5 設(shè)計(jì)代碼 ............................................................... 24 總結(jié) ..................................................................... 34 謝辭 ..................................................................... 35 參考文獻(xiàn) ..............................................................