customsxlistaction.java

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

/*
 * 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.CustomSxForm;

/**
 * @author Skywalker
 * 
 * TODO To change the template for this generated type comment go to Window -
 * Preferences - Java - Code Style - Code Templates
 */
public class CustomSxListAction 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
		CustomSxForm workform = (CustomSxForm) form;

		String sql = workform.getSql();
		String work = request.getParameter("submit2");
		if (work != null && work.equals("添加条件")) {
			String tjz = workform.getTjz();
			int tjzd = Integer.parseInt(workform.getTjzd());
			int tj = Integer.parseInt(workform.getTj());
			int tjgx = Integer.parseInt(workform.getTjgx());
			if (sql == null || sql.length() < 1) {
				sql = "select bysbase.* from bysbase,bysjy where bysbase.xh=bysjy.xh and";
				switch (tjzd) {
				case 1:
					sql = sql + " bysbase.xh";
					break;
				case 2:
					sql = sql + " bysbase.xm";
					break;
				case 3:
					sql = sql + " bysbase.zy";
					break;
				case 4:
					sql = sql + " bysbase.xb";
					break;
				case 5:
					sql = sql + " bysbase.mz";
					break;
				case 6:
					sql = sql + " bysbase.zzmm";
					break;
				case 7:
					sql = sql + " bysbase.pyfs";
					break;
				case 8:
					sql = sql + " bysbase.xz";
					break;
				case 9:
					sql = sql + " bysbase.xl";
					break;
				case 10:
					sql = sql + " bysbase.syszd";
					break;
				case 11:
					sql = sql + " bysbase.xjbd";
					break;
				case 12:
					sql = sql + " bysbase.bj";
					break;
				case 13:
					sql = sql + " bysbase.xy";
					break;
				case 14:
					sql = sql + " bysbase.xslb";
					break;
				case 15:
					sql = sql + " bysbase.wyyz";
					break;
				case 16:
					sql = sql + " bysjy.byqx";
					break;
				case 17:
					sql = sql + " bysjy.jyxs";
					break;
				case 18:
					sql = sql + " bysjy.lcnr";
					break;
				case 19:
					sql = sql + " bysjy.dwmc";
					break;
				case 20:
					sql = sql + " bysjy.dwszd";
					break;
				case 21:
					sql = sql + " bysjy.dwxz";
					break;
				case 22:
					sql = sql + " bysjy.ljdlbz";
					break;
				case 23:
					sql = sql + " bysjy.jyzt";
					break;
				case 24:
					sql = sql + " bysjy.xysh";
					break;
				case 25:
					sql = sql + " bysjy.jlsd";
					break;
				}
				switch (tj) {
				case 1:
					sql = sql + " = '" + tjz + "'";
					break;
				case 2:
					sql = sql + " like '%" + tjz + "%'";
					break;
				case 3:
					sql = sql + " <> '" + tjz + "'";
					break;
				case 4:
					sql = sql + " not like '%" + tjz + "%'";
					break;
				case 5:
					sql = sql + " like '" + tjz + "%'";
					break;
				case 6:
					sql = sql + " not like '" + tjz + "%'";
					break;
				}
			} else {
				switch (tjgx) {
				case 1:
					sql = sql + " and";
					break;
				case 2:
					sql = sql + " or";
					break;
				}
				switch (tjzd) {
				case 1:
					sql = sql + " bysbase.xh";
					break;
				case 2:
					sql = sql + " bysbase.xm";
					break;
				case 3:
					sql = sql + " bysbase.zy";
					break;
				case 4:
					sql = sql + " bysbase.xb";
					break;
				case 5:
					sql = sql + " bysbase.mz";
					break;
				case 6:
					sql = sql + " bysbase.zzmm";
					break;
				case 7:
					sql = sql + " bysbase.pyfs";
					break;
				case 8:
					sql = sql + " bysbase.xz";
					break;
				case 9:
					sql = sql + " bysbase.xl";
					break;
				case 10:
					sql = sql + " bysbase.syszd";
					break;
				case 11:
					sql = sql + " bysbase.xjbd";
					break;
				case 12:
					sql = sql + " bysbase.bj";
					break;
				case 13:
					sql = sql + " bysbase.xy";
					break;
				case 14:
					sql = sql + " bysbase.xslb";
					break;
				case 15:
					sql = sql + " bysbase.wyyz";
					break;
				case 16:
					sql = sql + " bysjy.byqx";
					break;
				case 17:
					sql = sql + " bysjy.jyxs";
					break;
				case 18:
					sql = sql + " bysjy.lcnr";
					break;
				case 19:
					sql = sql + " bysjy.dwmc";
					break;
				case 20:
					sql = sql + " bysjy.dwszd";
					break;
				case 21:
					sql = sql + " bysjy.dwxz";
					break;
				case 22:
					sql = sql + " bysjy.ljdlbz";
					break;
				case 23:
					sql = sql + " bysjy.jyzt";
					break;
				case 24:
					sql = sql + " bysjy.xysh";
					break;
				case 25:
					sql = sql + " bysjy.jlsd";
					break;
				}
				switch (tj) {
				case 1:
					sql = sql + " = '" + tjz + "'";
					break;
				case 2:
					sql = sql + " like '%" + tjz + "%'";
					break;
				case 3:
					sql = sql + " <> '" + tjz + "'";
					break;
				case 4:
					sql = sql + " not like '%" + tjz + "%'";
					break;
				case 5:
					sql = sql + " like '" + tjz + "%'";
					break;
				case 6:
					sql = sql + " not like '" + tjz + "%'";
					break;
				}
			}
			request.setAttribute("sql", sql);
			return mapping.findForward("continue");
		} else {
			if(sql==null||sql.equals(""))
			{
				
				request.setAttribute("info", "请输入SQL语句！");
				return mapping.findForward("failure");
			}
			HashMap map = new HashMap();
			map.put("sql", sql);
			try {
				List studentList = this.stuBaseDao.getSQLBaseInfoList(map);
				Vector vector = new Vector();
				for (int i = 0; i < studentList.size(); i++) {
					String xh = ((StudentBaseInfo) studentList.get(i)).getXh();
					StudentJYInfo info = this.stuJYDao.getStudentJYInfoByXh(xh);
					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", "数据库操作失败！");
				return mapping.findForward("failure");
			}
		}

	}
}