学生信息管理系统
学 院：系 部：专 业：学生姓名：学 号：指导教师：
( 2009届 )
清远职业技术学院
信息科技系 计算机网络技术 彭华健 02040902041 黄华
摘要
在各高校扩大招生的形势下,学生管理的工作变得越来越繁重。采用传统的人工管理模式，效率低下，不能满足实际的需求。
本文描述的是基于Windows环境的学生信息管理系统，对学生管理的需求进行了分析。本系统的主要功能包括：要提供新生信息录入、学籍变更、成绩管理和奖惩管理等相关的功能。可以更快地知道每个学生的情况，使学生的管理效率更高。系统的设计与开发采用服务器/客户机的系统结构模式，使用Delphi开发工具开发，应用Access2003数据库管理系统，通过ADO连接数据库。
本篇论文以一个学生管理系统的分析、设计和开发的全过程为主线，给出了学生管理系统的设计和技术实现的过程，特别在细节上分析功能和函数的实现思想。涉及到学生信息管理的基本功能在本论文中都有相应的描述。
关键字：Delphi，ADO，Access2003，学生信息管理
STUDENT INFORMATION MANAGEMENT
ABSTRACT
In the last few years in company with university institution deepening reformation, in many universities student administration work take charge all by logistics group. In university enlarged recruit student’s posture, administration became more and more pettiness. And conventional manual supervising pattern is inefficiency and insatiability for practical wants and needs, connect database through ADO.
The architecture of system is client and server. The Windows based DM system developed by Delphi and Access2003 database tools. This thesis analyzes the requirements of organization and configuration. The system's main functions include: to provide new information recorded, student status change, performance management and rewards and punishments management of related functions. To know that every student can be faster, so that the students information management efficiency is higher.
This thesis fully describes the whole process of system design and application details. All most functions of administration are discussed in the corresponding part of this thesis.
Key words: Delphi, ADO, Access2003, Student information management
目录
第一章 引言............................................................................................................................... 1
1.1课题背景 ........................................................................................................................... 1 1.2研究与应用现状................................................................................................................ 1 1.3本文的主要内容................................................................................................................ 1 第二章 相关技术介绍 ............................................................................................................... 2
2.1 Delphi .............................................................................................................................. 2
2.1.1 Delphi特点 .............................................................................................................. 2 2.1.2 Delphi7 ..................................................................................................................... 2 2.1.3 Delphi与VB ........................................................................................................... 3 2.2 SQL Server ...................................................................................................................... 3
2.2.1 Access 2003 .............................................................................................................. 3 2.2.2 Access 2003的特点 ................................................................................................. 3 2.3 ADO技术 ........................................................................................................................... 4 第三章 需求分析 ....................................................................................................................... 5
3.1需求分析 ........................................................................................................................... 5
3.1.1学生信息管理需求简介 .......................................................................................... 5 3.1.2功能性需求 .............................................................................................................. 5 3.1.3 非功能性需求 ......................................................................................................... 5 3.2可行性分析........................................................................................................................ 5
3.2.1经济可行性 .............................................................................................................. 6 3.2.2技术可行性 .............................................................................................................. 6
第四章 总体设计 ....................................................................................................................... 7
4.1总体设计目标.................................................................................................................... 7 4.2功能模块设计.................................................................................................................... 7 4.3数据库设计........................................................................................................................ 7
4.3.1数据流分析 .............................................................................................................. 8 4.3.2数据建模 ................................................................................................................ 14 4.3.3各实体关系模型 .................................................................................................... 14 4.3.4数据库逻辑结构设计 ............................................................................................ 15
第五章 系统详细设计 ............................................................................................................. 18
5.1系统各模块详细设计...................................................................................................... 18
5.1.1登录窗体与系统主界面设计 .............................................................................. 118 5.1.2新生管理模块设计 ................................................................................................ 18 5.1.3成绩管理模块设计 ................................................................................................ 19 5.1.4学籍变更管理模块 ................................................................................................ 20 5.1.5奖励管理模块设计 ................................................................................................ 22 5.1.6处罚管理模块设计 ................................................................................................ 23 5.1.7查询修改模块设计 ................................................................................................ 26
第六章 学生信息管理系统设计总结 ..................................................................................... 27
6.1系统的优点...................................................................................................................... 27 6.2系统的局限性.................................................................................................................. 27 6.3毕业设计心得.................................................................................................................. 28 6.4 毕业设计总结................................................................................................................. 28 参考文献 ........................................................................................................................................ 29