搜索
学生信息管理系统项目系统功能说明书文档作者：项目组长：批准人：批准日期：目录1系统的实现...................................................................31.1登录页面的实现.........................................................31.2学生界面功能实现.......................................................51.2.1修改密码界面.....................................................51.2.2学籍信息维护界面.................................................71.2.3修改学生信息界面.................................................81.2.4添加学生信息界面................................................101.2.5查看并修改选课界面..............................................111.2.6添加学生选课课表................................................131.2.7添加学生成绩....................................................131.2.8修改选课信息....................................................152系统的测试..................................................................182.1测试概述.............................................................182.1.1测试目的........................................................182.1.2测试范围........................................................182.1.3测试计划执行情况................................................192.2测试用例.............................................................192.2.1用户名实例......................................................192.2.2学号实例........................................................202.2.3密码实例........................................................202.3测试结果.............................................................2031系统的实现1.1登录页面的实现该页面是进入学生信息管理系统的入口，用户首先在该页面中输入“用户名”和“密码”，然后选择登录身份，点击”提交”，系统将该页面的表单提交给login.jsp，如果输入学号和密码有错误，则系统提示”输入的学号或密码错误”，并重定向至login.jsp，要求用户重新填写学号和密码。登录界面如下图5-1所示：图5-1系统登录界面Login.jsp页面代码：%@pagecontentType=text/html;charset=GB2312%%@pageimport=java.sql.*%%@pagelanguage=java%%@pageimport=java.util.*%%@pageimport=yu.*%jsp:useBeanid=ascope=pageclass=yu.dbconn/htmlheadtitle身份验证/title4/headbody%request.setCharacterEncoding(GBK);if(sel.equals(student)){sql=SELECT*FROMstudentwherestu_id='+user+'andpassword='+pwd+';URL=student.jsp;ResultSetrs=stmt.executeQuery(sql);if(rs.next()){Stringa=rs.getString(name);request.getSession(true);session.setAttribute(name,a);session.setAttribute(id,user);response.sendRedirect(URL);}elseresponse.sendRedirect(error.jsp);}elseif(sel.equals(admin)){sql=SELECT*FROMadminwhereadmin_id='+user+'andpassword='+pwd+';URL=admin.jsp;ResultSetrs=stmt.executeQuery(sql);if(rs.next()){request.getSession(true);session.setAttribute(id,user);response.sendRedirect(URL);}elseresponse.sendRedirect(error.jsp);}//使用executeQuery执行SQL查询语句%5/body/html1.2学生界面功能实现1.2.1修改密码界面在学生主页面中有学生所需要的一些功能，如修改自己的登入密码，查看学籍并进行修改，查看选修课表并进行选修，查看已选课程并可修改学生修改密码页面如下图5-2示：图5-2修改密码界面Change.Jsp页面：bodybgcolor=#ffffff%request.setCharacterEncoding(GBK);Stringpwd=;Stringnumber=(String)session.getAttribute(id);Stringsql=;sql=SELECT*FROMstudentwherestu_id='+number+';ResultSetrs=a.executeQuery(sql);if(rs.next()){pwd=rs.getString(password);}%SCRIPTLANGUAGE=javascriptfunctionb(){if(form2.pwd1.value!=%=pwd%||form2.pwd1.value==){alert(输入的原始密码不正确，请重新输入);6form2.pwd1.focus();returnfalse;}if(form2.pwd2.value==){alert(请输入新密码);form2.pwd2.focus();returnfalse;}elseif(form2.pwd2.value!=form2.pwd3.value){alert(两次输入的新密码不同，请重新输入);form2.pwd3.focus();returnfalse;}else{alert(密码修改成功);returntrue;}returntrue;}/SCRIPT以输入一个密码修改框的table已删，下面是修改后把新密码导入数据库：Change_pwd.jsp页面代码：bodybgcolor=#ffffff%request.setCharacterEncoding(GBK);Stringsql=;Stringpassword=request.getParameter(pwd2);Stringnumber=(String)session.getAttribute(id);sql=updatestudentsetpassword='+password+'wherestu_id='+number+';a.executeUpdate(sql);response.sendRedirect(welcome.jsp);%71.2.2学籍信息维护界面界面实现如图5-3所示：图5-3学籍信息界面学籍维护页面代码主要有两个页面来实现：Xueji.jsp页面：用来显示已有信息，并能让学生进行修改提交；change_xueji.jsp页面用来把学生新提交信息保存到数据库中：Change_xueji.jsp页面代码：%request.setCharacterEncoding(GBK);Stringsql=;Stringxuehao=(String)session.getAttribute(id);Stringcym=request.getParameter(cym);8Stringsfz=request.getParameter(sfz);Stringcsrq=request.getParameter(csrq);Stringjg=request.getParameter(jg);Stringjkzk=request.getParameter(jkzk);Stringrxnf=request.getParameter(rxnf);Stringjtdz=request.getParameter(jtdz);Stringjtdh=request.getParameter(jtdh);Stringyzbm=request.getParameter(yzbm);Stringbrlxfs=request.getParameter(brlxfs);Stringemail=request.getParameter(email);Stringqtlxfs=request.getParameter(qtlxfs);Stringbz=request.getParameter(bz);sql=updatestudentsetcym='+cym+',sfz='+sfz+',csrq='+csrq+',jg='+jg+',jkzk='+jkzk+',rxnf='+rxnf+',jtdz='+jtdz+',jtdh='+jtdh+',yzbm='+yzbm+',lxfs='+lxfs+',email='+email+',qtlxfs='+qtlxfs+',bz='+bz+'wherestu_id='+xuehao+';a.executeUpdate(sql);response.sendRedirect(xueji.jsp);%1.2.3修改学生信息界面界面实现如下图5-4所示：图5-4修改学生信息界面9该功能主要有xuesheng.jsp页面来完成。tablealign=centerborder=2width=100%bordercolorlight=#CC99FFcellpadding=2bordercolordark=#FFFFFFcellspacing=2%Stringid2=request.getParameter(id);Stringsql=select*fromstudentwherestu_id='+id2+';ResultSetrs=a.executeQuery(sql);while(rs.next()){%trtdalign=centercolspan=2fontcolor=bluesize=5b修改学生信息/font/tdtralign=ce