基于PHP+MYSQL的企业图书管理系统

I摘要目前，社会上流行的图书管理系统已经有很多，包括各种各样学校的图书馆管理和国家图书馆管理等。而对于企业，尤其是较小的企业根本没有完善的图书馆管理系统。现在，企业图书管理基本上是停留在人工管理的状况。随便企业的发展，一些企业越来越重视企业教育培养机制，企业的图书管理系统也会越来越壮大。而人工的图书管理也将被电脑管理所代替。本次设计是针对现在企业存在的情况，将计算机信息管理应用到企业图书管理上面，根据企业的特点，在现有的社会、学校的图书管理系统，改善一些技术和增加创新，创建适合企业的独特的图书管理系统，使企业图书管理系统能够快捷的实施一些管理功能。基于WINDOWSXP开发研制，结合B/S图书管理系统的要求，对MySQL数据库管理系统、SQL语言原理、PHP应用程序设计，以及对PHP＋MySQL技术的深入学习和应用，完成了企业对图书管理系统的需求分析、功能模块划分和分析，然后设计出数据库和应用程序。设计中充分利用PHP5、MySQL5数据库技术的强大功能，提高了编程效率和系统可靠性。全文主要分六章来讨论。第一章介绍了课题研究背景和项目开发环境。第二章则对项目进行需求分析。第三章和第四章是本文的主要部分，是整个系统的设计与实现。在第五章说明系统的环境与测试。最后一章就是对完成这次设计的总结。关键词:数据库;PHP;MySQL;数据库技术;图书管理IIAbstractAtpresent,therearealotofLibrarymanagementsystemsonthesociety,includingvariousschoolslibrarymanagementandtheNationalLibrarymanagement.Butforenterprises,especiallythesmallerenterprisestherearenotasoundlibrarymanagementsystem.Nowadays,librarymanagementofenterprisesstillremainsinthemanuallibrarymanagementofthesituation.Adthedevelopmentofenterprises,someenterprises,increasingemphasisonenterpriseeducationandtrainingmechanisms,theenterprise'slibrarymanagementsystemwillgrowmoreandmorescience.Thelibrarymanagementwillbeinsteadbycomputermanagement.Accordingtotheabove-mentioneddisadvantages,thisdesigntoapplycomputerinformationmanagementcorporatelibrarymanagement.Basedontheavailablemanagesoftwaretosignificantlyconsiderthecharacteristicsofenterprisesandimprovethemanagefunctionsinthestudymanagesystem,tocreatealibrarymanagementsystemsuitableforenterprisesunique,sothatenterprisescanbeefficientimplementationofsomemanagementfunctions.BasedonWINDOWSXPdeveloped,withB/Slibrarymanagementsystemrequirements,theMySQLdatabasemanagementsystem,SQLlanguageprinciple,PHPapplicationdesign,andthePHP+MySQLtechnologyin-depthstudyandapplication,completedabusiness-to-bookmanagementsystemneedsanalysis,Thefunctionalmoduledivisionandanalysis,andthendesignadatabaseandapplicationprocedures.ThedesigntakesfulladvantageofPHP5andthepowerofMySQL5databasetechnology,improvedprogrammingefficiencyandsystemreliability.Thetexthassixchapterstodiscussthemainpoints.Thefirstchapterintroducestheresearchbackgroundandprojectdevelopmentenvironment.ChapterIIisabouttherequirementanalysisoftheproject.ChapterIIIandIVisthemajorpartofthewholetext,itisdescribesthedesignandrealizationofthesystem.Inthefifthchapterisabouttheenvironmentofthesystemandsystemtesting.Thefinalchapterissummaryofthisdesign.Keyword:Database;PHP;MySQL;DatabaseTechnology;LibraryManagementIII目录1绪论....................................................................11.1研究背景............................................................11.2数据库简介..........................................................11.3开发环境简介........................................................21.3.1PHP概述.......................................................21.3.2MYSQL概述.....................................................31.3.3PHP+MYSQL组合.................................................31.4文本工作............................................................32需求分析..................................................................42.1系统需求............................................................42.2需求分析............................................................42.3系统功能分析图......................................................52.4系统模块组成........................................................62.4.1系统功能模块...................................................62.4.2功能模块的实现.................................................63总体设计..................................................................83.1系统结构图..........................................................83.2总体功能设计........................................................83.2.1系统设计目标...................................................83.2.2总体设计.......................................................93.3数据库设计.........................................................103.3.1系统数据分析..................................................103.3.2系统E－R图...................................................113.4数据流图...........................................................133.5数据字典...........................................................143.5.1图书信息表....................................................143.5.2图书分类表....................................................153.5.3图书状态表....................................................153.5.4图书借阅信息表................................................153.5.5预定图书信息表................................................163.5.6图书评价信息表................................................163.5.7用户信息表....................................................173.5.8用户权限信息表................................................174设计思想与实现...........................................................18IV4.1用户登陆模块.......................................................184.2主界面模块.........................................................204.3检索功能...........................................................204.4添加功能模块.......................................................214.5修改功能模块.......................................................234.6删除功能模块