实验设备管理系统的设计与实现

西南科技大学毕业设计说明书(论文)设计(论文)题目:实验管理系统的设计与实现专业: 信息管理与服务__________准考证号:_ 07011____________姓名: 马兴松_______________指导教师: 云贵全________________ 2013年7月25日摘要现今实验室管理一般都以办公人员进行批次记录，其的繁索给具有强烈时间观念的办公人员带来了诸多不便，实验室设备管理缺少一种完善的设备管理软件，为了对设备基本情况管理方便，开发人员完成了全面的调查与分析，同时与目标用户进行了多次深入沟通，并在次基础上着手开发《实验室管理系统》软件。

通过课程设计，让学生能够全面了解数据库应用系统的整个开发过程，验证课堂教学中的理论，掌握数据库系统的基本概念，基本原理及应用技术，掌握SQL语言，真正实现实践检真理。

信息社会的高科技，商品经济化的高效益，使计算机的应用已普及到经济和社会生活的各个领域。

实验室设备管理迫切需要与计算机联系，不仅可以减轻办公人员的工作同时更能让实验室设备系统管理。

计算机虽然与人类的关系愈来愈密切，还有人由于计算机操作不方便继续用手工劳动。

为了适应现代社会人们高度强烈的时间观念，实验室设备管理系统软件将会为实验室设备管理带来了极大的方便。

在我们生活的21世纪里计算机技术已经在各行各业中发挥着不可替代的作用。

当前越来越多的商业、企事业单位已经将计算机技术应用于日常的管理工作，以信息技术为主要标志的科技进步日新月异，高科技成果向现实生产力的转化越来越快。

实验设备管理系统根据实验设备的报修、报检、统计等，这样为实验设备的日常维护与管理提供了极大地方便，同时也进一步规范了实验设备的管理，为实验设备的管理向着信息化迈出了重要的步伐。

本论文将介绍办实验管理系统的设计和开发过程，本系统采用Visual Studio作为开发工具，SQLServer作为后台数据库，这是经典的单机版数据库管理信息系统开发组合。

通过参与此系统的开发，可以了解信息管理系统的需求分析、设计和实现的完整过程，掌握SQL Server数据库的基本管理方法、常用SQL语言的使用方法以及Visual Studio的数据库开发技术，积累有效的数据库应用系统实战经验。

为日后的管理工作带来了极大地便利。

关键词：实验设备管理系统；实验用品管理；设备ABSTRACTCurrent laboratory management generally to office staff for batch record, the complexity of cable for a strong concept of time is office workers brought inconvenience, laboratory equipment management lacks a kind of perfect equipment management software, in order to be convenient for equipment basic information management, developers, completed a comprehensive investigation and analysis, at the same time held several in-depth communication with the target user, and based on time to the laboratory management system software development.Through the curriculum design, let the students to fully understand the whole development process of database application system, verify the theory of classroom teaching, master the basic concept of database system, basic principle and application technology, grasp the SQL language, realize practice test truth.Information society the high-tech, goods of contract high benefit, make the application of computer has spread to various fields of economic and social life. Lab equipment management is an urgent need to contact the computer, not only can reduce the work of office personnel at the same time, more can let the lab equipment management system. Although computer and human relations more and more close, and because the computer operation is not convenient to continue to use manual Labour. In order to adapt to the modern society people highly strong time concept, laboratory equipment management system software will have brought great convenience for laboratory equipment management.In the 21st century we live in computer technology have played an irreplaceable role in all walks of life. Currently more and more business, enterprises and institutions have computer technology was applied to the daily management work, information technology as the main symbol of rapid progress in science and technology and the transformation of high-tech achievements into real productivity faster and faster.Laboratory equipment management system according to the experimental equipment of the repair, inspection, statistics, etc., such as lab equipment routine maintenance and management provides a convenient greatly, and further standardize the management of experimental equipment and experimental equipment of management towards informatization is an important step.Do experiment management system this paper introduces the design and development process, the system adopts Visual Studio as a development tool, used as background database, this is the classic stand-alone database management information system development portfolio. Through participate in the development of this system, we can understand the demand of information management system analysis, design, and implementation of a complete process, master the basic SQL Server database management method, the methods of use of SQL language and Visual Studio database development technology, efficient database application system of actual combat experience. For future management work has brought great convenience.Keywords：Laboratory equipment management system; Experiment suppliesmanagement; equipment目录第1章系统概述 (6)1.1实验设备管理系统开发背景 (6)1.2任务概述 (6)1.3项目开发计划 (7)1.4模块设计 (7)第2章相关技术与开发工具简介 (8)2.1M ICROSOFT V ISUAL S TUDIO 2010简介 (8)2.2M ICROSOFT SQL S ERVER 2008R2 (9)第3章数据库分析与设计 (11)3.1数据库分析 (11)3.2数据库设计 (11)3.2.1数据库数据清单 (11)3.2.2数据表 (11)3.3办公用品管理系统数据库图 (13)第4章详细设计与实现 (14)4.1登录模块 (14)4.1.1简要说明 (14)4.1.2程序逻辑 (14)4.1.3界面设计 (15)4.2管理界面模块 (16)4.3功能模块设计及部分代码 (17)4.3.1实验设备管理信息模块 (17)4.3.2设备报修信息管理模块 (21)4.3.4实验设备报废管理模块 (24)4.3.5用户管理模块 (27)第5章逻辑模型设计和优化 (30)5.1逻辑模型设计和优化 (30)第6章系统测试 (31)6.1测试计划 (31)6.1.1测试方案 (31)6.1.2测试的原则 (31)6.2测试结果说明 (32)6.2.1登录测试 (32)6.2.2信息测试 (32)结论 (33)致谢 (34)参考文献 (35)第1章系统概述1.1 实验设备管理系统开发背景近年来，随着计算机技术渗透到各个领域，利用计算机技术管理已成为实验设备管理的必然趋势。