【正文】 ................................................................................... 10 2． 3 解決方案 ................................................................................................................ 10 2． 4 可行性分析 ............................................................................................................ 12 第三章 系統(tǒng)分析與設(shè)計(jì) ........................................................................................................ 12 現(xiàn)系統(tǒng)中存在的問題 ................................................................................................. 12 新系統(tǒng)的目標(biāo) ........................................................................................................... 13 應(yīng)用需求分析 .......................................................................................................... 13 系統(tǒng)數(shù)據(jù)庫設(shè)計(jì) ....................................................................................................... 15 系統(tǒng)總體規(guī)劃 ........................................................................................................................ 23 系統(tǒng)功能 .................................................................................................................. 23 流程圖 ...................................................................................................................... 24 數(shù)據(jù)庫設(shè)計(jì) ............................................................................................................... 25 數(shù)據(jù)庫詳細(xì)設(shè)計(jì) ........................................................................................................ 31 第六章 系統(tǒng)功能模塊結(jié)構(gòu)與實(shí)現(xiàn) .......................................................................................... 35 6． 1 登錄界面的實(shí)現(xiàn) ..................................................................................................... 35 6． 2 系統(tǒng)數(shù)據(jù)庫的實(shí)現(xiàn) ................................................................................................. 37 結(jié)束語 .................................................................................................................................. 38 參考文獻(xiàn) ............................................................................................................................... 39 第一章．開發(fā)本系統(tǒng)的目的及意義？ 今天，計(jì)算機(jī)的價(jià)格已經(jīng)十分低廉，性能卻有了長足的進(jìn)步。 圖書租借的設(shè)計(jì)分析 根據(jù)實(shí)際情況，我們使用原型法（ Rapid Prototyping）即以少量代價(jià)快速地構(gòu)造一個(gè)可執(zhí)行的軟件系統(tǒng)模型。 （ 5）圖書租借管理員把借書卡保存到寫有該讀者借書證號(hào)的口袋里。 這四個(gè)方面形成了圖書館一個(gè)工作整體，采用計(jì)算機(jī)自動(dòng)化信息處理，可方便快捷地共享信息、交流信息，高效地 協(xié)同工作。 管理上可行：該圖書館有很多的管理體制，每位借書人均有借書證，同時(shí)圖書館還為每位借書人建立了檔案。該系統(tǒng)已不能滿足多個(gè)人員對(duì)數(shù)據(jù)的索??；如副科長管理計(jì)算機(jī)，則科長就不能在自己的辦公室中查看資料。 圖書租借管理系統(tǒng)功能的信息量大，數(shù)據(jù)安全性和保密性要求最高。 1)確定公共實(shí)體類型 為了給多個(gè)局部 ER模式的合并提供開始合并的基礎(chǔ)，首先要確定各局部結(jié)構(gòu)中的公共實(shí)體類型。數(shù)據(jù)庫是 MIS 中的重要支持技術(shù)，在 MIS 開發(fā)過程 中，如何選擇數(shù)據(jù)庫管理是一個(gè)重要的問題，目前，數(shù)據(jù)庫產(chǎn)品較多，每種產(chǎn)品都具有各自的特點(diǎn)和適用范圍，因此，在選擇數(shù)據(jù)庫時(shí)，應(yīng)考慮數(shù)據(jù)庫應(yīng)用的特點(diǎn)及適用范圍，本系統(tǒng)選用的數(shù)據(jù)庫語言 Visual Basic 語言，該開發(fā)工具具有很多長處： Visual Basic 是一種可視化的、面對(duì)對(duì)象和條用事件驅(qū)動(dòng)方式的結(jié)構(gòu)化高級(jí)程序設(shè)計(jì)，可用于開發(fā) Windows 環(huán)境下的種類應(yīng)用程序。 Visual Basic 自動(dòng)產(chǎn)生界面設(shè)計(jì)代碼，程序設(shè)計(jì)人員只需要編寫實(shí)現(xiàn)程序功能的那部分代碼，從而可以大大提高程序設(shè)計(jì)的效率。在設(shè)計(jì) Visual Basic 程序的過程中，隨時(shí)可以運(yùn)行程序，而在整個(gè)程序設(shè)計(jì)好之后，可以編譯生成 可執(zhí)行文件 (.EXE)，脫離 Visual Basic 環(huán)境，直接在 Windows 環(huán)境下運(yùn)行。 Visual Basic 提供 開放式數(shù)據(jù)連接，即 ODBC 功能，可通過直接訪問或建立連接的方式使用并操作后臺(tái)大型網(wǎng)絡(luò)數(shù)據(jù)庫，如 SQL Server， Oracle 等。 動(dòng)態(tài)鏈接庫 (DLL) Visual Basic是一種高級(jí)程序設(shè)計(jì)語言，不具備低級(jí)語言的功能，對(duì)訪問機(jī)器硬件的操作不太容易實(shí)現(xiàn)。 Access 是一種關(guān)系數(shù)據(jù)庫工具，關(guān)系數(shù)據(jù)庫是已開發(fā)的最通用的數(shù)據(jù)庫之一。 DATA控件還提供了用來瀏覽不同記錄的各種跳轉(zhuǎn)按鈕。 數(shù)據(jù)庫的設(shè)計(jì)和開發(fā)及包括藝術(shù)有包括工程。存儲(chǔ)器的容量、存儲(chǔ)速率直接影響到數(shù)據(jù)管理技術(shù)的發(fā)展。同時(shí)合理的數(shù)據(jù)結(jié)構(gòu)也將有利于程序的實(shí)現(xiàn)。 在下面的對(duì)話框中選 ” 使用設(shè)計(jì)器創(chuàng)建表 ” ，上面 還有三個(gè)按鈕，一個(gè)是打開，一個(gè)是設(shè)計(jì)，一個(gè)是新建，點(diǎn)擊設(shè)計(jì)，就可以開始設(shè)計(jì)數(shù)據(jù)表了。設(shè)置數(shù)據(jù)的路徑 Provider=。如果聲明在下面，那就成了局部變量，那么作用范圍就會(huì)不同了，作用就更不同，而且在其它窗體中使用到了這個(gè)變量，程序會(huì)出錯(cuò)。（因表較多，只列出兩表） 管理員表：用于存放管理員的信息。楊老師認(rèn)真負(fù)責(zé)的工作態(tài)度，嚴(yán)謹(jǐn)?shù)闹螌W(xué)精神和深厚的理論水平都使我收益匪淺。Of the theme that I have declared to you, I will now that ye make in harmony together a Great Music. And since I have kindled you with the Flame Imperishable, ye shall show forth your powers in adorning this theme, each with his own thoughts and devices, if he will. But I win sit and hearken, and be glad that through you great beauty has been wakened into song.39。 but it was loud, and vain, and endlessly repeated。 And he showed to them a vision, giving to them sight where before was only hearing。 as who should ta ke the whole field of Arda for the foundation of a pillar and so raise it until the cone of its summit were more bitter than a needle。Behold your Music! This is your minstrelsy。Mighty are the Ainur, and mightiest among them is Melkor 。 and a sound arose of endless interchanging melodies woven in harmony that passed beyond hearing into the depths and into the heights, and the places of the dwelling of Il 鷙 atar were filled to overflowing, and the music and the echo of the music went out into the Void, and it was not void. Never since have the A inur made a ny music like to this music, though it has been said that a greater still shall be made before Il鷙 atar by the choirs of the Ainur and the Children of Il 鷙 atar after the end of days. Then the themes of Il鷙 atar shall be played aright, and ta ke Being in the moment of their utterance, for all shall then understand fully his intent in their part, and each shall know the prehension of eac h, and Il 鷙 atar shall give to their thoughts the secret fire, being well pleased. But now Il 鷙 atar sat and hearkened, and for a great while it seemed good to him, for in the music there were no flaws. But as the theme progressed, it came into the heart of Melkor to interweave matters of his own imagining that were not in accord with the theme of Il 鷙 atar, for he sought therein to increase the power and glory of the part assigned to himself. To Melkor among the A inur had be en given the greatest gifts of power and knowledge, and he had a share in all the gifts of his brethren. He had gone often alone into the void places seeking the I mperishable Flame。 另外，在系統(tǒng)開發(fā)過程中助手同學(xué)也給于我很大的幫助，幫助解決了不少的難點(diǎn)，使得系統(tǒng)能及時(shí)開發(fā)完成，還有同組的同學(xué)同樣給與我不少幫助，這里一并表示感謝。 字段名 字段類型 字段長度 字段說明 訂單編號(hào) 文本 8 訂單編號(hào) 讀者編號(hào) 文本 8 讀者編號(hào) 借閱日期 文本 6 借閱日期 押金方式 文本 4 押金方式 其它數(shù)據(jù)庫表略