韶 关 学 院
毕 业 论 文
毕业论文题目：驾校预约聊天系统设计与实现
学生姓名：陈汝杨 学 号：12115013040 院（系）：信息科学与工程学院 专 业：计算机科学与技术 班 级：12 计算机3班
指导教师姓名及职称：梁永霖（讲师）
起止时间： 2015 年 06 月—— 2015 年 11 月
驾校预约聊天系统设计与实现
摘要：驾校预约聊天系统是给驾校学员和教练使用的即时通信系统，该系统可以为教练和学员间提
供便捷高效的练车预约服务，也可以为学员、教练间提供即时聊天通信服务。本系统主要使用Android作为技术开发基础，使用Http Client + Socket + JSP等多种开源技术作为通信手段，以Eclipse ADT和MyEclipse分别做为移动端和后端的开发工具。系统主要实现以下模块：用户信息模块，预约模块和聊天模块。
关键词：预约；聊天；Android；Http Client；Socket；JSP；Eclipse
Design and implementation of “DriveChat”
Abstract: “DriveChat” which means Driving reservation and chat system, is designed for driving
school’s students and coaches to use. The system can provide convenient and efficient reservation service as well as real-time chatting communication service for coaches and students. The system is mainly use Android as a technical basis for development and use Http Client, Socket , JSP and other open source technologies as a means of communication. Eclipse ADT and MyEclipse are used as mobile-end and back-end development tools. The system is mainly to achieve the following modules: user information module, appointment module and chat module.
Keywords:Appointment; Chat; Android; Http Client; Socket; JSP; Eclipse
目 录
1 绪论 ........................................................................................................................................ 1
1.1 特点 .............................................................................................................................. 1 1.2 意义 .............................................................................................................................. 1 2 开发环境及开发工具的介绍 ................................................................................................ 2
2.1 Android概述 ................................................................................................................. 2 2.2 HttpClient+Socket技术概述 ........................................................................................ 2 2.3 开发环境概述 ............................................................................................................. 2 3 可行性分析 ............................................................................................................................ 3
3.1 技术上可行性 .............................................................................................................. 3 3.2 经济上可行性 .............................................................................................................. 3 3.3 运行上可行性 .............................................................................................................. 4 4 需求分析 ................................................................................................................................ 4
4.1 项目概述 ...................................................................................................................... 4 4.2 功能分析 ...................................................................................................................... 4
4.2.1 4.2.2 4.2.3
用户信息模块 ................................................................................................ 4 预约模块 ........................................................................................................ 5 聊天模块 ........................................................................................................ 6
5 总体设计 ................................................................................................................................ 7
5.1 系统功能结构图 .......................................................................................................... 7 5.2 系统流程图 .................................................................................................................. 7
5.2.1 5.2.2 5.3.1 5.3.2
学员系统流程图 ............................................................................................ 7 教练系统流程图 ............................................................................................ 8 学员系统组织结构图 .................................................................................... 9 学员系统组织结构图 .................................................................................... 9
5.3 系统组织结构图 .......................................................................................................... 9
6 详细设计设计 ...................................................................................................................... 10
6.1 用户信息模块设计 .................................................................................................... 10
6.1.1 6.1.2 6.1.3
登录/退出 ..................................................................................................... 10 查看基本信息 .............................................................................................. 10 查看驾考信息 .............................................................................................. 10
6.2 预约模块设计 ............................................................................................................ 10
6.2.1 6.2.2 6.2.3 6.2.4 6.2.5 6.2.6 6.3.1 6.3.2 6.3.3
学员自行预约申请 ...................................................................................... 10 学员申请教练预约时间 .............................................................................. 11 查看学员预约情况 ...................................................................................... 11 教练制定预约 .............................................................................................. 11 教练确定预约 .............................................................................................. 11 查看预约结果 .............................................................................................. 11 即时聊天 ...................................................................................................... 11 添加好友 ...................................................................................................... 12 热门评论 ...................................................................................................... 12
6.3 聊天模块设计 ............................................................................................................ 11
7 数据库设计 .......................................................................................................................... 12
7.1 数据库分析 ................................................................................................................ 12 7.2 数据流分析 ................................................................................................................ 13
7.2.1 7.2.2 7.3.1 7.3.2 7.3.3 7.3.4 7.4.1 7.4.2 7.4.3 7.4.4 7.4.5 7.4.6 7.4.7 7.4.8 7.4.9
学员数据流 .................................................................................................. 13 教练数据流 .................................................................................................. 13 用户信息模块主要E-R图 ......................................................................... 14 预约模块主要E-R图 ................................................................................. 14 聊天模块主要E-R图 ................................................................................. 14 系统总E-R图 ............................................................................................. 15 用户信息表 .................................................................................................. 16 用户类型表 .................................................................................................. 17 用户-用户类型表 ......................................................................................... 17 用户状态表 .................................................................................................. 17 学员表 .......................................................................................................... 17 学员类型表 .................................................................................................. 18 预约表 .......................................................................................................... 18 申请表 .......................................................................................................... 18 预约-申请表 ................................................................................................. 19
7.3 数据库E-R图 ........................................................................................................... 14
7.4 数据表结构设计 ........................................................................................................ 15
7.4.10 驾考信息表 ................................................................................................. 19 7.4.11 驾考类型表 ................................................................................................. 20 7.4.12 朋友信息表 ................................................................................................. 20
7.4.13 驾校信息表 ................................................................................................. 20 7.4.14 评论表 ......................................................................................................... 20 7.4.15 车辆信息表 ................................................................................................. 21 7.4.16 教练-车辆信息表 ........................................................................................ 21 7.4.17 聊天消息表 ................................................................................................. 22 7.4.18 离线消息表 ................................................................................................. 22
8 代码实现 .............................................................................................................................. 23
8.1 PO层代码示例 ........................................................................................................... 23 8.2 DAO层代码示例 ....................................................................................................... 23 8.3 Service层代码示例 .................................................................................................... 24 8.4 Module层代码示例 ................................................................................................... 24 9 测试用例 .............................................................................................................................. 25
9.1 界面原型及测试用例 ................................................................................................ 25 10 总结与体会 ........................................................................................................................ 30 致 谢 .................................................................................................................................. 31 参 考 文 献 ............................................................................................................................ 32