sumxqaction.java

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

/*
 * Created on 2006-8-1
 *
 * 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.XQInfo;
import org.ug.sztz.domain.oa.XQTJ;

/**
 * @author Skywalker
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class SumXqAction 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");
		Vector all = new Vector();
		String allsql = "select * from bysbase where xsstatus='1' and fdyxm='" + fdy.getName()
				+ "' order by zy";   
		HashMap map = new HashMap();
		map = new HashMap();
		map.put("sql", allsql);

		List allList = this.stuBaseDao.getSQLBaseInfoList(map);//取出该辅导员所带的全部学生
		if(allList.size()==0){
			request.setAttribute("reason","您没有学生……");
			return mapping.findForward("failure");
		}
        Vector zyList = new Vector();
        String temp = "";
		for (int i = 0; i < allList.size(); i++) {
			String zy = ((StudentBaseInfo) allList.get(i)).getZy();
			if (!zy.equals(temp)) {
				temp = zy;
				zyList.add(zy.trim());
           }

		}//取得全部专业
		String xl = ((StudentBaseInfo)allList.get(0)).getXl();//取得该辅导员所带学生类型：研究生/本科生
		XQTJ main = new XQTJ();
		main.setZrs(allList.size());
		main.setGxb(0);
		main.setXqzs(0);
		main.setZy("总计");
		all.add(main);
		
		int sumxq=0;
		List xqxxList = this.xqxxDao.getXQInfoList();
		for(int i=0;i<zyList.size();i++){
			XQTJ tj = new XQTJ();
			tj.setZy((String)zyList.get(i));
			String sql = "select * from bysbase where xsstatus='1' and fdyxm='" + fdy.getName()
			+ "' and zy='" + zyList.get(i) + "'";
			map.put("sql",sql);
			List sList = this.stuBaseDao.getSQLBaseInfoList(map);//取得该专业的学生列表
			tj.setZrs(sList.size());
			int zyxq = 0;//该专业的需求量
			for(int j=0;j<xqxxList.size();j++){
				XQInfo info = (XQInfo)xqxxList.get(j);
				String zyyq = info.getXqzyyq().trim();
				String[] detail = zyyq.split("；");//用“；”拆分字符串，结果为一个字符数组，每一元素为一条具体需求信息
				for(int k=0;k<detail.length;k++){
					String[] item = detail[k].split("-");//用“-”拆分字符串，结果为一个字符数组，第一项为学生类型，第二项为需求专业，第三项为需求数，第四项为相关要求
					if(item[0].equals(xl)&&item[1].equals((String)zyList.get(i))){
						zyxq = zyxq + Integer.parseInt(item[2]);
					}
				}
			}
			sumxq = sumxq + zyxq;
			tj.setXqzs(zyxq);
			tj.setGxb((float)zyxq/sList.size());
			all.add(tj);
		}
		main.setXqzs(sumxq);
		main.setGxb(sumxq/allList.size());
		all.set(0,main);
		request.setAttribute("xqqklist",all);
		return mapping.findForward("success");
	}
}