陕西理工学院毕业设计

基于ASP技术的在线售票系统的开发与设计

赵咸博

(陕理工计算机科学与技术系计算机科学与技术专业052班，陕西 汉中 723003)

指导教师：魏 佳

【摘要】基于在线售票系统是通过网络查询信息，进行火车车票售订的系统。通过网络该系统能够为旅客提供

一个快捷、便利的购票渠道，对促进铁路交通事业的发展具有重要意义。本文详细介绍了铁路售订票系统开发过程及其相关技术，运用动态网页、数据库、数据结构等技术，提出了售订票系统的解决方案，将整个票系统按用户的不同分为前台查询、订票、售票和系统管理共两个主要的功能模块。系统的设计与实现综合运用了JSP、HTML、SQl2000数据库和JAVA等技术，完成了数据库开发、票务信息管理和网页站点设计等工作。

【关键词】 票务查询；JSP；SQl2000数据库

陕西理工学院毕业设计

Design and Develop of Online Booking Ticket-selling System

Based on ASP Technique

ZHAO Xian-Bo

(Grade 05,Class 2, Major Computer Science and Technology, Computer Science and Technology Dept.,

Shaanxi University of Technology, Hanzhong 723003, Shaanxi)

Tutor: WEI Jia

Abstract: The Train Online Booking Ticket-selling System, is a kind of E-commerce system, by which the passenger

can query the information of the tickets and order the tickets. Ticket-selling system based on Web can provide a quickness and convenience way of buying ticket, and also has important meaning of speeding up the development of railway.This article deeply discusses the procedure of develop and the related techniques of the Ticket-selling system. By using dynamic pages, database and data structure to work out the solution of the Ticket-selling system. The whole system includes two main modules: the queries and the book of tickets and the management of system.which was discussed in depth in this paper. The design and implement of the system used some techniques as JSP, HTML, JAVA,SQL2000, and so on to complete the design of database, ticket information and Web site.

JSP, query of tickets,

Key words: query of tickets; JSP; Database

陕西理工学院毕业设计

目 录

引 言 ..................................................................................................................................... 1 1 课题研究背景 ................................................................................................................. 2

1.1 课题背景意义 ......................................................................................................... 2 1.2 系统开发技术 ......................................................................................................... 2

1.2.1 B/S模式简介 ................................................................................................ 2 1.2.2 JSP开发技术 ............................................................................................. 3 1.2.3 ODBC数据访问接口 .............................................................................. 3 1.2.4 JDBC数据访问接口 ................................................................................... 4

2 系统可行性分析与需求分析 ................................................................................... 5

2.1 系统需求分析 ......................................................................................................... 5

2.1.1 功能需求 ...................................................................................................... 5 2.1.2 数据需求 ........................................................................................................ 5 2.1.4 数据流图 ........................................................................................................ 6 2.1.5 数据字典 ........................................................................................................ 6 2.2 可行性研究 .............................................................................................................. 7

2.2.1 经济可行性 ................................................................................................... 7 2.2.2 技术可行性 ................................................................................................... 7 2.2.3 操作可行性 ................................................................................................. 8

3 系统的总体设计 ............................................................................................................ 9

3.1 系统设计目标 ......................................................................................................... 9 3.2 系统结构功能设计 ................................................................................................ 9 3.3 系统流程设计 ....................................................................................................... 10

3.3.1 系统流程总设设计 ................................................................................... 10 3.3.2 系统流程详细设计 ................................................................................... 11 3.4系统模块算法 ........................................................................................................ 13

3.4.1系统模块算法 .............................................................................................. 13 3.4.2 系统调用关系............................................................................................. 14 3.5 系统UML图 ........................................................................................................ 14 4 系统数据库设计 .......................................................................................................... 16

4.1 数据库需求分析................................................................................................... 16 4.2 数据库概念结构设计 ......................................................................................... 16 4.3 数据库逻辑结构设计 ......................................................................................... 17 5 系统详细设计 ............................................................................................................... 19

5.1 数据库关键应用 ................................................................................................. 19 5.2 系统首页 ............................................................................................................... 22

陕西理工学院毕业设计

5.3管理员登录及访问权限..................................................................................... 22 5.4系统前台设计 ....................................................................................................... 22

5.4.1会员登录及访问权限 ................................................................................ 22 5.4.2 车次信息查询............................................................................................. 23 5.4.3 订票信息查询............................................................................................. 23 5.4.4 订票 ............................................................................................................... 24 5.5 系统后台设计 ....................................................................................................... 24

5.5.1增加车次 ....................................................................................................... 24 5.5.2 管理员设置 ................................................................................................. 25 5.5.3 订票管理 ...................................................................................................... 25 5.5.4 会员管理 ...................................................................................................... 25 5.5.5 售票统计 ...................................................................................................... 25

6 系统测试 ......................................................................................................................... 27

6.1功能测试.................................................................................................................. 27 6.2性能测试.................................................................................................................. 27 6.3可用性测试 ............................................................................................................. 28 6.4客户端兼容性测试 ............................................................................................... 28 总结 ........................................................................................................................................ 30 致谢 ........................................................................................................................................ 31 参考文献 .............................................................................................................................. 32 科技外文文献 .................................................................................................................... 33 附录A: 源程序代码....................................................................................................... 39 附录B: 系统使用说明书............................................................................................. 45