摘 要
为了提高机房管理者的管理效率和减轻管理者的劳动强度,提高机房的利用率,发挥计算机的方便性和快捷性,提出了机房自由上机收费管理系统的设计方案。
机房自由上机收费系统是典型的数据库管理系统,其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面,对于前者要求建立起数据一致性和完整性、数据安全性好的库,而对于后者则要求应用程序功能完备,易使用等特点。本系统采用B/S模式,主要应用了JSP和JavaBean技术进行程序编制,以Sql Server2000为本系统的数据库。系统主要实现了实验教师设定上机收费标准,维护设备管理和使用信息,管理更新实验教师信息及上机卡信息,管理实验教师值班记录,上机用户充值,销卡及查询使用记录的功能。系统充分利用计算机检索迅速、查找方便、可靠性高、存储量大、保密性好的特点,为机房上机管理发挥作用。
关键词:收费管理;信息管理;上机管理
Abstract
In order to enhance the management efficiency of room managers and reduce superintendent's labor intensity, reduce labor intensity of managers, improve the utilization of room and play computer’s convenience and rapidity , proposed design of the Charges System of Using Computer.
Charges system is typical of database management system, including development of its key database background to the establishment and maintenance of front-end applications and the development of two areas. Regarding the former requirement to establish consistency and data integrity, data security for good, as for the latter demanded the application functions, and easy-to-use features. The system used B / S mode, take SQL Server2000 as this system database. The main achievement of the experimental set teachers on the plane charges, service equipment management and using information, update experimental teachers and information on the card, manage the record of experimental teachers on duty, and the charge of Computer users, Pin card and check usage records. Computer system to take full advantage of the rapid retrieval and search for convenient, high reliability, large memory capacity, high security, good features, room on the plane for the management role to play.
Keywords: Charge management; Information management; Computer management;
1 概述................................................................................................................................... 1
1.1 课题背景..................................................................................................................... 1
1.2 现状与分析................................................................................................................. 1
1.3 研究意义..................................................................................................................... 2
2 需求分析........................................................................................................................... 3
2.1 项目内容..................................................................................................................... 3
2.2 设计目标..................................................................................................................... 3
2.3 可行性分析................................................................................................................. 3
2.3.1 技术经济可行性.................................................................................................. 4
2.3.2 社会可行性.......................................................................................................... 4
2.4 研究设计中要解决的问题......................................................................................... 4
2.5 系统开发环境与开发工具......................................................................................... 5
2.5.1 开发环境.............................................................................................................. 5
2.5.2 开发工具.............................................................................................................. 5
3 系统结构特性设计........................................................................................................... 8
3.1 系统模型分析............................................................................................................. 8
3.1.1 实体说明.............................................................................................................. 8
3.1.3 E-R图.................................................................................................................... 9
3.2 数据库设计............................................................................................................... 11
4 行为特性设计................................................................................................................. 14
4.1 软件结构设计........................................................................................................... 14
4.2 功能子模块设计....................................................................................................... 15
4.2.1 管理员登录模块................................................................................................ 15
4.2.2 卡信息查询模块................................................................................................ 16
4.2.3 注册信息模块.................................................................................................... 17
4.2.4 卡充值模块........................................................................................................ 18
4.2.5 销卡模块............................................................................................................ 19
4.2.6 设备维护管理模块............................................................................................ 21
4.2.7 设定上机收费标准模块.................................................................................... 21
4.2.8 刷卡上机模块.................................................................................................... 22
5 系统测试及分析............................................................................................................. 24
5.1.1 测试目的............................................................................................................ 24
5.1.2 测试实例............................................................................................................ 24
5.1.3 测试结果............................................................................................................ 25
6 结论与展望..................................................................................................................... 27
参考文献............................................................................................................................. 28
致 谢................................................................................................................................. 29