教务工作信息管理系统VB+SQL

教务工作信息管理系统

摘要：教务工作信息管理系统是典型的管理信息系统（MIS），其系统开发主要包括数据库的规划设计与维护、客户端应用程序的开发两个方面。基于前面的要求建立起的数据库应具有完整性和1致性，且具有1定的数据安全性；而基于后面的要求编写的程序应该具有界面友好、功能完备、容易使用和流行软件的操作习惯等特点。经过详细的调查分析，选用SQL Server 2000和Visual Basic 6.0作为系统开发工具。利用Visual Basic 6.0提供的集成开发环境、面向对象的各种标准化的控件和ADO来完成对数据库的各种操作，最终达到对教务工作信息管理的目的。设计时首先在短时间内先建立系统应用原形，然后对初始原形系统进行需求迭代、修正，直到形成用户满意的实际可行系统。本系统实现的功能主要包括：用户管理(包括用户登录、添加用户、修改密码、删除用户)、基本信息的管理(包括教师、学生、班级、课程、成绩、文件基本信息的添加、修改、删除、查询)、系统日志管理以及打印和帮助；其最大优点是查询方便，提供了多种查询手段，以提高用户查询的效率。
关键词：教务管理；设计；实现；ADO
 
Management Information System of Educational Work

Abstract:The management information system of educational work is a typical management information system (MIS),and its system development mainly includes two aspects,of which one is the database’s planning to design and maintaining,the other is the application procedures development of the client side.The database which is created based on the former request should have not only the integrity and the uniformity,but also a certain data security;but the procedure compiled based on the latter request should contact the following characteristics:friendly surface,complete function,easy using and popular software’s operation custom and so on.After detailed diagnosis,SQL Server 2000 and Visual Basic 6.0 are taked as the system developments tools.Take use of Visual Basic 6.0s integrated development environment,each kind of object-oriented standardization controler and ADO to finish each kind of operation on database,and finally achieve the goal of managing the educational work.First,establish the system’s primary form of application in short time during the design,then carry on the demand iteration and the revising to the primary system until the feasible system with which users are satisfied is formed.This system’s realization functions mainly include:management of users(including users logining,adding users,modifying passwords,deleting users),management of basic information(including adding,modifying,deleting and inquiring the basic information of teachers,students,classes,courses,performances and files),management of the system diary as well as printing and help;its biggest advantage is convenient inqury,because it provides many kinds of inquiry methods so as to enhance users inquiry efficiency.

注释：不含源代码