基于SQL的小型实验室管理系统设计.docVIP

摘 要 本文所设计的系统主要用于小型自主实验室的开放式管理。该系统基于计算机技术和网络技术，采用C/S模式建立。其中，服务端采用SQL语言在SQL Server 2005上开发，客户端采用VisualBasic语言在visual Basic6.0开发。本文通过系统分析、总体设计、详细设计和测试总结等章节详细介绍开发的流程及内容。在系统分析中，对系统的需求、可行性、用到的关键技术进行了详细的分析说明，在总体设计设计中仔细的介绍系统的关系结构、各模块的功能和数据库的各个表及其字段的属性，在详细设计中给出了各模块的界面设计和功能实现的代码。最后通过运行程序对系统进测试分析和总结。 本小型实验室管理系统的开发囊括了实验室管理、人员管理、仪器管理、学生网上预约实验、教师网上评分等功能。在高校中使用该系统，可实现师生高效利用实验室资源，管理员方便快捷的管理实验室，达到提高工作效率和办公自动化及无纸化的目标。 关键字：实验室管理，SQL，C/S模式  ABSTRACT In this paper, the designed system is mainly used for the management of small autonomous open laboratory. this system is based on computer network technology, and it adopts the C/S model. Among them, the Server uses the SQL language and develops on the SQL Server 2005; the client uses the visual basic language and develops in visual Basic6.0. the paper introduces the process and content through the system analysis, general design, detailed design and so on. In system analysis, the paper makes a detailed analysis on system requirements, feasibility and key technologies; in general design, the paper carefully discusses the relationship structure of the system, the function of each module and the attributes of the database--each table and field; in the detailed design, the paper shows the interface design of each module and the code of function implementation; finally, testing, analyzing and summarizing the system through the running of the program. The development of this small laboratory management system contains the laboratory management, personnel management, equipment management, students’ booking experiment online, teachers’ online judging, and other functions. Using the system in the colleges and universities, which can realize the efficient utilization of laboratory resources, and it’s convenient for administrators to manage the laboratory. In the end, it can make the goal of to improving the work efficiency and the goal of office automation and paperless office. KEY WORDS: laboratory management, SQL , C/S mode  目 录 第