【導(dǎo)讀】在不斷信息化的今天,網(wǎng)絡(luò)的出現(xiàn)讓人們能夠更快地獲取更多的信息。領(lǐng)域都引進(jìn)了計(jì)算機(jī)網(wǎng)絡(luò)來(lái)為他們提高辦事效率。在學(xué)校的教學(xué)管理中，利用計(jì)。算機(jī)網(wǎng)絡(luò)實(shí)現(xiàn)學(xué)生成績(jī)信息的管理、統(tǒng)計(jì)和分析勢(shì)在必行。息化服務(wù)體系的重要組成部分。本系統(tǒng)采用B/S模式開發(fā)，以ASP作為主要的開。用柱狀圖直觀地展現(xiàn)了統(tǒng)計(jì)分析的結(jié)果。

　　

【正文】 n=center WIDTH=200 bgcolor=39。ff993339。 strReturn = strReturn amp。 TRTD align=centerfont color=red size=2 amp。 CStr(Message) strReturn = strReturn amp。 /fontbrfont size=2 strReturn = strReturn amp。 本頁(yè) 3 秒刷新后 ,自動(dòng)返回 /font strReturn = strReturn amp。 /TD/TR/TABLE strReturn = strReturn amp。 /body/html strReturn End Sub End Class 結(jié) 論 本系統(tǒng)是一個(gè)面向 各類型學(xué)校 的 考試成績(jī)分析 系統(tǒng) ， 采用當(dāng)前 主流的頁(yè)面開發(fā)工具 ASP 來(lái)完成整個(gè)系統(tǒng)的設(shè)計(jì)，在數(shù)據(jù)庫(kù)的設(shè)計(jì)上 使用 了功能強(qiáng)大的 SQL Server 2021 進(jìn)行構(gòu)建 。本系統(tǒng)完成 了 對(duì) 學(xué)生考試成績(jī)的 一系列管理 、統(tǒng)計(jì)與分析 ，包括 學(xué)生信息、課程信息成績(jī)數(shù)據(jù)的添加、刪除和修改。 錄入相關(guān)數(shù)據(jù)后，可單獨(dú) 查詢學(xué)生 個(gè)人 成績(jī) ，可對(duì) 學(xué)生考試成績(jī) 分年級(jí)或班級(jí) 進(jìn)行 單科成績(jī)、學(xué)期第 27 頁(yè) 共 29 頁(yè) 各科成績(jī)匯總，實(shí)現(xiàn)了統(tǒng)計(jì)單科及格人數(shù)、優(yōu)秀人數(shù)， 分析各科的及格率、優(yōu)秀率、各分?jǐn)?shù)段人數(shù)， 并進(jìn)行單科排名； 計(jì)算 學(xué)期各科成績(jī) 總分 、 總分平均分、 總分名次，單科成績(jī)分析 各分?jǐn)?shù)段人數(shù) 的結(jié)果支持柱狀圖顯示。本系統(tǒng)無(wú)需登錄就可通過(guò)學(xué)號(hào)對(duì)學(xué)生個(gè)人成績(jī)進(jìn)行查詢。教師和管理員用戶登錄后均可對(duì) 查詢分析模塊進(jìn)行訪問(wèn)，但是只有管理員用戶才有數(shù)據(jù)管理模塊的訪問(wèn)權(quán)限，能對(duì)系統(tǒng)數(shù)據(jù)進(jìn)行添加、修改、刪除操作。 系統(tǒng)在設(shè)計(jì)過(guò)程中不可避免地遇到了各種各樣的問(wèn)題，由于整個(gè)系統(tǒng)完全都是由個(gè)人設(shè)計(jì)的，有關(guān) ASP 和 SQL 的 許多細(xì)節(jié)問(wèn)題都要靠自己去摸索，加之本人水平有限，并沒(méi)有完全地理解 ASP 和 SQL 的強(qiáng)大功能， 因而 還存在著許多不足之處。如：在一些數(shù)據(jù)輸入時(shí)沒(méi)有及時(shí)的進(jìn)行數(shù)據(jù)格式校驗(yàn)，不能保證數(shù)據(jù)輸入的絕對(duì)正確性 ； 沒(méi)有實(shí)現(xiàn)多條記錄的連鎖刪除和添加以及數(shù)據(jù)的導(dǎo)入功能 ； 這些都是需要完善的地方，該系統(tǒng)離實(shí)際使用也還有 一定 的距離 ，需要我進(jìn)行不斷地補(bǔ)充和完善。 通過(guò)本次畢業(yè)設(shè)計(jì)我學(xué)到了不少新的東西，也發(fā)現(xiàn)了大量的問(wèn)題，有些在設(shè)計(jì)過(guò)程中已經(jīng)解決，有些還有待今后慢慢學(xué)習(xí)。只要學(xué)習(xí)就會(huì)有更多的問(wèn)題，有更多的難點(diǎn)，但也會(huì)有更多的收獲。 參考文獻(xiàn) [1]. 方睿 , 刁仁宏 .網(wǎng)絡(luò)數(shù)據(jù)庫(kù)原理及應(yīng)用 [M].成都：四川大學(xué)出版社 .2021 [2]. 鄧文淵 ,陳惠貞 ,陳梭榮 .ASP與網(wǎng)絡(luò)數(shù)據(jù)庫(kù)技術(shù) [M].北京：中國(guó)鐵道出版社 .2021 [3]. 陳明 .實(shí)用軟件工程基礎(chǔ) [M].北京：清華大學(xué)出版社 .2021 [4]. 劉瑞新 .ASP編程基礎(chǔ)及應(yīng)用教程 [M].北京：機(jī)械工業(yè)出版社 .2021 [5]. 鄭阿奇 .SQL Server實(shí)用教程 [M].北京：電子工業(yè)出版社 .2021 [6]. 黃雷 .ASP+SQL Server項(xiàng)目開發(fā)實(shí)踐 [M]. 北京：中國(guó)鐵道出版社 .2021 [7]. 劉洪海 .網(wǎng)絡(luò)數(shù)據(jù)庫(kù)開發(fā)實(shí)戰(zhàn) ASP與電子商務(wù) [M].北京：中國(guó)鐵道出版社 .2021 [8]. 張樹亮 .ASP+SQL Server網(wǎng)絡(luò)應(yīng)用系統(tǒng)開發(fā)案例精解 [M].北京：清華大學(xué)出版社 . 2021 [9]. 李曉黎 ,張巍 .ASP+SQL Server 網(wǎng)絡(luò)應(yīng)用系統(tǒng)開發(fā)與實(shí)例 [M].北京：人民郵電出版社 . 2021第 28 頁(yè) 共 29 頁(yè) 致 謝 本文是在昌燕老師的熱情關(guān)心和指導(dǎo)下完成的，他淵博的知識(shí)和嚴(yán)謹(jǐn)?shù)闹螌W(xué)作風(fēng)使我受益匪淺，對(duì)順利完成本課題起到了極大的作用。在此向他表示我最衷心的感謝！ 在論文完成過(guò)程中，本人還得到了其他一些老師和同學(xué)的熱心幫助，本人向他們表示深深的謝意！ 最后向在百忙之中評(píng)審本文的各位專家、老師表示衷心的感謝！ 作者簡(jiǎn)介： 姓 名：岳國(guó)平 性別： 男 出生年月： 民族： 漢 Email: 第 29 頁(yè) 共 29 頁(yè) 聲 明 本論文的工作是 2021 年 2 月至 2021 年 6 月在成都信息工程學(xué)院 系完成的。文中除了特別加以標(biāo)注地方外，不包含他人已經(jīng)發(fā)表或撰寫過(guò)的研究成果，也不包含為獲得成都信息工程學(xué)院或其他教學(xué)機(jī)構(gòu)的學(xué)位或證書而使用過(guò)的材料。除非另有說(shuō)明，本文的工作是原始性工作。 關(guān)于學(xué)位論文使用權(quán)和研究成果知識(shí)產(chǎn)權(quán)的說(shuō)明： 本人完全了解成都信息工程學(xué)院有關(guān)保管使用學(xué)位論文的規(guī)定，其中包括： （ 1）學(xué)校有權(quán)保管并向有關(guān)部門遞交學(xué)位論文的原件與復(fù)印件。 （ 2）學(xué)?？梢圆捎糜坝?、縮印或其他復(fù)制方式保存學(xué)位論文。 （ 3）學(xué)?？梢詫W(xué)術(shù)交流為目的復(fù)制、贈(zèng)送和交換學(xué)位論文。 （ 4）學(xué)校可允許學(xué)位論文被查閱或借閱。 （ 5）學(xué)?？梢怨紝W(xué)位論文的全部或部分內(nèi)容（保密學(xué)位論文在解密后遵守此規(guī)定）。 除非另有科研合同和其他法律文書的制約，本論文的科研成果屬于成都信息工程學(xué)院。 特此聲明！ 作者簽名： 第 30 頁(yè) 共 29 頁(yè) This boothwn outside, each car became a single anism which ate and drank and excreted through its ventilators. It talked or sometimes yelled through its ventilators, too. In went water and loaves of blackbread and sausage and cheese, and out came shit and piss and language. Human beings in there were excreting into steel helmets, which were passed to the people at the ventilators, who dumped them. Billy was a dumper. The human beings also passed canteens, which guards would fill with water. When food came in, the human beings were quiet and trusting and beautiful. They shared. Human beings in there took turns standing or lying down. The legs of those who stood were like fence posts driven into a warm ., squirming, fatting, sighing earth. The queer earth was a mosaic of sleepers who nestled like spoons. Now the train began to creep eastward. Somewhere in there was Christmas. Billy Pilgrim nestled like a spoon with the hobo on Christmas night, and he fell asleep, and he traveled in time to 1967 againto the night he was kidnapped by a flying saucer from Tralfamadore. Four Billy Pilgrim could not sleep on his daughters wedding night. He was forty four. The wedding had taken place that afternoon in a gaily striped tent in Billy39。s backyard. The stripes were orange and black. Billy and his wife, Valencia, nestled like spoons in their big double bed. They were jiggled by Magic Fingers. Valencia didn39。 t need to be jiggled to sleep. Valencia was snoring like a bandsaw. T he poor woman didn39。t have ovaries or a uterus any more. They had been removed by a surgeonby one of Billy39。s partners in the New Holiday Inn. There was a full moon. Billy got out of bed in the moonlight. He felt spooky and luminous felt as though he were wrapped in cool fur that was full of static electricity. He looked down at his bare feet. They were ivory and blue. Billy now shuffled down his upstairs hallway, knowing he was about to be kidnapped by a flying saucer. The hallway was zebra striped with darkness and moonlight. The moonlight came into the hallway through doorways of the empty rooms of Billy39。s two children, children no more. They were gone forever. Billy was guided by dread and the lack of dread. Dread told him when to stop. Lack of it told him when to move again. He stopped. He went into his daughter39。s room. Her drawers were dumped. her closet was empty. Heaped in the middle of the room were all the possessions she could not take on a honeymoon. She had a Princess telephone extension all her ownon her windowsill Its tiny night light stared at Billy. And then it rang. Billy answered. There was a drunk on the other end. Bi 39。Who killed me? he would ask. And everybody knew the answer., which was this: Billy Pilgrim.39。 Listen on the tenth night the peg was pulled out of the hasp on Billy39。s boxcar door, and the door was opened. Billy Pilgrim was lying at an angle on the cornerbrace, selfcrucified, holding himself there with a blue and ivory claw hooked over the sill of the ventilator. Billy coughed when the door was opened, and when he coughed he shit thin gruel. This was in accordance with the Third Law of Motion according to Sir Isaac Newton. This law tells us that for every action there is a reaction which is equal and oppos