【導(dǎo)讀】本論文主要論述的是基于WEB的選課系統(tǒng)的系統(tǒng)維護(hù)模塊的設(shè)計(jì)與實(shí)現(xiàn)。設(shè)計(jì)本系統(tǒng)的目的是對(duì)選課信息進(jìn)行管理。份，數(shù)據(jù)還原，注銷(xiāo)等功能。系統(tǒng)在校園網(wǎng)上安全有效地運(yùn)作。之后根據(jù)需求提出了系統(tǒng)管理模塊的總體設(shè)。計(jì)方案，并據(jù)此進(jìn)行了詳細(xì)設(shè)計(jì)和編碼實(shí)現(xiàn)。代碼中通過(guò)使用進(jìn)程中的Session、盡量使用存儲(chǔ)過(guò)程和盡量。減少數(shù)據(jù)庫(kù)連接的打開(kāi)時(shí)間等手段來(lái)提高性能。系統(tǒng)開(kāi)發(fā)完成后，對(duì)課題

　　

【正文】 主鍵越少，表間的連接就越簡(jiǎn)單。 3）字段的個(gè)數(shù)越少越好。 4）所有基本表的設(shè)計(jì)均應(yīng)盡量符合第三范式。數(shù)據(jù)庫(kù)的設(shè)計(jì)中，如何處理多對(duì)多的關(guān)系和如何設(shè)計(jì)主鍵，是兩個(gè)有著較大難度、需要重點(diǎn)考慮的問(wèn)題。 結(jié)論 29 結(jié)論 通過(guò)最后兩個(gè)多月的畢業(yè)設(shè)計(jì)，我對(duì)使用 開(kāi)發(fā)頁(yè)面的能力有了很大提高?；緦?shí)現(xiàn)了學(xué)生選課系統(tǒng)所期望的功能，驗(yàn)證也得到了預(yù)期的效果。 由于在此之前對(duì)于 和網(wǎng)頁(yè)知識(shí)的了解太少，從書(shū)本上學(xué)到的知識(shí)有限，所以從一開(kāi)始就碰到許多困難。例如一開(kāi)始我使用的是框架結(jié)構(gòu)，由于有許多的局限性，又想使用 中的頁(yè)面繼承，也沒(méi)有得到解決，最后使用 table 和 panel 控件解決了同一頁(yè)面鏈接不同的頁(yè)面。系統(tǒng)還原上也出現(xiàn)問(wèn)題，由于系統(tǒng)正在使用，還原會(huì)出現(xiàn)排它訪問(wèn)，導(dǎo)致不能進(jìn)行還原，這就必修斷開(kāi)與數(shù)據(jù)庫(kù)的連結(jié)，到 master 數(shù)據(jù)庫(kù)中進(jìn)行還原，需要?dú)⑺老到y(tǒng)所在數(shù)據(jù)庫(kù)的進(jìn)程號(hào)，另外在網(wǎng)頁(yè)中腳本代碼與 html 代碼之間的關(guān)系上都有過(guò)很大的困難，通過(guò)在網(wǎng)上尋找有關(guān)資料以及 同學(xué)的幫助下最后都得到了解決。 在整個(gè)設(shè)計(jì)階段感受最為深刻的是掌握學(xué)習(xí)的方式和解決問(wèn)題的方法。雖然面臨的信息很多，但是如何從大量的信息中篩選出所需的信息，有用的信息，才是解決問(wèn)題的關(guān)鍵。 參考文獻(xiàn) 30 參考文獻(xiàn) [1] 羅斌 . Visual Basic NET 精彩編程實(shí)例集錦 .中國(guó)水利水電出版社 , [2] 高春蓉 . 與 從入門(mén)到精通 .電子工業(yè)出版社 , [3] 楊浩 . 高級(jí)編程 .清華大學(xué)出版社 , [4] 尚俊杰 . 程序設(shè) 計(jì) .清華大學(xué)出版社 , [5] 李偉紅 .SQL Server2021 數(shù)據(jù)庫(kù)及應(yīng)用 .中國(guó)水利水電出版社 , [6] 龍懷冰 .SQL Server 2021 實(shí)用開(kāi)發(fā)教程 .人民郵電出版社 , [7] Dan Kent . Evolution .Sams , [8] Mahesh Chand, David Talbot .Applied : Building DataDriven Solutions . Apress, [9] John Kauffman, Thiru Thangarathinam .Beginning Databases Beta Preview . Wrox, [10] 李存斌 .SQL Server 2021 實(shí)用教程 .中國(guó)水利水電出版社 , [11] 劉小偉 . 與 SQL Server 網(wǎng)站開(kāi)發(fā)實(shí)用教程 .電子工業(yè)出版社 , [12] 戴志誠(chéng) .SQL Server 2021 數(shù)據(jù)庫(kù)系統(tǒng)開(kāi)發(fā)與實(shí)例 .電子工業(yè)出版社 , [13] 賓晟 . 網(wǎng)絡(luò)程序開(kāi)發(fā)原理與實(shí)踐教程 .電子工業(yè)出版社 , [14] Thiru Thangarathinam .Professional Databases. wrox, [15] (美 )Joseph ,Paul . SQL Server開(kāi)發(fā)指南 .電子出版社 , [16] 宋昆 ,李嚴(yán) . SQL Server數(shù)據(jù)庫(kù)開(kāi)發(fā)實(shí)例解析 .機(jī)械工業(yè)出版社 , [17] 王穎 ,李敏業(yè) . Visual Basic + SQL Server數(shù)據(jù)庫(kù)應(yīng)用實(shí)例完全解析 .人民郵電出版社 , [18] 董國(guó)平 ,顏志軍 . Visual Basic數(shù)據(jù)庫(kù)開(kāi)發(fā)典型模塊與實(shí)例精講 .電子工業(yè)出版社 , 第四章 系統(tǒng)實(shí)現(xiàn)與驗(yàn)證 31 致謝 歷經(jīng)兩個(gè)月的努力，在老師的悉心指導(dǎo)下，我們終于順利完成了畢業(yè)設(shè)計(jì)。這次畢業(yè)設(shè)計(jì)是對(duì)我們大學(xué)學(xué)習(xí)成果的考驗(yàn)和總結(jié)，是我們實(shí)現(xiàn)理想之前的一次實(shí)戰(zhàn)，一次磨練，一次提高。從而讓我們對(duì)自己有了一個(gè)更加準(zhǔn)確的認(rèn)識(shí)，對(duì)專(zhuān)業(yè)知識(shí)有了一個(gè)更加融會(huì)貫通的理解，更為 下一階段的學(xué)習(xí)打下了一個(gè)重要的基礎(chǔ)。 在此，我們首先要向各位領(lǐng)導(dǎo)，老師致以最衷心的謝意！我們特別要感謝的是我們的畢業(yè)設(shè)計(jì)指導(dǎo)老師―王奉元老師和張冬梅老師，不辭辛苦的指導(dǎo)我們，啟發(fā)我們，幫助我們查找資料，為我們解答疑惑！在這里請(qǐng)讓我們懷著最大的誠(chéng)意道一聲“您辛苦了，衷心地謝謝您！” ,感謝電子信息系的全體老師和同學(xué)多年來(lái)的關(guān)心和支持！ 第四章 系統(tǒng)實(shí)現(xiàn)與驗(yàn)證 32 As Alexander went off duty he noticed the bobbing flicker of ships39。 lights far to port and starboard. Sea Shepherd ploughed on towards Miami. 4. All ashore Susan opened her arms, as if to greet a longlost friend. The sun had returnednot the halfhearted, hideandseek sun of recent wee ks. No, this was the real thing, pure gold pouring out of a perfect sky. She felt the warmth seeping deep into her skin. Slowly the shore floated forward to meet them, or so it seemed. Miami! Without asking, she helped herself to the binoculars hanging round Gary39。s neck. Fumbling, she adjusted the focus. She wanted to see everything. Susan gave a little grunt of pleasure: white sand, palm trees, high hotels whose reflecting w indows signalled like lighthouse s, elegant yachts leaning on the wind and bing creamily through the smooth blue water. Blue! The sea was so blue! Travel brochureblue. Susan gazed in wonder. Could this be the same Atlantic whose grey green waves had made her stomach churn and driven her into her bunk? She handed back Gary39。s binoculars. Both were shading their eyes. The sun shone everywhere, from above and from below, sparking silver on the water, teeming and gleaming like a shoal of surfacing fish ... Warm enough for you? Ben Bellingham stood between them. Temperature39。s in the niies on the mainland. They chatted for a minute or two. Look, there39。s a pelican. Ben pointed. A brown pelican, quite mon around the Florida c oast. People love watching their antics. The big bird, which reminded Gary of a pterodactyl, was ma king a reconnaissance flight parallel to Sea Shepherd. Suddenly the pelican plunged. A splash, a quic k gobbling movement, and another fat fish was stored away in the bird39。s expandable throat pouch. Pelicans use their elastic bills as scoops, Ben explained. And they vary the height of their dive depending on the depth of the fish. Eat two pounds a day, those fellas, a quarter of their body weight. The bird came in to land on an old jetty. Now it looked clumsy, swaying and teetering down invisible steps to alight on flat webbed feet. Soon after, a dishevelled chick was rummaging in the adult39。s beak. Must have a nest nearby, mented Bellingham. He shook himself. Well, gotta be going. I39。ll see you again before we disembark. By the way, better alter your watchesit39。s 910 local time, five hours behind England. The bearlike naturalist shambled away. To think Susan had once felt shy, almost frightened of meeting him! She sensed, rather than saw, a new presence and peeked sideways. It was Yves. He was draped over the ship39。s rail and looked about as happy as someone being seasick. Why so glum? Susan39。s eyes took in the scene farther along the deck. Ah, that was it. Vanessa. Wearing a polka dot sunsuit that showed off her slender figure and shapely legs. Talking to Johnny Masterson, the handsome heman security officer, in khaki shirt and shorts. Obviously enjoying themselves. Poor Yves! The pelican had resumed its patrol. Susan inched nearer to Yves. Hello, she said lightly. See the pelican? Betcha it catches something in a minute? Yves lifted his head. Immediately the pelican obliged with a spectacular swoop. Told you, didn39。t I? Susan chirped. Yves feigned interest, but his face let him down. Susan switched her gaze from the bird to Yves, from Yves to Vanessa, and back to Yves. The pelican flapped off. Never mind, she murmured, there are 第四章 系統(tǒng)實(shí)現(xiàn)與驗(yàn)證 33 plenty more fish in the sea. Yao: And I am Yao, king of the rock. And there39。s nothin39。 you girls can do about it. Ling [taking a fighting stance]: Oh, yeah? Well, I think Ping [elbowing Mulan] and I could take you. Mulan [wading away]: I really don39。t want to take him anywhere. Ling [following Mulan]: Ping, we have to fight! Mulan: No we don39。t. [unnaturally] We could