基于web的圖書管理系統(tǒng)（JAVA+SQL）畢業(yè)設計


摘要
當今時代是飛速發(fā)展的信息時代。在各行各業(yè)中離不開信息處理，這正是計算機被廣泛應用于信息管理系統(tǒng)的環(huán)境。計算機的最大好處在于利用它能夠進行信息管理。使用計算機進行信息控制，不僅提高了工作效率，而且大大的提高了其安全性。
尤其對于復雜的信息管理，計算機能夠充分發(fā)揮它的優(yōu)越性。計算機進行信息管理與信息管理系統(tǒng)的開發(fā)密切相關，系統(tǒng)的開發(fā)是系統(tǒng)管理的前提。本系統(tǒng)就是為了管理好圖書館信息而設計的。
圖書館作為一種信息資源的集散地，圖書和用戶借閱資料繁多，包含很多的信息數(shù)據(jù)的管理，現(xiàn)今，有很多的圖書館都是初步開始使用，甚至尚未使用計算機進行信息管理。根據(jù)調查得知，他們以前對信息管理的主要方式是基于文本、表格等紙介質的手工處理，對于圖書借閱情況（如借書天數(shù)、超過限定借書時間的天數(shù)）的統(tǒng)計和核實等往往采用對借書卡的人工檢查進行，對借閱者的借閱權限、以及借閱天數(shù)等用人工計算、手抄進行。數(shù)據(jù)信息處理工作量大，容易出錯；由于數(shù)據(jù)繁多，容易丟失，且不易查找?？偟膩碚f，缺乏系統(tǒng)，規(guī)范的信息管理手段。盡管有的圖書館有計算機，但是尚未用于信息管理，沒有發(fā)揮它的效力，資源閑置比較突出，這就是管理信息系統(tǒng)的開發(fā)的基本環(huán)境。
數(shù)據(jù)處理手工操作，工作量大，出錯率高，出錯后不易更改。圖書館采取手工方式對圖書借閱情況進行人工管理，由于信息比較多，圖書借閱信息的管理工作混亂而又復雜；一般借閱情況是記錄在借書證上，圖書的數(shù)目和內容記錄在文件中，圖書館的工作人員和管理員也只是當時對它比較清楚，時間一長，如再要進行查詢，就得在眾多的資料中翻閱、查找了，造成查詢費時、費力。如要對很長時間以前的圖書進行更改就更加困難了。
基于這些問題，我認為有必要建立一個圖書管理系統(tǒng)，使圖書管理工作規(guī)范化，系統(tǒng)化，程序化，避免圖書管理的隨意性，提高信息處理的速度和準確性，能夠及時、準確、有效的查詢和修改圖書情況。

關鍵字：圖書管理系統(tǒng)，圖書管理系統(tǒng)的實現(xiàn)，數(shù)據(jù)庫
Abstract
The present era is the rapid development of the information age. In all walks of life can not be separated from information processing, which is widely used in computer information management system environment. The greatest advantage the computer is able to use its information management. Control the use of computers for information, not only improve the work efficiency, but also greatly improved its security.
Especially for complex information management, computer can give full play to its advantage. Computer information management and information management system is closely related to system development is a prerequisite for system management. The system is to manage the design of library information.
Library as a distribution center for information resources, books and many users to borrow materials, including a lot of information and data management, today, there are many libraries are initially started, not even the use of computer information management. According to the survey that they had previously on the main form of information management is based on the text, tables, etc. to deal with the previous manual, for books to borrow (for example, the number of days library, library time exceeds the allotted number of days) and verification, such as statistics are often used library card to carry out manual inspections of the lending authority to borrow and borrow, such as artificial days, the manual for. Data processing work load is heavy, prone to error; as a result of the data range, easily lost, and not easy to find. Overall, the lack of a systematic, standardized means of information management. While some libraries have computers, but has not yet been used for information management, and its effect does not play, the more prominent of idle resources, which is management information system developed by the basic environment.
Manual data processing, the workload and high error rate, not easy to change mistakes. Manually take the library to borrow books manually manage the situation, as more information, books to borrow the management of information confusing and complicated; general lending are recorded in the library card, the number of books and the content recorded in the document library staff and administrators at the time it is only more clearly, over time, such as to carry out further inquiries, many have read the information, find the resulting query time-consuming, laborious. Such as a long time ago to make changes to the book is even more difficult.
Because of these problems, I think it is necessary to establish a library management system, so that the work of library management standardization and systematization, procedures, and to avoid arbitrary library management to improve the information processing speed and accuracy of timely, accurate and effective inquiry and revision of the book case.

