getlistaction.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.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 GetListAction 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
		FuDaoYuan fdy = (FuDaoYuan) request.getSession().getAttribute("fdy");
		String sql = "select * from bysbase where xsstatus='1'  and fdyxm='"
				+ fdy.getName().trim()
				+ "'order by xh";
		
		HashMap map = new HashMap();
		map.put("sql", sql);
		try {
			List baseList = this.stuBaseDao.getSQLBaseInfoList(map);
			System.out.println(baseList.size());
			
			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);
			
			return mapping.findForward("success");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			request.setAttribute("reason","数据库操作失败！");
			return mapping.findForward("failure");
		}
	}
}