郑州大学毕业设计（论文）
题 目： 成绩查询管理系统
指导教师： 李俊锋 职称： 讲师
学生姓名： 李鹏 学号： [1**********] 专 业： 计算机科学与技术（网络工程） 院（系）： 软件学院 完成时间： 2011-12-20
2011年12月20日
目 录
目录………………………………………………………………..............................................................I 摘要……………………………………………………………………………………………………….II Abstract „„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„III
1 绪论 .................................................................................................................................................... 4
1．1 引言 .......................................................................................................................................... 4
1．2 背景 .......................................................................................................................................... 5
1.2.1 B/S模型的优点 ................................................ 5
1.2.2 JSP技术发展背景 .............................................. 6
1.2.3 MS SQL Server 简介 .......................................... 7
2 系统分析............................................................................................................................... 8
2.1 系统需求分析 . ........................................................................................................................ 8
2.2 系统模块介绍 ............................................................................................................................ 8
2.2.1登陆模块 . ..................................................... 8
2.2.2学生模块介绍 . ................................................. 9
2.2.3老师（管理员）模块介绍 ........................................ 9
2.3系统逻辑方案 ............................................................................................................................. 9
2.3.1数据流图（简称为DFD ） ........................................ 9
3 系统设计 .............................................................................................................................................. 11
3.1学生成绩查询系统功能需求简介 ........................................................................................... 11
3.2 功能需求描述 .......................................................................................................................... 11
3.3数据库设计 ............................................................................................................................... 12
3.3.1数据库需求分析 ............................................... 12
3.3.2 数据库的逻辑设计 ............................................ 12
3.3.3 数据库的规范化设计思想 ...................................... 13
3.3.4、逻辑结构设计（E －R 图向关系模型的转换） ..................... 13
4 系统实施 .............................................................................................................................................. 15
4.1 软件测试的目的和原则 ........................................................................................................... 15
4.2各子系统模块程序设计举例 .................................................................................................... 15
5 结论 .................................................................................................................................................. 34
参考文献（References ） ........................................................................................................................ 35
外文资料 .................................................................................................................................................. 35
外文资料译文 .......................................................................................................................................... 40
摘 要
Internet 网是目前全球最大的计算机通信网，它遍及全球几乎所有的国家和地区，它已经成为人们生活、工作、学习越来越离不开的平台。www 系统是一个大型的分布式超媒体信息数据库，它极大的推动了Internet 的发展，己经成为Internet 中最流行、最主要的信息服务方式。www 技术之所以能在全球普及，一个重要的原因就是它与数据库管理系统相互融合，成为一个处理和共享信息的强大工具。一方面，数据库是一种强大的信息管理工具，另一方面，www 提供了共享数据的方法。两者强强联合取长补短，发挥各自优势，使用户可以在Web 浏览器上方便地检索数据库的内容。
本论文主要包括学生课绩管理系统方案分析，本系统是一个典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于前者要求建立起数据一致性和完整性强、数据安全性好的库。而对于后者则要求应用程序功能完备, 易使用等特点。本文中数据库服务器端采用了SQL 2000作为后台数据库，以先进的JDBC 技术与数据库连接，结合SQL 语句处理对用户分类，添加，删除，修改等操作，使Web 与数据库紧密联系起来。
利用其提供的各种面向对象的开发工具, 首先在短时间内建立系统应用原型, 然后, 对初始原型系统进行需求迭代, 不断修正和改进, 直到形成用户满意的可行系统。
本系统可以方便老师、学生的成绩管理。实现全校学生选课在线查询。还可以对新来的学生信息进行信息录入。由于学生情况复杂，可以实现信息修改，及时调整学生的基本情况。整个个性化页面生成系统主要由使用JSP 技术开发实现个性化Web 页面生成和JavaBeans 技术实现组件重用两部分组成。
关键词 课程 成绩 学生 数据库 查询
Abstract
The Internet net is the present whole world biggest computer communications network, it spreads global nearly all countries and thearea, it already became the people to live the platform which, thework, the study more and more could not leave. The www system is alarge-scale distributional ultra media information database, it senormous impetus Internet development, the oneself after has become in Internet to be most popular, the most main information service way. The www technology therefore can be popular in the whole world, an important reason is
it mutually fuses with the database management system, becomes a processing and the sharing information powerful tool. On the one hand, the database is one kind of formidable information management tool, on the other hand, www has provided the sharing data method. Two is strong strongly jointly makes up for one's deficiency by learning from others' strong points, displays respective superiority, enables the user to be allowed conveniently to retrieve the database on the Web browser the content.
The present paper mainly includes the student class to twist the management system management system plan analysis, this system is atypical information management system (MIS), its development mainly includes the back stage database the establishment and the maintenanceas well as front end the application procedure development two aspects. Establishes the data uniformity and the integrity regarding former request is strong, the data security good storehouse. But requests the application procedure function regarding latter completely, is easy to use and so on the characteristic. In this article the database server end used SQL 2,000 to take the back stage database, by the advanced JDBC technology and the database connection, unified the SQL sentence to process to the user classification, the increase, deleted, operation and so on revision, caused Web and the database closely relates.
Each kind of object-oriented development kit provides which using it, first establishes the system application prototype in the short time, then, carries on the demand iteration to the initial prototype system, unceasingly revises and the improvement, until forms user satisfaction the feasible system. This system may facilitate teacher, student's result management. Realizes the entire school student to choose the class on-line inquiry. Also may to the student information which newly comes carry on the information input. Because the student situation is complex, may realize the information to revise, promptly adjusts student's basic situation. The entire individuality page production system mainly by uses JSP the technical development realization individuality Web page production and the JavaBeans technology realization module entrusts with heavy responsibility two parts to be composed.
Keyword : courses/score results students database query
郑州大学毕业设计（论文）
题 目： 成绩查询管理系统
指导教师： 李俊锋 职称： 讲师
学生姓名： 李鹏 学号： [1**********] 专 业： 计算机科学与技术（网络工程） 院（系）： 软件学院 完成时间： 2011-12-20
2011年12月20日
目 录
目录………………………………………………………………..............................................................I 摘要……………………………………………………………………………………………………….II Abstract „„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„III
1 绪论 .................................................................................................................................................... 4
1．1 引言 .......................................................................................................................................... 4
1．2 背景 .......................................................................................................................................... 5
1.2.1 B/S模型的优点 ................................................ 5
1.2.2 JSP技术发展背景 .............................................. 6
1.2.3 MS SQL Server 简介 .......................................... 7
2 系统分析............................................................................................................................... 8
2.1 系统需求分析 . ........................................................................................................................ 8
2.2 系统模块介绍 ............................................................................................................................ 8
2.2.1登陆模块 . ..................................................... 8
2.2.2学生模块介绍 . ................................................. 9
2.2.3老师（管理员）模块介绍 ........................................ 9
2.3系统逻辑方案 ............................................................................................................................. 9
2.3.1数据流图（简称为DFD ） ........................................ 9
3 系统设计 .............................................................................................................................................. 11
3.1学生成绩查询系统功能需求简介 ........................................................................................... 11
3.2 功能需求描述 .......................................................................................................................... 11
3.3数据库设计 ............................................................................................................................... 12
3.3.1数据库需求分析 ............................................... 12
3.3.2 数据库的逻辑设计 ............................................ 12
3.3.3 数据库的规范化设计思想 ...................................... 13
3.3.4、逻辑结构设计（E －R 图向关系模型的转换） ..................... 13
4 系统实施 .............................................................................................................................................. 15
4.1 软件测试的目的和原则 ........................................................................................................... 15
4.2各子系统模块程序设计举例 .................................................................................................... 15
5 结论 .................................................................................................................................................. 34
参考文献（References ） ........................................................................................................................ 35
外文资料 .................................................................................................................................................. 35
外文资料译文 .......................................................................................................................................... 40
摘 要
Internet 网是目前全球最大的计算机通信网，它遍及全球几乎所有的国家和地区，它已经成为人们生活、工作、学习越来越离不开的平台。www 系统是一个大型的分布式超媒体信息数据库，它极大的推动了Internet 的发展，己经成为Internet 中最流行、最主要的信息服务方式。www 技术之所以能在全球普及，一个重要的原因就是它与数据库管理系统相互融合，成为一个处理和共享信息的强大工具。一方面，数据库是一种强大的信息管理工具，另一方面，www 提供了共享数据的方法。两者强强联合取长补短，发挥各自优势，使用户可以在Web 浏览器上方便地检索数据库的内容。
本论文主要包括学生课绩管理系统方案分析，本系统是一个典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于前者要求建立起数据一致性和完整性强、数据安全性好的库。而对于后者则要求应用程序功能完备, 易使用等特点。本文中数据库服务器端采用了SQL 2000作为后台数据库，以先进的JDBC 技术与数据库连接，结合SQL 语句处理对用户分类，添加，删除，修改等操作，使Web 与数据库紧密联系起来。
利用其提供的各种面向对象的开发工具, 首先在短时间内建立系统应用原型, 然后, 对初始原型系统进行需求迭代, 不断修正和改进, 直到形成用户满意的可行系统。
本系统可以方便老师、学生的成绩管理。实现全校学生选课在线查询。还可以对新来的学生信息进行信息录入。由于学生情况复杂，可以实现信息修改，及时调整学生的基本情况。整个个性化页面生成系统主要由使用JSP 技术开发实现个性化Web 页面生成和JavaBeans 技术实现组件重用两部分组成。
关键词 课程 成绩 学生 数据库 查询
Abstract
The Internet net is the present whole world biggest computer communications network, it spreads global nearly all countries and thearea, it already became the people to live the platform which, thework, the study more and more could not leave. The www system is alarge-scale distributional ultra media information database, it senormous impetus Internet development, the oneself after has become in Internet to be most popular, the most main information service way. The www technology therefore can be popular in the whole world, an important reason is
it mutually fuses with the database management system, becomes a processing and the sharing information powerful tool. On the one hand, the database is one kind of formidable information management tool, on the other hand, www has provided the sharing data method. Two is strong strongly jointly makes up for one's deficiency by learning from others' strong points, displays respective superiority, enables the user to be allowed conveniently to retrieve the database on the Web browser the content.
The present paper mainly includes the student class to twist the management system management system plan analysis, this system is atypical information management system (MIS), its development mainly includes the back stage database the establishment and the maintenanceas well as front end the application procedure development two aspects. Establishes the data uniformity and the integrity regarding former request is strong, the data security good storehouse. But requests the application procedure function regarding latter completely, is easy to use and so on the characteristic. In this article the database server end used SQL 2,000 to take the back stage database, by the advanced JDBC technology and the database connection, unified the SQL sentence to process to the user classification, the increase, deleted, operation and so on revision, caused Web and the database closely relates.
Each kind of object-oriented development kit provides which using it, first establishes the system application prototype in the short time, then, carries on the demand iteration to the initial prototype system, unceasingly revises and the improvement, until forms user satisfaction the feasible system. This system may facilitate teacher, student's result management. Realizes the entire school student to choose the class on-line inquiry. Also may to the student information which newly comes carry on the information input. Because the student situation is complex, may realize the information to revise, promptly adjusts student's basic situation. The entire individuality page production system mainly by uses JSP the technical development realization individuality Web page production and the JavaBeans technology realization module entrusts with heavy responsibility two parts to be composed.
Keyword : courses/score results students database query