河北经贸大学毕业论文
学生成绩管理系统
专业名称： 网络工程 班 级： 2007级1班 学生姓名： 蔡海如 指导老师： 高双喜 完成时间： 2011年5月
河北经贸大学毕业论文
摘 要
学生成绩管理信息系统是针对学校教务处的大量业务处理工作而开发的管理软件，是典型的管理信息系统（Management Information System）。它的开发主要包括前端应用程序的开发和后台数据库的建立两个方面。本人采用Visual Studio .NET作为前台界面开发工具，Microsoft SQL Sever作为后台数据库管理系统，设计并实现了这个系统。
本系统的主要功能模块包括：登录管理模块，系统管理模块，基本信息管理模块，成绩管理模块，课程管理模块，信息查询模块等六大功能模块。登录管理模块：分为管理员登录和用户（教师、学生）登录两个子模块。通过权限管理，将用户进行分级管理，分别拥有不同的权限，根据不同的用户权限来提供不同的服务。系统管理模块包括用户账户和管理员账户维护；基本信息管理模块主要应用于用户个人基本信息的维护；成绩、课程管理模块用于课程登记、成绩录入和管理；信息查询模块具有查询教师、学生个人信息，课程信息，成绩统计信息等的功能
本管理系统具有以下几个特点：具有快速的查询能力，为用户提供充足的信息和快捷的查询手段。能有效的帮助学校和老师掌握学生的情况，改变目前信息反应速度慢、秩序混乱的局面；具有快速和大容量的信息交换能力,使用户能获得最新、完整、稳定、可靠的信息；流程简洁，界面美观友好，操作简单，不需要用户掌握高难技术，适合学校的成绩信息管理。
关键词 信息化 ； 数据管理 ； Asp.net ；管理信息系统
I
河北经贸大学毕业论文
Abstract
Student performance Management Information System is aimed at the school of business handling office work and development Management software is a typical Management Information System (MIS). Its development mainly includes front application program development and backend database establishment two aspects. I using Visual studio.net as a receptionist interface development tools, Sever as backstage Microsoft SQL database management system, this system was designed and implemented.
The system's main function modules including: login management module, system management module, the basic information management module, performance management module, the curriculum management module, information query model .Login management module: divided into administrator and user (teacher, student) two sons module. System management module include user accounts and administrator account maintenance; The basic information management module mainly applied to users of the basic information of the maintenance; personal Results, the curriculum management modules used course registration, achievements input and management; Information query module possesses inquires the teachers, students' personal information, curriculum information, achievements statistics and other information function
This system has the following characteristics: quickly inquiring, providing users with sufficient information and quick searching method. Helping schools and teacher grasps student's situation, change the current information reaction slow and order mess; Having fast and large capacity information exchange capacity, the user can obtain the newest, complete, stable and reliable information; Process is concise, interface aesthetics friendly, the operation is simple, does not require the user to master skaters technology, suitable for school performance of information management.
Keywords : informationalization ; Data management ;Asp.net；MIS
II
河北经贸大学毕业论文
目 录
1 绪 论 ............................................................................................................................... 1 2 系统概述......................................................................................................................... 2 2.1 本系统概述 ............................................................................................................... 2 2.2 本系统特点 .............................................................................................................. 2 2.3 项目开发背景 ......................................................................................................... 3 2.4 项目开发的意义 ..................................................................................................... 3 3 系统分析......................................................................................................................... 4 3.1 系统目标 ................................................................................................................. 4 3.2 可行性分析............................................................................................................. 4 3.3 需求分析 ................................................................................................................. 5 3.3.1 成绩管理流程分析......................................................................................... 5 3.3.2 功能需求分析 ................................................................................................. 6 3.3.3 性能需求分析 ................................................................................................. 7 3.3.4 技术需求分析 ................................................................................................. 7 3.3.5 环境需求分析 ................................................................................................. 8 4 总体设计......................................................................................................................... 9 4.1 系统设计思想 ......................................................................................................... 9 4.2 B/S结构 ................................................................................................................... 9 4.3 系统模块设计 ......................................................................................................... 9 4.4 技术平台的选择 ................................................................................................... 12 4.4.1 Visual C# 2005简介 ..................................................................................... 12 4.4.2 SQL Sever 2005简介 ................................................................................... 12 5 数据库设计 .................................................................................................................. 14 5.1 数据库设计概述 ................................................................................................... 14 5.2 逻辑结构与概念结构 ........................................................................................... 14
I
河北经贸大学毕业论文
5.3 数据库表设计 ....................................................................................................... 17 6 系统详细设计与实现.................................................................................................. 20 6.1 系统管理模块 ...................................................................................................... 20 6.1.1 登录功能 ....................................................................................................... 20 6.1.2 更改登录密码功能....................................................................................... 22 6.2 信息管理模块 ....................................................................................................... 24 6.2.1 成绩录入 ....................................................................................................... 24 6.2.2 成绩修改 ....................................................................................................... 26 6.2.3 学生信息删除 ............................................................................................... 28 7 系统测试 ......................................................................................................................... 30 7.1 测试环境 ................................................................................................................ 30 7.1.1 硬件环境 ....................................................................................................... 30 7.1.2 软件环境 ....................................................................................................... 30 7.2 测试 ........................................................................................................................ 30 7.2.1 各模块测试 ................................................................................................... 30 7.2.2 集成测试 ....................................................................................................... 31 7.2.3 测试评价 ....................................................................................................... 31 结 论 ................................................................................................................................. 32 致 谢 ................................................................................................................................... 33 参考文献 ............................................................................................................................... 1
II