成都信息工程学院
学位论文
基于JSP的公交线路查询系统的设计与实现
论文作者姓名： 申请学位专业： 申请学位类别： 指导教师姓名（职称）：
xxx
计算机科学与技术
工学学士 叶剑新（副教授）
论文提交日期： 2011年06月01日
基于JSP的公交线路查询系统的设计与实现
摘 要
公交查询系统是城市道路交通的重要组成部分，是城市发展的必然产物。城市公交查询系统的发展处于一个较落后的水平，人们可以获得信息的方式较少，为了解决这种问题，需要大力发展我国公交线路查询系统。
本文首先对公交查询系统的需求进行分析，包括功能需求和非功能需求；接着介绍了系统总体设计思路、方案选择和数据库设计；随后详细阐述了系统主要功能模块的实现过程；最后给出系统的测试方案。本公交查询系统主要具有公交查询、用户留言、用户管理和车次管理。公交查询包括车次、站点、换乘等方案的查询；用户留言主要是了解用户的留言信息，以方便管理员根据用户提供的留言信息或是提出的建议对系统进行完善；用户管理主要是删除用户信息和修改用户注册的基本信息；后台车次管理能主要是添加车次和站点、更新车次和站点、删除车次和站点。本系统基于B/S模式开发，采用JSP技术，SQL Server 2000构建后台数据库。
关键词：JSP；SQL Server 2000；公交线路查询；B/S
Based on JSP bus lines inquires the system design and
implementation
Abstract
Bus inquires the system is the urban road traffic, is an important part of the inevitable outcome of the urban development. The development of city bus query system in a relatively backward level, people can get information, the way to solve this problem is less, the need to develop our bus lines inquires the system.
In this paper, first bus query system needs were discussed, including functional requirements and the function demand; Then it introduces the whole system design idea, plan selection and database design; Then illustrates the system the realization process of the main function modules; Finally give system test scheme. This bus inquires the system mainly has the bus inquiry, user message, the user management and back-office train journeys management functions. Bus inquires run number, site, including transfer of query; such scheme User message is mainly collect user information, to facilitate the message provided by user message information or advice on system modified and perfected; User management function mainly delete a user information and modify user registration of the basic information; Backstage main function is to add train management site function, updated train and train and site function, delete trains and stations function. This system based on B/S model development, using the JSP technology, SQL Server 2000 construct backend database.
Key words: JSP; SQL Server 2000; Bus lines inquiry; B/S
目 录
论文总页数：29页 1 引言............................................................................................................................................... 1 1.1 选题背景 ............................................................................................................................... 1 1.2 国内外研究现状 ................................................................................................................... 1 1.3 本课题研究的意义 ............................................................................................................... 1 1.4 本课题的研究方法 ............................................................................................................... 2 1.5 开发环境及技术简介 ........................................................................................................... 2 1.5.1 JSP基础知识 ................................................................................................................. 2 1.5.2 JDBC ............................................................................................................................. 3 1.5.3 Java Servlet .................................................................................................................... 4 1.5.4 开发环境 ....................................................................................................................... 4 1.5.5 主要工作 ....................................................................................................................... 4 2 系统需求分析 ............................................................................................................................... 4 2.1系统调研 ................................................................................................................................ 4 2.2系统目标 ................................................................................................................................ 4 2.3 系统的功能需求 ................................................................................................................... 5 2.3.1 系统需求描述 ............................................................................................................... 5 2.3.2 系统数据流图 ............................................................................................................... 5 2.3.3 系统的功能 ................................................................................................................... 5 2.4 系统非功能需求 ................................................................................................................... 7 2.4.1 精度 ............................................................................................................................... 7 2.4.2 安全性要求 ................................................................................................................... 7 2.4.3 时间特性要求 ............................................................................................................... 7 2.4.4 灵活性 ........................................................................................................................... 7 3 系统设计 ....................................................................................................................................... 7 3.1 系统总体设计 ....................................................................................................................... 7 3.2 系统方案选择 ....................................................................................................................... 8 3.3 系统数据库设计 ................................................................................................................. 11 3.3.1数据库设计 .................................................................................................................. 11 3.3.2 系统E-R图 ................................................................................................................ 11 3.3.3 数据库表结构 ............................................................................................................. 12 4 系统实现 ..................................................................................................................................... 14 4.1 用户登录模块 ..................................................................................................................... 14
4.2 个人信息管理模块 ............................................................................................................. 16 4.3 公交系统查询模块 ............................................................................................................. 16 4.3.1 车次信息查询 ............................................................................................................. 16 4.3.2 站点信息查询 ............................................................................................................. 17 4.3.3 公交换乘方案查询 ..................................................................................................... 19 4.4 站点信息管理模块 ............................................................................................................. 20 4.4.1 删除站点 ..................................................................................................................... 20 4.4.2 添加站点 ..................................................................................................................... 21 4.5 车次信息管理模块 ............................................................................................................. 21 4.5.1 删除车次 ..................................................................................................................... 21 4.5.2 添加车次 ..................................................................................................................... 22 4.6 留言板模块 ......................................................................................................................... 23 4.6.1 发表留言 ..................................................................................................................... 23 4.6.2 查看留言 ..................................................................................................................... 23 4.6.3 删除留言 ..................................................................................................................... 23 5 系统测试与分析 ......................................................................................................................... 24 5.1 测试概述 ............................................................................................................................. 24 5.1.1 测试目的 ..................................................................................................................... 24 5.1.2 测试原则 ..................................................................................................................... 25 5.1.3 测试方法 ..................................................................................................................... 25 5.2 测试用例 ............................................................................................................................. 25 5.3 测试分析 ............................................................................................................................. 26 结 束 语 ..................................................................................................................................... 26 参考文献 ......................................................................................................................................... 27 致 谢 ......................................................................................................................................... 28 声 明 ......................................................................................................................................... 29
毕业论文《基于JSP的公交线路查询系统的设计与实现》
