sourceaddbatch.java

校园管理系统 利用struts+hibernate+spring 学校管理者决定在学生信息管理、学生成绩管理、图书馆管理采用先进的计算机技术

package com.spring.controller;

import java.util.HashMap;
import java.util.HashSet;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.sql.Date;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.validation.BindException;
import org.springframework.web.bind.ServletRequestDataBinder;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.AbstractController;
import org.springframework.web.servlet.mvc.SimpleFormController;
import org.springframework.web.servlet.view.RedirectView;

import com.hibernate.dao.DAOSupport;
import com.hibernate.model.CourseStuInfo;
import com.hibernate.model.DocuStuInfo;
import com.hibernate.model.SystemCourseCode;

public class SourceAddBatch extends AbstractController{
	private DAOSupport dao;
	private String successView;
	public DAOSupport getDao() {
		return dao;
	}

	public void setDao(DAOSupport dao) {
		this.dao = dao;
	}

	protected ModelAndView handleRequestInternal(HttpServletRequest req, HttpServletResponse rep) throws Exception {
		req.setCharacterEncoding("GB2312");
		String stuId,examType;
		Date examDate;
		stuId = req.getParameter("stuId");
		examType = req.getParameter("examType");
		examDate = Date.valueOf(req.getParameter("examDate"));
		String findSql = "From CourseStuInfo csi where csi.docuStuInfo.stuId = '" + stuId + 
		                  "' and examType = '" + examType + "' and examDate = '" + examDate + "'";
		List findList = dao.QueryObject(findSql);
		System.out.println("findList: " + findList);
		System.out.println("findList.isEmpty(): " + findList.isEmpty());
		if(!findList.isEmpty()){
			Map model = new HashMap();
			model.put("message", "该学生的成绩数据已经存在，请重新输入!!!");
			List list = dao.QueryObject("from SystemCourseCode");			
			model.put("list", list);
			return new ModelAndView("/sourceview/doc_stusource_input", model);
			//return new ModelAndView(new RedirectView("regCjInfo.htm"),model);
		}
		
		List list = dao.QueryObject("from SystemCourseCode");
		Object[] obj = list.toArray();
		
		//DocuStuInfo stuinfo = new DocuStuInfo();
		List stuList = dao.QueryObject("from DocuStuInfo where stu_id = '" + req.getParameter("stuId") +"'");
		System.out.println("sddds:" + stuList);
		DocuStuInfo stuinfo = (DocuStuInfo)stuList.get(0);
		Set MM = stuinfo.getCourseStu();
		//Set MM = new HashSet();
		//stuinfo.setStuId(req.getParameter("stuId"));
		for(int i = 0 ; i < obj.length ; i ++){
			SystemCourseCode courseObject = (SystemCourseCode)obj[i];
			CourseStuInfo regForm = new CourseStuInfo();
			regForm.setDocuStuInfo(stuinfo);
			regForm.setSystemCourseCode(courseObject);
			regForm.setCzy(req.getParameter("czy"));
			regForm.setExamType(req.getParameter("examType"));
			regForm.setExamDate(Date.valueOf(req.getParameter("examDate")));
			regForm.setGrade(Float.valueOf(req.getParameter("grade" + courseObject.getCode())));
			//stuinfo.getCourseStu().add(regForm);
			MM.add(regForm);
			//dao.InsertOrUpdate(regForm);
		}
		//stuinfo.setCourseStu(MM);
		dao.InsertOrUpdate(stuinfo);
		
		
		Map model = new HashMap();
		model.put("message", "成绩录入成功，请继续录入!!!");
		List listcode = dao.QueryObject("from SystemCourseCode");
		model.put("list", listcode);
		return new ModelAndView("/sourceview/doc_stusource_input", model);
		/*if (submit==null||submit.length()<=0){			
			if(stuId != null){
				List list1 = dao.QueryObject("from DocuStuInfo where stuId='"+ stuId + "'");
				DocuStuInfo stuinfo = (DocuStuInfo)list1.get(0);
				model.put("stuName", stuinfo.getName());
			}
			
			model.put("list", list);			
		}else{
			CourseStuInfo regForm = new CourseStuInfo();
			DocuStuInfo insertStuInfo=new DocuStuInfo();
			insertStuInfo.setStuId(req.getParameter("stuId"));
			regForm.setDocuStuInfo(insertStuInfo);
			SystemCourseCode insertCourseCode=new SystemCourseCode();
			insertCourseCode.setCode(req.getParameter("code"));
			regForm.setSystemCourseCode(insertCourseCode);	
			model.put("form", regForm);
			dao.InsertOrUpdate(regForm);
			model.put("message", "成绩录入成功，请继续录入。");	
		}	*/
		
	}

	public String getSuccessView() {
		return successView;
	}

	public void setSuccessView(String successView) {
		this.successView = successView;
	}

}