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

　　

【正文】 3）字段的個數(shù)越少越好。 4）所有基本表的設計均應盡量符合第三范式。數(shù)據(jù)庫的設計中，如何處理多對多的關系和如何設計主鍵，是兩個有著較大難度、需要重點考慮的問題。 結論 29 結論 通過最后兩個多月的畢業(yè)設計，我對使用 開發(fā)頁面的能力有了很大提高?；緦崿F(xiàn)了學生選課系統(tǒng)所期望的功能，驗證也得到了預期的效果。 由于在此之前對于 和網(wǎng)頁知識的了解太少，從書本上學到的知識有限，所以從一開始就碰到許多困難。例如一開始我使用的是框架結構，由于有許多的局限性，又想使用 中的頁面繼承，也沒有得到解決，最后使用 table 和 panel 控件解決了同一頁面鏈接不同的頁面。系統(tǒng)還原上也出現(xiàn)問題，由于系統(tǒng)正在使用，還原會出現(xiàn)排它訪問，導致不能進行還原，這就必修斷開與數(shù)據(jù)庫的連結，到 master 數(shù)據(jù)庫中進行還原，需要殺死系統(tǒng)所在數(shù)據(jù)庫的進程號，另外在網(wǎng)頁中腳本代碼與 html 代碼之間的關系上都有過很大的困難，通過在網(wǎng)上尋找有關資料以及 同學的幫助下最后都得到了解決。 在整個設計階段感受最為深刻的是掌握學習的方式和解決問題的方法。雖然面臨的信息很多，但是如何從大量的信息中篩選出所需的信息，有用的信息，才是解決問題的關鍵。 參考文獻 30 參考文獻 [1] 羅斌 . Visual Basic NET 精彩編程實例集錦 .中國水利水電出版社 , [2] 高春蓉 . 從入門到精通 .電子工業(yè)出版社 , [3] 楊浩 . .清華大學出版社 , [4] 尚俊杰 . 計 .清華大學出版社 , [5] 李偉紅 .SQL Server2020 數(shù)據(jù)庫及應用 .中國水利水電出版社 , [6] 龍懷冰 .SQL Server 2020 實用開發(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 2020 實用教程 .中國水利水電出版社 , [11] 劉小偉 . SQL Server 網(wǎng)站開發(fā)實用教程 .電子工業(yè)出版社 , [12] 戴志誠 .SQL Server 2020 數(shù)據(jù)庫系統(tǒng)開發(fā)與實例 .電子工業(yè)出版社 , [13] 賓晟 . 網(wǎng)絡程序開發(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ù)庫應用實例完全解析 .人民郵電出版社 , [18] 董國平 ,顏志軍 . Visual Basic數(shù)據(jù)庫開發(fā)典型模塊與實例精講 .電子工業(yè)出版社 , 第四章 系統(tǒng)實現(xiàn)與驗證 31 致謝 歷經(jīng)兩個月的努力，在老師的悉心指導下，我們終于順利完成了畢業(yè)設計。這次畢業(yè)設計是對我們大學學習成果的考驗和總結，是我們實現(xiàn)理想之前的一次實戰(zhàn)，一次磨練，一次提高。從而讓我們對自己有了一個更加準確的認識，對專業(yè)知識有了一個更加融會貫通的理解，更為 下一階段的學習打下了一個重要的基礎。 在此，我們首先要向各位領導，老師致以最衷心的謝意！我們特別要感謝的是我們的畢業(yè)設計指導老師―王奉元老師和張冬梅老師，不辭辛苦的指導我們，啟發(fā)我們，幫助我們查找資料，為我們解答疑惑！在這里請讓我們懷著最大的誠意道一聲“您辛苦了，衷心地謝謝您！” ,感謝電子信息系的全體老師和同學多年來的關心和支持！ 第四章 系統(tǒng)實現(xiàn)與驗證 32 t was not until midafternoon that the inspector ambled up on his pony. My father pulled himself together, and went out to receive him。 the effort to be even formally polite nearly strangled him. Even then the inspector was not brisk. He dis mounted in a leisurely fashion, and strolled into the house, chatting about the weather. Father, red in the face, handed him over to Mary who took him along to mother39。s room. Then followed the worst wait of all. Mary said afterwards that he hummed and ha39。d for an unconscionable time while he examined the baby in minutest detail. At last, however, he emerged, with an expressionless face. In the littleused sittingroom he sat down at the table and fussed for a while about getting a good point on his quill. At last he took a form from his pouch, and in a slow, deliberate hand wrote that he officially found the child to be a true female human being, free from any detectable form of deviation. He regarded that thoughtfully for some moments, as though not perfectly satisfied. He let his hand hesitate before he actually dated and signed it, then he sanded it carefully, and handed it to my enraged father, still with a faint air of uncertainty. He had, of course, no real doubt in his mind, or he would have called for another opinion。 my father was perfectly well aware of that, too. At last Petra39。s existence could be admitted. I was formally told that I had a new sister, and presently I was taken to see her where she lay in a crib beside my mother39。s bed. She looked so pink and wrinkled to me that I did not see how the inspector could have been quite sure about her. However, there was nothing obviously wrong with her, so she had got her certificate. Nobody could blame the inspector for that。 she did appear to be as normal as a newborn baby ever looks. ... While we were taking turns to look at her somebody started to ring the stable bell in the customary way. Everyone on the farm stopped work, and very soon we were all assem bled in the kitchen for prayers of thanksgiving. Two, or it may have been three, days after Petra was born I happened upon a piece of my family39。s history that I would prefer not to have known. I was sitting quietly in the room next to my parents39。 bedroom where my mother still lay in bed. It was a matter of chance, and strategy, too. It was the latest place that I had found to stay hidden awhile after the midday meal until the coast was clear and I could slip away without being given an afternoon job。 so far, nobody had thought of looking there for me. It was simply a matter of putting in half an hour or so. Normally the room was very convenient, though just at present its use required caution because the wattle wall between the rooms was cracked and I had to move very cautiously on tiptoe lest my mother should hear me. On that particular day I was just thinking that I had allowed nearly enough time for people to be busy again when a twowheeled trap drove up. As it passed the w indow I had a glimpse of my Aunt Harriet holding the reins. I had only seen her some eight or nine times, for she lived fifteen miles away in the Kentak direction, but what I knew of her I liked. She was some three years younger than my mother. Superficially they were not dissimilar, and yet, in Aunt Harriet each feature had been a little softened, so that the effect of them all together was different. I used to feel when I looked a t her that I was seeing my mother as she might have been — as, I thought, I would have liked her to be. She was easier to talk to, too。 she did not have a somewhat damping manner of listening only to correct. I edged over carefully on stoc kinged feet to the window , watched her tether the horse, pic k a white bundle out of the trap, and carry it into the house. S he cannot have met anyone, for a few seconds later her steps passed the door, and the latch of the next room clicked. 39。Why, Harriet!39。 my mother39。s voice