【導(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ì)課題

　　

【正文】 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] 楊浩 . .清華大學(xué)出版社 , [4] 尚俊杰 . 計(jì) .清華大學(xué)出版社 , [5] 李偉紅 .SQL Server2020 數(shù)據(jù)庫(kù)及應(yīng)用 .中國(guó)水利水電出版社 , [6] 龍懷冰 .SQL Server 2020 實(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 2020 實(shí)用教程 .中國(guó)水利水電出版社 , [11] 劉小偉 . SQL Server 網(wǎng)站開(kāi)發(fā)實(shí)用教程 .電子工業(yè)出版社 , [12] 戴志誠(chéng) .SQL Server 2020 數(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 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