Keywords: library management system, library management system, databas
目錄
第一章 緒論 3
1.1目的 3
1.2范圍 3
1.3總體概括 4
1.4可行性研究的前提 4
1.4.1項目基本要求 4
1.4.2可行性研究方法 5
1.4.3決定可行性的主要因素 5
1.4.3可行性分析報告 5
1.5采用建議系統(tǒng)可能帶來的影響 5
1.6社會因素可行性分析 6
1.6.1法律因素 6
1.6.2用戶使用可行性 6
1.6.3系統(tǒng)存在的不足 7
1.7數(shù)據(jù)庫 7
1.7.1SQL基礎 7
1.7.2SQL語句 8
1.8應用技術以及開發(fā)工具的介紹 11
1.8.1Struts： 12
1.8.2Hibernate： 18
1.8.3Eclipse： 22
1.8.4JDK： 23
1.8.5Tomcat： 25
1.8.6MySQL： 25
1.8.7MD5加密技術： 29
1.9需求信息的整理 32
1.9.1對現(xiàn)有系統(tǒng)的分析 32
1.9.2對所建議系統(tǒng)的分析 33
1.10總結 36
第二章 系統(tǒng)需求分析 36
2.1軟件概述 36
2.1.1介紹 36
2.2用戶特征 39
2.3項目背景 39
2.4一般性約束 40
2.5假定的依據(jù) 40
2.5具體需求 41
2.5.1功能需求 41
2.5.2性能需求 41
2.5.3安全性需求 42
2.5.4軟件質量屬性 42
2.5.5技術方面 43
2.5.6系統(tǒng)功能分析 43
2.5.7應用需求分析 43
2.6數(shù)據(jù)庫需求 44
2.6.1用戶數(shù)據(jù) 44
2.6.2元數(shù)據(jù) 45
2.6.3索引 45
2.6.4應用元數(shù)據(jù) 46
2.6.5數(shù)據(jù)庫管理系統(tǒng) 46
2.6.6創(chuàng)建數(shù)據(jù)庫 47
2.6.7數(shù)據(jù)庫理論基礎 47
2.7系統(tǒng)數(shù)據(jù)庫設計 51
2.7.1概念設計 51
2.7.2關系數(shù)據(jù)庫的邏輯設計 52
2.7.3數(shù)據(jù)庫的實現(xiàn) 53
2.8系統(tǒng)特色 61
第三章、系統(tǒng)概要設計 62
3.1系統(tǒng)總體設計 62
3.2系統(tǒng)流程 63
3.3概念設計 65
3.4用例設計 66
3.5概要設計說明書 66
3.5.1前言 67
3.5.2概要設計說明書 68
3.5.6數(shù)據(jù)模塊窗體的設置 68
第四章、系統(tǒng)詳細設計 74
4.1登錄模塊 74
4.1.1頁面 74
4.1.2功能 74
4.2用戶信息管理 76
4.2.1查詢用戶信息 76
4.2.2添加用戶信息 77
4.3圖書信息管理 78
4.3.1查詢圖書信息 78
4.3.2增加圖書信息 80
4.4借閱信息管理 81
4.4.1查詢借閱信息 81
4.5讀者信息管理 83
4.5.1查詢讀者信息 83
4.5.2添加讀者信息 84
4.6歷史操作信息管理 85
4.6.1查詢歷史操作信息 85
4.7數(shù)據(jù)約束 86
4.8JavaScript驗證腳本： 89
第五章、系統(tǒng)測試 95
5.1確認測試計劃 95
5.2集成測試計劃 95
5.3單元測試計劃 95
5.4單元測試報告 95
5.5集成測試報告 96
5.6確認測試報告 97
第六章、用戶手冊 99
6.1引言 99
6.1.1編寫目的 99
6.1.2背景 99
6.1.3參考資料 99
6.2用途 100
6.2.1功能 100
6.2.2性能 100
6.2.3安全保密 101
6.3運行環(huán)境 101
6.3.1硬設備 101
6.3.2支持軟件 101
第七章、結論 102
第八章、英文資料 104
第九章、參考文獻 107