【正文】 meamp。在 下一小節(jié)將介紹的是在線考試功能模塊及其功能的實(shí)現(xiàn)的過程。 要完成以上這些功能，在線考試模塊必須實(shí)現(xiàn)題目的增減，考題的讀取，考試計時，學(xué)生成績的評定等多項功能。學(xué)生利用網(wǎng)絡(luò)的獲取更多的知識，并利用網(wǎng)絡(luò)來提升自己的認(rèn)識水平，但這些還不夠，最終學(xué)生還需要能夠驗證自己的學(xué)習(xí)成果。理解這些也是實(shí)現(xiàn)學(xué)生功能的前提 學(xué)生首先通過系統(tǒng)登錄驗證，證明是一個合法的系統(tǒng)用戶。 39。判斷是否有該權(quán)限 if rs(passwd)=password then session(password)=rs(passwd) 39。其實(shí)現(xiàn)的效果如圖 7 所示： 圖 7 學(xué)生測試 % sql=select * from test //從題庫中調(diào)出試題。 通過使用 (update()。 end if% % i=i+1 loop % 上面這一段代碼完成設(shè)定每題的時間的。 % id=request(id) % %if request(id) then sql=select 1 * from test where id like39。//通過題目的 ID號查找 else sql=select top 1 * from test end if sql=select * from test where id like39。 sql,conn,1,1 if and then 沒有這個信息 ... else % 考試完成后學(xué)生可以馬上查看自己的成績，成績是通過查找用戶名來得到的。 % sql=select * from test sql,conn,3,3 dim score rsCount=0 ycorrect=0 rs(ans) rsCount=rsCount + 1 if (rsCount)=rs(ans) then ycorrect=ycorrect + 1 end if loop score=int(ycorrect/rscount*100)//計算成績 % （ 3） 用戶密碼修改功能的實(shí)現(xiàn)。下面的這段代碼完成學(xué)生用戶在線考試功能中密碼的修改。) pass=Replace(Trim((pass)),39。,39。 pass amp。教師所具備的特點(diǎn)是：教師要能夠更改題庫中的題目，還要能增加，刪除題目等，其具體功能實(shí)現(xiàn)如下面小節(jié)中所示的那樣。那么在這個模塊中，此用戶將擁有出題的權(quán)力，修改題庫的權(quán)力，刪除題目的權(quán)利，下面這段 代碼實(shí)現(xiàn)的是教師功能中添加題目這一子功能。39。39。39。39。39。39。39。下面的代碼就是在線考試系統(tǒng)完成題目移出功能的代碼。 下一節(jié)要介紹的是在線聊天功能模塊的實(shí)現(xiàn)。老師能夠從大家的討論了解到學(xué)生有那些問題是急需解決的。在這個功能模塊中，只有系統(tǒng)的管理員才須要驗證。要求很嚴(yán)格的驗證機(jī)制才能擁有某一項權(quán)限，所以它的代碼也不像在線考試模塊那樣的復(fù)雜。 圖 11 在線交流界面 對在線交流功能重點(diǎn)還是介紹一下其的管理員功能。 （ 1） 管理員驗證過程的代碼實(shí)現(xiàn)及效果圖 因為管理員具有的權(quán)限太高，因此必須設(shè)計一個能夠驗證管理員身份的辦法。下面的代碼段所實(shí)現(xiàn)的就是管理員的驗證功能 %selectname,passwordfromathoritywherename=39。 and password=39。,conn,1 set rs=nothing set conn=nothing () % 當(dāng)管理員把自己的信息輸入后， form就會把了輸入的數(shù)據(jù)傳給上面的這些代碼 讓它們?nèi)シ謩e用戶到底是不是管理員，管理員登錄的視圖效果如圖 12 所示： 圖 12 管理員界面 （ 2） 管理員刪除留言功能 對于管理員來說有時候需要決定哪些留言是不允許發(fā)表的，比如帶有明顯的人身攻擊性質(zhì)的留言是不被允許發(fā)表的，遇到這樣的留言時管理員就要把它屏蔽掉，以免產(chǎn)生不好的影響。 （ 3）管理員備份及恢復(fù)留言的代碼 不是所有的留言都是刪除就可以了 。查看備份目錄是否存在 OFE=(originalfile)39。在線視頻使用戶能夠在休息中就能學(xué)習(xí)知識、它的實(shí)現(xiàn)簡單，這里也就不再過多的敘述。流媒體數(shù)據(jù)流具有三個特點(diǎn)：連續(xù)性 (Continuous) 、實(shí)時性 (Real time) 、時序性，即其數(shù)據(jù)流具有嚴(yán)格的前后時序關(guān)系 在線視頻的設(shè)計與實(shí)現(xiàn) 在線視頻功能主要完成流媒體技術(shù)在精品課程網(wǎng)站中的應(yīng)用，最主要是完成播放器內(nèi)嵌，并且讓流媒體播放器尋找到要播放文件的 URL。amp。 圖 15 在線視頻 4 運(yùn)行測試與分析 運(yùn)行測試 為了驗證網(wǎng)站的運(yùn)行效果，作者對系統(tǒng)采用大量的隨機(jī)數(shù)據(jù)進(jìn)行測試，系統(tǒng)均運(yùn)行正常，未出現(xiàn)數(shù)據(jù)錯誤及其它類型的錯誤，例如：通過注冊用戶名“ lijihong”，密碼“ 111111” ,密碼提示問題：“我是誰”，密碼提示問題：“李繼紅”，更改密碼：“ 222222”通過這一組數(shù)據(jù)的測試，當(dāng)以“ lijihong“進(jìn)行用戶注冊成功后 ，系統(tǒng)提示注冊成功，自動轉(zhuǎn)向登錄界面，用利注冊的用戶名及密碼，成功進(jìn)入網(wǎng)站主頁面。進(jìn)入在線聊天模塊后，能夠正常留言。退后網(wǎng)站后，返回到網(wǎng)站登錄界面。此外測試過程中還發(fā)現(xiàn)了它的不足，因為對 ASP 開發(fā)不是特別的熟練所以代碼編寫的不是很簡潔，界面不夠美觀，系統(tǒng)給人臃腫的感覺，在設(shè)計功能時考慮的不夠全面以至于一些功能實(shí)現(xiàn)的不太理想， 而且一些功能在實(shí)現(xiàn)的時候顯的多余，這些情況的產(chǎn)生是由于缺少相關(guān)開發(fā)工作經(jīng)驗造成的，但總的來說這個精品課程網(wǎng)站還是具有一定的實(shí)用價值，能夠從一定程度上滿足用戶的需要。其不足之處有：由于不善于美工，因此，此精品課程網(wǎng)站的界面做的不太美觀，一些功能也 達(dá)不到設(shè)計時的要求，系統(tǒng)某些地方設(shè)計時分析不夠詳細(xì)以至于功能不夠完善。同時也看到了自己的不足，在大學(xué) 的這幾年雖然過的相當(dāng)順利，學(xué)習(xí)成績也不錯，但是比起天天玩的同學(xué)來說，明顯在動手能力上不如他們，而且現(xiàn)在自己好像也不怎么習(xí)慣于思考問題，做畢業(yè)設(shè)計使作者明白了很多事情，其實(shí)作者最大的收獲并不是做出了一個精品課程網(wǎng)站，而是戰(zhàn)勝了自己。 [4] 袁鵬 飛． SQLServer2020 中文版設(shè)計實(shí)務(wù) [M]．北京 :人民郵電出版社 /旗標(biāo)出版社， 。同時易老師和張老師不僅在畢業(yè)設(shè)計方面向我們提供了可貴 的幫助，同時還在我們工作的問題上向我們伸出了援助之手，這使得我們能更全身心的投入到畢業(yè)設(shè)計的制作當(dāng)中去。文中除了特別加以標(biāo)注地方外，不包含他人已經(jīng)發(fā)表或撰寫過的研究成果，也不包含為獲得成都信息工程學(xué)院或其他教學(xué)機(jī)構(gòu)的學(xué)位或證書而使用過的材料。 （ 3）學(xué)?？梢詫W(xué)術(shù)交流為目的復(fù)制、贈送和交換學(xué)位論文。 特此聲明！ 作者簽名： 2020 年 6 月 10 日 h? What I say? I speak true when I say dat Buck two devils. This was Francois39。 but Francois, not noticing him, brought Solleks to the coveted position. In his judgment, Solleks was the best leaddog left. Buck sprang upon Solleks in a fury, driving him back and standing in his place. Eh? Eh? Francois cried, slapping his thighs gleefully. Look at dat Buck. Him kill dat Spitz, him think to take de job. Go 39。 and h e answered curse with snarl and kept out of their reach. He did not try to run away, but retreated around and around the camp, advertising plainly that when his desire was met, he would e in and be good. Francois sat down and scratched his head. Perrault looked at his watch and swore. Time was flying, and they should have been on the trail an hour gone. Francois scratched his head again. He shook it and grinned sheepishly at the courier, who shrugged his shoulders in sign that they were beaten. Then Francois went up to where Solleks stood and called to Buck. Buck laughed, as dogs laugh, yet kept his distance. Francois unfastened Solleks39。 and ere the first day was done he was pulling more than ever before in his life. The first night in camp, Joe, the sour one, was punished soundly a thing that Spitz had never succeeded in doing. Buck simply smothered him by virtue of superior weight, and cut him up till he ceased snapping and began to whine for mercy. The general tone of the team picked up immediately. It recovered its oldtime solidarity, and once more the dogs leaped as one dog in the traces. At the Rink Rapids two native huskies, Teek and Koon a, were added。 for this was the mail train, carrying word from the world to the men who sought gold under the shadow of the Pole. Buck did not like it, but he bore up well to the work, taking pride in it after the manner of Dave and Solleks, and seeing that his mates, whether they prided in it or not, did their fair share. It was a monotonous life, operating with machinelike regularity. One day was very like another. At a certain time each morning the cooks turned out, fires were built, and breakfast was eaten. Then, while some broke camp, others harnessed the dogs, and they were under way an hour or so before the darkness fell which gave warning of dawn. At night, camp was made. Some pitched the tents, others cut firewood and pine boughs for the beds, and still others carried water or ice for the cooks. Also, the dogs were fed. To them, this was the one feature of the day, though it was good to loaf around, after the fish was eaten, for an hour or so with the other dogs, of which there were fivescore and odd. There were fierce fighters among them, but th ree battles with the fiercest brought Buck to mastery, so that when he bristled and showed his teeth, they got out of his way.