【正文】 Dim mrc As Dim msgtext As Stringusername = If Trim( = ) ThenMsgBox 沒有這個用戶，請重新輸入用戶名！, vbOKOnly + vbExclamation, 警告ElseIf Trim((1)) = Trim() Thenok = Trueusername = Trim( = )Else 宿舍管理系統(tǒng)主界面一般用戶登陸后，即進入了主界面，主界面分成四大塊：系統(tǒng)管理，人員管理，日常工作管理和幫助信息。5. 3 查詢信息的主界面查詢模塊的主要功能是：學生入住學校后，對存入數(shù)據(jù)庫的信息按輸入的條件查詢，對學生信息表，可以按學號和姓名進行查詢你所需要的信息，對寢室信息表，可以輸入學號進行查詢，了解此寢室情況，對學生信息表，可以輸入姓名和宿舍號進行查詢宿舍的信息，了解宿舍的入住情況，否則，不可以查到信息，系統(tǒng)會提醒你必須同時輸入學號和姓名才可以查詢，由于查詢模塊有好幾個了，此處只選擇一個作為代表，如下：查詢系統(tǒng)的主要代碼如下： Private Sub Command1_Click() Select Case Case 1 txtsql = select * from jjxx where xm=39。 Set mrc = ExecuteSQL(txtsql, msgtext) Set = mrc mbDataChanged = False = = Case 2 txtsql = select * from jjxx where xh=39。 Set mrc = ExecuteSQL(txtsql, msgtext) Set = mrc mbDataChanged = False = = Case 3 txtsql = select * from jjxx where jjsj=39。 Set mrc = ExecuteSQL(txtsql, msgtext) Set = mrc mbDataChanged = False = = End SelectEnd Sub5. 4 數(shù)據(jù)錄入的主界面對學生的信息錄入到數(shù)據(jù)庫中，可以隨時地對信息進行添加，刪除和修改，并把處理以后的信息保存到數(shù)據(jù)庫中，以方便一般用戶和管理員查詢，對學生信息的查詢，用戶可以選擇按姓名和學號進行查詢。四大模塊中人員管理和日常工作管理這兩大模塊是設計的重點所在，下面重點宿舍管理這部分的主要模塊及功能。日常工作管理這部分主要功能：寢室物品配置輸入對于各個宿舍的物品的配置的輸入，來訪登記記錄每天人員到宿舍的來訪情況，借物信息，以及查詢學生信息、管理人員信息、寢室配置信息、來訪登記、借物信息等功能。并配有（BDE），可通過sql links，ODBC等技術訪問多種數(shù)據(jù)庫，還可以 利用ADO來訪問各種數(shù)據(jù)庫，Visual Basic語言是結構嚴謹、數(shù)據(jù)類型豐富、運行性能優(yōu)越的ActiveX語言。輸 入 用 戶 名開 始輸 入 密 碼登 陸 到 主 界 面系統(tǒng)管理人員管理日常工作管理幫助信息添加用戶修改用戶密碼退出系統(tǒng)管理人員信息學生信息寢室物品配置來訪登記攜物外出登記查詢信息學生信息設置管理信息入住學生信息來訪登記借物信息信息注銷離校管理 系統(tǒng)運行與操作指南運行時，用戶首先得輸入正確的用戶名和密碼，才能登陸到主界面，進入到主界面，用戶可以輸入學生的基本信息，管理人員的基本信息，宿舍的使用情況以及借物來訪登記，進入后，在系統(tǒng)管理中用戶可以用到日常工作管理中的查詢信息功能。四大模塊中人員管理和日常工作管理這兩大模塊是設計的重點所在，下面重點介紹日常工作管理這部分的主要模塊及功能。在查詢功能中找到你想要查詢的信息攔輸入指定查詢信息，就可以查詢到你要的信息，如果想要修改信息，先查詢一下，如果確信需要修改的話，再在數(shù)據(jù)維護中就可以很方便的進行添加、刪除、修改和更新。數(shù)據(jù)庫管理系統(tǒng)采用SQL SERVER 2000，采用Visual Basic開發(fā),系統(tǒng)的應用規(guī)?？梢愿鶕?jù)用戶的需要動態(tài)配置。具體地說，對于信息查詢功能還不能做到隨意多個條件的查詢和任意多個表的復合查詢等等功能，身份驗證模塊比較簡單，可能對保密性要求不是非常的高等等方面都需要改進和完善。結 論我們的畢業(yè)設計快要結束，答辯即將開始開始，我們大學三年的生活也就要劃上結束符號，這最后的符號是問號、逗號或者感嘆號再有幾天也就有結果了。如果在要用的時候你因為知識的不能應用而放棄了自己的計劃，這就是你對學習這門知識的第二次失敗，我想你是很難有第三次的勇氣再去學習這門知識的。雖然不能說“人有多大膽，地有多大產(chǎn)”，但是我相信只要我們能始終如一地朝著我們的目標前進，總有一天我們會實現(xiàn)我們的愿望！通過這段時間的畢業(yè)設計，學到了很多東西，不僅把以前所學的很多知識充分利用上了，還要我學會使用了兩種數(shù)據(jù)庫開發(fā)軟件（Visual Basic和SQL SERVER），初步了解了Visual Basic強大的數(shù)據(jù)庫開發(fā)能力，對Visual Basic開發(fā)語言上有了進一步的了解，我們體會到了軟件開發(fā)不僅是編程，它需要方方面面的考慮，同時也必須具備比較全面的知識。同時我們也認識到本身不存在很多不足的地方，還需要不斷的努力 來充實自己完善自己，只有這樣我們才能學無止境，以求得更大的發(fā)展。另外我還要感謝本小組等同學，在我們遇到技術型難題的時候，是他們給了我們無私的幫助，使我順利渡過難關。 dorms, but you saw everybody in the rec room and the dining hall and so on, and she was in my psychodrama group. Her hair had been black, and shiny as the lacquered furniture in Dr. Hong39。 but when she said this the floating ring of light that gave them the necessary separation from the small doctorandpatient audience, ceased, by i And when I was there it rained. There was a big ,39。t always get dark here, Diane said. Sometimes the rain sparkles. I think Dr. Island must do it to cheer everyone up.No, the waves explained, or at least not in the way you mean, Diane.Nicholas was hungry and started to ask them for something to eat, then turned his hunger in against itself, spat on the sand, and was still. es. I never met any one of his class who remembered him. They did not even remember that he was middleweight boxing champion. I mistrust all frank and simple people, especially when their stories hold together, and I always had a suspicion that perhaps Robert Cohn had never been middleweight boxing champion, and that perhaps a horse had stepped on his face, or that maybe his mother had been frightened or seen something, or that he had, maybe, bumped into something as a young child, but I finally had somebody verify the story from Spider Kelly. Spider Kelly not only remembered Cohn. He had often wondered what had bee of him. Robert Cohn was a member, through his father, of one of the richest Jewish families in New York, and through his mother of one of the oldest. At the military school where he prepped for Princeton, and played a very good end on the football team, no one had made him raceconscious. No one had ever made him feel he was a Jew, and hence any different from anybody else, until he went to Princeton. He was a nice boy, a friendly boy, and very shy, and it made him bitter. He took it out in boxing, and he came out of Princeton with painful selfconsciousness and the flattened nose, and was married by the first girl who was nice to him. He was married five years, had three children, lost most of the fifty thousand dollars his father left him, the balance of the estate having gone to his mother, hardened into a rather unattractive mould under domestic unhappiness with a rich wife。s six of them, and they run midway between the spokes from the hub to the rim, radially. They pass through th frared, which seems to be the best spectrum. Cirocco raised herself on one elbow, careful not to dislodge any of Calvin39。re what 1 originally saw。re at just the right angle, and that39。s transmitting it. It39。ve got all that, Cirocco said, slightly amused. Gaby could he so intense when explaining something. Right. So when you39。t move, and neither can the skylights. So it has to be that way. Permanent day or permanent night. Why do you think they39。d like to know.I am more like Earth than Earth now is, Nicholas. If you were to take the best of all the best beaches of Earth, and clear them of all the poisons and all the dirt of the last three centuries, you would have me.But this isn39。s trail kept to the beach。re bleeding. I thought you were my mother, the girl said. She was a head taller than Nicholas. Been fighting, haven39。s quite a good cook. She really is. Do you like cabbage with bacon? Have you got anything to eat? Not now. I had a thing a while ago What kind of thing? A bird. The girl made a vague little gesture