學(xué)籍管理系統(tǒng)的設(shè)計與實現(xiàn)—計算機(jī)畢業(yè)設(shè)計論文(已修改)

　

【正文】 學(xué)籍管理系統(tǒng)摘 要學(xué)籍管理系統(tǒng)是典型的信息管理系統(tǒng)(MIS),其開發(fā)主要包括后臺數(shù)據(jù)庫的建立和維護(hù)以及前端應(yīng)用程序的開發(fā)兩個方面。對于前者要求建立起數(shù)據(jù)一致性和完整性強(qiáng)、數(shù)據(jù)安全性好的庫。而對于后者則要求應(yīng)用程序功能完備,方便使用等特點。本系統(tǒng)主要完成對學(xué)生情況和學(xué)生成績的管理，包括數(shù)據(jù)庫中表的添加、修改、刪除等。系統(tǒng)還可以完成對各類信息的瀏覽、查詢、添加、刪除、修改、報表等功能。系統(tǒng)的核心是數(shù)據(jù)庫中各個表的聯(lián)系，每一個表的修改都將連動的影響其它的表，當(dāng)完成對數(shù)據(jù)的操作時系統(tǒng)會自動地完成數(shù)據(jù)庫的修改。查詢功能也是系統(tǒng)的核心之一，在系統(tǒng)中即有單條件查詢和多條件查詢，也有精確查詢和模糊查詢，系統(tǒng)不僅有靜態(tài)的條件查詢，也有動態(tài)生成的條件查詢，其目的都是為了方便用戶使用。系統(tǒng)有完整的用戶添加、修改、刪除和密碼修改功能，并具備報表打印功能。 經(jīng)過分析,我們使用 Microsoft 公司的 Visual Basic 開發(fā)工具,利用其提供的各種面向?qū)ο蟮拈_發(fā)工具,尤其是數(shù)據(jù)窗口這一能方便而簡潔操縱數(shù)據(jù)庫的智能化對象,首先在短時間內(nèi)建立系統(tǒng)應(yīng)用原型，然后，對初始原型系統(tǒng)進(jìn)行需求迭代,不斷修正和改進(jìn),直到形成用戶滿意的可行系統(tǒng)。關(guān)鍵字：控件、窗體、數(shù)據(jù)庫、MIS、SQL Server 2022。AbstractStudent status management system is development two aspects that typical information management system （MIS）, its development includes primarily the background database creates with support and the front end applies the procedure. Creates to rise to the former request the consistency of data is strong with the integrity, the library that the safeness of data like. But request the latter very much to apply the procedure function plete, easy usage etc. characteristics.This system pletes primarily to student39。s circumstance with the management of student39。s score, include the database the inside the watch increase, modify, delete etc.. The system can also plete to the browsing various information, search, increase, delete, modify, and tablereport etc. function.System of nucleus is other table in an influence for of relation, each a modification of watch moving in a table in database that modification that operation hour system, be to plete the logarithms according to will plete the database of oneself. Search the function is also one of the nucleus of the system, having namely in system the single condition search to search with many conditions, also having the accurate search to search with blur, system not only contain static condition search, also have the dynamic born condition search, its purpose is all for the sake of the convenient consumer to use. System contain plete consumer increase, delete to modify the function with the password, the union has the report prints the function.Through analysis, we use the Microsoft pany Visual Basic development tool, making use of its every kind of the tool of development that provide that face to the object, particularly is intelligence that the window of data this on canning be convenient but manipulate the database in brief to turn the object, create in the in a short time first system application prototype, then, start to the beginning the prototype system proceeds to require with the iteration, revising continuously with improve, until forming the consumer is satisfied can row system.Keywords: Control piece, Form, Database, MIS, , SQL Server 2022.目 錄ABSTRACT ..............................................................................................................................2 系統(tǒng)需求分析 ................................................................................................................7 系統(tǒng)的初步調(diào)查 ............................................................................................................7 開發(fā)學(xué)籍管理系統(tǒng)的目的 ...................................................................................7 業(yè)務(wù)流程分析 ..............................................................................................................8 數(shù)據(jù)流程分析： ........................................................................................................10數(shù)據(jù)流程圖： ...................................................................................................................10 選題背景及意義 .................................................................................................11 開發(fā)工具的選用 ...........................................................................................................11 Visual Basic的使用 ........................................................................................11 SQL Server 2022的使用 ..................................................................................12 系統(tǒng)的可行性研究 ......................................................................................................13 技術(shù)上的可行性 .................................................................................................13 管理上的可行性 .................................................................................................13 安全上的可行性 .................................................................................................13 系統(tǒng)性能分析 ..............................................................................................................13 系統(tǒng)的安全性 .....................................................................................................13 系統(tǒng)的快捷性 .....................................................................................................14 系統(tǒng)的準(zhǔn)確性 .....................................................................................................14 系統(tǒng)的嚴(yán)謹(jǐn)性 .....................................................................................................14第 2 章 概要設(shè)計 .................................................................................................................14 系統(tǒng)設(shè)計思路分析 ......................................................................................................15 界面 .....................................................................................................................15 用戶登錄 .............................................................................................................15 學(xué)籍信息內(nèi)容查詢和錄入 .................................................................................15 數(shù)據(jù)庫分析 .........................................................................................................15 設(shè)計簡述 ......................................................................................................................15 VB設(shè)計的界面簡述 .............