毕 业 设 计（论 文）
题目：汽车售票网站的设计与实现
I
摘 要
互联网发展至今，无论是其理论还是技术都已经成熟，而且它广泛参与在社
会中的方方面面。它让信息都可以通过网络传播，搭配信息管理工具可以很好地
为人们提供服务。针对汽车售票信息管理混乱，出错率高，信息安全性差，劳动
强度大，费时费力等问题，采用汽车售票网站可以有效管理，使信息管理能够更
加科学和规范。
汽车售票网站在 Eclipse 环境中，使用 Java 语言进行编码，使用 Mysql 创建
数据表保存本系统产生的数据。系统可以提供信息显示和相应服务，其管理员负
责审核会员充值，审核客户购票信息以及会员购票信息，管理客运班次与留言板，
管理会员等级。客户查看客运班次，购买并支付车票，在前台联系客服，向管理
员留言，在后台查看购票记录，进行会员充值。会员通过会员购票渠道进行购票，
并在后台支付车票，查看购票审核情况，查看会员等级，管理收藏信息。
总之，汽车售票网站集中管理信息，有着保密性强，效率高，存储空间大，
成本低等诸多优点。它可以降低信息管理成本，实现信息管理计算机化。
关键词：汽车售票网站；Java 语言；Mysql
II
Abstract
Since the development of the Internet, both its theory and technology have
matured, and it has been widely involved in all aspects of society. It allows
information to be disseminated through the Internet, and it can serve people well with
information management tools. In view of the chaotic management of car ticketing
information, high error rate, poor information security, high labor intensity, and
time-consuming and labor-intensive problems, the use of car ticketing websites can
effectively manage and make information management more scientific and
standardized.
The car ticketing website is coded in Java language in the Eclipse environment,
and MySQL is used to create a data table to save the data generated by the system.
The system can provide information display and corresponding services. Its
administrator is responsible for reviewing member recharge, reviewing customer
ticket purchase information and member ticket purchase information, managing
passenger transport schedules and message boards, and managing membership levels.
Customers check passenger schedules, purchase and pay for tickets, contact customer
service at the front desk, leave a message to the administrator, check ticket purchase
records at the backstage, and perform member recharge. Members purchase tickets
through member ticketing channels, pay for tickets in the background, check the ticket
purchase review, check membership levels, and manage collection information.
In short, the centralized management of information on car ticketing websites has
many advantages such as strong confidentiality, high efficiency, large storage space,
and low cost. It can reduce the cost of information management and realize the
computerization of information management.
Key Words：Automobile ticketing website; Java language; Mysql
III
目 录
第 1 章 绪论...........................................1
1.1 课题背景 .........................................................................................................1
1.2 课题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
第 2 章 开发环境与技术.................................3
2.1 MYSQL 数据库 ...............................................................................................3
2.2 JSP 技术 ...........................................................................................................3
2.3 SSM 框架 .........................................................................................................4
第 3 章 系统分析.......................................5
3.1 可行性分析 .....................................................................................................5
3.1.1 技术可行性 ..........................................................................................5
3.1.2 经济可行性 ..........................................................................................5
3.1.3 操作可行性 ..........................................................................................5
3.2 系统流程 .........................................................................................................6
3.2.1 操作流程 ..............................................................................................6
3.2.2 登录流程 ..............................................................................................6
3.2.3 删除信息流程 ......................................................................................7
3.2.4 添加信息流程 ......................................................................................8
3.3 性能需求 .........................................................................................................8
3.4 功能需求 .........................................................................................................9
第 4 章 系统设计......................................13
4.1 设计原则 .......................................................................................................13
4.2 功能结构设计 ...............................................................................................13
4.3 数据库设计 ...................................................................................................15
4.3.1 数据库概念设计 ................................................................................15
IV
4.3.2 数据库物理设计 ................................................................................17
第 5 章 系统实现......................................21
5.1 管理员功能实现 ...........................................................................................21
5.1.1 客运班次管理 ....................................................................................21
5.1.2 会员充值管理 ....................................................................................21
5.1.3 购票记录管理 ....................................................................................22
5.1.4 留言板管理 ........................................................................................22
5.2 客户功能实现 ...............................................................................................23
5.2.1 客运班次 ............................................................................................23
5.2.2 购票记录 ............................................................................................23
5.2.3 会员充值 ............................................................................................24
5.3 会员功能实现 ...............................................................................................24
5.3.1 留言反馈 ............................................................................................24
5.3.2 客运班次 ............................................................................................25
5.3.3 会员购票记录 ....................................................................................25
第 6 章 系统测试......................................27
6.1 功能测试 .......................................................................................................27
6.1.1 登录功能测试 ....................................................................................27
6.1.2 修改密码功能测试 ............................................................................28
6.2 测试结果 .......................................................................................................28
结 论...............................................29
致 谢...............................................30
参考文献.............................................31
