【導(dǎo)讀】本論文首先使用了VisualBasic作為開發(fā)工具和Access作為后臺數(shù)據(jù)庫，然后再介紹了開發(fā)背景，最后通過截圖和表格來說明該系統(tǒng)的開發(fā)與操作。同時對系統(tǒng)的開發(fā)原理、系統(tǒng)的功能特點和設(shè)計方案進行了介紹。在對運動會管理體。系進行充分分析和系統(tǒng)論證的基礎(chǔ)上開發(fā)。它不但能完成運動會管理中的基本操作，而且具。有程序設(shè)計合理、操作簡單、運行可靠、保密性強等特點。

　　

【正文】 lexGrid1 39。詳細查詢的信息顯示 .Rows = 2 .CellAlignment = 4 .TextMatrix(0, 0) = 姓名 .TextMatrix(0, 1) = 項目名稱 .TextMatrix(0, 2) = 成績 Do While Not .Rows = .Rows + 1 .CellAlignment = 4 .TextMatrix(.Rows 2, 0) = (0) .TextMatrix(.Rows 2, 1) = Trim((1)) .TextMatrix(.Rows 2, 2) = (2) Loop 39。.Rows = .Rows 1 End With End If End if 上述代碼只是實現(xiàn)選擇的項目是田賽項目的成績輸出，選擇的 項目是徑賽項目和全能項目這里就不列出來了。實現(xiàn)項目成績查詢首先選擇項目名稱再查詢，先判斷選擇的項目是哪一種類型的項目，如果是全能項目或田賽項目則第一行是姓名、項目名稱和成績，如果是徑賽項目第一行就是姓名、項目名稱、初賽成績、預(yù)賽成績和決賽成績，從第二行開始就是該項目所有運動員的成績信息。 系統(tǒng)工具 系統(tǒng)工具是為本系統(tǒng)服務(wù)的工具，方便本系統(tǒng)的使用。如數(shù)據(jù)庫備份與恢復(fù)就是為了防止系統(tǒng)的數(shù)據(jù)庫出現(xiàn)錯誤，可以通過還原數(shù)據(jù)庫來修正這個錯誤。而數(shù)據(jù)表的瀏覽是讓人清楚數(shù)據(jù)庫中有哪些表及表的屬性，讓人更清楚明白數(shù)據(jù) 庫表的結(jié)構(gòu)。這里就以數(shù)據(jù)庫備份與還原為例，界面如圖 56所示 圖 56備份與還原界面 圖 57 備份完成界面 只要單擊下圖 (6)中備份或恢復(fù)即可完成備份或恢復(fù)操作。圖 (7)就是完成了數(shù)據(jù)庫備份成功后的界面。備份數(shù)據(jù)庫就是把系統(tǒng)中的數(shù)據(jù)庫壓縮拷貝到另外的路徑文件下面。 Dim FileName As String Dim FileBack As String Dim Info As String FileName = mypath amp。 FileBack = mypath amp。 backup/ Info = 正在備份數(shù)據(jù)庫 amp。 FileName BackupDatabase FileName, FileBack, Info MsgBox 備份數(shù)據(jù)庫成功！ , vbInformation, 提示 結(jié)束語 本系統(tǒng)在 Windows XP環(huán)境下設(shè)計調(diào)試成功，經(jīng)過調(diào)試證明： 1． 只要錄入的報名和比賽成績數(shù)據(jù)準確， 本 軟件就能保證處理結(jié)果準確。不需要 反復(fù)核對，重復(fù)勞動。 2． 軟件處理的速度快，保證實時的數(shù)據(jù)處理，滿足隨時的信息查詢要求。 3．由于水平和時間有限，本系統(tǒng)還有不足之處，比如在徑賽中如有一組運動員成績特別好也只能取其中幾人不能按絕對成績錄取等。 參考文獻 [1] 鄭海春，謝維成 . Visual Basic編程及實例分析教程 .清華大學(xué)出版社 .2020 [2] 王新民 . Visual Basic程序設(shè)計與數(shù)據(jù)庫應(yīng)用 .電子工業(yè)出版社 .2020 [3]吳永琢 .看實例學(xué)編程 — Visual Basic程序設(shè)計 .西安電子 科技大學(xué)出版社 .2020 [4] 薩師煊 . 數(shù)據(jù)庫系統(tǒng)概論 .高等教育出版社 .2020 [5] 張平 . 數(shù)據(jù)庫應(yīng)用基礎(chǔ) .2020 [6] 趙國玲，咎玲 .ACCESS數(shù)據(jù)庫應(yīng)用 .機械工業(yè)出版社 .2020 [7] 叢明禮 . 田徑競賽規(guī)則 .人民體育出版社 .2020 [8] 李老民 . 田徑競賽 裁判工作手冊 .北京體育大學(xué)出版社 .2020 致 謝 經(jīng)過一個多月的調(diào)研、設(shè)計和開發(fā)，這套 學(xué)校田徑運動會管理系統(tǒng) 已基本結(jié)束。在本次畢業(yè)設(shè)計中，我從指導(dǎo)老師陳木生 老師身上學(xué)到了很多東西，陳老師認真負責的工作態(tài)度、嚴謹治學(xué)的精神和深厚的理論水平都使我受益匪淺 ； 同時我還要感謝同學(xué)對我的幫助，指出我的錯誤及不妥之處，進一步完善我的畢業(yè)設(shè)計。 無論在理論上還是在實踐中，他 們 都給予我很大的幫助，使我 的 應(yīng)用水平得到了很大的提高，這對于我以后的工作和學(xué)習(xí)都有一種巨大的幫助。今后的工作中，我將充分運用自己所學(xué)的計算機知識，并在工作中不斷學(xué)習(xí)和完善，充分發(fā)揮一名計算機專業(yè)人員的作用，為企業(yè)的騰飛和發(fā)展貢獻自己的力量。 “ Easy, now,” said Ted Tonks, placing a hand on Harry?s shoulder and pushing him back against the cushions. “That was a nasty crash you just had. What happened, anyway? Something go wrong with the bike? Arthur Weasley overstretch himself again, him and his Muggle contraptions?” “ No,” said Harry, as his scar pulsed like an open wound. “Death Eaters, loads of them – we were chased – ” “ Death Eaters?” said Ted sharply. “What d?you mean, Death Eaters? I thought they didn?t know you were being moved tonight, I thought – ” “ They knew,” said Harry. Ted Tonks looked up at the ceiling as though he could see through it to the sky above. “ Well, we know our protective charms hold, then, don?t we? They shouldn?t be able to get within a hundred yards of the place in any direction.” Now Harry understood why Voldemort had vanished。 it had been at the point when the motorbike crossed the barrier of the Order?s charms. He only hoped they would continue to wor k: He imagined Voldemort, a hundred yards above them as they spoke, looking for a way to perate what Harry visualized as a great transparent bubble. He swung his legs off the sofa。 he needed to see Hagrid with his own eyes before he would believe that he was alive. He had barely stood up, however, when a door opened and Hagrid squeezed through it, his face covered in mud and blood, limping a little but miraculously alive. “ Harry!” Knocking over tw o delicate tables and an aspidistra, he covered the floor between them in two strides and pulled Harry into a hug that nearly cracked his newly repaired ribs. “Blimey, Harry, how did yeh get out o? that? I thought we were both goners.” “ Yeah, me too. I can?t believe – ” Harry broke off. He had just noticed the woman who had entered the room behind Hagrid. “ You!” he shouted, and he thrust his hand into his pocket, but it was empty. “ Your wand?s here, son,” said Ted, tapping it on Harry?s arm. “It fell right beside you, I picked it up…And that?s my wife you ?re shouting at.” “ Oh, I?m – I?m sorry.” As she moved forward into the room, Mrs. Tonks?s resemblance to her sister Bellatrix became much less pronounced: Her hair was a light soft brown and her eyes were wider and kinder. Nevertheless, she looked a little haughty after Harry?s exclamation. “ What happened to our daughter?” she asked. “Hagrid said you were ambushed。 where is Nymphadora?” “ I don?t know,” said Harry. “We don?t know what happened to anyone else.” She and Ted exchanged looks. A mixture of fear and guilt gripped Harry at the sight of their expressions, if any of the others had died, it was his fault, all his fault. He had consented to the plan, given them his hair… “ The Portkey,” he said, remembering all of a sudden. “We?ve got to get back to the Burrow and find out – then we?ll be able to send you word, or – or Tonks will, once she?s – ” “ Dora?ll be ok, ?Dromeda,” said Ted. “She knows her stuff, she?s been in plenty of tight spots with the Aurors. The Portkey?s through here,” he added to Harry. “It?s supposed to leave in three minutes, if you want to take it.” “ Yeah, we do,” said Harry. He seized his rucksack, swung it onto his shoulders. “I – ” He looked at Mrs. Tonks, wanting to apologize for the state of fear in which he left her and for which he felt so terribly re sponsible, but no words occurred to him that he did not seem hollow and insincere. “ I?ll tell Tonks – Dora – to send word, when she… Thanks for patching us up, thanks for everything, I – ” He was glad to leave the room and follow Ted Tonks along a short hallway and into a bedroom. Hagrid came after them, bending low to avoid hitting his head on the door lintel. “ There you go, son. That?s the Portkey.”