/*
 * Created on 2006-7-22
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package org.ug.sztz.webview.structs.actions.oa;

import java.util.HashMap;
import java.util.List;
import java.util.Vector;

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.ug.sztz.domain.oa.StudentBaseInfo;
import org.ug.sztz.domain.oa.StudentJYInfo;
import org.ug.sztz.webview.structs.forms.QuickSxForm;

/**
 * @author Skywalker
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class GetSxListAction extends BaseAction {

	/* (non-Javadoc)
	 * @see org.apache.struts.action.Action#execute(org.apache.struts.action.ActionMapping, org.apache.struts.action.ActionForm, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws Exception {
		// TODO Auto-generated method stub
		QuickSxForm workform = (QuickSxForm)form;
		String xh = workform.getXh();
		String xl = workform.getXl();
		String zy = workform.getZy();
		String xm = workform.getXm();
		HashMap map = new HashMap();
		
		/*map.put("sql","update bysbase set xm='updatename' where xh='45646' ");
		stuBaseDao.updateStudentInfoBySQL(map);
		*/
		
		
		map.put("xsstatus",new Integer(1));
		if(xh!=null&&xh.length()>=1){
			map.put("xh",xh);
		}
		if(xl!=null&&xl.length()>=1){
			map.put("xl",xl);
		}
		if(zy!=null&&zy.length()>=1){
			map.put("zy",zy);
		}
		if(xm!=null&&xm.length()>=1){
			map.put("xm",xm);
		}
		try {
			List studentList = this.stuBaseDao.getShaXuanStudentBaseInfoList(map);
			Vector vector=new Vector();
			for(int i=0;i<studentList.size();i++)
			{
				String xh2 = ((StudentBaseInfo)studentList.get(i)).getXh();
				StudentJYInfo info = this.stuJYDao.getStudentJYInfoByXh(xh2);
				vector.add(info);
			}
			
			request.getSession().setAttribute("studentlist",studentList);
			request.getSession().setAttribute("infolist",vector);
			return mapping.findForward("success");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			request.setAttribute("info","數(shù)據(jù)庫(kù)操作失??！");
			return mapping.findForward("failure");
		}
		
	}
}