衡阳师范学院
毕业论文(设计)
题 目:学生网上选课系统的设计
所 在 系:计算机科学
专 业:计算机科学与技术
学 号:
作者姓名:
指导教师:
二零一零年五月五日
学生网上选课系统的设计
计算机科学系 计算机科学与技术专业
学号: 姓名: 指导教师:
摘 要 随着计算机网络迅速发展,信息资源统计和日常办公也迅速无纸化和网络化。大量数据的搜
集及处理通过网络实现已经非常普遍,且技术已经相当成熟,如国家公务员考试报名系统,学生电
子档案管理系统等。本系统旨在使高校学生选课简单化、方便化和快捷化,抛弃了传统的 ASP 技
术而是采用了 B/S(Browser/Server)架构和 ASP.NET 技术用以实现。系统分三种角色登陆,学生,
教师和管理员都可以在浏览器端完自己的各项工作,且本系统是服务器端执行,故效率较 ASP 网
站有所提高。
关键词 ASP.NET;ACCESS 数据库;选课系统
Abstract: With the rapid development of computer networks, statistics of information resources and the
daily office work are becoming paperless and networking quickly. Large amounts of data collection and
processing through the network is very popular, and the technology is quite mature, such as the National
Civil Service Examination Registration System, student electronic records management systems. The
system is designed to simplify the college students course selection, the convenience and faster technology,
abandoning the traditional ASP technology instead of using the B / S architecture and ASP.NET technology
to achieve. System is divided into three types of landing the role of students, teachers and administrators
can be completed in the browser all the work themselves, and this system is a server-side implementation,
so more efficient than the ASP web site increased.
Key words: ASP.NET Access Database Course Selection System
2
3
目录
1. 引言................................................................................................................................................................6
1.1 课题研究的目的及意义......................................................................................................................6
1.2 课题的可行性分析..............................................................................................................................6
1.2.1 课题调研...................................................................................................................................6
1.2.2 可行性分析...............................................................................................................................6
1.3 选题相关知识......................................................................................................................................7
1.3.1 ASP.NET...................................................................................................................................7
1.3.2 C#..............................................................................................................................................7
1.3.3 ACCESS 数据库.......................................................................................................................7
1.3.4 Microsoft Visual Studio 2008...................................................................................................7
2.需求分析.........................................................................................................................................................8
2.1 需求分析..............................................................................................................................................8
3.系统设计.........................................................................................................................................................9
3.1 系统分析..............................................................................................................................................9
3.1.1 开发环境...................................................................................................................................9
3.1.2 系统分析...................................................................................................................................9
3.2 系统架构..............................................................................................................................................9
3.3 数据库设计........................................................................................................................................13
3.3.1 管理员信息表 Admin.............................................................................................................13
3.3.2 教师信息表 teacher................................................................................................................13
3.3.3 学生信息表 student................................................................................................................14
3.3.4 所有已上传到教研室的课程 JiaoyanshiClass......................................................................14
3.3.5 学院所有可开课程 Allcourses..............................................................................................14
3.3.6 所有学生已选课程 studentclass............................................................................................15
3.3.7 学生成绩信息表 Score...........................................................................................................15
3.3.8 教师评论信息表 Tpinglun.....................................................................................................15
3.3.9 系统公告信息表 News...........................................................................................................16
3.3.10 学院所有系信息表 Xi..........................................................................................................16
3.3.11 系统开关时间信息表 opentime...........................................................................................16
4.详细设计.......................................................................................................................................................17
4.1 管理员功能实现................................................................................................................................17
4.1.1 登录.........................................................................................................................................17
4.1.2 所有课程信息查询.................................................................................................................18
4.1.3 课程信息审核.........................................................................................................................20
4.1.4 开课教师信息.........................................................................................................................21
4.1.5 教师测评结果.........................................................................................................................21
4.1.6 用户信息维护.........................................................................................................................22
4.1.7 发布系统公告.........................................................................................................................23
4.1.8 添加课程信息.........................................................................................................................23
4
4.1.9 开启关闭系统.........................................................................................................................24
4.2 教师管理功能实现............................................................................................................................25
4.2.1 登录注册.................................................................................................................................25
4.2.2 上传课程信息.........................................................................................................................25
4.2.3 查看所授课程信息.................................................................................................................26
4.2.4 在线点名.................................................................................................................................27
4.2.5 学生成绩录入.........................................................................................................................28
4.2.6 查看系统公告.........................................................................................................................28
4.2.7 我的测评.................................................................................................................................29
4.2.8 密码修改.................................................................................................................................29
4.3 学生选课功能实现............................................................................................................................30
4.3.1 选课操作.................................................................................................................................30
4.3.2 我的课程表.............................................................................................................................31
4.3.3 出勤记录查询.........................................................................................................................32
4.3.4 我的成绩.................................................................................................................................32
4.3.5 教师测评.................................................................................................................................33
4.3.6 查看公告和个人信息管理....................................................................................................34
4.4 系统风格设计....................................................................................................................................34
4.5 系统安全............................................................................................................................................34
5.运行与调试...................................................................................................................................................35
5.1 运行与调试过程中的错误................................................................................................................35
5.1.1 系统无法调试的错误.............................................................................................................35
5.1.2DropdownList 控件多次数据绑定时出错.............................................................................35
5.1.3 学生成绩录入时验证控件的错误........................................................................................36
5.2 系统尚需完善的部分........................................................................................................................36
6.结论...............................................................................................................................................................37
7.致谢...............................................................................................................................................................38
8.参考文献.......................................................................................................................................................39
5
- 1
- 2
- 3
- 4
前往页