目 录
摘要...................................................................................................................................................................I
ABSTRACT.....................................................................................................................................................II
引言 ..................................................................................................................................................................3
第一章 绪论 ................................................................................................................................................4
1.1 选题背景和意义....................................................................................................................................4
1.3 系统开发技术........................................................................................................................................5
1.3.1 B/S 体系结构 ......................................................................................................................................5
1.3.2 SQL SERVER 2000 ...............................................................................................................................6
1.3.3 JSP 技术............................................................................................................................................7
1.3.4 ODBC 数据访问接口.......................................................................................................................7
1.3.5 JDBC 数据访问接口 ..........................................................................................................................8
1.3.6 JAVASCRIPT .........................................................................................................................................9
第二章 系统设计 ..........................................................................................................................................10
2.1 需求分析..............................................................................................................................................10
2.1.1 运行环境...........................................................................................................................................10
2.2 系统总体设计......................................................................................................................................10
2.2.1 系统目标设计 ..................................................................................................................................10
2.2.2 系统设计思想 ..................................................................................................................................11
2.2.3 系统功能描述 ..................................................................................................................................11
2.2.4 系统用例图.......................................................................................................................................14
2.2.5 系统 UML 活动图............................................................................................................................16
第三章 数据库设计 ......................................................................................................................................18
3.1 总体表设计..........................................................................................................................................18
3.2 数据库表的结构 .................................................................................................................................18
3.3 实体及 ER 图 ......................................................................................................................................20
3.3.1 登录管理 ..........................................................................................................................................20
3.3.2 实体的 ER 图....................................................................................................................................21
3.4 数据库表的关系图 .............................................................................................................................23
3.5 数据库表的视图 .................................................................................................................................24
第四章 系统具体实现 ..................................................................................................................................25
4.1 关键应用 .............................................................................................................................................25
4.1.1 数据库连接.......................................................................................................................................25
4.2 登录管理 .............................................................................................................................................28
4.3 菜单界面 .............................................................................................................................................29
4.4 系统管理 .............................................................................................................................................30
4.4.1 学生信息显示页面...........................................................................................................................30
4.4.2 学生信息修改页面...........................................................................................................................33
4.4.3 添加学生信息页面...........................................................................................................................33
4.4.4 成绩查看页面...................................................................................................................................34
4.5 课程管理..............................................................................................................................................35
4.5.1 选修课表显示...................................................................................................................................35
