titlemanageaction.java

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

package com.zjxy.hibernate.action;

import java.sql.Date;
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 com.zjxy.hibernate.base.PageDAO;
import com.zjxy.hibernate.base.TitleManager;
import com.zjxy.hibernate.form.TitleManageForm;
import com.zjxy.hibernate.model.TitleManage;
import com.zjxy.hibernate.pagerHelp.Pager;
import com.zjxy.hibernate.pagerHelp.PagerHelp;


public class TitleManageAction 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.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("display");
      }
	 /**
		 * 科目信息查询
		 * @param actionMapping
		 * @param actionForm
		 * @param request
		 * @param response
		 * @return
		 */
	 public ActionForward search(ActionMapping actionMapping,
	         ActionForm form,
	         HttpServletRequest request,
	         HttpServletResponse response) {
		     TitleManageForm titleManageForm = (TitleManageForm) form;
		     TitleManager titleManager = new TitleManager();
			 String name = titleManageForm.getKemuIDSearch();
			 // 用于输出到页面的记录集合
		        List clInfos = null;
		        String sqlBean = "from com.zjxy.hibernate.model.TitleManage as titleManage where titleManage.kemuID=?";
		        // 记录总行数
		        int totalRows = 0;
		        List list = titleManager.getTitleManageList();
		        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.titleManage.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 httpServletRequest
		 * @param httpServletresponse
		 * @return
		 */
	 public ActionForward addDisplay(ActionMapping actionMapping,
       ActionForm actionForm,
       HttpServletRequest httpServletRequest,
       HttpServletResponse httpServletresponse) {
		 return actionMapping.findForward("addDisplay");
	 }
		/**
		 * 科目信息添加
		 * @param actionMapping
		 * @param actionForm
		 * @param request
		 * @param response
		 * @return
		 */
	 public ActionForward add(ActionMapping actionMapping,
       ActionForm form,
       HttpServletRequest request,
       HttpServletResponse response) {
		 
		 // 定义TeacherForm对象用于获取页面信息
		 TitleManageForm titleManageForm = (TitleManageForm) form;
		 TitleManage titleManage = new TitleManage();
		 TitleManager titleManager = new TitleManager();
		 
		 // 将页面取得的信息设置值到TitleManage JavaBean中
		 // 科目ID
		 titleManage.setKemuID(titleManageForm.getKemuID());
		 // 考试科目
		 titleManage.setKemuName(titleManageForm.getKemuName());
		 // 任课老师
		 titleManage.setTeacherName(titleManageForm.getTeacherName());
		 // 授课班级
		 titleManage.setKemuClass(titleManageForm.getKemuClass());
		 // 学生人数
		 titleManage.setKemuStudentNumber(titleManageForm.getKemuStudentNumber());
		 // 现有题目数量
		 titleManage.setKemuTikuNumber(titleManageForm.getKemuTikuNumber());
		 // 定义Date型变量并设初始值：1900-01-01
		 Date kemuTime = Date.valueOf("1900-01-01");

		 if (!("".equals(titleManageForm.getKemuTime())) || (titleManageForm.getKemuTime().length()!=0)) {
			 // 入岗日期不为空时的表示形式转化
			 kemuTime = Date.valueOf(titleManageForm.getKemuTime().replace('/', '-'));
		 }
		 // 重新设置入库日期值
		 titleManage.setKemuTime(kemuTime);		
		 // 备注
		 titleManage.setKemuRemarks(titleManageForm.getKemuRemarks());
		 // 调用TitleManager类的addTitleManage方法向数据库添加教师信息
		 titleManager.addTitleManage(titleManage);
		 //重定向：页面跳转
		 return actionMapping.findForward("addSuccess");
	 }
		/**
		 * 题库系统信息一览画面显示
		 * @param actionMapping
		 * @param actionForm
		 * @param httpServletRequest
		 * @param httpServletresponse
		 * @return
		 */
		 public ActionForward tikuDisplay(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("tikuDisplay");
	      }

}