发布时间 : 星期四 文章桂林航天工业学院网上选课系统毕业论文 - 图文更新完毕开始阅读
桂林航天工业学院毕业设计论文
摘 要
随着计算机及互联网的普及，网络选课系统作为高校信息化的一个重要组成
部分，正逐渐改变着传统的人工教务管理选课模式，逐步提高着教务管理人员以及师生的工作效率。应用此系统，学生可以通过网络在任意地点、指定的时间进行选课。网络选课系统具有无可比拟的优势，如大量数据的存储与查询，信息的完全公开，而且通过计算机系统的设计可以做到公平公正，尽量减少错误。在此背景下，充分利用现有网络资源，建立网上选课系统势在必行。目前的选课系统的实现方式有很多种，既有C/S结构的，也有B/S结构的，总体来说，基于Web的B/S结构的选课系统是最适合当前高校教务管理需要的，因此是目前的发展主流。
本系统是基于JSP平台进行开发的，主要开发工具是Myeclipse和SQL Server 2008。本系统由学生选课模块、教师信息管理模块、学生信息管理模块、课程管理模块、课程分配模块、成绩录入模块、留言板管理模块等组成。本文通过分析B/S结构的特点并结合选课的实际情况，提出了基于浏览器/服务器结构网上选课系统的基本设计思想，简要介绍了系统各功能模块及数据库的设计，着重讨论了用 MyEclipse技术和SQL Server 2008开发网上选课系统时的数据库访问技术和动态网页制作技术,并给出了部分实现代码。通过该系统，使学生可以方便地在校园网上进行网上选课。该B/S结构的系统在Windows XP系统和MyEclipse平台下开发完成，使用JAVA作为MyEclipse的开发语言，SQL Server 2008作为数据库。系统有较高的安全性和较好的性能。其中连接数据库的字符串可以随时在Hibernate里修改，并经过编码加密，增加了灵活性，保护了数据库的安全。代码尽量使用存储过程和尽量减少数据库连接的打开时间等手段来提高性能。 本文中除了有对程序的系统分析、总体设计、数据库设计、功能实现等主体部分外，在这之前还介绍了与网上选课系统相关的信息、IIS介绍、IIS与JSP的结合等的基本内容及发展情况。
关键词：网上选课，B/S结构，MyEclipse,数据库管理系统
1
桂林航天工业学院毕业设计论文
ABSTRACT
With the popularity of computers and the Internet,online Network Elective system as a important part of college information.it is gradually changing the traditional of artificial Educational Administration Elective.And also gradually increase the efficiency of teachers and students.Students could choose courses anywhere anytime via internet by this system.The Network Elective system has an unparalleled advantage,for example,like large amounts of data storage and query,disclosure of information,and it can be fair,justice and minimize errors by computer design.In this context,it is necessary to establish a online register system by full use of exsiting network resources.There are many ways to realize a Network Elective system,not only C/S structure,also exsits B/S structure.Overall,the system based on B/S structure is the best suited to current needs.So it is the trend of development.
This system is designed on the base of JSP platform, and I use MyEclipse as the exploit tool and use SQL Server 2008 as database. This system is made up of course selection module, teachers info management module, courses info management module, course arrangement module, messages management module, etc.This paper gives the basic design idea of the B/S structure based online course elect system by analyzing the characteristic of the B/S structure and combining with the actual public elective courses conditions of our school．It introduces the function module and database design briefly，followed by a discussion on database accessing technology and the active page technology of the course elect system based on MyEclipse and SQL Server 2008．By using this system，students can elect courses online efficiently．This B/S structure system is developed under Myeclipsei platform in Windows XP operating system, using JAVA as MyEclipse development language and SQL Server 2008 as the database. This system is of higher security and better performance. The character string, which is used to connecting to the database, can be modified at any time in the file “Hibernate”. The string is encoded and encrypted, increasing flexibility of the system and security of the database. In code, making use of stored procedure and minimizing the database opening time to improve performance of the system.
This paper includes the system analysis ,the main designing ,the database designing, the function designing and , before this , some basic knowledge and present development of the programs mentioned above.
Key words: online course elect, B/S structure, MyEclipse, SQL Server 2008, Hibernate
2
桂林航天工业学院毕业设计论文
目录
引言 ........................................................................................................................................... 6 1.1 开发背景 ........................................................................................................................ 6 1.2 系统构架 ........................................................................................................................ 6 1.3 系统目标 ........................................................................................................................ 6 第二章 选题的目的与意义 ................................................................................................... 7 2.1国内外研发现状 ............................................................................................................. 7 2.2课题研究的目的 ............................................................................................................. 8 2.3课题研究的意义 ............................................................................................................. 8 第三章 课题的可行性分析 ................................................................................................... 9 3.1 课题调研 ........................................................................................................................ 9 3.2 需求分析 ........................................................................................................................ 9 3.2可行性分析 ..................................................................................................................... 9 3.3系统配置需求 ............................................................................................................... 10 第四章 主要技术介绍 ........................................................................................................... 11 4.1 J2EE概述 ...................................................................................................................... 11 4.2 J2EE的优势 .................................................................................................................. 11 4.3JavaScript介绍 .............................................................................................................. 12 4.4 框架的选择 .................................................................................................................. 12 4.4.1 Struts2简介 ........................................................................................................... 12 4.4.2 Hibernate简介 ........................................................................................................... 13 4.4.3 Spring简介 ................................................................................................................ 13 第五章 系统开发工具及容器 ........................................................................................... 15 5.1 开发工具 .................................................................................................................. 15 5.2 数据库的选择 .......................................................................................................... 15 5.2.1 SQL Server 2008 简介 ............................................................................................ 15 5.3 JDK版本的选择 ........................................................................................................... 16 5.4 容器 .............................................................................................................................. 16 5.4.1 Tomcat简介 ........................................................................................................... 16 第六章 网络选课系统总体设计 ........................................................................................... 17
3
桂林航天工业学院毕业设计论文
6.1 需求分析 .................................................................................................................. 17 6.1.2 系统流程 ............................................................................................................... 17 6.1.3 用UML用例图描述 ................................................................................................ 19 6.2系统的分层设计 ........................................................................................................... 20 第七章 详细设计 ............................................................................................................... 21 7.1 数据库 .......................................................................................................................... 21 7.1.1 数据库设计 ........................................................................................................... 21 7.1.2 数据表 ................................................................................................................... 21 7.2 Web层的设计............................................................................................................... 23 7.2.1 JSP简介 ..................................................................................................................... 23 7.2.2 ExtJS简介 .................................................................................................................. 24 7.2.3 字符集编码问题 ................................................................................................. 24 7.3 EJB层的设计 ............................................................................................................... 24 7.3.1 实体Bean的设计 ............................................................................................... 24 7.3.2 数据库映射与连接 ............................................................................................. 26 7.4 网络选课系统的实现 .................................................................................................. 27 7.4.1 用户登录 ............................................................................................................... 27 7.4.2 权限管理 ............................................................................................................... 30 7.4.3 管理员功能 ............................................................................................................... 31 7.4.4 学生功能 ................................................................................................................. 38 7.4.5 教师功能 ............................................................................................................. 42 第8章 网络选课系统的性能优化方案 ............................................................................... 44 8.1 基于软件的优化措施 ................................................................................................. 44 8.1.1 Tomcat服务器性能调优 .................................................................................... 44 8.1.2 Java虚拟机性能调优 ........................................................................................ 45 8.1.3 操作系统性能调优 ............................................................................................. 46 8.1.4 数据库服务器性能调优 ..................................................................................... 46 8.2基于硬件的优化措施 ................................................................................................... 47 8.2.1服务器性能优化 .................................................................................................. 47 8.2.2 Web服务器集群技术 .......................................................................................... 48
4