9图书分类号:密级:毕业论文(设计)基于C#图书管理系统的设计与实现C#forlibrarymanagementsystemdesignandimplementation姓名学号专业计算机科学与技术指导教师2014年3月22日I摘要随着科技的发展和社会的进步,计算机已成为人们生活和工作中的得力助手。设计一个现代的图书管理系统势在必得。图书管理系统是常用的信息管理系统之一,它的实现主要由两部分组成:数据库建立与维护和前台应用程序的开发。数据库要求非常强的一致性与完整性以及安全性,而前台应用程序则要求功能完善,简单易用。SQLServer2005具有比较完善的功能,而VisualC#.NET是专门针对Microsoft的.NET战略而推出的语言,它对.NETFramework有最为全面的支持。综合各个方面选择C#作为程序设计语言和SQLServer2005数据库。通过对中小型图书馆的需求分析,实现了对图书馆管理系统的功能模块划分,数据库模式分析,并设计了数据库结构和应用程序。由此得到了一个基本满足读者、图书馆管理员和高级管理者需求的图书管理系统。关键词图书馆管理系统;C#;.NET;SQLServer2005IIAbstractAlongwiththetechnicaldevelopmentandsociety'sprogress,thecomputerhasbecomethepeopletolivewiththeworkinprimaryassistant.Designsforamodernagelibrarymanagementsystemimperative.Librarymanagementsystemisoneofthecommoninformationmanagementsystem,TheLibraryManagementSystemofwhichdevelopmentmainlycontainstwoaspectsthatoneistheestablishmentandmaintenanceofthebackstagedatabaseandtheotheristhedevelopmentoftheforegroundapplicationprocedures,isatypicalManagementInformationSystem.TheDatabasewhichmusthasdataconsistency,integrality,securityaswell.Andtheforegroundapplicationrequiresthefunctionisperfect,easytouse.Allabovethese,IchosetheC#programminglanguageandSQLServer2005database.ThereasonwhyIchosetousetheMSSQLServer2005asadevelopmenttoolisthatitcanhandlestrongdatacompletelyandexactly.AndIchoseVisualC#.NETamongmanywouldbelanguages,becauseitisthebestlanguageindevelopingtheapplicationprocedure.Accordingtheanalysisofrequirementminorsmalllibrary,carvedupthemoduleoffunction,analyzedthemodeofdatabaseanddesigneditsstructureandapplication.Bythatthebookmanagementsystemcansatisfythebasicalneedofthereader,theadministratorsofthelibraryandthehigh-leveladministrators.Keywords:LibrarymanagementsystemC#.NETSQLServer2005I目录1绪论........................................................................................................................................11.1课题研究的背景和意义.................................................................................................11.2系统介绍.........................................................................................................................11.3开发工具及运行环境.....................................................................................................12系统分析................................................................................................................................32.1需求分析的目的.............................................................................................................32.2需求分析.........................................................................................................................32.3可行性分析.....................................................................................................................33系统设计................................................................................................................................43.1设计目标.........................................................................................................................43.2数据库设计.....................................................................................................................43.2.1概念结构设计..........................................................................................................43.2.2逻辑结构设计..........................................................................................................53.3总体设计.........................................................................................................................73.3.1项目规划..................................................................................................................73.3.2系统功能结构图......................................................................................................74系统主要功能模块实现........................................................................................................84.1登录界面.........................................................................................................................84.2主控制界面.....................................................................................................................84.3用户信息维护.................................................................................................................94.4读者信息维护...............................................................................................................104.5图书信息维护...............................................................................................................114.6出版社信息维护...........................................................................................................124.7借阅图书.......................................................................................................................134.8归还图书.......................................................................................................................134.9在库图书查询...............................................................................................................144.10个人借还情况...............................