Abstract
Along with our country economy vigorous development and with the world trail connection, various professions all is gradually conducting each scale the exposition or the exhibition, impetus economy development. However regarding the organizer of the exhibition, must be busy with each tedious procedure, the coordinated various relations, the relation unfolds the resources which business, the facility, the management assignment can unfold (for example to exhibition position, advertisement and so on). Because these work also is at the manual management stage, the organizer is very difficult the arrangement advancement which tracks and the prompt understanding can unfold, the resources mixes the difficulty, under this background, proposed the development can unfold the management information system.
This exhibition management system helps the committee to plan and design in several aspects, such as size of exhibition and visitor, activities, and budges of exhibition. It does not only integrate the abstract work flow in exhibitions, but also contains some special features to provided a flexible manner. With the help of customized definitions of activities and different properties in the system, different users can design according to different real world circumstances, observing the procedure and resources of the exhibit on time, so as to make correct decisions.
System is developed under Apache, PHP, and MySQL.
Keywords: based on network, B/S structure，exhibition, exhibition management, Management Information System
II
目 录
摘 要 ......................................................................................................................................... I ABSTRACT .............................................................................................................................. II 第一章 概 述 ............................................................................................................................ 1 1.1 问题的提出 ..................................................................................................................... 1 1.2 课题概述 ......................................................................................................................... 1 1.3 B/S结构 .......................................................................................................................... 2 1.3.1 B/S结构的优点 ...................................................................................................... 2 1.3.2 B/S架构软件的优势与劣势 .................................................................................. 3 第二章 系统分析 ...................................................................................................................... 4 2.1 可行性分析 ..................................................................................................................... 4 2.1.1 可行性分析原则 ..................................................................................................... 4 2.1.2 可行性分析内容 ..................................................................................................... 4 2.1.3 可行性分析结果 ..................................................................................................... 4 2.2 需求分析 ......................................................................................................................... 5 2.2.1 需求分析准则 ......................................................................................................... 6 2.2.2 功能需求分析 ......................................................................................................... 6 2.2.3 系统对象分析 ......................................................................................................... 6 2.2.4 数据需求分析 ......................................................................................................... 7 2.2.5 性能需求分析 ......................................................................................................... 8 2.3 开发工具选择 ................................................................................................................. 8 2.3.1 Apache服务器 ........................................................................................................ 8 2.3.2 数据库：MySQL 5.0.45 ......................................................................................... 9 2.3.3 PHP 5.0 ................................................................................................................... 9 2.3.4 EditPlus2 ............................................................................................................... 9 2.3.5 Dreamweaver 8 ....................................................................................................... 9 第三章 总体设计 .................................................................................................................... 11 3.1 项目规划及设计目标 ................................................................................................... 11 3.1.1 项目规划 ............................................................................................................... 11 3.1.2 设计目标 ............................................................................................................... 12 3.2 系统业务流程分析 ....................................................................................................... 12 3.3 系统功能结构 ............................................................................................................... 13 3.4 开发及运行环境 ........................................................................................................... 13
1
第四章 系统设计 .................................................................................................................... 15 4.1 编码规范 ....................................................................................................................... 15 4.1.1 数据库命名规范 ................................................................................................... 15 4.1.2 变量及对象名称定义规则 ................................................................................... 16 4.1.3 数据类型简写规则 ............................................................................................... 16 4.2 数据库设计 ................................................................................................................... 17 4.2.1 数据表概要说明 ................................................................................................... 17 4.2.2 系统实体关系图 ................................................................................................... 17 4.2.3 数据表结构 ........................................................................................................... 20 第五章 技术准备 .................................................................................................................... 29 5.1 安装APACHE .................................................................................................................... 29 5.2 安装MYSQL .................................................................................................................... 30 5.3 安装PHP ........................................................................................................................ 31 5.4 安装PHPMYADMIN ............................................................................................................. 33 第六章 公共模块设计 ............................................................................................................ 35 6.1 文件及文件夹模块设计 ............................................................................................... 35 6.2 系统配置文件 ............................................................................................................... 36 6.2 公共类设计 ................................................................................................................... 36 6.2.1 数据库类 ............................................................................................................... 36 6.2.2 分页显示类 ........................................................................................................... 38 第七章 主要功能模块设计实现 ............................................................................................ 43 7.1 系统管理 ....................................................................................................................... 43 7.1.1 系统登录设计 ....................................................................................................... 43 7.1.2 找回密码设计 ....................................................................................................... 45 7.1.3 修改密码设计 ....................................................................................................... 46 7.1.4 用户管理设计 ....................................................................................................... 47 7.2 系统注册设计 ............................................................................................................... 48 7.3 基础信息管理 ............................................................................................................... 49 7.3.1 场馆维护模块设计 ............................................................................................... 49 7.3.2 地区信息模块设计 ............................................................................................... 50 7.3.3 展品类别模块设计 ............................................................................................... 51 7.3.4 单位性质模块设计 ............................................................................................... 52 7.4会展管理........................................................................................................................ 53 7.4.1 单位管理模块设计 ............................................................................................... 53 7.4.2 发函处理模块设计 ............................................................................................... 55
2
7.4.3 邀请函管理模块设计 ........................................................................................... 56 7.4.4 展品管理 ............................................................................................................... 57 7.4.5 会议管理模块设计 ............................................................................................... 58 7.5 会展服务管理 ............................................................................................................... 58 7.5.1 活动资源管理模块设计 ....................................................................................... 58 7.5.2 单位活动管理 ....................................................................................................... 59 7.5.3 活动收费管理 ....................................................................................................... 60 7.6 财务管理设计 ............................................................................................................... 62 7.7 查询与报表设计 ........................................................................................................... 62 7.8 数据服务设计 ............................................................................................................... 62 7.8.1 数据服务类 ........................................................................................................... 62 7.8.2 数据备份模块设计 ............................................................................................... 63 7.8.3 数据恢复模块设计 ............................................................................................... 64 第八章 程序调试与错误处理 ................................................................................................ 65 8.1 数据表外码问题 ........................................................................................................... 65 8.2 “#2003 - 服务器没有响应”的问题 ........................................................................ 66 8.3 连接数据库问题 ........................................................................................................... 67 第九章 改进和完善方面 ........................................................................................................ 68 9.1 安全性改进 ................................................................................................................... 68 9.2 功能扩展 ....................................................................................................................... 69 9.3 电子商务应用 ............................................................................................................... 70 第十章 总结 ............................................................................................................................ 71 10.1 技术总结 ..................................................................................................................... 71 10.1.1 释放内存 ............................................................................................................. 71 10.1.2 获取插入记录自动标识 ..................................................................................... 71 10.2 经验总结 ..................................................................................................................... 72 致 谢 ........................................................................................................................................ 73 参考文献 .................................................................................................................................. 74 附录A 系统数据流图 ............................................................................................................. 75 A.1 数据流图用途 ............................................................................................................... 75 A.2 系统数据流图的实现 ................................................................................................... 75 附录B 系统数据字典 ............................................................................................................. 78 B.1 数据字典的用途 ........................................................................................................... 78 B.2 系统数据字典的实现 ................................................................................................... 78 附录C 系统安装手册 ............................................................................................................. 80
3
C.1 开发及运行环境设置 ................................................................................................... 80 C.2 用户名与密码 ............................................................................................................... 80 C.3 系统安装说明 ............................................................................................................... 80
4