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

　　

【正文】 lexGrid1 39。詳細(xì)查詢的信息顯示 .Rows = 2 .CellAlignment = 4 .TextMatrix(0, 0) = 姓名 .TextMatrix(0, 1) = 項(xiàng)目名稱 .TextMatrix(0, 2) = 成績(jī) 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 上述代碼只是實(shí)現(xiàn)選擇的項(xiàng)目是田賽項(xiàng)目的成績(jī)輸出，選擇的 項(xiàng)目是徑賽項(xiàng)目和全能項(xiàng)目這里就不列出來了。實(shí)現(xiàn)項(xiàng)目成績(jī)查詢首先選擇項(xiàng)目名稱再查詢，先判斷選擇的項(xiàng)目是哪一種類型的項(xiàng)目，如果是全能項(xiàng)目或田賽項(xiàng)目則第一行是姓名、項(xiàng)目名稱和成績(jī)，如果是徑賽項(xiàng)目第一行就是姓名、項(xiàng)目名稱、初賽成績(jī)、預(yù)賽成績(jī)和決賽成績(jī)，從第二行開始就是該項(xiàng)目所有運(yùn)動(dòng)員的成績(jī)信息。 系統(tǒng)工具 系統(tǒng)工具是為本系統(tǒng)服務(wù)的工具，方便本系統(tǒng)的使用。如數(shù)據(jù)庫備份與恢復(fù)就是為了防止系統(tǒng)的數(shù)據(jù)庫出現(xiàn)錯(cuò)誤，可以通過還原數(shù)據(jù)庫來修正這個(gè)錯(cuò)誤。而數(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è)計(jì)調(diào)試成功，經(jīng)過調(diào)試證明： 1． 只要錄入的報(bào)名和比賽成績(jī)數(shù)據(jù)準(zhǔn)確， 本 軟件就能保證處理結(jié)果準(zhǔn)確。不需要 反復(fù)核對(duì)，重復(fù)勞動(dòng)。 2． 軟件處理的速度快，保證實(shí)時(shí)的數(shù)據(jù)處理，滿足隨時(shí)的信息查詢要求。 3．由于水平和時(shí)間有限，本系統(tǒng)還有不足之處，比如在徑賽中如有一組運(yùn)動(dòng)員成績(jī)特別好也只能取其中幾人不能按絕對(duì)成績(jī)錄取等。 參考文獻(xiàn) [1] 鄭海春，謝維成 . Visual Basic編程及實(shí)例分析教程 .清華大學(xué)出版社 .2020 [2] 王新民 . Visual Basic程序設(shè)計(jì)與數(shù)據(jù)庫應(yīng)用 .電子工業(yè)出版社 .2020 [3]吳永琢 .看實(shí)例學(xué)編程 — Visual Basic程序設(shè)計(jì) .西安電子 科技大學(xué)出版社 .2020 [4] 薩師煊 . 數(shù)據(jù)庫系統(tǒng)概論 .高等教育出版社 .2020 [5] 張平 . 數(shù)據(jù)庫應(yīng)用基礎(chǔ) .2020 [6] 趙國玲，咎玲 .ACCESS數(shù)據(jù)庫應(yīng)用 .機(jī)械工業(yè)出版社 .2020 [7] 叢明禮 . 田徑競(jìng)賽規(guī)則 .人民體育出版社 .2020 [8] 李老民 . 田徑競(jìng)賽 裁判工作手冊(cè) .北京體育大學(xué)出版社 .2020 致 謝 經(jīng)過一個(gè)多月的調(diào)研、設(shè)計(jì)和開發(fā)，這套 學(xué)校田徑運(yùn)動(dòng)會(huì)管理系統(tǒng) 已基本結(jié)束。在本次畢業(yè)設(shè)計(jì)中，我從指導(dǎo)老師陳木生 老師身上學(xué)到了很多東西，陳老師認(rèn)真負(fù)責(zé)的工作態(tài)度、嚴(yán)謹(jǐn)治學(xué)的精神和深厚的理論水平都使我受益匪淺 ； 同時(shí)我還要感謝同學(xué)對(duì)我的幫助，指出我的錯(cuò)誤及不妥之處，進(jìn)一步完善我的畢業(yè)設(shè)計(jì)。 無論在理論上還是在實(shí)踐中，他 們 都給予我很大的幫助，使我 的 應(yīng)用水平得到了很大的提高，這對(duì)于我以后的工作和學(xué)習(xí)都有一種巨大的幫助。今后的工作中，我將充分運(yùn)用自己所學(xué)的計(jì)算機(jī)知識(shí)，并在工作中不斷學(xué)習(xí)和完善，充分發(fā)揮一名計(jì)算機(jī)專業(yè)人員的作用，為企業(yè)的騰飛和發(fā)展貢獻(xiàn)自己的力量。 “ 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.”