resultaction.java

采用STRUTS+HIBERNATE做的一个学生成绩管理系统.用的ORACLE9I数据库.

//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.1.1/xslt/JavaClass.xsl

package org.yangyang.action;

import java.util.ArrayList;
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.DynaActionForm;
import org.apache.struts.actions.DispatchAction;
import org.yangyang.bean.Course;
import org.yangyang.bean.Dictionary;
import org.yangyang.bean.Result;
import org.yangyang.bean.Student;
import org.yangyang.common.util.CodeConstant;
import org.yangyang.dao.CourseDao;
import org.yangyang.dao.DictionaryDao;
import org.yangyang.dao.ResultDao;
import org.yangyang.dao.StudentDao;

import com.sun.org.apache.bcel.internal.classfile.Code;

/** 
 * MyEclipse Struts
 * Creation date: 03-24-2008
 * 
 * XDoclet definition:
 * @struts.action path="/result" name="mainForm" scope="request" validate="true"
 */
public class ResultAction extends DispatchAction {

	// --------------------------------------------------------- Instance Variables

	// --------------------------------------------------------- Methods

	/** 
	 * Method init 评分页面的初始化
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward init(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		DynaActionForm mainForm = (DynaActionForm) form;
		String studentid = request.getParameter(CodeConstant.STUID);
		if(studentid != null){
			CourseDao courseDao = new CourseDao();
			//所有课程信息
			List<Course> temp = courseDao.getAll();
			StudentDao stuDao = new StudentDao();
			//评分学员信息
			Student stu = stuDao.getSudentbyId(studentid);
			DictionaryDao dicDao = new DictionaryDao();
			//评分种类
			List<Dictionary> resultNum = dicDao.getName(CodeConstant.KINDID,"2");
			//评分学年
			List<Dictionary> resultDate = dicDao.getName(CodeConstant.KINDID,"3");
			
			//设置REQUEST
			request.setAttribute(CodeConstant.STUDENT,stu);
			request.setAttribute(CodeConstant.COURSE_LIST,temp);
			request.setAttribute(CodeConstant.RESULTNUM,resultNum);
			request.setAttribute(CodeConstant.RESULTDATE,resultDate);
			return mapping.findForward(CodeConstant.RESULT_STUDENT);
		}else{
			String id = request.getParameter("id");
			CourseDao courseDao = new CourseDao();
			//评分课程信息
			Course cou = courseDao.getCoursebyId(id);
			//所有学员信息
			StudentDao stuDao = new StudentDao();
			List<Student> temp = stuDao.getAll();
			DictionaryDao dicDao = new DictionaryDao();
			//评分种类
			List<Dictionary> resultNum = dicDao.getName(CodeConstant.KINDID,"2");
			//评分学年
			List<Dictionary> resultDate = dicDao.getName(CodeConstant.KINDID,"3");
			
			//设置REQUEST
			request.setAttribute(CodeConstant.STUDENT_LIST,temp);
			request.setAttribute(CodeConstant.COURSE,cou);
			request.setAttribute(CodeConstant.RESULTNUM,resultNum);
			request.setAttribute(CodeConstant.RESULTDATE,resultDate);
			return mapping.findForward(CodeConstant.RESULT_COUSE);
		}
	}

	/** 
	 * Method show 进行跳转
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward show(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		DynaActionForm mainForm = (DynaActionForm) form;
		//跳转
		return mapping.findForward("show");
	}
	
	/** 
	 * Method search 查找评分信息
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward search(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
    	List<Result> result;
		DynaActionForm mainForm = (DynaActionForm) form;
		//得到学生编号
		String studentid = request.getParameter("studentid");
		//得到课程编号
		String id = request.getParameter("id");
		//判断学生编号是否为空
		if(studentid != null && studentid != ""){
			ResultDao resultDao = new ResultDao();
			StudentDao stuDao =new StudentDao();
			//通过编号得到学生信息
			Student stu = stuDao.getSudentbyId(studentid);
			//通过编号得到评分信息
			result = resultDao.getCoursebyStuid(stu);
			request.setAttribute(CodeConstant.RESULT_LIST,result);
		}else if(id != null && id != ""){
			ResultDao resultDao = new ResultDao();
			CourseDao coDao = new CourseDao();
			//通过编号得到课程信息
			Course co = coDao.getCoursebyId(id);
			//通过编号得到评分信息
			result = resultDao.getCoursebyCoiid(co);
			request.setAttribute(CodeConstant.RESULT_LIST,result);
		}
		return mapping.findForward("show");
	}
	
	/** 
	 * Method add 增加评分信息
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward add(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		DynaActionForm mainForm = (DynaActionForm) form;
		String type = request.getParameter(CodeConstant.TYPE);


		//提示信息
		request.setAttribute(CodeConstant.MESSAGE,CodeConstant.RESULT_SUCCESS);
		if(type != null){
			Result res = new Result();
			String stuid = (String)request.getParameter("id");
			String couid = (String)request.getParameter("courseid");
			res.setGradeyear((String)request.getParameter("gradeyear"));
			res.setKind((String)request.getParameter("kind"));
			res.setCount(new Double((String)request.getParameter("count")));
			StudentDao stuDao = new StudentDao();
			res.setStudent(stuDao.getSudentbyId(stuid));
			CourseDao courseDao = new CourseDao();
			res.setCourse(courseDao.getCoursebyId(couid));
			ResultDao resultDao = new ResultDao();
			resultDao.addOrupadate(res);
			//得到页面数量
			int pageNum = stuDao.getPage(CodeConstant.PAGE_COUNT,Student.class);
			//得到学生信息
			showPage(request,pageNum,0);
			//进行跳转
			return mapping.findForward(CodeConstant.SHOW_STUDENT);
		}else{
			Result res = new Result();
			String couid = (String)request.getParameter("id");
			String stuid = (String)request.getParameter("courseid");
			res.setGradeyear((String)request.getParameter("gradeyear"));
			res.setKind((String)request.getParameter("kind"));
			res.setCount(new Double((String)request.getParameter("count")));
			StudentDao stuDao = new StudentDao();
			res.setStudent(stuDao.getSudentbyId(stuid));
			CourseDao courseDao = new CourseDao();
			res.setCourse(courseDao.getCoursebyId(couid));
			ResultDao resultDao = new ResultDao();
			resultDao.addOrupadate(res);
			//得到页面数量
			int pageNum = courseDao.getPage(CodeConstant.PAGE_COUNT,Course.class);
			//得到课程信息
			showPage(request,pageNum,1);
			//进行跳转
			return mapping.findForward(CodeConstant.SHOW_COURSE);
		}
	}
	
	/** 
	 * Method showPage 得到学生信息,并进行初始化
	 * @param request
	 */
	protected void showPage(HttpServletRequest request,int pageNum,int type){
		//保存页数
		List<Integer> pageList = new ArrayList();
		//保存结果
		List<Student> resultList = new ArrayList();
		//保存结果
		List<Course> resultListCount = new ArrayList();
		//页数
		int page = 1;
		//得到页数
		if(request.getParameter(CodeConstant.PAGE_NUM) != null){
			page = new Integer(request.getParameter(CodeConstant.PAGE_NUM));
		}
		StudentDao studentDao = new StudentDao();
		CourseDao courseDao = new CourseDao();
		//判断是否有数据
		if(pageNum > 0){
			for(int n = 1;n <= pageNum;n ++){
				pageList.add(n - 1,n);
			}
			//返回页面数量
			request.setAttribute(CodeConstant.PAGE_NUM,pageList);
			if(type == 0){				
				//得到结果
				resultList = studentDao.showStudent(page,CodeConstant.PAGE_COUNT);
				//返回结果
				request.setAttribute(CodeConstant.STUDENT_LIST,resultList);
			}else
				//得到结果
				resultListCount = courseDao.showCourse(page,CodeConstant.PAGE_COUNT);
				//返回结果
				request.setAttribute(CodeConstant.COURSE_LIST,resultListCount);
		}
	}
	
	/** 
	 * Method delResult 删除成绩
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward del(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		//得到要删除课程的编号
		String id = request.getParameter("stuid");
		ResultDao resultDao = new ResultDao();
		//进行删除
		resultDao.del(id,CodeConstant.COURSE);
		//提示信息
		request.setAttribute(CodeConstant.MESSAGE,CodeConstant.DEL_SUCCESS);
		//进行跳转
		return mapping.findForward(CodeConstant.SHOW_COURSE);
	}
}