二、进度安排： 2014-11-13：明确所选课题的具体要求，按要求阅读相关的参考文献及资料 2014-11-13至2014-12-25：课题代码实现、课程设计报告书写 2014-12-25：综合设计答辩 三、应收集资料及主要参考文献： [1]谭火彬.UML 2面向对象分析与设计[M].北京:清华大学出版社,2013.5. [2]王珊,萨师煊.数据库系统概论[M].北京:高等教育出版社,2006.5. [3]罗晓芾.数据库技术（高级）[M].北京:清华大学出版社,1999.
四、摘要： 学生管理系统是对在校学生信息记录管理的一个小型系统。传统的纸质记录容易出错且效率也很低下。为了减轻学校相关工作人员的任务，也为了减小出错的概率，使老师和相关管理人员能快速的获取或记录学生信息。本系统主要从三个方面的功能加以开发，包括学生信息管理，选修课程管理和学生成绩管理。其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。采用SQL Server2008数据库作为后台数据库、Visual C#编程语言作为前台开发工具。系统运行良好，本系统可以满足在校老师和相关管理人员对学生信息的查阅和修改借，达到了设计要求。 关键词：学生管理；DataSet；SQL Server2008 五、Abstract： Student management system is on a small system of students informationrecords management. Traditional paper records error prone and the efficiency is very low. In order to reduce the school staff related tasks, but also to reduce the probability of error, so teachers and related management personnel can quicklyobtain or record student information. This system mainly from three aspects of the function to the development, including the student information management,elective course management and student achievement management. Its development mainly includes two aspects the background of the establishment and maintenance of database and front-end application development. Using SQLServer2008 database as the background database, Visual C# programming language as a development tool. The system runs well, the system can meet theteachers in the school and the relevant management personnel information for students to access and modify borrow, reached the design requirements. Keywords：The management of students ；DataSet；SQL 2008
武汉工程大学计算机科学与工程学院 综合设计报告
目 录
摘 要 ……………………………………………………………………………………… II Abstract ………………………………………………………………………………...... III 第一章 课题背景……………………………………................................……………….. 1 1.1 设计的背景……………………..……………………………………………………...1 1.2 设计的目的.……………….……………………………..…………………………… 1 1.3 设计的意义.……………….……………………………..…………………………… 1 1.4 系统的可行性分析………….….………………………..…………………………… 2 1.5 技术要求.……………....….……………………………..…………………………… 2 第二章 设计简介及设计方案论述 ………………………............……………………….. 3 2.1 系统需求分析…………………………..….……..………………...........………….…3 2.2 系统实现目标…………………………………………..……….........………….…….3 2.1 系统主要流程图……………………..…………..………….............……………….…3 2.1 数据库设计概要………………..………..……………........................…………….…4 第三章 详细设计…………………………………………………………..…………….…..6 3.1 数据库详细设计……………................………..……............………..…………….…6 3.2 系统设计……....……………………..…………............................………..……….…7 3.2.1 登入界面………………………………..…................………………..……….…7 3.2.2 系统界面…………………............…………..............................……..……….…8 第四章 设计结果及分析 ...................................................................................................... 11 4.1 学生信息管理模块 ...................................................................................................... 11 4.2 选修课程管理模块 ........................................................................................................................... 14 4.3 学生成绩管理模块 ........................................................................................................................... 16
4.4 结果分析 .............................................................................................................................................18
总 结 …….………………………………………………….....…………………………....19 致 谢 …….…………………………………………………..….……………….……….…21 参考文献 …….………………..………………………………..…….…………….…….…22
- I -
武汉工程大学计算机科学与工程学院 综合设计报告
摘 要
学生管理系统是对在校学生信息记录管理的一个小型系统。传统的纸质记录容易出错且效率也很低下。为了减轻学校相关工作人员的任务，也为了减小出错的概率，使老师和相关管理人员能快速的获取或记录学生信息。本系统主要从三个方面的功能加以开发，包括学生信息管理，选修课程管理和学生成绩管理。其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。采用SQL Server2008数据库作为后台数据库、Visual C#编程语言作为前台开发工具。系统运行良好，本系统可以满足在校老师和相关管理人员对学生信息的查阅和修改借，达到了设计要求。 关键词：学生管理；DataSet；SQLServer2008
- II -
武汉工程大学计算机科学与工程学院 综合设计报告
Abstract
Student management system is on a small system of students informationrecords management. Traditional paper records error prone and the efficiency is very low. In order to reduce the school staff related tasks, but also to reduce the probability of error, so teachers and related management personnel can quicklyobtain or record student information. This system mainly from three aspects of the function to the development, including the student information management,elective
course
management and student
achievement
management. Its development mainly includes two aspects the background of the establishment and maintenance of database and front-end application development. Using SQLServer2008 database as the background database, Visual C# programming language as a development tool. The system runs well, the system can meet theteachers in the school and the
relevant management
personnel information
for
students
to access
and modify borrow, reached the design requirements.
Keywords：The management of students ；DataSet；SQL 2008
- III -