addeleteaction.java

这是一个可以让学生选择自己喜欢的课题

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

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import allBeans.FstBean;
import allBeans.LstBean;
import allBeans.Tittles;
import allBeans.Students;
import allDAOFactory.IAdministratorDAO;
import allDAOFactory.IFirstStudentTittleDAO;
import allDAOFactory.ILastStudentTittleDAO;
import allDAOFactory.IStudentDAO;
import allDAOFactory.ITaskDAO;
import allDAOFactory.ITeacherDAO;
import allDAOFactory.ITittleDAO;

/** 
 * MyEclipse Struts
 * Creation date: 07-23-2008
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 */
public class AddeleteAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		String loginkey=request.getParameter("loginkey");
		if(loginkey.equals("student"))
		{
			String id=request.getParameter("id");
			IStudentDAO stdao=new IStudentDAO();
		    stdao.stdelete(id);
			List list=stdao.stget();
			request.setAttribute("stlist", list);
			return mapping.findForward("toadstudent");
		}
		else if(loginkey.equals("teacher"))
		{
			String id=request.getParameter("id");
			ITeacherDAO thdao=new ITeacherDAO();
			thdao.thdelete(id);
			List list=thdao.thget();
			request.setAttribute("thlist", list);
			return mapping.findForward("toadteacher");
		}
		else if(loginkey.equals("tittle"))
		{
			Integer id=Integer.parseInt(request.getParameter("id")); 
			ITittleDAO tidao=new ITittleDAO();
			tidao.tidelete(id);
			List list=tidao.tiget();
			request.setAttribute("tilist", list);
			return mapping.findForward("toadtittle");
		}
		else if(loginkey.equals("admin"))
		{
			String id=request.getParameter("id");
			String ad_id=id;
			IAdministratorDAO addao=new IAdministratorDAO();
			addao.addelete(ad_id);
			addao=new IAdministratorDAO();
			List list=addao.adget();
			request.setAttribute("adlist", list);
			return mapping.findForward("toadadmin");
		}
		else if(loginkey.equals("task"))
		{
			String id=request.getParameter("id");
			ITaskDAO tadao=new ITaskDAO();
			tadao.tadelete(id);
			System.out.println(id);
			List list=tadao.taget();
			request.setAttribute("talist", list);
			return mapping.findForward("toadtask");
		}
		else if(loginkey.equals("fst"))
		{		
			String sfiid=request.getParameter("fiid");
			Integer fiid=Integer.parseInt(sfiid);
			IFirstStudentTittleDAO fstdao=new IFirstStudentTittleDAO();
			String stid=fstdao.fstgetbyfiid(fiid).getFiStid(); //根据fiid得到要删除的关系中的学生id
			Integer tiid=fstdao.fstgetbyfiid(fiid).getFiTiid();//根据fiid得到要删除的关系中的题目id
			fstdao.fstdelete(fiid);
	        
			//使题目的被选人数减1 
			ITittleDAO tidao=new ITittleDAO();
			Tittles tittle=tidao.tiget(tiid);
			tittle.setTiStsum(tittle.getTiStsum()-1);
			tidao.tiupdate(tittle);
			
			//将学生的选题数目减1			
			IStudentDAO stdao=new IStudentDAO();
			Students st=stdao.stget(stid);
			st.setStTisum(st.getStTisum()-1);
			stdao.stupdate(st);

			//得到返回界面的显示信息
			fstdao=new IFirstStudentTittleDAO();
			List list=fstdao.fstget();
			List lastlist=new ArrayList();
			FstBean temp=null;
			Iterator it=list.iterator();
			while(it.hasNext())
			{
				temp=new FstBean();
				Object[] result=(Object[])it.next();
				temp.setFiid(result[0].toString());
				temp.setStid(result[1].toString());
				temp.setStname(result[2].toString());
				temp.setTiid(result[3].toString());
				temp.setTiname(result[4].toString());
				lastlist.add(temp);
				
			}
			request.setAttribute("fstlist", lastlist);
			return mapping.findForward("toadfirstresult");
		}
		else if(loginkey.equals("lst"))
		{
			String stid=request.getParameter("id");
			ILastStudentTittleDAO lstdao=new ILastStudentTittleDAO();
			Integer tiid=lstdao.lstget(stid).getLaThid(); //根据stid得到要删除关系中的题目id
			lstdao.lstdelete(stid);  //根据id删除这个关系
			
			/* 学生表中的选题数目 和 题目表中的选择人数只与预选有关，与补选无关，即与最后选定表无关
			//重新设置题目的被选人数
			ITittleDAO tidao=new ITittleDAO();
			Tittles tittle=tidao.tiget(tiid);
            tittle.setTiStsum(tittle.getTiStsum()-1);
			tidao.tiupdate(tittle);

			//将学生的选题数目置0
			IStudentDAO stdao=new IStudentDAO();
			Students st=stdao.stget(stid);
			st.setStTisum(0);
			stdao.stupdate(st);
			*/
			
			List list=lstdao.lstget();
			List lastlist=new ArrayList();
			LstBean temp=null;
			Iterator it=list.iterator();
			while(it.hasNext())
			{
				temp=new LstBean();
				Object[] result=(Object[])it.next();
				temp.setStid(result[0].toString());
				temp.setStname(result[1].toString());
				temp.setTiid(result[2].toString());
				temp.setTiname(result[3].toString());
				lastlist.add(temp);
				
			}
			request.setAttribute("lstlist", lastlist);
			return mapping.findForward("toadlastresult");
		}
		else
		{
			return mapping.getInputForward();
		}
	}
}