namerankaction.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.actions.DispatchAction;

import com.zjxy.hibernate.base.PageDAO;
import com.zjxy.hibernate.base.ScoreManager;
import com.zjxy.hibernate.base.TitleManager;
import com.zjxy.hibernate.pagerHelp.Pager;
import com.zjxy.hibernate.pagerHelp.PagerHelp;

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

	/**
	 * 成绩查询科目选择
	 * @param actionMapping
	 * @param actionForm
	 * @param httpServletRequest
	 * @param httpServletresponse
	 * @return
	 */
	 public ActionForward kemuSelect(ActionMapping actionMapping,
             ActionForm actionForm,
             HttpServletRequest httpServletRequest,
             HttpServletResponse httpServletresponse) {
        
		// 用于输出到页面的记录集合
        List clInfos = null;
        String sqlBean = "from com.zjxy.hibernate.model.TitleManage";
        // 记录总行数
        int totalRows = 0;
        TitleManager titleManager = new TitleManager();
        List list = titleManager.getTitleManageList();
        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("kemuSelect");
		}
	 
	 /**
		 * 成绩查询科目选择
		 * @param actionMapping
		 * @param actionForm
		 * @param httpServletRequest
		 * @param httpServletresponse
		 * @return
		 */
		 public ActionForward rankView(ActionMapping actionMapping,
	             ActionForm form,
	             HttpServletRequest request,
	             HttpServletResponse httpServletresponse) {
			 
				    ScoreManager scoreManager = new ScoreManager();
				    String kemuName = request.getParameter("kemuName");
				    
				    List scoreList = null;
				    scoreList = scoreManager.getScoreByKemuName(kemuName);
			        request.setAttribute("CLINFOS", scoreList);

			        request.setAttribute("kemuName", kemuName);
			         
			        return actionMapping.findForward("rankView");
		 }
		 
		 /**
			 * 总分排名
			 * @param actionMapping
			 * @param actionForm
			 * @param httpServletRequest
			 * @param httpServletresponse
			 * @return
			 */
			 public ActionForward totalRank(ActionMapping actionMapping,
		             ActionForm form,
		             HttpServletRequest request,
		             HttpServletResponse httpServletresponse) {
				 
				 ScoreManager scoreManager = new ScoreManager();
				 List totalScoreList = null;
				 totalScoreList = scoreManager.getTotalScore();
				 request.setAttribute("CLINFOS", totalScoreList);
				 return actionMapping.findForward("totalRank");
			 }
}