圖書(shū)管理系統(tǒng)畢業(yè)論文.doc

論文編碼：首都師范大學(xué)本科學(xué)生畢業(yè)論文圖書(shū)管理系統(tǒng)作者：蔣森院（系）：撫順職業(yè)技術(shù)學(xué)院專(zhuān)業(yè)：計(jì)算機(jī)應(yīng)用_學(xué)號(hào)：0703030111指導(dǎo)教師：袁媛日期：2010年4月第1頁(yè)中文提要圖書(shū)管理系統(tǒng)是典型的管理信息系統(tǒng)，其開(kāi)發(fā)主要包括后臺(tái)數(shù)據(jù)庫(kù)的建立和維護(hù)以及前端應(yīng)用程序的開(kāi)發(fā)兩個(gè)方面。對(duì)于前者要求建立起數(shù)據(jù)一致性和完整性強(qiáng)、數(shù)據(jù)安全性好的數(shù)據(jù)庫(kù)。而對(duì)于后者則要求應(yīng)用程序功能完備,易使用等特點(diǎn)。本文在第一章對(duì)數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)開(kāi)發(fā)和圖書(shū)管理系統(tǒng)進(jìn)行了簡(jiǎn)明的介紹，并分析了開(kāi)發(fā)圖書(shū)管理系統(tǒng)所應(yīng)進(jìn)行的工作。第二章對(duì)數(shù)據(jù)庫(kù)的設(shè)計(jì)和access的使用進(jìn)行了系統(tǒng)分析，為深入理解數(shù)據(jù)庫(kù)應(yīng)用打下了基礎(chǔ)。第三章學(xué)習(xí)了具體的開(kāi)發(fā)工具visualbasic6.0，對(duì)其數(shù)據(jù)庫(kù)組件，數(shù)據(jù)庫(kù)編程關(guān)鍵技術(shù)進(jìn)行了系統(tǒng)的介紹。第四章分析了圖書(shū)管理信息系統(tǒng)的應(yīng)用需求，按照數(shù)據(jù)庫(kù)設(shè)計(jì)理論的要求給出了系統(tǒng)需求說(shuō)明書(shū)、局部ER圖、全局ER圖、系統(tǒng)關(guān)系模式，子模式，利用access建立了數(shù)據(jù)庫(kù)。第五章進(jìn)行了具體的程序設(shè)計(jì)，實(shí)現(xiàn)了數(shù)據(jù)庫(kù)表的瀏覽，記錄的添加、刪除和修改，報(bào)表的生成，實(shí)現(xiàn)了多數(shù)據(jù)庫(kù)表的連接操作，實(shí)現(xiàn)了多條件查詢(xún)和模糊查詢(xún)，并靈活實(shí)現(xiàn)了對(duì)不可更新查詢(xún)結(jié)果集的更新操作，實(shí)現(xiàn)了主從表操作，實(shí)現(xiàn)了密碼維護(hù)功能，最后，系統(tǒng)還可以導(dǎo)入數(shù)據(jù)庫(kù)以對(duì)任意同結(jié)構(gòu)的數(shù)據(jù)庫(kù)進(jìn)行操作設(shè)計(jì)充分利用visualbasic6.0、access數(shù)據(jù)庫(kù)。關(guān)鍵詞：管理數(shù)據(jù)庫(kù)圖書(shū)accessVisualBasic6.0第2頁(yè)EnglishabstractThebooksmanagementsystemisatypicalmanagementinformationsystem.Itsdevelopmentmainlyincludestwoaspectsthattheestablishmentofthebackstagedatabaseaswellasthefrontoftheapplicationproceduredevelopment.Establishesthedatauniformityandtheintegrityregardingformerrequestisstrong,thedatasecurityandagooddatabase.Howeverforthelattertherequestapplicationprocedurefunctionistobecomplety,Easytouseandsoon.Thispaperhascarriedontheconciseintroductioninthefirstchaptertothedatabaseapplicationsystemdevelopmentandthebooksmanagementsystem,andhasanalyzedthedevelopmentbooksmanagementsystemmanagementsystemshouldcarryon.Thesecondchapterhascarriedonthesystemanalysistothedatabasedesignandtheaccessuse,hasbuiltthefoundationforthethoroughunderstandingdatabaseapplication.Thethirdchapterhasstudiedthedevelopmenttoolvisualbasic6.0,toitsdatabasemodule,thedatabaseprogrammingessentialtechnologyhascarriedonthesystemintroduction.Thefourthchapterhasanalyzedthebooksmanagementinformationsystemapplicationdemand,hasproducedthesystemdemandinstruction,thepartialERchart,theoverallsituationERchart,thesystemrelationspatternaccordingtothedatabasedesigntheoryrequest,thesub-pattern,hasestablishedthedatabaseusingaccess.Thefifthchapterhascarriedontheconcreteprogramming,hasrealizedthedatabasetablebrowsing,therecordingincrease,thedeletionandtherevision,thereportformproduction,hasrealizedthemulti-databasestableconnectionoperation,hasrealizedthemulti-conditionsinquiryandthefuzzyinquiry,andnimblyrealizedtohasnotbeenpossibletorenewtheinquiryresultcollectiontherenewaloperation,hasrealizedthehostfromthetableoperation,hasrealizedthepasswordmaintenancefunction,finally,thesystemalsomightinductthedatabasebytocarryontheoperationdesigntothefreeisostructuralismdatabasefullytousevisualbasic6.0,theaccessdatabase.Keywords:managementdatabasebookaccessVisualBasic6.0第3頁(yè)目錄第1章前言51.1數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)開(kāi)發(fā)簡(jiǎn)介51.1.1數(shù)據(jù)庫(kù)51.1.2數(shù)據(jù)庫(kù)管理系統(tǒng)61.1.3創(chuàng)建數(shù)據(jù)庫(kù)71.2圖書(shū)管理系統(tǒng)71.3系統(tǒng)所做工作8第2章數(shù)據(jù)庫(kù)理論基礎(chǔ)82.1數(shù)據(jù)庫(kù)系統(tǒng)設(shè)計(jì)及范式分析92.1.1數(shù)據(jù)庫(kù)系統(tǒng)設(shè)計(jì)92.1.2數(shù)據(jù)庫(kù)設(shè)計(jì)范式分析112.2access介紹112.2.1access的發(fā)展現(xiàn)狀112.2.2access2000的運(yùn)行環(huán)境13第3章應(yīng)用系統(tǒng)開(kāi)發(fā)工具143.1VisualBasic概念143.2VB訪問(wèn)數(shù)據(jù)庫(kù)的方案比較15第4章圖書(shū)管理系統(tǒng)設(shè)計(jì)分析204.1需求分析204.2系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì)214.2.1概念設(shè)計(jì)214.2.2關(guān)系數(shù)據(jù)庫(kù)的邏輯設(shè)計(jì)234.2.3數(shù)據(jù)庫(kù)的實(shí)現(xiàn)23第5章圖書(shū)管理系統(tǒng)應(yīng)用程序設(shè)計(jì)235.1系統(tǒng)窗體模塊組成245.2數(shù)據(jù)模塊窗體的設(shè)置245.3用戶(hù)登錄窗體的的實(shí)現(xiàn)255.4用戶(hù)密碼認(rèn)證窗體的的實(shí)現(xiàn)255.5借閱者服務(wù)模塊的實(shí)現(xiàn)26第4頁(yè)5.5.1圖書(shū)查詢(xún)功能的實(shí)現(xiàn)265.5.2借閱者登錄功能的實(shí)現(xiàn)275.5.3借閱者借閱情況功能的實(shí)現(xiàn)285.5.4