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

　　

【正文】 主鍵越少，表間的連接就越簡單。 3）字段的個數(shù)越少越好。 4）所有基本表的設(shè)計均應(yīng)盡量符合第三范式。數(shù)據(jù)庫的設(shè)計中，如何處理多對多的關(guān)系和如何設(shè)計主鍵，是兩個有著較大難度、需要重點考慮的問題。 結(jié)論 29 結(jié)論 通過最后兩個多月的畢業(yè)設(shè)計，我對使用 開發(fā)頁面的能力有了很大提高?；緦崿F(xiàn)了學(xué)生選課系統(tǒng)所期望的功能，驗證也得到了預(yù)期的效果。 由于在此之前對于 和網(wǎng)頁知識的了解太少，從書本上學(xué)到的知識有限，所以從一開始就碰到許多困難。例如一開始我使用的是框架結(jié)構(gòu)，由于有許多的局限性，又想使用 中的頁面繼承，也沒有得到解決，最后使用 table 和 panel 控件解決了同一頁面鏈接不同的頁面。系統(tǒng)還原上也出現(xiàn)問題，由于系統(tǒng)正在使用，還原會出現(xiàn)排它訪問，導(dǎo)致不能進行還原，這就必修斷開與數(shù)據(jù)庫的連結(jié)，到 master 數(shù)據(jù)庫中進行還原，需要殺死系統(tǒng)所在數(shù)據(jù)庫的進程號，另外在網(wǎng)頁中腳本代碼與 html 代碼之間的關(guān)系上都有過很大的困難，通過在網(wǎng)上尋找有關(guān)資料以及 同學(xué)的幫助下最后都得到了解決。 在整個設(shè)計階段感受最為深刻的是掌握學(xué)習(xí)的方式和解決問題的方法。雖然面臨的信息很多，但是如何從大量的信息中篩選出所需的信息，有用的信息，才是解決問題的關(guān)鍵。 參考文獻 30 參考文獻 [1] 羅斌 . Visual Basic NET 精彩編程實例集錦 .中國水利水電出版社 , [2] 高春蓉 . 與 從入門到精通 .電子工業(yè)出版社 , [3] 楊浩 . 高級編程 .清華大學(xué)出版社 , [4] 尚俊杰 . 程序設(shè) 計 .清華大學(xué)出版社 , [5] 李偉紅 .SQL Server2021 數(shù)據(jù)庫及應(yīng)用 .中國水利水電出版社 , [6] 龍懷冰 .SQL Server 2021 實用開發(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 實用教程 .中國水利水電出版社 , [11] 劉小偉 . 與 SQL Server 網(wǎng)站開發(fā)實用教程 .電子工業(yè)出版社 , [12] 戴志誠 .SQL Server 2021 數(shù)據(jù)庫系統(tǒng)開發(fā)與實例 .電子工業(yè)出版社 , [13] 賓晟 . 網(wǎng)絡(luò)程序開發(fā)原理與實踐教程 .電子工業(yè)出版社 , [14] Thiru Thangarathinam .Professional Databases. wrox, [15] (美 )Joseph ,Paul . SQL Server開發(fā)指南 .電子出版社 , [16] 宋昆 ,李嚴 . SQL Server數(shù)據(jù)庫開發(fā)實例解析 .機械工業(yè)出版社 , [17] 王穎 ,李敏業(yè) . Visual Basic + SQL Server數(shù)據(jù)庫應(yīng)用實例完全解析 .人民郵電出版社 , [18] 董國平 ,顏志軍 . Visual Basic數(shù)據(jù)庫開發(fā)典型模塊與實例精講 .電子工業(yè)出版社 , 第四章 系統(tǒng)實現(xiàn)與驗證 31 致謝 歷經(jīng)兩個月的努力，在老師的悉心指導(dǎo)下，我們終于順利完成了畢業(yè)設(shè)計。這次畢業(yè)設(shè)計是對我們大學(xué)學(xué)習(xí)成果的考驗和總結(jié)，是我們實現(xiàn)理想之前的一次實戰(zhàn)，一次磨練，一次提高。從而讓我們對自己有了一個更加準確的認識，對專業(yè)知識有了一個更加融會貫通的理解，更為 下一階段的學(xué)習(xí)打下了一個重要的基礎(chǔ)。 在此，我們首先要向各位領(lǐng)導(dǎo)，老師致以最衷心的謝意！我們特別要感謝的是我們的畢業(yè)設(shè)計指導(dǎo)老師―王奉元老師和張冬梅老師，不辭辛苦的指導(dǎo)我們，啟發(fā)我們，幫助我們查找資料，為我們解答疑惑！在這里請讓我們懷著最大的誠意道一聲“您辛苦了，衷心地謝謝您！” ,感謝電子信息系的全體老師和同學(xué)多年來的關(guān)心和支持！ 第四章 系統(tǒng)實現(xià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)實現(xià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