毕业设计设计说明书
2009届
基于web的实验室综合管理系统设计与
实现（后台）
学生姓名 **** 学 号 ******* 院 系 工学院计算机系 专 业 计算机科学与技术 指导教师 *** 填写日期 2009年 4月30日
摘 要
摘 要
随着科学技术的不断发展，计算机技术被应用于多种领域，如研究机构、教育机构等等。这些机构配备了相当数量的硬件设备、器械等，但往往由于设备数量多，管理混乱以及其他等原因导致在管理这些设备过程中需要耗费比较多的人力、物力资源。这严重违背了资源的合理利用和设备的高效率应用的原则。很多高科技设备都无法体现其正真的使用价值。为此，这就提出了一个需求：如何实现设备的合理管理，以使设备发挥应有的效用。对此，本文以教育机构的实验室设备管理为例，建立一个基于web的实验室综合管理系统。该系统是基于当前正迅猛发展的Internet 技术之上，以实现实验室设备管理的最优化为根本，以加强实验室教学能力的提升为目标。最终形成集实验室设备管理和实验室教学管理为一体的综合管理平台。
关键词：管理系统；ASP.NET；ADO.NET；SQL Server；三层架构
I
Abstract
Abstract
With the continuous development of science and technology, computer
technology has been applied to a variety of areas, such as research institutions and educational institutions, etc. These institutions Equip a number of hardware devices and equipment, etc. But often as a result of the number of devices which are too much, chaotic management and other reasons that lead to more costly human and material resources in the process of the equipment management. It violates seriously the principle of the rational use of resources and equipment for efficient application. Many high-tech equipment can not reflect its true value. Therefore, it put forward a demand that is how to achieve the reasonable management of the equipment to play their proper effects. Therefore, according to the management of laboratory equipment in educational institutions as an example to set up a web-based laboratory management system. The system is based on the currently rapid development of internet technology,in order to achieve the optimization of the management of laboratory equipment for the basis ,in order to enhance the capacity of laboratory education for the objective. Ultimately,an integrated management platform has been engender,which is that the management of laboratory equipment is combined with the laboratory education management.
Key words: Management system; ASP.NET; ADO.NET; SQL Server; Three-tier structure
II
目 录
目录
摘 要 ........................................................... I ABSTRACT ......................................................... II 1. 绪论 ............................................................ 1 1.1 系统开发背景 .................................................. 1 1.2 系统开发目的 .................................................. 1 1.3 实验室综合管理系统现状与分析 .................................. 2 1.4 系统开发技术和环境 ............................................ 2
1.4.1 ASP.NET技术 ............................................. 2 1.4.2 ADO.NET技术 ............................................. 3 1.4.3 三层架构技术 ............................................. 3 1.5 全文体系 ...................................................... 5 2. 系统需求分析 .................................................... 6 2.1系统总体需求分析概述 .......................................... 6 2.2 系统功能分析 .................................................. 7 2.3系统数据需求分析 .............................................. 8 3. 系统设计 ........................................................ 9 3.1 系统功能设计 .................................................. 9 3.2 系统数据库设计 ............................................... 11
3.2.1 系统数据表设计 .......................................... 11 3.2.2 E-R图 .................................................. 16 3.3系统详细设计 ................................................. 18 4. 系统实现 ....................................................... 19 4.1 系统后台架构设计实现 ......................................... 19
4.1.1 数据访问层（DAL）实现 ................................... 19 4.1.2 业务逻辑层（BLL）实现 ................................... 24 4.2 系统后台主要界面设计和实现 ................................... 27
4.2.1 首页界面设计 ............................................ 27 4.2.2 系统登录模块实现 ........................................ 27 4.2.3 学生管理模块实现 ........................................ 28 4.2.4 教师管理模块实现 ........................................ 29 4.2.5 管理员管理模块实现 ...................................... 29 4.2.6 新闻发布管理模块实现 .................................... 33 结论 ............................................................. 34 参考文献 ......................................................... 35 致谢 ............................................................. 36
III
