【正文】 ........................................... 6 ....................................................................................... 7 C ...................................................................................................................... 8 .................................................................................... 8 SQL Server 2020 ............................................................................................... 9 Microsoft Visual .......................................................................... 9 3 城市公交車查詢系統(tǒng)的分析與設(shè)計 ................................................................................ 9 需求分析 ............................................................................................................ 9 概要設(shè)計 .......................................................................................................... 10 系統(tǒng)功能描述 ........................................................................................ 10 系統(tǒng)功能模塊劃分 ................................................................................. 10 系統(tǒng)流程設(shè)計 .........................................................................................11 系統(tǒng) ER圖 ............................................................................................ 13 4 數(shù)據(jù)庫結(jié)構(gòu)設(shè)計與實現(xiàn) ............................................................................................... 15 數(shù)據(jù)表的創(chuàng)建 ................................................................................................... 15 數(shù)據(jù)庫的連接 ................................................................................................... 16 存儲過程 .......................................................................................................... 17 5 城市公交 查詢系統(tǒng)的實現(xiàn) ............................................................................................ 18 系統(tǒng)首頁 .......................................................................................................... 18 后臺管理界面 ................................................................................................... 21 6 系統(tǒng)測試 .................................................................................................................... 26 測試用戶查詢模塊 ............................................................................................ 26 測試系統(tǒng)管理模塊 ............................................................................................ 26 測試留言簿管理 ............................................................................................... 27 結(jié) 論 ........................................................................................................................ 28 參考文獻 ........................................................................................................................ 28 致 謝 ......................................................................................................................... 29 聲 明 ......................................................................................................................... 30 1 引言 當(dāng)今是一個以網(wǎng)絡(luò)為中心的信息化世界，計算機已成為廣大市民不可缺少的工具。 City Bus inquiries。 關(guān)鍵詞： 互聯(lián)網(wǎng)；城市公交查詢； .NET；存儲過程 The Design and Realization of City Bus Inquiry System Based on .NET Abstract With the rapid development of Inter, the Inter has bee an important channel of people acquiring, publishing and transmitting information and obviously bee one part of social life. But China39。數(shù)據(jù)庫選用的是 SQL Server 2020，而應(yīng)用程序通過 與 SQL Server 2020 數(shù)據(jù)庫建立鏈接，并且運用 SQL 語言實現(xiàn)對其數(shù)據(jù)庫進行操作。 城市公交查詢系統(tǒng)開發(fā)技術(shù)采用的是基于 .NET 的 B/S 架構(gòu)，它的前端選用 為主要的編程框架，其 .ASPX 文件 包含組成用戶界面的 HTML 文本和控件 ，而 后臺選用了 C編程語言。而城市公交查詢系統(tǒng)就是使人們 能夠在因特網(wǎng)上方便、簡單的查詢出各條路線，了解自己所經(jīng)過的每個站點等信息，以便能更好的制定自己的行動計劃而設(shè)計的。 畢業(yè)設(shè)計 ( 論文 ) 基于 .NET 的城市公交查詢系統(tǒng)的設(shè)計與實現(xiàn) 論文作者姓名： 申請學(xué)位專業(yè)： 申請學(xué)位類別： 指導(dǎo)教師（職稱）： 論文提交日期： 基于 .NET 的城市公交查詢系統(tǒng)的設(shè)計與實現(xiàn) 摘 要 隨著 Inter 的快速發(fā)展，互聯(lián)網(wǎng)已成為人們快速獲取、發(fā)布和傳遞信息的重要渠道，顯然它已成為社會生活的一部分。但我國的城市公交信息查詢卻還處于比較落后的水平上，廣大的市民獲取路線信息方式也比較少，最常用的方式只局限在詢問和交通地圖上。它主要實現(xiàn)的模塊是公交信息的查詢模塊，其中包括的功能有：線路查詢、站點查詢、站站查詢、車站查詢；而系統(tǒng)管理模塊主要實現(xiàn)的是對各個數(shù)據(jù)表進行添加、編輯、刪除等功能操作以及對留言版進行一些相應(yīng)的回復(fù)。用 .NET 編程 的最大好處在于易于管理和重用性比較高。在此系統(tǒng)中，大量采用了存儲過程來對數(shù)據(jù)庫進行操作。s technology of urban public transport information inquiry is still in a relatively backward level. The numerous citizens have a little access to acquire the information about bus lines. The most mon ways are confined to traffic maps or the reference to stranger. And the urban public transport system is designed for people to inquire of all lines in the Inter conveniently and simply and get to know every site that they passed away in order to make their plans more efficiently. The main module of this system is the bus information query module. Its functions include line inquiry, site inquiry, stationtostation inquiry and station inquiry. The system management module mainly realizes the functional operation on adding, editing, deleting of all data tables and responses to the message correspondingly. The development technology of the city bus inquiry system adopt B/S framework based on .NET. Its frontend part uses as the major framework. The .ASPX file contains HTML text and controls which make up of user interface. The backend chooses C as its programming language. The greatest benefit of choosing .NET to programming is the easy managements and reusability. Database uses the SQL Server 2020, and the application accesses the database by and uses SQL language to operate the database. The stored procedure is used a lot to operate the database in the system. Key words: Inter。 .NET。由于我國城市化進程的推進，目前城市不斷地在向郊區(qū)延伸，邊緣不斷擴大，和郊區(qū)的邊界甚至開始變得模糊化，城市公交路線不斷地增多，加之眾多公交路線時常調(diào)整，目前眾多市民，特別是一些大中型城市的市民，對各條公交路線的信息不清楚或掌握得不準確。而公共交通與其它交通方式相比具有人均占用道路少、能源消耗低、運輸成本低 、污染相對較小、客運量大，運送效率高等優(yōu)點，它是解決大、中城市交通擁堵等交通問題，所以各大城市都在積極地發(fā)展公共交通的運用。 本