摘要：城市公共交通是与广大市民生产生活息息相关的重要基础设施，就目前来说，它是大多数人出行的首选工具。本系统基于B/S模式开发，利用SQLServer2008和Myeclipse等编写工具实现了前台包括按线路查询、按站点查询、换乘查询等），后台实现了公交路线信息的管理功能（包括对路线信息的添加、删除、修改）。本系统分为前台和后台，既相互独立又相互联系。客户端通过管理人员登陆页面来管理公交线路的变更等，用户人员通过输入线路站点等信息来访问，用户点击查询按钮后浏览器会向服务器发送查询的条件来得出查询的结果。服务器端通过登录的过程生成管理员或者用户的管理页面，收到用户发送的查询条件通过数据库来查询，然后又将数据库查询到的内容发送到客户端。本文论述了该系统的设计与实现过程，首先对系统设计的需求和要求进行了详细的分析，然后在介绍本系统中部分主要实现功能进行了详细的介绍，最后针对系统进行了测试并提出了改进的方向。65072

毕业论文关键字：SQLServer2008，Myeclipse，线路查询，公交。

Abstract：Urban public transport is an important infrastructure and is closely related to the general public on the production and life, at present, it is the tool of choice for most people travel. This system is developed based on B / S model, using MyEclipse and SQL Server2008 writing tools to achieve the front, including by line query, query by site, transfer query), the background to achieve the bus route information management functions (including route information to add, delete, modify). This system is pided into front and back, both independent and interrelated. Client through the management of personnel landing page to manage the change of bus lines, users through the input line site to access, users click the query button browser will refer to the sending server conditions, come to the query results. The server through the login process generates an administrator or user management page, received user sends the query conditions through the database to query, and then turn the content to a database query is sent to the client. This paper discusses the design and implementation process of the system, first of all the needs and requirements of the system design were detailed analysis, then the part of the system to achieve the main function are introduced in detail. Finally, according to the system were tested and the direction of improvement.

Keywords: SQLServer2008，Myeclipse，Line query，transit。

目录

1 引言 5

1.1课题背景 5

1.2国内外研究现状 5

1.3公交路线系统的构建 5

1.4建立公交路线系统的必然性 5

2 开发工具及系统模式 6

2.1开发环境的介绍 6

2.2 JSP技术简介 6

2.3系统开发模式 7

2.4 JDBC访问数据库 8

3 系统需求与可行性分析 8

3.1需求分析 8

3.2可行性研究 9

4.系统总体设计 9

4.1前台设计方案 9

4.2后台管理设计方案 10

4.3数据库设计 11

5 系统详细设计