www.pudn.com > onlineexam.zip > RemoveQuestionAction.java

package org.mmxbb.exam.business.paper; 
 
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 org.mmxbb.exam.dao.ExaminationPaperDAO; 
import org.mmxbb.exam.dao.ExaminationPaperDetailDAO; 
import org.mmxbb.exam.dao.TestPaperDAO; 
import org.mmxbb.exam.dao.TestPaperDetailDAO; 
 
import java.util.Vector; 
import java.sql.*; 
 
 
 
public class RemoveQuestionAction 
    extends Action { 
  public ActionForward execute(ActionMapping actionMapping, 
                               ActionForm actionForm, 
                               HttpServletRequest httpServletRequest, 
                               HttpServletResponse httpServletResponse) { 
    long e_id = 0; 
    long t_id = 0; 
    ExaminationPaperDAO epDAO = null; 
    ExaminationPaperDetailDAO examinationPaperDetailDAO = null; 
    TestPaperDAO testPaperDAO = null; 
    TestPaperDetailDAO testPaperDetailDAO = null; 
    Vector t_idVector = null; 
    
    e_id = Long.parseLong(httpServletRequest.getParameter("e_id")); 
     
    epDAO = new ExaminationPaperDAO(); 
    epDAO.removeExaminationPaper(e_id); 
 
    examinationPaperDetailDAO = new ExaminationPaperDetailDAO(); 
    examinationPaperDetailDAO.removeExaminationPaperDetail_byE_id(e_id); 
 
   
    t_idVector = new Vector(); 
    try { 
      testPaperDAO = new TestPaperDAO(); 
      t_idVector = testPaperDAO.getT_idList(e_id); 
    } catch (SQLException ex) { 
      ex.printStackTrace(); 
    } 
    testPaperDAO = new TestPaperDAO(); 
    testPaperDAO.removeTestPaper_byE_id(e_id); 
 
      int i = 0; 
      while(i < t_idVector.size()){ 
        t_id = java.lang.Long.parseLong(t_idVector.elementAt(i).toString()); 
        testPaperDetailDAO = new TestPaperDetailDAO(); 
        testPaperDetailDAO.removeByT_id(t_id); 
        i++; 
      } 
 
    String jsp = "e_list"; 
    httpServletRequest.setAttribute("jsp", jsp); 
    return actionMapping.findForward("searchaction"); 
  } 
}