泰 山 学 院 本科毕业论文
教室信息管理系统
CLASSROOM INFORMATION MANAGEMENT SYSTEM
专 业 名 称 申请学士学位所属学科 指导教师姓名、职称
2012 年 5 月 10日
摘要
摘要
教室信息管理系统是一个教育单位不可缺少的部分。一个功能齐全、简单易用的信息管理系统不但能有效地减轻学校各类工作人员的工作负担，它的内容对于学校的决策者和管理者来说都至关重要。
教室管理系统是典型的信息管理系统,其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面.对于前者要求建立数据一致性和完整性强,数据安全性好的数据库.而对于后者则要求应用程序功能完备,易使用等特点。在学校，教室信息管理包括教室信息，显然如果以人工的方式对其管理将耗费大量的人力、物力，本系统以此作为开发的目标，用以减轻教室管理人员的负担。
系统开发采用Visual Basic 6.0，利用其强大功能及对Access数据库的支持，先构造一个原型，逐步增加功能，最终满足需求。系统中大量采用SQL查询语句，界面友好，功能较强。不足的地方是当数据访问量大时，将致使性能的下降，且不利于数据的有效共享，在以后改进的中应考虑采用SQL SERVER作为数据库，解决访问速度及数据共享的问题。该系统性能力求易于使用，具有较高的扩展性和可维护性。
关键词：VB，ACCESS，教室管理系统，系统开发
I
ABSTRACT
ABSTRACT
Classroom information management systemis an indispensable part of the education unit. A fully functional, easy to use information management system not only can effectively reduce all school personel work burden, its contents for the school administrators and policy makers is crucial.
The classroom management system is a typical information management system, its development mainly includes the backstage database the establishment and the maintenance as well as front end application procedure development two aspects. The request for the establishment of a strong data consistency and integrity, good data security database. For the latter request application procedure function is complete, easy to use and so on characteristics of. In the school, classroom information management includes classroom information, if artificial means of its management to spend a lot of manpower, material resources, the system as a development goal, to reduce the burden of classroom management.
The system development uses the Visual Basic 6, using its powerful function and to the Access database support, to construct a prototype, gradually increasing function, finally meet the demand. System of a large number of SQL query, friendly interface, strong function. The insufficient place is when the data traffic, will cause a decline in performance, and is not conducive to the effective data sharing, in the future improvement should be considered in using SQL SERVER as database, access speed and solve the problem of data sharing. The system is easy to use performance, high scalability and maintainability.
Key words: VB, SQL server, classroom management system, system development
II
目录
目 录
1 引言 -------------------------------------------------------------------------------------------------------------- 1 1.1 开发背景 ------------------------------------------------------------------------------------------------------ 2 1.2开发意义 ------------------------------------------------------------------------------------------------------- 2 2系统分析 --------------------------------------------------------------------------------------------------------- 3 2.1 现有系统分析 ------------------------------------------------------------------------------------------------ 3 2.2可行性分析 ---------------------------------------------------------------------------------------------------- 3 2.3系统功能划分 ------------------------------------------------------------------------------------------------- 4 3开发环境及工具 ------------------------------------------------------------------------------------------------ 6 3.1系统环境 ------------------------------------------------------------------------------------------------------- 6 3.2 Visual Basic 6.0 简介 ---------------------------------------------------------------------------------- 6 3.3 Access 2000 实现关系型数据库 --------------------------------------------------------------------- 10 4系统总体设计 -------------------------------------------------------------------------------------------------- 11 4.1系统总体架构 ----------------------------------------------------------------------------------------------- 11 4.2数据库设计分析 -------------------------------------------------------------------------------------------- 13 5系统主窗体设计 ----------------------------------------------------------------------------------------------- 15 5.1 创建工程项目 ---------------------------------------------------------------------------------------------- 15 5.2创建主窗体菜单 -------------------------------------------------------------------------------------------- 16 6 主要功能模块设计与实现 ---------------------------------------------------------------------------------- 19 6.1 数据库的连接 ---------------------------------------------------------------------------------------------- 19 6.2 管理员模块 ------------------------------------------------------------------------------------------------- 22 6.3 学生模块 ---------------------------------------------------------------------------------------------------- 28 7系统测试 -------------------------------------------------------------------------------------------------------- 30 7.1任务概述 ----------------------------------------------------------------------------------------------------- 30 7.2 测试设计说明 ---------------------------------------------------------------------------------------------- 31 7.3 测试计划 ---------------------------------------------------------------------------------------------------- 31 8 结束语 ---------------------------------------------------------------------------------------------------------- 33 参考文献 ---------------------------------------------------------------------------------------------------------- 33 致 谢 ------------------------------------------------------------------------------------- 错误！未定义书签。
III
INDEX
INDEX
1 Introduction ---------------------------------------------------------------------------------------------------- 1 1.1 Development and background ------------------------------------------------------------------------------- 2 1.2 Development and significance ------------------------------------------------------------------------------ 2 2 Analysis of system --------------------------------------------------------------------------------------------- 3 2.1 The system analysis ------------------------------------------------------------------------------------------- 3 2.2 Feasibility analysis -------------------------------------------------------------------------------------------- 3 2.3 The division of system functions --------------------------------------------------------------------------- 4 3 Development environment and tool------------------------------------------------------------------------ 6 3.1 Thesystem of environment ----------------------------------------------------------------------------------- 6 3.2 Visual Basic 6.0 introduce ----------------------------------------------------------------------------------- 6 3.3 Access2000 relational database --------------------------------------------------------------------------- 10 4 Overall design ------------------------------------------------------------------------------------------------- 11 4.1 System Architecture ----------------------------------------------------------------------------------------- 11 4.2 Database Design --------------------------------------------------------------------------------------------- 13 5 The overall framework of the system--------------------------------------------------------------------- 15 5.1 Create project ------------------------------------------------------------------------------------------------- 15 5.2 Create the main menu --------------------------------------------------------------------------------------- 16 6 Main function module design and Implementation --------------------------------------------------- 19 6.1 Database connection ---------------------------------------------------------------------------------------- 19 6.2 Adminster Module------------------------------------------------------------------------------------------- 22 6.3 Student module----------------------------------------------------------------------------------------------- 28 7 System Test ----------------------------------------------------------------------------------------------------- 30 7.1 Task overview ------------------------------------------------------------------------------------------------ 30 7.2 Test design specification ----------------------------------------------------------------------------------- 31 7.3 Test plan --------------------------------------------------------------------------------------------------------- 3 8 Tag --------------------------------------------------------------------------------------------------------------- 33 References -------------------------------------------------------------------------------------------------------- 33 Thanks ------------------------------------------------------------------------------------ 错误！未定义书签。
IV