scoresearchaction.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.ScoreManager;
import com.zjxy.hibernate.form.ScoreForm;
import com.zjxy.hibernate.model.User;
import com.zjxy.hibernate.pagerHelp.Pager;
import com.zjxy.hibernate.pagerHelp.PagerHelp;

/**
 * @author gradenarn
 *
 */
public class ScoreSearchAction extends DispatchAction{
	/**
	 * 成绩查询一览画面显示
	 * @param actionMapping
	 * @param actionForm
	 * @param httpServletRequest
	 * @param httpServletresponse
	 * @return
	 */
	 public ActionForward searchDisplay(ActionMapping actionMapping,
             ActionForm actionForm,
             HttpServletRequest httpServletRequest,
             HttpServletResponse httpServletresponse) {
        
		// 用于输出到页面的记录集合
        List clInfos = null;
        
        User user=(User)httpServletRequest.getSession().getAttribute("User");
      //  if(user==null)return;
        
        String studentid=user.getSequenceID()+"";
        String sqlBean = "from com.zjxy.hibernate.model.StudentPaper where studentid='"+studentid+"'";
        // 记录总行数
        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());
         }
       
         Integer total = Integer.valueOf(totalRows);
         //把输出的记录集和pager对象保存到request对象中
         httpServletRequest.setAttribute("TOTALROWS", total);
         httpServletRequest.setAttribute("CLINFOS", clInfos);
         httpServletRequest.setAttribute("PAGER", pager);

         return actionMapping.findForward("searchDisplay");
}
	 
	 /**
		 * 成绩查询
		 * @param actionMapping
		 * @param actionForm
		 * @param request
		 * @param response
		 * @return
		 */
	 public ActionForward search(ActionMapping actionMapping,
	         ActionForm form,
	         HttpServletRequest request,
	         HttpServletResponse response) {
		 
		     ScoreForm scoreForm = (ScoreForm) form;
			 ScoreManager scoreManager = new ScoreManager();
			 String studentNO = scoreForm.getStudentNO();
			 // 用于输出到页面的记录集合
		        List clInfos = null;
		        String sqlBean = "from com.zjxy.hibernate.model.Score as score where score.studentID=?";
		        // 记录总行数
		        int totalRows = 0;
		        List list = scoreManager.getScoreList();
		        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, studentNO);
		            } catch (Exception ex) {
		                servlet.log(ex.toString());
		         }
		       
		         if (clInfos.size() == 0) {
		        	 request.setAttribute("noRecord", new ActionMessage("oes.admin.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("search");
		 }
}