高校在线答疑系统的设计与实现

高校在线答疑系统的设计与实现高校在线答疑系统的设计与实现摘要随着高校内学生人数的日益增长，教师和上课地点的不断变动使得学生和老师之间的交流受时间和空间限制，导致师生间的答疑工作难以开展。为此开发一个高校在线答疑系统大有裨益。本系统是基于B/S架构，使用JSP、SERVLET、JAVASCRIPT作为编程语言，结合MYSQL数据库和JavaWeb开发的三层架构来实现学生模块、教师模块和管理员模块功能。学生模块主要功能包括学生对某位老师或所有老师提问、下载学习资料、查看并修改信息及根据提问数对学生进行排名。教师模块主要功能包括回答问题并获得积分、上传资料、按积分对教师进行排名。管理员模块主要功能包括对问题、学院、专业和用户的管理操作。其中三层架构将整个系统划分为界面层、业务逻辑层和数据访问层，分层目的在于实现“高内聚低耦合”思想。目前，大部分高校的答疑模块都是内嵌在网络教学系统中，独立存在的不多。本系统主要作用于学生和教师之间的答疑互动，其特点有回答质量高，利于用户管理所有提问或回答信息。关键词：答疑系统；B/S架构；三层架构高校在线答疑系统的设计与实现DESIGNANDIMPLEMENTATIONOFONLINEQUESTIONANSWERINGSYSTEMINUNIVERSITIESABSTRACTWiththeincreasingnumberofstudentsandcontinuouschangeofteachets,coursesandclassroom,thecommunicationbetweenstudentsandteachersbytimeandspaceconstraints,whichresultinginaQ&Abetweenteachersandstudentsisdifficulttocarryout.Soitisusefultodevelopanonlinequestionansweringsysteminuniversities.Thecompletionofstudentmudule,teachermoduleandadministratormoduleisbasedonJSP,SERVLET,JAVASCRIPTprogramminglanguageandMYSQLandthreetierarchitectureofJavaWeb.ThemainfunctionofStudentmoduleincludesastudentaskquestionstooneparticularteacherorallteachers,downloadlearningfiles,viewandmodifythebaseinformation,rankstudentaccordingtotheirnumberofquestions.Themainfunctionofteachermoduleincludesanswerquestionsandgetpoints,uploadfiles,rankteacheraccordingtothetheirpoints.Administratormodulemainfunctionsincludeproblemmanagement,collegemanagement,professionalmanagementandusermanagement.Thesystemisdividedintointerfacelayer,businesslogiclayeranddataaccesslayer,thepurposeistodeepenthehighcohesionandlowcouplingidea.Atpresent,mostofthequestionandanswermoduleisembeddedinthenetworkteachingsystem,therearenotmanyindependentsystem.Theaimofthissystemistointeractwithstudentsandteachers.Itsfeaturesarehighquality,tohelpusersmanageallquestionsoranswers.Keywords:questionansweringsystem;B/Sstructure;Threetierarchitecture高校在线答疑系统的设计与实现目录1绪论..................................................................51.1研究背景及意义...................................................51.2研究现状及发展趋势...............................................51.3论文主要内容.....................................................52系统及相关技术概述....................................................92.1系统概述.........................................................92.2开发环境.........................................................92.3相关技术........................................................102.3.1MYSQL数据库介绍...........................................102.3.2JSP语言介绍...............................................102.3.2SERVLET技术介绍...........................................102.3.4JAVASCRIPT脚本语言介绍....................................113系统的总体设计.......................................................123.1需求分析........................................................123.2系统架构........................................................133.3模块设计........................................................143.4数据库设计......................................................164系统的实现...........................................................204.1学生模块功能的实现..............................................224.1.1提出问题..................................................224.1.2查看我的提问..............................................234.1.3采纳答案..................................................254.1.4学生提问数排名............................................264.1.5下载资料..................................................264.2教师模块功能的实现..............................................274.2.1解答问题..................................................274.2.2查看我的回答..............................................284.2.3教师积分排名..............................................284.2.4上传资料..................................................294.3管理员模块功能的实现............................................304.3.1问题管理...................................................304.3.2学院管理..................................................314.3.3专业管理..................................................324.3.4用户管理..................................................334.4通用功能的实现..................................................344.4.1登录......................................................344.4.2注销......................................................35高校在线答疑系统的设计与实现4.4.3找回密码..................................................354.4.4修改信息..................................................355系统测试.............................................................375.1系统测试目的....................................................375.2子模块测试......................................................375.2.1学生模块..................................................375.2.2教师模块..................................................425.2.2管理员模块................................................435.2.3通用功能测试..............................................516总结与展望...........................................................566.1总结............................................................566.2展望............................................................56参考文献.............................................................