圖書館管理系統是壹些單位不可缺少的部分,書籍是人類不可缺少的精神食糧，尤其對壹些學校來說，尤其重要。所以圖書館管理系統應該能夠為用戶提供充足的信息和快捷的查詢手段。但壹直以來人們使用傳統人工的方式管理圖書、期刊、試卷合訂本等，這種管理方式存在著許多缺點,如:效率低、保密性差,另外時間壹長,將產生大量的文件和數據,這對於查找、更新和維護都帶來了不少的困難。
隨著科學技術的不斷提高,計算機科學日漸成熟,其強大的功能已為人們深刻認識,它已進入人類社會的各個領域並發揮著越來越重要的作用。作為計算機應用的壹部分,使用計算機對圖書資源信息進行管理,具有著手工管理所無法比擬的優點.例如:檢索迅速、查找方便、可靠性高、存儲量大、保密性好、壽命長、成本低等。這些優點能夠極大地提高圖書館管理的效率,也是企業、學校的科學化、正規化管理,與世界接軌的重要條件。
因此，開發這樣壹套管理軟件成為很有必要的事情,在下面的各章中我們將以開發壹套圖書館管理系統為例,談談其開發過程和所涉及到的問題及解決方法。
關鍵字:圖書館,借書,還書,VB,sqlserver2000
Abstract
The library management system is some unit essential part, the books is humanity's essential spiritual food, especially to some schools, especially important.Therefore the library management system should be able to provide the sufficient information and the quick inquiry method for the user.But the people have since always used the traditional artificial way management books, the periodical, the examination paper one-volume edition and so on, this management way has many shortcomings, for example: The efficiency low, the secrecy is bad, moreover time one long, will produce the massive documents and the data, this regarding the search, the renewal and the maintenance has all brought many difficulties.
Along with the science and technology unceasing enhancement, the computer science is mature day after day, its formidable function had known profoundly for the people, it entered the human society each domain and is playing the more and more vital role.As a computer application part, uses the computer to carry on the management for the books resources information, is having the merit which the manual administration center is unable to compare. For example: Retrieves, the search rapidly convenient, the reliability high, the reserves big, the secrecy good, the life long, the cost low status.These merits can enhance the library management enormously the efficiency, also is the enterprise, the school scientific style, the standardized management, with world trail connection important condition.
Therefore, develops this kind of set of management software to become has the necessity matter very much, in following each chapter of we take will develop a set of library management system as the example, chats question and solution which its performance history and will involve.
Key words: Library, taking advantage of book, but also book, VB,sqlserver2000
目 錄
摘 要 2
Abstract 3
第壹章 前言 5
1.1 課題背景及意義 6
1.2 課題的來源 6
1.3 國內外發展概況 7
1.4 研究內容 7
1.5 開發工具 7
第二章 系統開發環境介紹 8
2.1 Visual Basic的簡介 8
2.2 SQL Server 2000 簡介 9
第三章 需求分析 11
3.1 系統功能分析 11
3.2 系統功能模塊 12
3.2.1 “借閱管理”模塊： 12
3.2.2 “書籍管理”模塊： 12
3.2.3 “讀者管理”模塊： 12
3.2.4 “系統管理”模塊： 13
3.3 系統結構圖 13
3.4 數據庫關系圖 14
3.5 系統E-R圖 14
3.6 數據庫設計 19
第四章 系統總體設計 22
4.1 界面設計 22
4.2 系統登陸模塊 22
4.3 圖書添加信息 25
4.4 讀者信息模塊 29
4.5 借閱圖書模塊 31
4.6 還書信息模塊 36
第五章 系統測試 39
5．1測試項目 39
5．2測試方法 40
第六章 小 結 42
參考文獻 43