updateaction.java

一个学生选课系统

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.student.action;

import java.io.UnsupportedEncodingException;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;

import com.student.DB.Md5;
import com.student.dao.BackLog;
import com.student.dao.BakMysql;
import com.student.dao.DataOperate;
import com.student.po.Course;
import com.student.po.Student;
import com.student.po.Teacher;


public class UpdateAction extends DispatchAction {
	//查看日志
	public ActionForward getLog(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws SQLException 
	{
		ArrayList logs=BakMysql.getLog();
		System.out.println("qqqqqqqqqqqqqqqq");
		HttpSession session=request.getSession();
		session.setAttribute("logs", logs);
		return new ActionForward("/logs.jsp");
	}
	//退选课
	public ActionForward exitCourse(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) 
	throws UnsupportedEncodingException 
	{
		System.out.println("hfusdhfusdhfus");
		HttpSession session=request.getSession();
		Student stu = (Student) session.getAttribute("stu");
		String sid=stu.getId();
		ArrayList score = (ArrayList) stu.getScore();
		
		ArrayList Cid=new ArrayList();//存储所选择的课程
		for(int i=0;i<score.size();i++){	
			String str=request.getParameter("checkbox"+i);
			if(str!=null){ Cid.add(str);System.out.println(str);}//
		}
		DataOperate.exitCourse(Cid,sid);
		Student student=DataOperate.personInfo(sid);
		session.setAttribute("stu", student);
		return new ActionForward("/student.jsp");
	}
	//添加一名教师
	public ActionForward addTeacher(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) 
			throws UnsupportedEncodingException {
		System.out.println("wwwwwwwwwwwww");
		String tid=request.getParameter("tid");
		//System.out.println(tid);
		String name=request.getParameter("tname");
		String password=request.getParameter("tpass");
		//System.out.println(sid+sname+sage+ssex+sdept);
		
		//Md5 md = new Md5();		
	    //String md5pass=	md.md5(password);
	    
//	    System.out.println(username);
//	    System.out.println(md5pass);
		String rt=request.getParameter("root");
		int root=0;
		if(rt==null||rt.equals(""))
	          root=0;
		else root=Integer.parseInt(rt);
		boolean bool = DataOperate.insertTeacherInfo(tid, name, password, root);
		String result;
		System.out.println(bool);
		if(bool)
		{
			result="添加教师信息成功";
			request.setAttribute("result",result);
			ArrayList teachers=DataOperate.getAllTeacher();
			HttpSession session=request.getSession();
			session.setAttribute("teachers", teachers);
			return new ActionForward("/root_teacher.jsp");
		}
		else
		{
			result="该教师已存在！";
			request.setAttribute("result",result);
			ArrayList teachers=DataOperate.getAllTeacher();
			HttpSession session=request.getSession();
			session.setAttribute("teachers", teachers);
			return new ActionForward("/rootteacher.jsp");
		}	
	}
	//查询所有教师信息
	public ActionForward queryAllTeacher(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
	{
		ArrayList teachers=DataOperate.getAllTeacher();
		HttpSession session=request.getSession();
		session.setAttribute("teachers", teachers);
	    return new ActionForward("/root_teacher.jsp");
	}
	//查询某个教师信息
	public ActionForward queryTeacher(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
	{
		String tid = request.getParameter("tid");
		Teacher teacher=DataOperate.getTeacherInfo(tid);
		System.out.println(teacher.getId());
		request.setAttribute("teacher", teacher);
	    return new ActionForward("/teachetInfo.jsp");
	}
	//修改某个教师信息
	public ActionForward alterTeacher(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
	{
		String tid=request.getParameter("tid");
		System.out.println(tid);
		String name=request.getParameter("name");
		int root=Integer.parseInt(request.getParameter("root"));
		HttpSession session=request.getSession();
		int usr=Integer.parseInt((String) session.getAttribute("root"));
		if(usr>root)
		{
		     boolean bool = DataOperate.alterTeacherInfo(tid, name, root);
		     ArrayList teachers=DataOperate.getAllTeacher();				
			 session.setAttribute("teachers", teachers);
			 return new ActionForward("/root_teacher.jsp");
		}
		else{
			String result="你没有权限修改";
			session.setAttribute("result", result);
			ArrayList teachers=DataOperate.getAllTeacher();
			
			session.setAttribute("teachers", teachers);
		    return new ActionForward("/root_teacher.jsp");
		}
		
	}
	//删除某个教师信息
	public ActionForward deleteTeacher(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
	{
		HttpSession session=request.getSession();
		String tid=request.getParameter("usr");
		System.out.println("wwwwwwwwwwwwwwwwwww"+tid);
		//int rt=Integer.parseInt(request.getParameter("rt"));
		int root=Integer.parseInt((String) session.getAttribute("root"));
		boolean bool=DataOperate.deleteTeacher(tid,root);
		if(bool)
		{
			String result="删除成功!";
			request.setAttribute("result", result);
			ArrayList teachers=DataOperate.getAllTeacher();
			session.setAttribute("teachers", teachers);
			return new ActionForward("/root_teacher.jsp");
		}
		else
		{
			String result="你没有权限，或者没有该用户!";
			request.setAttribute("result", result);
			ArrayList teachers=DataOperate.getAllTeacher();
			session.setAttribute("teachers", teachers);
			return new ActionForward("/root_teacher.jsp");
		}
	}
	//查询某个学生信息
	public ActionForward queryStudent(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		String usr = request.getParameter("usr");
		//System.out.println(usr);
		Student stu = DataOperate.personInfo(usr);
		if(stu.getId()==null)
		{
		     String 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");
		}
		else{
			request.setAttribute("stu", stu);
			return new ActionForward("/studentInfo.jsp");
		}
	}
	//删除某一条学生记录
	public ActionForward deleteStudent(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) 
			throws UnsupportedEncodingException {
		// TODO Auto-generated method stub
		String usr = request.getParameter("usr");
		String sname = request.getParameter("sname");
		//System.out.println(sname);
		//System.out.println("houhou"+usr);
		boolean bool = DataOperate.deletePersonInfo(usr);
		String result="";
		if(bool==false)  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 insertStudent(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) 
			throws UnsupportedEncodingException {
		System.out.println("wwwwwwwwwwwww");
		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+sname+sage+ssex+sdept);
		
		String password = "111111";
		
		//Md5 md = new Md5();		
	    //String md5pass=	md.md5(password);
	    
//	    System.out.println(username);