【正文】 實(shí)，不斷地完善。 [5].黃明，梁旭 .Asp信息系統(tǒng)設(shè)計(jì)與開發(fā)實(shí)例 [M].北京：機(jī)械工業(yè)出版社 .2021。 （ 2）學(xué)?？梢圆捎糜坝　⒖s印或其他復(fù)制方式保存學(xué)位論文。 I hesitated, but childhood is a time thic kly beset with in prehensible, though important, conventions, so I withdrew a few yards and turned my back. I heard her breathing hard. Then she was crying again. I turned round. 39。 I promised. She was very brave. Nothing more than the puppy noises. When I did succeed in getting the foot free, it looked queer: I mean, it was all twisted and puffy I didn39。 it awed me slightly. I helped her to stand up on her sound foot, and steadied her while she pointed out where her home was, and the trickle of smoke that marked it. When I looked back she was on all fours again, disappearing into the bushes. I found the house w ithout much difficulty, and knoc ked, a little nervously. A tall woman answered. She had a fine, hand some face with large bright eyes. Her dress was russet and a little shorter than those most of the women at home wore, but it carried the conventional cross, from neck to hem and breast to breast, in a green that matched the scarf on her head. 39。Her foot!39。 39。t be helped now. Up you get.39。s six toes stirred nothing in my memory. I saw the foot resting in her mother39。re a good boy, David. You were very kind to Sophie. I want to thank you for that.39。I think she39。 she said, looking steadily into my face. 39。 I agreed, but a little uncertain in my tone for not realizing what the secret was. 39。Yes,39。t reach them. Then she nodded slowly, and said in words: 39。s: she should grow no beard: she should have two breasts ...39。 Her mother nodded slowly. She sighed. 39。He39。Oh!39。ll crawl,39。 she said. 39。Go away! You mustn39。除非另有說(shuō)明，本文的工作是原始性工作。 [3].石志國(guó)，王志良 .ASP 精解案例教程 [M].北京：清華大學(xué)出版社 /北方交通大學(xué)出版社 . 2021。與此同時(shí)我更加深入的進(jìn)一步研究，發(fā)現(xiàn)系統(tǒng)還存在一定的不足。nameamp。nameamp。,39。,39。User ID=biyesheji。messegeamp。 FileName Set Stream = () = adTypeBinary (music/amp。39。 session(name)% br 你的登錄時(shí)間 :br %(now)%/td /tr 2. 音樂(lè)搜索代碼： form action= method=post 歌手 : input name=singer type=text style=width:120px / br / 歌曲 : input type=text name=songstyle=width:120px / br / input type=submit value=ok.. / /form 3. 新 歌推薦代碼： ul % exec0=select * from information where class=39。usernameamp。如下 表所示： 表 字段名 數(shù)據(jù)類型及長(zhǎng)度 說(shuō)明 備注 id int（ 4） 專集 ID 主關(guān)鍵字 type char（ 100） 專集類型 null song char（ 700） 專集名稱 null hit char（ 100） 點(diǎn)擊率 null introduce char（ 5000） 專集介紹 null url char（ 1000） 專集 URL null photo char（ 1000） 專集圖片 null 6. 論壇數(shù)據(jù)信息表 BBS 該表存放論壇留言功能具體信息。如表 所示： 表 vip表設(shè)計(jì) 字段名 數(shù)據(jù)類型及長(zhǎng)度 說(shuō)明 備注 name char(100) 用戶姓名 主關(guān)鍵字 pass char(100) 用戶密碼 not null mail char(200) 電子郵件 null sex char(50) 用戶性別 null [date] datetime(8) 注冊(cè)時(shí)間 not null admin text（ 16） 用戶類型 null 2. 用戶登錄信息表 zhuce 該表用于記錄用戶登錄的基本信息，包括用戶名（ name）、密碼（ password）及注冊(cè)時(shí)間（ [date]）。在線試聽主要采用在用戶端調(diào)用 windows 默認(rèn)播放器 media player 從服務(wù)器數(shù)據(jù)庫(kù)查詢播放歌曲的路徑 ,賦予播放器來(lái)實(shí)現(xiàn)的 .而下載的功能是利用 stream 組件的讀寫操作 ,從服務(wù)器端打開 并讀取文件向?yàn)g覽器端的 stream 寫入數(shù)據(jù) ,用戶端再保存文件到本地計(jì)算機(jī)來(lái)實(shí)現(xiàn)的 .搜索功能 ,主要采取的三模糊查詢和精確查詢兩種 .在搜索歌手的時(shí)候三用的精確查詢 ,換句話說(shuō)就是必須要正確輸入想要查詢的歌手的名字才能夠查詢到相應(yīng)的歌曲 ,而對(duì)歌曲名稱的搜索三模糊查詢 ,用戶可以輸入相關(guān)的字段便可以從數(shù)據(jù)庫(kù)里面找到相近或相似的歌曲 .音樂(lè)論壇用到的計(jì)算就相對(duì)較簡(jiǎn)單一點(diǎn) ,主要是對(duì)數(shù)據(jù)庫(kù)執(zhí)行插入、更新和查詢的操作。 系統(tǒng)功能需求 音樂(lè)網(wǎng)站下載是一個(gè)非常實(shí)用的網(wǎng)站且并是需要一個(gè)過(guò)于復(fù)雜的工運(yùn)行環(huán)境。注冊(cè)后成為會(huì)員，就可在網(wǎng) 站上在線視聽音樂(lè)、在線看電影、搜索歌曲、在線留言（音樂(lè)論壇）、享受專輯的在線視聽以及實(shí)現(xiàn)下載歌曲等功能。通過(guò)這種模式，為網(wǎng)民創(chuàng)造一種享受音樂(lè)的環(huán)境，使音樂(lè)突破時(shí)空限制，讓音樂(lè)更加貼近，充實(shí)生活。所以客戶機(jī)越來(lái)越 “ 瘦 ” ，而服務(wù)器越來(lái)越 “ 胖 ” 是將來(lái)信息化發(fā)展的主流方向。在這種結(jié)構(gòu)下，用戶工作界面是通過(guò) WWW 瀏覽器來(lái)實(shí)現(xiàn)。 數(shù)據(jù)庫(kù)，顧名思義，是存入數(shù)據(jù)的倉(cāng)庫(kù)。 2. Session: Session 的所有信息，僅適用于一個(gè)用戶。 ASP 程序其實(shí)是以擴(kuò)展名為 .ASP 純文本形式存在于 WEB 服務(wù)器上的，可以用任何文本編輯器打開它，只需將 .ASP 程序放在WEB 服務(wù)器的虛擬目錄下，就可以通過(guò) WWW 的方式訪問(wèn) ASP程序了。采用 sql 數(shù)據(jù)庫(kù)，包含六張表，實(shí)現(xiàn)整個(gè)系統(tǒng)的操作。 關(guān)鍵字： ASP ； SQL Sever 2021 ；音樂(lè)網(wǎng)站 ；論壇Designing and Implementation of Music Website Abstract As the following ages of the society developing, IT filed develop so quickly that it has affected our life and living ways. Net spread is accepted as a fast, efficacious and convenient way, and is weled by more and more families. Because of being affected by pop music nowadays, Music is so much everywhere that our life really needs it. The designing and implementation with ASP+SQL Sever 2021 of music website is discussed in this paper. The functions of classification display and inquiring, listening songs on line and downloading, user registering, the latest news about music introduction have been finished in Foreground. The online Communication platform is also workable. The database manage is operated in the Background. The function of songs add, delete and upgrade user information are also operated in the background. Easy operation and good interface are also typical features of the system. Keywords: ASP ； SQL Sever 2021； Music website； BBS 目 錄 論文總頁(yè)數(shù)： 25 頁(yè) 1 引言 ......................................................................................................................... 3 課題背景 ........................................................................................................ 3 本課題研究的意義 .......................................................................................... 3 本課題研究的方法 .......................................................................................... 3 2 系統(tǒng)采用技術(shù) ........................................................................................................... 3 開發(fā)語(yǔ)言 ........................................................................................................ 3 ASP語(yǔ)言 .............................................................................................. 3 SQL介紹 .............................................................................................. 4 B/S模式介紹 .................................................................................................. 5 3 需求分析 ........................................................