JSP课程设计报告学生成绩管理系统

..>课程设计说明书课程设计名称：Web课程设计课程设计题目：学生成绩管理系统学院名称：信息工程学院专业：计算机科学与技术班级：110451**：：评分：教师：2014年6月15日1.选题的目的和意义1.2课程来源、目的与意义〔2〕对各个数据库能进展动态管理，有效的防止了数据的混乱。〔3〕能够按照用户选择的不同的条件进展简单查询和复合查询。2.系统的开发技术及主要架构2.2工程开发的工具2.2.4Tomcat简介2.3数据库的连接3.需求分析图3-1功能模块图3.2.1系统流程图3-2选课系统流程图3.2.2登录流程图3-3登录流程图3.3系统概念模型描述3.3.2系统E-R图图4-1登录页面图4-2管理员修改密码图4-2管理员修改密码4.1.1教师信息管理添加教师的操作界面如图4-3所示。publicvoiddoPost(ServletRequestrequest,ServletResponseresponse)throwsServletE*ception,IOE*ception{ response.setContentType("te*t/html;charset=utf-8"); PrintWriterout=response.getWriter(); request.setCharacterEncoding("utf-8"); Stringtid=request.getParameter("tid"); Patternpattern=Patternpile("[0-9]*"); MatcherisNum=pattern.matcher(tid);if(!isNum.matches()){ JOptionPane.showMessageDialog(null,"教师工号必须由数字组成！！！","警告",1); out.print("教师工号输入错误！正在返回，请稍候……"); response.setHeader("refresh","1;url=/stu_score_ms/manager/addteacher.jsp");return; //不加return为何会继续执行后面代码？？？ }teachertea=newteacher();if(tea.isValid(tid)){ JOptionPane.showMessageDialog(null,"该教师工号已经存在！！！","警告",1); response.setHeader("refresh","1;url=/stu_score_ms/manager/addteacher.jsp");return; }intn=JOptionPane.showConfirmDialog(null,"确认添加"","确认框",JOptionPane.YES_NO_OPTION);if(n!=0){ out.print("取消添加！正在返回，请稍候……"); response.setHeader("refresh","1;url=/stu_score_ms/manager/showteacher.jsp");return; //不加return为何会继续执行后面代码？？？publicvoiddoPost(ServletRequestrequest,ServletResponseresponse)throwsServletE*ception,IOE*ception{ request.setCharacterEncoding("utf-8"); response.setContentType("te*t/html;charset=utf-8"); PrintWriterout=response.getWriter(); Stringtid,tname,password; tid=request.getParameter("t_id"); intn=JOptionPane.showConfirmDialog(null,"确认修改"","确认框",JOptionPane.YES_NO_OPTION);if(n!=0){ out.print("取消修改！正在返回，请稍候……"); response.setHeader("refresh","1;url=/stu_score_ms/manager/showteacher.jsp");return; //不加return为何会继续执行后面代码？？？ } tname=request.getParameter("tname"); password=check.makeMD5(request.getParameter("password"));//if(hasE*ist(request,response,*uehao)==false){ teachertea=newteacher(); tea.setId(tid); tea.setName(tname); tea.setPassword(password); tea.updateTeacher(); out.print("教师修改成功！正在返回，请稍候……"); response.setHeader("refresh","1;url=/stu_score_ms//manager/showteacher.jsp");publicvoiddoGet(ServletRequestrequest,ServletResponseresponse)throwsServletE*ception,IOE*ception{ response.setContentType("te*t/html;charset=utf-8"); PrintWriterout=response.getWriter(); request.setCharacterEncoding("utf-8");intn=JOptionPane.showConfirmDialog(null,"确认删除"","确认框",JOptionPane.YES_NO_OPTION);if(n!=0){ out.print("取消删除！正在返回，请稍候……"); response.setHeader("refresh","1;url=/stu_score_ms/manager/showteacher.jsp");return; //不加return为何会继续执行后面代码？？？ } Stringtid; tid=request.getParameter("t_id"); teachertea=newteacher(); tea.deleteTeacher(tid); out.print("删除教师成功，正在返回……"); response.setHeader("refresh","1;url=/stu_score_ms/manager/showteacher.jsp");return;4.1.2成绩排名按课程查询学生成绩排名的界面如图4-5所示。图4-5按课程查询学生排名局部源代码：Stringsql="selectstudent.id,student.sname,student.smajor,ame,score.grade,score.jpafromscore,studentwherescore.cid='"+cid+"'andscore.sid=student.idgroupbyjpaDESC";图4.6按专业查询学生排名局部源代码：Stringsql="selectstudent.id,student.sname,student.sclass,rank.averagepointfromstudent,rankwherestudent.smajor='"+smajor+"'andrank.sid=student.idgroupbyaveragepointDESC";总结参考文献苗连强，王国辉等编著．JSP程序设计根底教程．人民邮电出版社出版发行王珊，萨师煊编著．数据库系统概论．北京高等教育出版社李振捷，王军编著．JSP网站开发典型模块与实例精．电子工业出版社孙涌．现代软件工程．北京希望电子出版社,2003萨师煊，王珊．数据库系统概论．高等教育出版社，2002陈雄，宋来等编著．Ja