【正文】 畢業(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ā)布和傳遞信息的重要渠道，顯然它已成為社會生活的一部分。但我國的城市公交信息查詢卻還處于比較落后的水平上，廣大的市民獲取路線信息方式也比較少，最常用的方式只局限在詢問和交通地圖上。而城市公交查詢系統(tǒng)就是使人們 能夠在因特網(wǎng)上方便、簡單的查詢出各條路線，了解自己所經(jīng)過的每個站點等信息，以便能更好的制定自己的行動計劃而設(shè)計的。它主要實現(xiàn)的模塊是公交信息的查詢模塊，其中包括的功能有：線路查詢、站點查詢、站站查詢、車站查詢；而系統(tǒng)管理模塊主要實現(xiàn)的是對各個數(shù)據(jù)表進行添加、編輯、刪除等功能操作以及對留言版進行一些相應(yīng)的回復(fù)。 城市公交查詢系統(tǒng)開發(fā)技術(shù)采用的是基于 .NET 的 B/S 架構(gòu)，它的前端選用 為主要的編程框架，其 .ASPX 文件 包含組成用戶界面的 HTML 文本和控件 ，而 后臺選用了 C編程語言。用 .NET 編程 的最大好處在于易于管理和重用性比較高。數(shù)據(jù)庫選用的是 SQL Server 2021，而應(yīng)用程序通過 與 SQL Server 2021 數(shù)據(jù)庫建立鏈接，并且運用 SQL 語言實現(xiàn)對其數(shù)據(jù)庫進行操作。在此系統(tǒng)中，大量采用了存儲過程來對數(shù)據(jù)庫進行操作。 關(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。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 2021, 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。 City Bus inquiries。 .NET。 Stored Procedure. 目 錄 論文總頁數(shù)： 26 頁 1 引言 .............................................................................................................................. 5 城市公交查詢系統(tǒng)的前景 ................................................................................... 5 城市公交查詢系統(tǒng)的作用 ................................................................................... 6 2 城市公交查詢系統(tǒng)的實現(xiàn)技術(shù)和工具 ............................................................................. 6 ............................................................................................................. 6 什么是 ....................................................................................... 6 .NET Framework概述 ............................................................................... 6 ....................................................................................... 7 C ...................................................................................................................... 8 .................................................................................... 8 SQL Server 2021 ............................................................................................... 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é) 論 ...............................................................