高校网上选课系统

  • 格式:doc
  • 大小:345.50 KB
  • 文档页数:26

高校网上选课系统摘要摘要Internet网是目前全球最大的计算机通信网,它遍及全球几乎所有的国家和地区。

www系统是一个大型的分布式超媒体信息数据库,它极大的推动了Internet的发展,己经成为Internet中最流行、最主要的信息服务方式。

www技术之所以能在全球普及,一个重要的原因就是它与数据库管理系统相互融合,成为一个处理和共享信息的强大工具。

一方面,数据库是一种强大的信息管理工具,另一方面,www提供了共享数据的方法。

两者强强联合取长补短,发挥各自优势,使用户可以在Web浏览器上方便地检索数据库的内容。

本论文主要包括学生选课系统方案分析与网络规划,本系统是一个典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。

对于前者要求建立起数据一致性和完整性强、数据安全性好的库。

而对于后者则要求应用程序功能完备,易使用等特点。

经过分析,我们使用 MICROSOFT公司的SQL 2000、ASP (active server pages)作为开发工具, 用Microsoft Windows XP Professional 版本2002 Service Pack 2 简体中文版,Microsoft Offices ACCESS 2003 中文版,Internet Information Services (IIS6) Manager,Intel(R) PIIII CPU 3.0GHz Double CPU 512MB Rom 160GBHardDisk作为开发平台。

本系统可以方便老师、学生更方便的选课。

实现全校学生选课在线查询。

还可以对新来的学生信息进行信息录入。

由于学生上课情况复杂,可以实现信息修改,及时调整学生的基本情况。

关键词: 选课,学生 ,数据库 ,查询University online courses systemAbstractAbstract The Internet network is currently the world's biggest computer network, it all over the globe almost all countries and regions. WWW system is a large distributed hypermedia information database, it greatly promoted the development of the Internet, have already become the most popular Internet information service, the most important way. WWW technology in the global popularization, makes an important reason is that it and database management system mutual confluence, become a processing and share information powerful tools. On the one hand, the database is a powerful information management tools, on the other hand, WWW provides share data method. Both the power-and-power union complement each other, play to their respective advantages, users can easily in the Web browser on the content of a searchable database.This thesis mainly including student elective course system plan analysis and the network planning, the system is a typical information management system (MIS), its development mainly includes the setting and maintenance of database and the programming of the frontend application. The former required establish data consistency and integrality, data security good storehouse. For the latter requires the application program function complete, easy to use, etc.Through analysis, we use the MICROSOFT company of SQL 2000, ASP (web) as active server development tool, does with MICROSOFT Windows XP Service Pack 2 simplified version 2002 Chinese version, MICROSOFT privately in Chinese, the paper takes ACCESS 2003 IIS6 Internet Information Services for (Manager, Intel (R) PIIII CPU 3.0 GHz) 160GBHardDisk CPU 512MB Rom Double as a development platform.This system can be convenient teachers, students more convenient course. Realizing whole school student courses online query. Can the new student information inputinformation. Because the student class, may realize the complicated circumstances, adjust students information modify the basic situation.Keywords: courses, students, databases, inquires目录1引言 .............................................................................................................................. - 1 -1.1 课题研究的目的 ................................................................................................. - 2 - 1.2 课题研究的意义 ................................................................................................. - 2 - 1.3 课题的可行性分析 ............................................................................................. - 2 -1.3.1 课题调研 ......................................................................................................... - 2 -1.3.2 可行性分析 ..................................................................................................... - 3 -2 准备阶段 ..................................................................................................................... - 4 -2.1 ASP基础 .............................................................................................................. - 4 - 2.2 数据库系统设计 ................................................................................................. - 4 -3 应用系统开发工具 ..................................................................................................... - 6 -3.1 对软件和硬件的要求 ......................................................................................... - 6 - 3.2 运行需求 ............................................................................................................. - 6 - 3.3 其他需求 ............................................................................................................. - 6 - 3.4 数据库应用系统开发简介 ................................................................................. - 6 - 3.5 学生选课系统 ..................................................................................................... - 7 - 3.6 MS SQL Server 简介........................................................................................... - 8 - 4系统分析 ........................................................................................................................ - 9 -4.1 系统简要分析 ................................................................................................... - 9 - 4.2 应用需求分析 ................................................................................................... - 9 - 4.3 业务流分析 ..................................................................................................... - 10 - 4.4 数据流分析 ..................................................................................................... - 10 - 4.5 系统数据模型设计 ......................................................................................... - 10 -4.5.1 E-R图............................................................................................................. - 10 -4.5.2 数据表 ........................................................................................................... - 12 -5 操作方法 ..................................................................................................................... - 14 -5.1 登录 ................................................................................................................. - 14 - 5.2 课程预览 ......................................................................................................... - 14 - 5.3 选课 ................................................................................................................. - 14 - 5.4 退课 ................................................................................................................. - 14 - 5.5 密码修改 ......................................................................................................... - 14 - 5.6 管理员登录 ..................................................................................................... - 14 -5.7 退出系统 ......................................................................................................... - 14 - 6 调和测试 ..................................................................................................................... - 15 -结论 ............................................................................................................................. - 16 -参考文献 ................................................................................................................... - 17 -附录 ............................................................................................................................... - 18 -附录1:用户注册页面 ............................................................................................ - 18 - 附录2:add_user.asp原代码................................................................................... - 18 - 附录2:数据库设置 ................................................................................................ - 20 - 附录3:注册资料 .................................................................................................... - 21 - 致谢 ..................................................................................................... 错误!未定义书签。