updateaction.java

一个学生选课系统

//	    System.out.println(md5pass);
	    
		boolean bool=DataOperate.insertStuInfo(sid, name, age, sex, dept,password);
		String result;
		if(bool)
		{
			result="添加学生成功";
			request.setAttribute("result",result);
			
			HttpSession session = request.getSession();
			session.removeAttribute("students");
			ArrayList students = DataOperate.getAllStudentInfo();
			session.setAttribute("students", students);
			
		     String root=(String)session.getAttribute("root");
		     if(root.equals("0"))
		          return new ActionForward("/teacher.jsp");
		     else
		    	  return new ActionForward("/root.jsp");
		}
		else
		{
			result="该学生已存在！";
			request.setAttribute("result",result);
			HttpSession session=request.getSession();
		     String root=(String)session.getAttribute("root");
		     if(root.equals("0"))
		          return new ActionForward("/teacher.jsp");
		     else
		    	  return new ActionForward("/root.jsp");
		}	
	}
	//修改某个学生信息
	public ActionForward alterStudent(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		String sid=request.getParameter("usr");
		System.out.println(sid);
		String name=request.getParameter("sname");
		int age=Integer.parseInt(request.getParameter("sage"));
		String sex=request.getParameter("ssex");
		String dept=request.getParameter("sdept");
		System.out.println(sid+name+age+sex+dept);
		boolean bool=DataOperate.alterStuInfo(sid, name, age, sex, dept);
		String result;
		if(bool)
		{
			result="修改学生资料成功！";
			request.setAttribute("result",result);
			
			HttpSession session = request.getSession();
			session.removeAttribute("students");
			ArrayList students = DataOperate.getAllStudentInfo();
			session.setAttribute("students", students);
			
		     String root=(String)session.getAttribute("root");
		     if(root.equals("0"))
		          return new ActionForward("/teacher.jsp");
		     else
		    	  return new ActionForward("/root.jsp");
		}
		else
		{
			result="修改学生资料失败！";
			request.setAttribute("result",result);
			
			HttpSession session = request.getSession();
			session.removeAttribute("students");
			ArrayList students = DataOperate.getAllStudentInfo();
			session.setAttribute("students", students);
			
		     String root=(String)session.getAttribute("root");
		     if(root.equals("0"))
		          return new ActionForward("/teacher.jsp");
		     else
		    	  return new ActionForward("/root.jsp");
		}
	}
	//查询某个课程信息
	public ActionForward queryCourse(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		System.out.println("queryCourse");
		String cid = request.getParameter("cid");
		Course course=(Course)DataOperate.courseInfo(cid);
		String result;
		if(course.getId()!=null)
		{
			
			HttpSession session=request.getSession();
			session.setAttribute("course", course);
			return new ActionForward("/courseInfo.jsp");
		}
		else
		{
			result="没有该课程信息!";
			request.setAttribute("result",result);
		      
		      ArrayList courses = DataOperate.getAllCourse();
		      HttpSession session = request.getSession();
		      session.removeAttribute("courses");
		      session.setAttribute("courses", courses);
		      
			     String root=(String)session.getAttribute("root");
			     if(root.equals("0"))
			          return new ActionForward("/teacher_course.jsp");
			     else
			    	  return new ActionForward("/root_course.jsp");
		}
	}
	//删除某门课程信息
	public ActionForward deleteCourse(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		System.out.println("deleteCourse");
		String cid = request.getParameter("cid");
		//String sname = request.getParameter("sname");
		//System.out.println(sname);
		//System.out.println("houhou"+usr);
		boolean bool = DataOperate.deleteCourse(cid);
		String result="";
		if(bool==false)  
			{
			      result="没有改课程！";
			      request.setAttribute("result",result);
			      
			      ArrayList courses = DataOperate.getAllCourse();
			      HttpSession session = request.getSession();
			      session.removeAttribute("courses");
			      session.setAttribute("courses", courses);
			      
				     String root=(String)session.getAttribute("root");
				     if(root.equals("0"))
				          return new ActionForward("/teacher_course.jsp");
				     else
				    	  return new ActionForward("/root_course.jsp");
			}
		else{
			result="删除课程成功！";
		    request.setAttribute("result",result);
		    ArrayList courses = DataOperate.getAllCourse();
		    HttpSession session = request.getSession();
		    session.removeAttribute("courses");
		    session.setAttribute("courses", courses);
		   
		     String root=(String)session.getAttribute("root");
		     if(root.equals("0"))
		          return new ActionForward("/teacher_course.jsp");
		     else
		    	  return new ActionForward("/root_course.jsp");
		}
	}
	//添加一门课程
	public ActionForward addCourse(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		System.out.println("addCourse");
		String cid=request.getParameter("cid");
		String cname=request.getParameter("cname");
		String cteacher=request.getParameter("cteacher");
		String cdept=request.getParameter("cdept");
		System.out.println(cid+cname+cteacher+cdept);
		boolean bool=DataOperate.addCourse(cid,cname,cdept,cteacher);
		String result;
		if(bool)
		{
			result="添加课程成功！";
			request.setAttribute("result", result);
			ArrayList courses = DataOperate.getAllCourse();
			HttpSession session = request.getSession();
            session.removeAttribute("courses");
			session.setAttribute("courses", courses);
			//request.setAttribute("courses", courses);
			
		     String root=(String)session.getAttribute("root");
		     if(root.equals("0"))
		          return new ActionForward("/teacher_course.jsp");
		     else
		    	  return new ActionForward("/root_course.jsp");
		}
		else
		{
			result="该课程已存在！";
			request.setAttribute("result", result);
			ArrayList courses = DataOperate.getAllCourse();
			HttpSession session = request.getSession();
            session.removeAttribute("courses");
			session.setAttribute("courses", courses);
			//request.setAttribute("courses", courses);
			
		     String root=(String)session.getAttribute("root");
		     if(root.equals("0"))
		          return new ActionForward("/teacher_course.jsp");
		     else
		    	  return new ActionForward("/root_course.jsp");
		}
	}
	//修改某门课程信息
	public ActionForward alterCourse(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		String cid=request.getParameter("cid");
		System.out.println(cid);
		String cname=request.getParameter("cname");
		String cdept=request.getParameter("cdept");
		String teacher=request.getParameter("teacher");
		//System.out.println(sid+name+age+sex+dept);
		boolean bool=DataOperate.alterCourseInfo(cid, cname,cdept, teacher);
		String result;
		if(bool)
		{
			result="修改课程资料成功！";
			request.setAttribute("result",result);
			
			ArrayList courses = DataOperate.getAllCourse();
			HttpSession session = request.getSession();
            session.removeAttribute("courses");
			session.setAttribute("courses", courses);
			//request.setAttribute("courses", courses);
			
		     String root=(String)session.getAttribute("root");
		     if(root.equals("0"))
		          return new ActionForward("/teacher_course.jsp");
		     else
		    	  return new ActionForward("/root_course.jsp");
		}
		else
		{
			result="修改课程资料失败！";
			request.setAttribute("result",result);
			
			ArrayList courses = DataOperate.getAllCourse();
			HttpSession session = request.getSession();
            session.removeAttribute("courses");
			session.setAttribute("courses", courses);
			//request.setAttribute("courses", courses);
			
		     String root=(String)session.getAttribute("root");
		     if(root.equals("0"))
		          return new ActionForward("/teacher_course.jsp");
		     else
		    	  return new ActionForward("/root_course.jsp");
		}
	}
}