《圖書(shū)管理系統(tǒng)》設(shè)計(jì)

全文31頁(yè) 約8400字 論述翔實(shí)

摘要：系統(tǒng)主要完成對(duì)圖書(shū)的庫(kù)存管理，包括圖書(shū)入庫(kù)、出庫(kù)、庫(kù)存，員工信息，供應(yīng)商信息以及密碼管理等六個(gè)方面。系統(tǒng)可以完成對(duì)各類(lèi)信息的瀏覽、查詢(xún)、添加、刪除、修改、報(bào)表等功能。
　　系統(tǒng)的核心是入庫(kù)、庫(kù)存和出庫(kù)三者之間的聯(lián)系，每一個(gè)表的修改都將聯(lián)動(dòng)的影響其它的表，當(dāng)完成入庫(kù)或出庫(kù)操作時(shí)系統(tǒng)會(huì)自動(dòng)地完成庫(kù)存的修改。查詢(xún)功能也是系統(tǒng)的核心之一，在系統(tǒng)中即有單條件查詢(xún)和多條件查詢(xún)，也有精確查詢(xún)和模糊查詢(xún)，系統(tǒng)不僅有靜態(tài)的條件查詢(xún)，也有動(dòng)態(tài)生成的條件查詢(xún)，其目的都是為了方便用戶(hù)使用。
系統(tǒng)采用Microsoft　Office中的Access　2000來(lái)設(shè)計(jì)數(shù)據(jù)庫(kù)，并使用當(dāng)前優(yōu)秀的開(kāi)發(fā)工具Delphi7.0，它有著最為靈活的數(shù)據(jù)庫(kù)結(jié)構(gòu)，對(duì)數(shù)據(jù)庫(kù)應(yīng)用有著良好的支持。
論文主要介紹了本課題的開(kāi)發(fā)背景，所要完成的功能和開(kāi)發(fā)的過(guò)程。重點(diǎn)的說(shuō)明了系統(tǒng)設(shè)計(jì)的重點(diǎn)、設(shè)計(jì)思想、難點(diǎn)技術(shù)和解決方案。

關(guān)鍵字：數(shù)據(jù)庫(kù)，SQL語(yǔ)言，Delph7.0，數(shù)據(jù)庫(kù)組件，圖書(shū)管理

Abstract:
A system basically deals with the storage management, which includes six parts: the register, checkout, storage of the books, information of the workers, business provider, and code management. A system can deal with the browse, query, addition, deletion, amendment and forms report of the information.
The core of a system is the relationship among the register, checkout and storage. The change of each form will accordingly affect other related forms. When the register or checkout has been finished, the system will do the amendment of the storage automatically. The function of query is also one of the cores. In a system, there are both single-condition query and multi-condition query, both exact query and related query, both static-condition query and dynamic-produce query, all of which are designed for the convenience of the users.
The system adopts Access　2000 of Microsoft　Office to design the databank and makes use of the advanced Delphi7.0 which has the most flexible structure of the databank and offers the best support towards the use of the databank.
This paper mainly introduces the development background, the function prospects and the development process of this subject. It focuses on the main point, the idea of the design, the technical difficulty and solvent of system design.
Key words:
databank, SQL language, Delph7.0, subassembly of databank, book management

部分參考文獻(xiàn)
　盧國(guó)俊，Delphi　7數(shù)據(jù)庫(kù)開(kāi)發(fā)，電子工業(yè)出版社，2002
　邊萌，Delphi　編程起步，機(jī)械工業(yè)出版社，2002
　伍俊良，Delphi　7課程設(shè)計(jì)案例精編，中國(guó)水利水電出版社，2002
　丁寶康，數(shù)據(jù)庫(kù)原理，經(jīng)濟(jì)科學(xué)出版社，2000
　陸麗娜，軟件工程，經(jīng)濟(jì)科學(xué)出版社，2000