IT机房设备管理系统

课程设计课程名称SQL数据库系统课程设计题目名称IT机房设备管理系统专业班级2014级计算机科学与技术升本学生姓名宋欢乐、张焕、范孝礼学号51402111042、51402111038、51402111043指导教师戚晓明（副教授）二○一四年十二月二十九日IT机房设备管理系统摘要:随着计算机的不断发展，一些计算机机房设备很难管理，此时需要一种软件系统来管理这些机房设备，有了此软件就可以很方便的管理这些设备。机房管理系统是信息管理系统，其开发的功能主要包括：通过计算机管理用户基本信息、设备基本信息、日常管理，通过强大的查询和检索高效的检索出数据，提高办事效率。管理员可以通过IT机房管理系统对管理员的信息进行修改和增加管理员，还可以增加、修改、查询用户信息，以便了解用户的最新动态此外，还可以对设备进行增加、修改、查询和删除，以便了解设备的最新动态。本系统是用MicrosoftVisualStudio.NET2010开发的C#窗体应用程序设计，数据库采用的是MicrosoftSQLServer2008，系统具有操作界面友好、简洁、实用的特点。关键词：IT机房管理系统，管理员，设备ComputerRoomManagementSystemAbstract：withthecontinuousdevelopmentofthecomputer,somecomputerroomequipmentisdifficulttomanage,thistimetheneedforasoftwaresystemtomanagethecomputerroomequipment,thesoftwarecanbeveryconvenienttomanagetheseequipment.Computerroommanagementsystemistheinformationmanagementsystem,itsdevelopmentfunctionmainlyincludes:throughthecomputermanagementofbasicinformation,basicinformationofuserequipment,dailymanagement,throughapowerfulqueryandretrievalefficientretrievalofdata,improveworkefficiency.AdministratorscanmodifytheadministratorinformationandincreasetheadministratorthroughtheITroommanagementsystem,canalsoadd,modify,querytheuserinformation,inordertounderstandthelatestdevelopmentsintheuser,canalsoadd,modifyequipment,queryanddelete,tothelatestdevelopmentsinsolutionofequipment.ThesystemisaC#formsapplicationdesignofMicrosoftVisualStudio.NET2010development,databaseusingMicrosoftSQLServer2008,thesystemhasthecharacteristicsoffriendlyinterface,simpleandpractical.Keywords:Systemmanagement,administrator,ITcomputerroomequipment目录蚌埠学院计算机科学与技术系课程设计任务书............................1蚌埠学院计算机科学与技术系本科课程设计成绩评定表....................2蚌埠学院计算机科学与技术系本科课程设计成绩评定表....................3蚌埠学院计算机科学与技术系本科课程设计成绩评定表....................41系统总体方案......................................................51.1开发背景............................................................................................................................51.2意义....................................................................................................................................51.3系统相关知识介绍............................................................................................................52设计思路与主要步骤...............................................72.1系统需求............................................................................................................................72.2功能需求............................................................................................................................72.2.1系统管理................................................................................................................72.2.2.设备基本信息管理...............................................................................................72.2.3.库存设备管理.......................................................................................................82.2.4.用户操作...............................................................................................................82.3数据库逻辑结构................................................................................................................82.4数据库中的约束................................................................................................................92.4.1主键约束................................................................................................................92.4.2外键约束................................................................................................................92.4.3DEFAULT约束......................................................................................................102.5数据库中的视图..............................................................................................................102.5.1显示库存设备信息视图......................................................................................102.5.2显示出库设备信息视图......................................................................................102.5.3显示入库设备信息视图......................................................................................102.6数据库中的触发器..........................................................................................................112.6.1入库信息维护触发器..........................................................................................112.6.2出库信息维护触发器..........................................................................................113各功能模块和流程图...............................................123.1系统软件结构设计..........................................................................................................124系统的详细设计...................................................134.1登录界面..........................................................................................................................134.2用户管理模块..................................................................................................................134.2.1添加用户..............................................................................................................134.2.2网上用户注册...........................