questionpaperaction.java

在线考试系统: 这是基于struts和Hibernate的最新技术的在线考试系统.数据库是MySql.能添加课程

/**
 * 
 */
package com.zjxy.hibernate.action;

import java.util.List;

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

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

import com.zjxy.hibernate.HibernateSessionFactory;
import com.zjxy.hibernate.base.PageDAO;
import com.zjxy.hibernate.base.QuestionPaperManager;
import com.zjxy.hibernate.form.QuestionPaperForm;
import com.zjxy.hibernate.pagerHelp.Pager;
import com.zjxy.hibernate.pagerHelp.PagerHelp;

/**
 * @author gradenarn
 *
 */
public class QuestionPaperAction extends DispatchAction{

	/**
	 * 试卷信息一览画面显示
	 * @param actionMapping
	 * @param actionForm
	 * @param httpServletRequest
	 * @param httpServletresponse
	 * @return
	 */
	 public ActionForward display(ActionMapping actionMapping,
             ActionForm actionForm,
             HttpServletRequest httpServletRequest,
             HttpServletResponse httpServletresponse) {
        
		 // 用于输出到页面的记录集合
        List clInfos = null;
        String sqlBean = "from com.zjxy.hibernate.model.QuestionPaper";
        // 记录总行数
        int totalRows = 0;
        
        Session session=HibernateSessionFactory.currentSession();
        
        List list = session.createQuery(sqlBean).list();
       
        HibernateSessionFactory.closeSession();
        
        totalRows = list.size();
        PageDAO pageDAO = new PageDAO();

        // 取得当前表中的总行数

        // 通过PagerHelper类来获取用于输出到页面的pager对象
        Pager pager=PagerHelp.getPager(httpServletRequest,totalRows);
       // 取出从startRow开始的pageSize行记录
        try {
            clInfos = pageDAO.findWithPage(pager.getPageSize(), pager.getStartRow(), sqlBean);
            } catch (Exception ex) {
                servlet.log(ex.toString());
         }
     

         //把输出的记录集和pager对象保存到request对象中
     
         httpServletRequest.setAttribute("CLINFOS", clInfos);
         httpServletRequest.setAttribute("PAGER", pager);
         

         return actionMapping.findForward("display");
}
	
	 /**
	 * 试卷信息查询
	 * @param actionMapping
	 * @param actionForm
	 * @param request
	 * @param response
	 * @return
	 */
 public ActionForward search(ActionMapping actionMapping,
         ActionForm form,
         HttpServletRequest request,
         HttpServletResponse response) {
	 	 QuestionPaperForm questionPaperForm = (QuestionPaperForm) form;
	 	QuestionPaperManager questionPaperManager = new QuestionPaperManager();
		 String name = questionPaperForm.getPaperNameSearch();
		 // 用于输出到页面的记录集合
	        List clInfos = null;
	        String sqlBean = "from com.zjxy.hibernate.model.QuestionPaper as questionPaper where questionPaper.name=?";
	        // 记录总行数
	        int totalRows = 0;
	        List list = questionPaperManager.getQuestionPaperList();
	        totalRows = list.size();
	        PageDAO pageDAO = new PageDAO();

	        // 取得当前表中的总行数

	        // 通过PagerHelper类来获取用于输出到页面的pager对象
	        Pager pager=PagerHelp.getPager(request,totalRows);

	        // 取出从startRow开始的pageSize行记录
	        try {
	            clInfos = pageDAO.findWithPage_search(pager.getPageSize(), pager.getStartRow(), sqlBean, name);
	            } catch (Exception ex) {
	                servlet.log(ex.toString());
	         }
	       
	         if (clInfos.size() == 0) {
	        	 request.setAttribute("noRecord", new ActionMessage("oes.teacher.error.noRecord"));
	         }
	         Integer total = Integer.valueOf(totalRows);
	         //把输出的记录集和pager对象保存到request对象中
	         request.setAttribute("TOTALROWS", total);
	         request.setAttribute("CLINFOS", clInfos);
	         request.setAttribute("PAGER", pager);

	     request.setAttribute("searchPage", new ActionMessage("searchPage"));
		 return actionMapping.findForward("searchSuccess");
	 }
	
 /**
  * 试卷信息删除
  * @param actionMapping
  * @param actionForm
  * @param request
  * @param response
  * @return
  */
 public ActionForward delete(ActionMapping actionMapping,
  ActionForm form,
  HttpServletRequest request,
  HttpServletResponse response) {
 	 System.out.println("=========="+request.getParameter("sequenceID"));
 	QuestionPaperManager questionPaperManager = new QuestionPaperManager();
  // 从页面取得要删除数据的sequenceID值
  int sequenceID = Integer.parseInt(request.getParameter("sequenceID"));
  questionPaperManager.delete(sequenceID);
  System.out.println("==========");
  return actionMapping.findForward("deleteSuccess");
 }
}