分类号: UDC :
密 级: 编号:
论 文
基于.NET 的城市公交查询系统的设计与实现
论 文 作 者 姓 名 :
申 请 学 位 专 业 :
申 请 学 位 类 别 :
指导教师(职称):
论 文 提 交 日 期 :
基于.NET 的城市公交查询系统的设计与实现
摘 要
随着 Internet 的快速发展,互联网已成为人们快速获取、发布和传递信息
的重要渠道,显然它已成为社会生活的一部分。但我国的城市公交信息查询却还
处于比较落后的水平上,广大的市民获取路线信息方式也比较少,最常用的方式
只局限在询问和交通地图上。而城市公交查询系统就是使人们能够在因特网上方
便、简单的查询出各条路线,了解自己所经过的每个站点等信息,以便能更好的
制定自己的行动计划而设计的。它主要实现的模块是公交信息的查询模块,其中
包括的功能有:线路查询、站点查询、站站查询、车站查询;而系统管理模块主
要实现的是对各个数据表进行添加、编辑、删除等功能操作以及对留言版进行一
些相应的回复。
城市公交查询系统开发技术采用的是基于.NET 的 B/S 架构,它的前端选用
ASP.NET 为主要的编程框架,其.ASPX 文件包含组成用户界面的 HTML 文本和控件,
而后台选用了 C#编程语言。用.NET 编程的最大好处在于易于管理和重用性比较
高。数据库选用的是 SQL Server 2000,而应用程序通过 ADO.NET 与 SQL Server
2000 数据库建立链接,并且运用 SQL 语言实现对其数据库进行操作。在此系统
中,大量采用了存储过程来对数据库进行操作。
关键词:互联网;城市公交查询;.NET;存储过程
The Design and Realization of City Bus Inquiry System
Based on .NET
Abstract
With the rapid development of Internet, the Internet has become an important
channel of people acquiring, publishing and transmitting information and obviously
become one part of social life. But China'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 common 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 Internet 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, station-to-station 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 front-end part uses ASP.NET as the major framework. The .ASPX
file contains HTML text and controls which make up of user interface. The back-end
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
2000, and the application accesses the database by ADO.NET and uses SQL language
to operate the database. The stored procedure is used a lot to operate the database in
the system.
Key words: Internet; City Bus inquiries; .NET; Stored Procedure.
目 录
论文总页数:26 页
1 引言.................................................................................................................................................1
1.1 城市公交查询系统的前景................................................................................................1
1.2 城市公交查询系统的作用................................................................................................2
2 城市公交查询系统的实现技术和工具.........................................................................................2
2.1 ASP.NET..............................................................................................................................2
2.1.1 什么是 ASP.NET.....................................................................................................2
2.1.2 .NET Framework 概述...........................................................................................2
2.1.3 ASP.NET 的特点.....................................................................................................3
2.2 C#........................................................................................................................................4
2.3 ADO.NET 对象操作数据库.................................................................................................4
2.4 SQL Server 2000..............................................................................................................5
2.5 Microsoft Visual Studio.NET......................................................................................5
3 城市公交车查询系统的分析与设计............................................................................................5
3.1 需求分析............................................................................................................................5
3.2 概要设计............................................................................................................................6
3.2.1 系统功能描述........................................................................................................6
3.2.2 系统功能模块划分................................................................................................6
3.2.3 系统流程设计........................................................................................................8
3.2.4 系统 E-R 图..........................................................................................................10
4 数据库结构设计与实现..............................................................................................................12
4.1 数据表的创建..................................................................................................................12
4.2 数据库的连接..................................................................................................................13
4.3 存储过程..........................................................................................................................14
5 城市公交查询系统的实现..........................................................................................................15
5.1 系统首页..........................................................................................................................15
5.2 后台管理界面..................................................................................................................18
6 系统测试......................................................................................................................................23
6.1 测试用户查询模块..........................................................................................................23
6.2 测试系统管理模块..........................................................................................................23
6.3 测试留言簿管理..............................................................................................................24
结 论..........................................................................................................................................25
参考文献..........................................................................................................................................25