高校職工管理系統(tǒng)設(shè)計

全文20頁 約9000字 論述翔實

目錄
摘要 ––––––––––––––––––––––––––––––––––––––––––3
ABSTRACT–––––––––––––––––––––––––––––––––––––––4
1前言 –––––––––––––––––––––––––––––––––––––––––5
2數(shù)據(jù)庫介紹–––––––––––––––––––––––––––––––––––––6
3系統(tǒng)需求分析和功能設(shè)計–––––––––––––––––––––––––––6
4系統(tǒng)詳細設(shè)計–––––––––––––––––––––––––––––––––––8
4.1 創(chuàng)建項目文件及項目結(jié)構(gòu)文件夾––––––––––––––––––––––8
4.2 高校職工管理系統(tǒng)數(shù)據(jù)庫及數(shù)據(jù)表的設(shè)計與創(chuàng)建––––––––––––8
4.3 創(chuàng)建應用系統(tǒng)啟動表單––––––––––––––––––––––––––10
4.4 制作系統(tǒng)權(quán)限認證表單––––––––––––––––––––––––––11
4.5 制作系統(tǒng)主表單––––––––––––––––––––––––––––––12
4.6 制作院處名稱編輯表單––––––––––––––––––––––––––13
4.7 制作系科名稱編輯表單––––––––––––––––––––––––––13
4.8 制作職工信息編輯表單––––––––––––––––––––––––––13
4.9 制作職工綜合管理表單––––––––––––––––––––––––––14
4.10 制作用戶權(quán)限維護表單––––––––––––––––––––––––––15
4.11 制作一個About表單–––––––––––––––––––––––––––16
5制作系統(tǒng)主程序––––––––––––––––––––––––––––––––16
6 結(jié)論 –––––––––––––––––––––––––––––––––––––––18
謝辭–––––––––––––––––––––––––––––––––––––––––19
參考文獻 –––––––––––––––––––––––––––––––––––––20
摘 要

通用高校職工管理系統(tǒng)主要是針對一般高校作為使用對象而開發(fā)的。系統(tǒng)開發(fā)的主要任務包括：數(shù)據(jù)庫設(shè)計與維護、應用程序開發(fā)兩個方面。對于前者要求建立起的數(shù)據(jù)庫具有完整性和一致性，且具有一定的數(shù)據(jù)安全性，如用戶需要密碼才能使用等，而對于后者則要求程序界面友好、功能完備等特點。經(jīng)過詳細的分析，選用VFP作為前端開發(fā)工具，利用利用其提供的集成開發(fā)環(huán)境及各種控件，完成對數(shù)據(jù)庫的各種操作，達到對職工信息進行管理的目的。
本文介紹了在Visual FoxPro6.0環(huán)境下開發(fā)一個通用高校職工管理系統(tǒng)的過程，創(chuàng)建了一套行之有效的方案，介紹了管理系統(tǒng)的系統(tǒng)分析部分，包括系統(tǒng)需求分析、系統(tǒng)功能設(shè)計等，以及項目管理器的創(chuàng)建，數(shù)據(jù)庫的設(shè)計，各個數(shù)據(jù)庫表的邏輯結(jié)構(gòu)、物理結(jié)構(gòu)，系統(tǒng)所需要的所有表單的制作，系統(tǒng)主程序的制作和應用系統(tǒng)的連接，可執(zhí)行文件的創(chuàng)建等等，通過一系列的過程，完成了“通用高校職工管理系統(tǒng)”的全部制作過程。
本文是基于Visual FoxPro 對高校職工信息進行管理而設(shè)計的應用系統(tǒng)。本系統(tǒng)能夠從大量的數(shù)據(jù)中非常方便的進行職工數(shù)據(jù)的編輯、增加、刪除、查詢等諸多方面的功能。

關(guān)鍵詞：職工信息，管理系統(tǒng)，高校，數(shù)據(jù)庫設(shè)計，界面設(shè)計

ABSTRACT
The general universities staff administration system mainly is aims at the common universities to develop as the user. The system development primary mission includes: The database design and the maintenance, the application procedure develop two aspects. The database establishes which regarding former request has the integrity and the uniformity, also has the certain data security, like the user needs the password to be able to use and so on,but requests the procedure contact surface regarding latter in a friendly way, the function to be complete and so on the characteristic. After the detailed analysis, selects VFP front end to take the development kit,the use uses the integrated development environment and each kind which it provides controls, completes to database each kind of operation, achieved carries on the management to the staff information the goal.
This article introduced management system analysis part of the management system, including the system demand analysis, the system function design and so on, as well as the project management foundation, the database design, each database table logical organization, the physical structure, the all tables single manufacture which the system needs, the system master routine manufacture and the application system connection, but execution file foundation and so on, through a series of processes, has completed "the general universities staff administration system" the completely manufacture process.
This article is carries on the application system based on Visual FoxPro to the universities staff information which the management designs. This system can extremely convenient carry on the staff data from the massive data the edition, the increase, the deletion, the inquiry and so on many aspects functions.


Key words: Staff information; Management system; Universities; Database design; Contact surface design

部分參考文獻

[14] 李玉波．SQL SERVER完全自學手冊． 機械工業(yè)出版社，2006年12月．
[15] 杭國英．SQL SERVER數(shù)據(jù)庫程序設(shè)計．機械工業(yè)出版社，2006年9月．
[16] 白以恩．計算機網(wǎng)絡基礎(chǔ)及應用． 哈爾濱工業(yè)大學出版社，2000年1月．
[17] Robert shedon．SQL實用教程．清華大學出版社，2004年．
[18] David iseminger．數(shù)據(jù)庫與數(shù)據(jù)倉庫實用操作大全．北京大學出版社，2001年．