getchecklistaction.java

基于JAVA的学生就业信息网 实现对信息浏览 检索 审核 修改和删除

/*
 * Created on 2006-7-30
 *
 * 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.college;

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.ListFactory.ListFactory;
import org.ug.sztz.domain.oa.FuDaoYuan;
import org.ug.sztz.domain.oa.StudentBaseInfo;
import org.ug.sztz.domain.oa.StudentJYInfo;

/**
 * @author Skywalker
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class GetCheckListAction extends BaseAction {
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		// TODO Auto-generated method stub
		FuDaoYuan fdy = (FuDaoYuan) request.getSession().getAttribute("fdy");
		String sql = "select bysbase.* from bysbase,bysjy where bysbase.xsstatus='1' and bysbase.xh=bysjy.xh and bysbase.fdyxm='"
				+ fdy.getName().trim()
				+ "'order by bysjy.xxbgsj desc,bysbase.zy,bysbase.xh";
		
		HashMap map = new HashMap();
		map.put("sql", sql);
		try {
			List baseList = this.stuBaseDao.getSQLBaseInfoList(map);
			
			Vector jyList = new Vector();
			for(int i=0;i<baseList.size();i++){
				StudentJYInfo info = this.stuJYDao.getStudentJYInfoByXh(((StudentBaseInfo)baseList.get(i)).getXh());
				jyList.add(info);
			}
			request.setAttribute("baselist",baseList);
			request.setAttribute("jylist",jyList);
			List byqxlist = new ListFactory(this.getServlet().getServletConfig(),
			"byqx").getList();
			request.setAttribute("byqxlist",byqxlist);
			return mapping.findForward("success");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			request.setAttribute("reason","数据库操作失败！");
			return mapping.findForward("failure");
		}
	}
}