【正文】 I 學(xué)校宿舍管理系統(tǒng)的設(shè)計與實現(xiàn) 摘 要 隨著我國高校招生規(guī)模的不斷擴大，學(xué)校宿舍管理人員的工作量也越來越大，然而效率卻在逐漸下降。 本 文通過調(diào)查了解到一些學(xué)校宿舍的實際情況 ，對學(xué)校 的 宿舍管理進行了探索和研究， 從而設(shè)計 了一套 界面簡單操作方便 的學(xué)校宿舍管理系統(tǒng)，從而 用來提高 管理工作的質(zhì)量和效率。本系統(tǒng)前臺在 Microsoft Visual Studio 2021 開發(fā)環(huán)境下使用 C編程 以及后臺采用 Microsoft SQL Server2021 數(shù)據(jù)庫管理工具實現(xiàn)了學(xué)校宿舍管理系統(tǒng)。本文所設(shè)計的系統(tǒng)包括 系統(tǒng)管理 、宿舍信息 管理 、學(xué)生入住 管理 、 衛(wèi)生檢查 管理 、水電收費 管理 、房屋報修 管理 、外來人員登記 管理 。每個 小 模塊 在 包含著查詢、添加、修改等功能 的基礎(chǔ)上 ， 還都有各自新穎的設(shè)計，便于宿舍管理人員的管理 。 本文設(shè)計的學(xué)校宿舍管理系統(tǒng) ，可以大大的簡化宿舍管理工作的流程， 能夠減輕宿舍 管理人員 的 工作負(fù)擔(dān)， 還 能夠充分體現(xiàn)出“管理育人、服務(wù)育人”的管理理念。 關(guān)鍵 詞 ： 學(xué)校 宿舍管理系統(tǒng) 。 SQL 2021。 宿舍信息管理 II The Design and Implementation of The School Dormitory Management System Abstract With the enlargement of enrollment scale in colleges and universities, the school dormitory management personnel’s workload is being more and more big, the efficiency, however, has gradually declined. This paper surveys understand some of the actual situation in the school dormitory, the school dormitory management are explored and research, thus designed a simple interface and convenient operation school dormitory management system, which is used to improve the management of quality and efficiency. The system front in Microsoft Visual Studio 2021 development environment using C programming and background using Microsoft SQL Server2021 database management tools to achieve the school dormitory management system. The design of this system, including system management, dormitory basic information management, student occupancy management, health inspection management, water management fees, housing repair management, registration and management of foreign workers. Each module contains a small query, add, modify functions, based on the novel also has its own design, easy dormitory management personnel management. The design school dormitory management system that can greatly simplify the dormitory management processes, can reduce the burden of management staff quarters, but also fully embodies the “management education, service education” management philosophy. Key words： Dormitory Management System。 SQL 2021。 Dormitory Information Management i 目 錄 第一章 緒論 ....................................................................................................................... 1 課題研究的背景 ........................................................................................................... 1 國內(nèi)外發(fā)展現(xiàn)狀與問題 ............................................................................................... 1 本文的主要工作和組織結(jié)構(gòu) ....................................................................................... 1 第二章 系統(tǒng)開發(fā)工具簡介 ............................................................................................... 3 C簡介 ........................................................................................................................... 3 C的安裝與啟動 ........................................................................................................... 3 數(shù)據(jù)庫概述 ................................................................................................................... 3 第三章 學(xué)校宿舍管理系統(tǒng)的需求分析 ........................................................................... 5 系統(tǒng)需求分析 ............................................................................................................... 5 可行性研究 ................................................................................................................... 5 系統(tǒng)功能需求分析 ....................................................................................................... 6 系統(tǒng)功能需求結(jié)構(gòu)圖 ................................................................................................... 6 系統(tǒng)數(shù)據(jù)流程圖 ........................................................................................................... 7 頂層數(shù)據(jù)流程圖 ........................................................................................................ 7 一層數(shù)據(jù)流程圖 ........................................................................................................ 8 系統(tǒng)業(yè)務(wù)流程圖 ........................................................................................................... 9 第四章 系統(tǒng)總體設(shè)計 ..................................................................................................... 10 系統(tǒng)功能設(shè)計目標(biāo) ..................................................................................................... 10 系統(tǒng)功能模塊設(shè)計 ..................................................................................................... 10 數(shù)據(jù)庫設(shè)計 ................................................................................................................. 11 數(shù)據(jù)庫表設(shè)計 .................................................