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

全文20頁(yè) 約9000字 論述翔實(shí)

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

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

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

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

部分參考文獻(xiàn)

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