【正文】 0 廣州大學(xué)華軟軟件學(xué)院 畢業(yè)論文（設(shè)計(jì)） 課題名稱 基于 JSP+SQL 的圖書館管理系統(tǒng) 的 設(shè)計(jì)與開發(fā) 學(xué) 院 廣州大學(xué)華軟軟件學(xué)院 系 別 軟件工程系 專業(yè)班級 10 軟件開發(fā) 1 班 學(xué)生姓名 學(xué) 號 指導(dǎo)教師 日 期 2021 年 4 月 1 日 I 摘 要 隨著網(wǎng)絡(luò)技術(shù)的發(fā)展、計(jì)算機(jī)應(yīng)用水平的提高的擴(kuò)大，原來系統(tǒng)的時(shí)效性、數(shù)據(jù)的正確性、操作的方便性上都存在不足，已影響到系統(tǒng)的正常使用。經(jīng)過考察比較，決定利用自己的力量對圖書管理系統(tǒng)重新設(shè)計(jì)，使系統(tǒng)能利用軟件開發(fā)技術(shù)的成果，方便圖書的管理。 圖書管理系統(tǒng)是典型的信息管理系統(tǒng)。系統(tǒng)介紹了圖書系統(tǒng)的開發(fā)過程，設(shè)計(jì)中遇到的問題及解決方法以及提高當(dāng)前 具 ,首先在短時(shí)間內(nèi)建立系統(tǒng)應(yīng)用原型 ,然后 ,對初始原型系統(tǒng)進(jìn)行需求迭代 ,不斷修正和改進(jìn) ,直到 形成用戶滿意的可行系統(tǒng)。 本次應(yīng)用程序或系統(tǒng)開發(fā)進(jìn)度和改善工作性能 . 利用其提供的各種面向?qū)ο蟮拈_發(fā)工 課程設(shè)計(jì)利用 JSP 開發(fā)工具和 SQLServer 數(shù)據(jù)庫來開發(fā)這個(gè)圖書管理系統(tǒng)。該系統(tǒng)要解決的圖書管理所要解決的問題，可以滿足圖書管理基本要求，包括添加、管理等功能。該系統(tǒng)能根據(jù)用戶的需求，快捷方便的為讀者提供借閱服務(wù)。 關(guān)鍵詞 圖書管理系統(tǒng) 信息管理 JSP II Abstract Along with working39。s development, the puter application level39。s enhancement39。s expansion, system39。s effectiveness, the data accuracy, in the operation conveniences has the insufficiency originally, Has affected system39。s normal use. After the inspection parison, decided that uses own strength to the literature management system management system redesign, enables the system to use the software development technology the achievement, convenient literature management. The literature registration management system management system is the typical information management system. The system introduced the literature referral system39。s performance history, in the design meets the question and the solution as well as enhance the current application procedure or the system development progress and the improvement operating performance. Each kind of objectoriented development kit which provides using it, first establishes the system application prototype in a short time, then, carries on the demand iteration to the initial prototype system, revises unceasingly and improves, until forms the user satisfied feasible system. This curriculum project 2021 databases develops this literature management system management system using the JSP development kits and SQL the Server. This system must solve the literature administration center must solve the question, may satisfy the literature management essential requirements, including increase, inquiry, management and so on three aspect functions. This system can act according to the user the demand, what facilitates quickly is the reader provides the service. KEY WORDS Literature management system Information management JSP 目 錄 摘要 ............................................................................................................................................. I Abstract ...................................................................................................................................... II 第 1 章 前言 .............................................................................................................................. 1 課題背景 ..................................................................................................................... 1 課題意義 ..................................................................................................................... 1 文獻(xiàn)綜述 ..................................................................................................................... 2 技術(shù)綜述 .......................................................................................................... 2 總體設(shè)計(jì)原則 ............................................................................................................. 2 第 2 章 系統(tǒng)分析 ...................................................................................................................... 4 系統(tǒng)的需求分析 ......................................................................................................... 4 業(yè)務(wù)流程分析 ............................................................................................................. 5 系統(tǒng)管理員業(yè)務(wù)流程分析 .............................................................................. 5 數(shù)據(jù)流程分析 ............................................................................................................. 7 圖書類別管理模塊 .......................................................................................... 7 圖書管理模塊 .................................................................................................. 7 讀者管理模塊 .................................................................................................. 8 圖書借閱模塊 .................................................................................................. 8 修改密碼模塊 .................................................................................................. 9 數(shù)據(jù)字典 ................................................................................................................... 10 數(shù)據(jù)項(xiàng)的描述 ................................................................................................ 10 數(shù)據(jù)流的描述 ................................................................................................ 11 第 3 章 系統(tǒng)設(shè)計(jì) .................................................................................................................... 13 系統(tǒng)體系結(jié)構(gòu)設(shè)計(jì) ................................................................................................... 13 系統(tǒng)子模塊功能介紹 ............................................................................................... 13 數(shù)據(jù)庫設(shè)計(jì) ............................................................................................................... 14 數(shù)據(jù)庫概念設(shè)計(jì) —— ER 模型 ..................................................................... 14 數(shù)據(jù)庫邏輯設(shè)計(jì) —— 關(guān)系模型 .................................................................... 15 數(shù)據(jù)庫選型 .................................................................................................... 15 數(shù)據(jù)庫表結(jié)構(gòu)設(shè)計(jì) ......