searchjyaction.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.List;
import java.util.HashMap;
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;
import org.ug.sztz.webview.structs.forms.CollegeSearchForm;

/**
 * @author Skywalker
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class SearchJyAction 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");
		CollegeSearchForm workform = (CollegeSearchForm)form;
		String sql = "select bysbase.* from bysbase,bysjy where bysbase.xh=bysjy.xh and bysbase.xsstatus='1' and bysbase.fdyxm='"+fdy.getName()+"'";
		
		if(!workform.getBj().equals("")){
			sql = sql +" and bysbase.bj='"+workform.getBj()+"'";
		}
		if(!workform.getXh().equals("")){
			sql = sql +" and bysbase.xh='"+workform.getXh()+"'";
		}
		if(!workform.getXm().equals("")){
			sql = sql +" and bysbase.xm='"+workform.getXm()+"'";
		}
		if(!workform.getByqx().equals("")){
			sql = sql +" and bysjy.byqx='"+workform.getByqx()+"'";
		}
		HashMap map = new HashMap();
		System.out.println(sql);
		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 (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			request.setAttribute("reason","数据库操作失败！");
			return mapping.findForward("failure");
		}
	}
}