目 录

摘要 ..................................................................... 1 Abstract ................................................................. 2 第一章 绪论 .............................................................. 3

1.1 系统开发目的 ...................................................... 3 1.2 系统开发背景 ...................................................... 3 1.3 系统开发意义 ........................................................ 4 1.4系统开发技术 .......................................................... 5

1.4.1ASP 的关键技术 ............................................... 5 1.4.2 基于 ASP 的 Web 应用程序 .................................... 6 1.4.3系统国内外研究状况 ........................................... 7

第二章 需求分析 .......................................................... 8

2.1可行性分析 ........................................................ 8

2.1.1技术可行性分析 ............................................... 8 2.1.2经济可行性分析 ............................................... 8 2.2功能模块需求分析 .................................................. 8 2.3系统功能要求 ..................................................... 8 2.4用户对系统的要求 ................................................. 9

2.4.1教师用户登录管理功能 ......................................... 9 2.4.2学生用户登录管理功能 ........................................ 10

第三章 系统概要设计 ..................................................... 10

3.1系统功能模块设计 ................................................. 10 3.2 数据库设计 ....................................................... 11

3.2.1数据存储分析 ................................................ 11 3.2.2主要实体数据表 .............................................. 13

第四章 系统详细设计与实现 ............................................... 15

4.1系统登陆界面 ..................................................... 15 4.2系统主界面 ....................................................... 17

4.3用户管理模块 ..................................................... 18 4.4添加教师模块 ..................................................... 20 4.5添加学生模块 ..................................................... 22 4.6添加成绩模块 ..................................................... 23 第五章 系统软件的测试 ................................................... 25

5.1软件测试概述 ..................................................... 25 5.2测试内容 ......................................................... 26 第六章 总结 ............................................................. 27 参考文献 ................................................................ 28 致谢 .................................................................... 29 附录 .................................................................... 30

摘要

随着高校内部学生的增多,以及学生科目学习的繁杂,一直以来传统人工的学生成

绩管理方式,因其效率低、保密性差而且传统的工作方式给教职工带了很大压力，这大大降低了整个学生成绩管理的效率。所以构建一个学生管理系统势在必行。开发本系统可以减轻教职员工的工作压力，比较系统地对教务、教学上的各项服务和信息进行管理从而提高了保密性，加快查询速度、提高了管理效率。本文用Visual Studio.net,使用SQL2005数据库实现了学生成绩管理系统，本系统分为四个模块：系统管理模块、教师管理模块、学生管理模块、学生成绩管理模块。其中学生成绩管理模块可以录入成绩、修改成绩、查看成绩。还包括三种权限：管理员、教师、学生。其中管理员拥有最高权限，可以对系统的四个模块进行操作。

关键词：SQL2005、学生成绩管理、Visual Studio.net应用

1

Abstract

Along with the increase in internal students in colleges and universities, and students' course learning multifarious, has long been the traditional artificial way of student achievement management, because of its low efficiency, poor confidentiality and traditional way of work to staff brought a lot of pressure, which greatly reduces the efficiency of the whole student performance management. So build a student management system is imperative. Development of this system can reduce the staff working pressure, systematically on educational administration, teaching management and improve the services and information secrecy, accelerate query speed, improve the management efficiency. In this paper, using Visual Studio.net, use SQL2005 database has realized the student achievement management system, this system is divided into four modules: system management module, teacher management module, student management module, the student achievement management module. The students achievements management module can be recorded, modification result, view result. Also includes three permissions: administrators, teachers and students. The administrator has the highest authority, he can four modules of the system operation. Keywords：SQL2005、student management、Visual Studio.net application

2