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