【正文】 畢業(yè)設(shè)計(jì)（論文）答辯委員會(huì)意見(jiàn)： 負(fù)責(zé)人簽名： 年 月 日 Ⅰ 圖書(shū)館借閱管理系統(tǒng) 摘 要 隨著科學(xué)技術(shù)的進(jìn)步，計(jì)算機(jī)行業(yè)的迅速發(fā)展，大大提高 人們的工作效率。本系統(tǒng)中包含 6 個(gè)功能模塊：系統(tǒng)設(shè)置，讀者管理，圖書(shū)管理，圖書(shū)借還，系統(tǒng)查詢和更改口令。s working efficiency introduction of puterized information system has sharply changed the management in many systems in many fields. The management system of the library takes an important role in the administration of school anization. I desigen the system after the thorough investigations about the library management system’s mechanism. This system contains with reader informantion management model, book information management model, books borrowing and returning including system information query and password setting. The system is contrived with Java Server Pages Techonolege as well as Struts,the software design mode of MVC with open source framework techonolege, which makes this system have the advantages of efficiently designed with beauteous and friendly interface . This system use jdbc driver to connect the mysql database server,which is also an open source database system for its users. The batabase was desigend with highly integrity, security, and consistency. Key words: book management, management of information ,jsp,struts Ⅰ 目 錄 摘 要 .............................................................................................................................. 1 Abstract........................................................................................................................ 2 第 1 章 課題背景與意義 ............................................................................................ 5 課題背景 ....................................................................................................... 5 圖書(shū)管理系統(tǒng)簡(jiǎn)介 ....................................................................................... 5 計(jì)算機(jī)信息系 統(tǒng)的發(fā)展 ............................................................................... 6 圖書(shū)管理系統(tǒng)的發(fā)展現(xiàn)狀 ........................................................................... 6 開(kāi)發(fā)圖書(shū)管理系統(tǒng)應(yīng)注意的問(wèn)題 ............................................................... 7 可行性分析 ................................................................................................... 7 系統(tǒng)開(kāi)發(fā)步驟 ............................................................................................... 8 第 2 章 開(kāi)發(fā)環(huán)境 ........................................................................................................ 8 Java 開(kāi)發(fā)環(huán)境 .............................................................................................. 8 SQL SERVER 2020 簡(jiǎn)介 ................................................................................ 9 SQL Server 特點(diǎn) ............................................................................ 9 SQL Server 2020 新特性 ............................................................... 9 第 3 章 系統(tǒng)分析 ........................................................................................................ 10 處理對(duì)象 ..................................................................................................... 10 業(yè)務(wù)分析 ..................................................................................................... 10 圖 書(shū)管理系統(tǒng)數(shù)據(jù)流程圖 ......................................................................... 10 系統(tǒng)功能模塊圖 ......................................................................................... 11 數(shù)據(jù)庫(kù)的設(shè)計(jì) ............................................................................................. 12 概念結(jié)構(gòu)設(shè)計(jì) ................................................................................ 12 邏輯結(jié)構(gòu)設(shè)計(jì) ................................................................................ 13 圖書(shū)類型信息表結(jié)構(gòu)設(shè)計(jì) ............................................................ 14 讀者信息表結(jié)構(gòu)設(shè)計(jì) .................................................................... 14 讀者類型信息表結(jié)構(gòu)設(shè)計(jì) ............................................................ 15 圖書(shū)借閱信息表結(jié)構(gòu)設(shè)計(jì) ............................................................ 15 圖書(shū)歸還信息表結(jié)構(gòu)設(shè)計(jì) ............................................................ 16 用戶信息表結(jié)構(gòu)設(shè)計(jì) .................................................................... 16 圖書(shū)館信息表結(jié)構(gòu)設(shè)計(jì) ................................................................ 17 辦證參數(shù)信息表結(jié)構(gòu)設(shè)計(jì) .......................................................... 17 第 4 章 總體設(shè)計(jì) ........................................................................................................ 18 數(shù)據(jù)庫(kù)設(shè)計(jì) ................................................................................................. 18 數(shù)據(jù)庫(kù)設(shè)計(jì)概述 ............................................................................ 18 系統(tǒng)總 體結(jié)構(gòu)設(shè)計(jì) ..................................................................................... 19 圖書(shū)管理系統(tǒng)總體結(jié)構(gòu)圖 ............................................................ 19 系統(tǒng)管理員模塊功能 .................................................................... 20 讀者管理模塊功能 ........................................................................ 21 圖書(shū)管理模塊功能 ........................................................................ 21 圖書(shū)借還模塊功能 ........................................................................ 22 系統(tǒng)查詢模塊功能 ........................................................................ 23 Ⅰ 第 5 章 程序設(shè)計(jì)與編碼 ............................................................................................ 24 開(kāi)發(fā)平臺(tái)與工具 ......................................................................................... 24 J2EE 平臺(tái) ....................................................................................... 24 WEB 服務(wù)器和數(shù)據(jù)庫(kù) ..................................................................... 25 程序設(shè)計(jì) ..................................................................................................... 26 程序設(shè)計(jì)概述 ............................................