replacezdxxaction.java

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

/*
 * Created on 2006-7-23
 *
 * 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.ReplaceZdxxForm;

/**
 * @author Skywalker
 * 
 * TODO To change the template for this generated type comment go to Window -
 * Preferences - Java - Code Style - Code Templates
 */
public class ReplaceZdxxAction 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
		ReplaceZdxxForm workform = (ReplaceZdxxForm) 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 {
			System.out.println(sql);
			HashMap map = new HashMap();
			map.put("sql", sql);
			int thzd = Integer.parseInt(workform.getThzd());
			String columnname=null;
			switch (thzd) {
			case 2:
				columnname="xm";
				break;
			case 3:
				columnname="zy";
				break;
			case 4:
				columnname="xb";
				break;
			case 5:
				columnname="mz";
				break;
			case 6:
				columnname="zzmm";
				break;
			case 7:
				columnname="pyfs";
				break;
			case 8:
				columnname="xz";
				break;
			case 9:
				columnname="xl";
				break;
			case 10:
				columnname="syszd";
				break;
			case 11:
				columnname="xjbd";
				break;
			case 12:
				columnname="bj";
				break;
			case 13:
				columnname="xy";
				break;
			case 14:
				columnname="xslb";
				break;
			case 15:
				columnname="wyyz";
				break;
			case 16:
				columnname="byqx";
				break;
			case 17:
				columnname="jyxs";
				break;
			case 18:
				columnname="lcnr";
				break;
			case 19:
				columnname="dwmc";
				break;
			case 20:
				columnname="dwszd";
				break;
			case 21:
				columnname="dwxz";
				break;
			case 22:
				columnname="ljdlbz";
				break;
			case 23:
				columnname="jyzt";
				break;
			case 24:
				columnname="xysh";
				break;
			case 25:
				columnname="jlsd";
				break;
			}
			String thz = workform.getThz();
			if (thz == null)
				thz = "";
			try {
				List studentList = this.stuBaseDao.getSQLBaseInfoList(map);
                if(thzd<=15){
                	for(int i=0;i<studentList.size();i++)
                	{
                		StudentBaseInfo info = (StudentBaseInfo)studentList.get(i);
                		String updatesql="update bysbase set "+columnname+"='"+thz+"' where xh='"+info.getXh()+"'";
                		map.put("sql",updatesql);
                		System.out.println(updatesql);
                		this.stuBaseDao.updateStudentInfoBySQL(map);
                	}
                }else{
                	for(int i=0;i<studentList.size();i++)
                	{
                		StudentBaseInfo info = ((StudentBaseInfo)studentList.get(i));
                		String updatesql="update bysjy set "+columnname+"='"+thz+"' where xh='"+info.getXh()+"'";
                		map.put("sql",updatesql);
                		System.out.println(updatesql);
                		this.stuJYDao.updateStudentJYInfoBySQL(map);
                		
                	}
                }
				return mapping.findForward("success");
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				request.setAttribute("info", "数据库操作失败！");
				return mapping.findForward("failure");
			}
		}
	}
}