【正文】 學(xué)科分類號 本科學(xué)生畢業(yè)論文（設(shè)計） 題 目： 基于 Web的圖書管理系統(tǒng)的設(shè)計與開發(fā) —— 圖書借閱與系統(tǒng)維護 姓 名 黎 可 學(xué) 號 M43000112 院 、 系 專 業(yè) 計算機科學(xué)與技術(shù) 指導(dǎo)教師 付 玉 2021 年 5 月 10 日 目 錄 摘 要 ................................................................................................... I ABSTRACT............................................................................................. II 前 言 ................................................................................................ 1 第 1 章 開發(fā)工具選擇 .................................................................... 2 前臺開發(fā)工具 ................................................................................ 2 后臺開發(fā)工具 ................................................................................ 2 數(shù)據(jù)庫的選擇 ................................................................................ 4 數(shù)據(jù)庫的連接 ............................................................................... 4 第 2 章 圖書借閱管理系統(tǒng)的開發(fā)與設(shè)計 ....................................... 7 系統(tǒng)開發(fā)思想 ................................................................................ 7 需求分析 ..................................................................................... 7 系統(tǒng)功能模塊劃分 ...................................................................... 8 系統(tǒng)數(shù)據(jù)庫設(shè)計 ............................................................................ 9 系統(tǒng)界面風(fēng)格設(shè)計 ....................................................................... 11 第 3 章 圖書借閱管理系統(tǒng)的具體實現(xiàn) .........................................12 借書／還書處理功能的實現(xiàn) ........................................................12 借書功能的具體實現(xiàn) ..............................................................12 還書功能的具體實現(xiàn) ...............................................................18 異常處理 ......................................................................................23 遺失書籍處理的具體實現(xiàn) .......................................................23 讀者證掛失處理的具體實現(xiàn) ....................................................30 系統(tǒng)維護模塊的具體實現(xiàn) ............................................................32 數(shù)據(jù)備份與恢復(fù)的具體實現(xiàn) ....................................................32 管理員口令維護的具體實現(xiàn) ...................................................36 系統(tǒng)中報表的具體實現(xiàn) ...............................................................42 第 4 章 系統(tǒng)運行情況 ...................................................................44 借書 /還書運行情況 ......................................................................44 遺失書籍處理的運行情況 ...........................................................45 掛失讀者證處理的運行情況 ........................................................45 登陸界面的運行情況 ...................................................................46 管理員信息修改 ..........................................................................47 數(shù)據(jù)庫備份與恢復(fù)的運行情況 ....................................................48 第 5 章 結(jié)論 ..................................................................................50 參考文獻 ............................................................................................51 I 摘 要 隨著現(xiàn)代企業(yè)的發(fā)展，對于提高企業(yè)內(nèi)部人員的綜合素質(zhì)，豐富員工的精神生活，已成為各先進企業(yè)的重要內(nèi)容之一，而圖書館也越來越多的在一些大中型企業(yè)出 現(xiàn)。因此，屬于企業(yè)內(nèi)部的圖書管理系統(tǒng)也就成為了其辦公網(wǎng)絡(luò)化的一個必不可少的部分。 本系統(tǒng)是針對大中型公司 (企業(yè) )的圖書管理而設(shè)計的一個基于 Web 的圖書管理系統(tǒng)，以實現(xiàn)對圖書信息的在線管理、及時更新、快速檢索、資料搜集 ,并提供讀者論壇以方便信息交流。其開發(fā)主要包括圖書館網(wǎng)站和圖書借閱管理系統(tǒng)兩大部分：圖書館網(wǎng)站的開發(fā)主要涉及圖書館的介紹、讀者服務(wù)、信息檢索及資料下載，并且提供方便的后臺管理；圖書借閱管理系統(tǒng)主要涉及圖書信息與讀者信息的管理、借書還書的處理、掛失異常處理、數(shù)據(jù)備份恢復(fù)和權(quán)限控制等。 在本系統(tǒng)中 ,我們使用 MICROSOFT 公司的 FrontPage 開發(fā)工具 , 在Windows 202 IIS、 Microsoft SQL Server 2021 平臺下通過 ASP 和 VB script 腳本語言來實現(xiàn)。具體實現(xiàn)過程主要涉及到 ASP 程序的設(shè)計、 MS SQL Server 數(shù)據(jù)庫的操作、網(wǎng)頁界面的設(shè)計、文件的讀寫、文件的上傳下載、水晶報表等技術(shù)。 關(guān)鍵字 :圖書館網(wǎng)站，圖書借閱管理系統(tǒng)，水晶報表 II ABSTRACT With the development of modern enterprises, improving the positive stuff of the personal in the enterprises and enriching their spirit living are the most important things to the excellent corporations. Libraries appear more and more frequently in the mediumsized or large enterprises .People may borrow books from library or read books in the library. Of course, they must return books on time. So Library Information Management System which belongs to the enterprises is the necessary part of realizing work manages in the enterprises. This is a WebBased Library Information Management System, which is specially designed for library management of the mediumsized or large enterprises. Through using the system, the manager can manage all the book information online, update the information according to user’s needs, and can also search and collect the data quickly. at the same time, user can municate with others in the reader forum. So according to the user’s requirments,the system consists of two parts: the web site of library and the book borrowing and reading management system. The web site mainly includes the introduction of library, reader server, information searching and file downloading. The book borrowing and reading management system deal with the management of book information and reader information, borrowing and returning books disposal, reporting the loss of books and reader certificates disposal, backuping and restoring the data and previewing control etc. In order to design and develop the system, we selected FrontPage presented by Microsoft。 and the system is based on Windows 2021, IIS, and Microsoft SQL Server selected Active Server Page (ASP) language and VB Script language. In detail, it includes technology of ASP programming, database operation, homepage design, file reading and writing, up file and download file, crystal report etc. Keywords:library Web site lo