【正文】 I 機房管理系統(tǒng) 摘 要 隨著計算機技術(shù)的高速發(fā)展，管理信息系統(tǒng)的開發(fā)和應(yīng)用仍然是計算機技術(shù)最廣泛的應(yīng)用領(lǐng)域之一。為此各學(xué)校，培訓(xùn)中心等單位建立起了機房供學(xué)生上機，機房的規(guī)范化管理也隨之提上了日程。本文主要介紹了我們的畢業(yè)設(shè)計課題 ——機房上機管理系統(tǒng)的各項功能及其實現(xiàn)過程。本論文以我校機房學(xué)生上機管理系統(tǒng)為背景，論述了該管理信息系統(tǒng)的結(jié)構(gòu)，系統(tǒng)開發(fā)的基本原理，過程和方法。 全文詳細闡述了系統(tǒng)的需求分析、系統(tǒng)分析、系統(tǒng)設(shè)計、程序界面的建立及程序代碼的編寫、總結(jié)與展望、致謝、參考文獻等五章內(nèi)容。在系統(tǒng)分析 中，就可以通過具體的分析工具對所要完成的功能進行分析。在系統(tǒng)分析的過程中，運用了 ER 圖和業(yè)務(wù)流圖對系統(tǒng)的功能進行了分析，相應(yīng)繪制出數(shù)據(jù)字典并進行數(shù)據(jù)庫的建立；系統(tǒng)的用戶界面十分簡潔、實用，它主要實現(xiàn)管理員如何對普通用戶進行授權(quán)，學(xué)生業(yè)余上機只能通過輸入會員卡號、密碼方可使用該計算機。系統(tǒng)由管理員一手操縱，它可對各計算機信息和用戶信息進行查詢、修改、刪除、錄入等操作。在辦理新的會員信息及查看、修改、刪除所有會員的信息，可通過輸入查詢條件，顯示符合條件的會員記錄以及顯示這個會員的全部信息，并由管理員對其進行相 應(yīng)的操作，其它功能操作與此相同。結(jié)合本系統(tǒng)詳細闡述了系統(tǒng)分析，系統(tǒng)設(shè)計的技術(shù)及應(yīng)用，尤其在機房管理人員和交流方面采用了 以 Visual 和 SQL Server2020 作為后臺數(shù)據(jù)庫以及 c/s結(jié)構(gòu)進行解決。 通過開發(fā)這個機房管理系統(tǒng)，進一步明確了開發(fā)研究一個管理信息系統(tǒng)的方法和思想，加深了對管理信息系統(tǒng)的認識，鞏固了以前所學(xué)的信息系統(tǒng)開發(fā)方面的知識，提高了軟件開發(fā)的水平，為今后在工作崗位上學(xué)好用好計算機打下了堅定的基礎(chǔ)。 關(guān)鍵字 :管理系統(tǒng)、 Visual Basic .、 SQL Server2020 II Abstract With the highspeed development of the puter technology, development and application of the management information system remain one of the most extensive applications of puter technology. Units such as every school for this reason, the training center,etc. set up the puter lab for students to operate the puter, the standardized management of the puter lab is thereupon brought into schedule too. This text has mainly introduced our graduation project subject Every function of the administrative system that the puter lab operates the puter and realizing the course. Thesis this operate the puter with student, puter lab of our school, administrative system as background, describe structure of the management information system this, basic principle that system develop, course and method. Systematic demand analysis that the full text has been explained in detail, contents of chapter five such as work analysis, systematic design, settingup and writing, summary, prospect, thanking, references of procedure code of procedure interface. In work analysis, can analyze functions finished through the concrete analysis tool. In the course of work analysis, have used ER picture and business to flow and pursue to analyze the function of the system, draw out the data dictionary and carry on the settingup of the database correspondingly。 Systematic user39。s interface is very succinct, practical, it mainly realizes how the administrator authorizes ordinary users, student it is can only through input membership card No., password can use this puter for spare time not to operate the puter. The system is handled all alone by the administrator, it can inquire, revise, delete, input etc. and operate to every puter information and user39。s information. Handling new member39。s information and information of looking over, revising, deleting all members, can through input condition of inquiring, reveal eligible member record and reveal the all message of member, and the administrator carries on corresponding operation to it, it is the same as this that other functions are operated. Combining this system has explained work analysis in detail, technology and application that the system is designed, have especially adopted and regarded Visual as and developed language and SQL Server2020 to form as backstage supporter39。s database and c/s in view of administrative staff of puter lab and exchanging Construct and solve. Through developing this puter lab administrative system, further developing III the method for studying a piece of the management information system clearly and thought, have strengthened the understanding of the management information system, develop knowledge after consolidating the information system studied in the past, heighten the level of software development, go to school handy kind puter lay firm foundation in work position in the future. Key words： Administrative system , Visual Basic . ,Sql Server2020 目 錄 摘 要 .................................................................................................................. I Abstract.................................................................................................................... II 第 1 章 緒 論 ................................................................................................... 6 軟件開發(fā)背景 ........................................................................................... 6 功 能 概 述 ............................................................................................. 7 系 統(tǒng) 特 點 ............................................................................................. 8 編 寫 目 的 ............................................................................................. 8 意 義 ......................................................................................................... 8 第 2 章 相關(guān)技術(shù)介紹 ......................................................................................... 10 Visual Basic 概述 ..................................................................................... 10 Visual Basic 特點 .................................................................................... 10 SQL Server 2020 數(shù)據(jù)庫 ......................................................................... 10 高級數(shù)據(jù)訪問對象 ADO 介紹 ................................................................ 11 OLEDB 和通用數(shù)據(jù)訪問 .............................................................. 12 OLEDB 體系結(jié)構(gòu)概述 .................................................................. 13 ActiveX 數(shù)據(jù)對象 (AD0) ............................................................... 15 ADO 體系結(jié)構(gòu) ............................................................................... 17 在 Visual Basic 中添加 ADO 對象的引用 ............................................ 20 第 3 章 可行性分析 ............................................................................................. 21 可行性研究 ............................................................................................ 21