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


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

關(guān)鍵字：圖書管理系統(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基礎(chǔ) 7
1.7.2SQL語句 8
1.8應(yīng)用技術(shù)以及開發(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加密技術(shù)： 29
1.9需求信息的整理 32
1.9.1對現(xiàn)有系統(tǒng)的分析 32
1.9.2對所建議系統(tǒng)的分析 33
1.10總結(jié) 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軟件質(zhì)量屬性 42
2.5.5技術(shù)方面 43
2.5.6系統(tǒng)功能分析 43
2.5.7應(yīng)用需求分析 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應(yīng)用元數(shù)據(jù) 46
2.6.5數(shù)據(jù)庫管理系統(tǒng) 46
2.6.6創(chuàng)建數(shù)據(jù)庫 47
2.6.7數(shù)據(jù)庫理論基礎(chǔ) 47
2.7系統(tǒng)數(shù)據(jù)庫設(shè)計 51
2.7.1概念設(shè)計 51
2.7.2關(guān)系數(shù)據(jù)庫的邏輯設(shè)計 52
2.7.3數(shù)據(jù)庫的實現(xiàn) 53
2.8系統(tǒng)特色 61
第三章、系統(tǒng)概要設(shè)計 62
3.1系統(tǒng)總體設(shè)計 62
3.2系統(tǒng)流程 63
3.3概念設(shè)計 65
3.4用例設(shè)計 66
3.5概要設(shè)計說明書 66
3.5.1前言 67
3.5.2概要設(shè)計說明書 68
3.5.6數(shù)據(jù)模塊窗體的設(shè)置 68
第四章、系統(tǒng)詳細(xì)設(shè)計 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確認(rèn)測試計劃 95
5.2集成測試計劃 95
5.3單元測試計劃 95
5.4單元測試報告 95
5.5集成測試報告 96
5.6確認(rèn)測試報告 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硬設(shè)備 101
6.3.2支持軟件 101
第七章、結(jié)論 102
第八章、英文資料 104
第九章、參考文獻(xiàn) 107