【正文】 畢業(yè)設(shè)計 網(wǎng)絡(luò)音樂庫 系統(tǒng) 院 (系 )、部： _____________________ 學(xué)生姓名： ______________________ 指導(dǎo)教師： ______________________ 專 業(yè)： ______________________ 班 級： ______________________ 完成時間： ______________________ I 摘 要 現(xiàn)代信息技術(shù)的發(fā)展 ,Inter 日益成為項事業(yè)的 發(fā)展方向。 本文就根據(jù)現(xiàn)已 存在的問題，對 ” 網(wǎng)絡(luò)音樂庫 ” 系統(tǒng)做了全面的分析和整體的介紹。介紹了 +SQL Server 技術(shù)開發(fā)該系統(tǒng)的子系統(tǒng)的整個過程，即網(wǎng)絡(luò)音樂庫。該系統(tǒng)主要利用了 強(qiáng)大的網(wǎng)絡(luò)數(shù)據(jù)庫訪問技術(shù)，實現(xiàn) B/S 交互。系統(tǒng)設(shè)計并實現(xiàn)了 Server 和Client 模塊。這些模塊各自發(fā)揮了不同的作用與功能 ,并以 C語言為實例進(jìn)行了系統(tǒng)實現(xiàn)。 論文主要介紹了本課題的開發(fā)背景、系統(tǒng)分析、數(shù)據(jù)庫設(shè)計和系統(tǒng)的設(shè)計與實現(xiàn)。 關(guān)鍵詞 ； SQL Server；音樂；網(wǎng)絡(luò)； B/S ABSTRACT Modern information technology development,Inter bees an enterprise day by day the development direction. This article question which already existed on the basis, right the work music storehouse the system has made the prehensive analysis and the whole introduction. Introduced +SQL Server technology development this system subsystem entire process, namely work music storehouse. This system has mainly used Net formidable work database visit technology, realizes B/S interactive. The system design and has realized Server and the Client module. These modules have played the different role and the function respectively,And has carried on the system realization take the C language as the example. The paper mainly introduced this topic development background, the system analysis, the database design and the system design and the realization. Key words: 。 SQL Server。 Music。 Network。 B/SII 目 錄 摘 要 ........................................................................................................................................ I ABSTRACT ............................................................................................................................... I 1 緒 論 ................................................................................................................................... 4 課題背景 ......................................................................................................................... 4 網(wǎng)絡(luò)音樂庫系統(tǒng)的現(xiàn)狀 ........................................................................................... 4 網(wǎng)絡(luò)音樂庫對系統(tǒng)和用戶對網(wǎng)絡(luò)音樂庫的要求 .................................................. 4 本課題的研究意義 ......................................................................................................... 5 相關(guān)技術(shù)介紹 ................................................................................................................. 6 瀏覽器 /服務(wù)器模型 .................................................................................................. 6 技術(shù)的介紹 ................................................................................................. 7 ADO 訪庫技術(shù)介紹 .................................................................................................. 9 2 系統(tǒng)分析 ............................................................................................................................. 10 系統(tǒng)的可行性研究 ....................................................................................................... 10 系統(tǒng)需求分析 ................................................................................................................11 用戶需求分析 ..........................................................................................................11 系統(tǒng)設(shè) 計目 標(biāo)分析 .................................................................................................11 用戶模型的介紹 ............................................................................................................11 系統(tǒng)功能模塊介紹 ....................................................................................................... 12 模塊介紹 ................................................................................................................ 13 服務(wù)器介紹 ............................................................................................................ 14 客戶端介紹 ............................................................................................................. 15 小結(jié) ............................................................................................................................... 15 3 數(shù)據(jù)庫設(shè)計 ......................................................................................................................... 16 數(shù)據(jù)庫的需求分析 ....................................................................................................... 16 后臺數(shù)據(jù)庫的配置 ....................................................................................................... 16 數(shù)據(jù)庫表結(jié)構(gòu)設(shè)計 ....................................................................................................... 20 ER 模型 ........................................................................................................................ 23 4 系統(tǒng)詳細(xì)設(shè)計與實現(xiàn) ......................................................................................................... 25 系統(tǒng)工作原理介紹 ....................................................................................................... 25 III 系統(tǒng)數(shù)據(jù)流圖 ............................................................................................................... 26 系統(tǒng)的實現(xiàn)算法 ........................................................................................................... 27 用戶信息初始化算法 ............................................................................................. 27 歌曲檢索算法 ......................................................................................................... 28 試聽算法 ................................................................................................................. 29 收藏算法 ................................................................................................................. 30 服務(wù)器端與客戶端的實現(xiàn) ........................................................................................... 31 服務(wù)器端 .....................