📄 rczx_zwxx_search_action.java

📁 这个程序是花了好几十万请人开发的
💻 JAVA
字号:
package struts.action;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionError;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.Connection;

import java.util.Vector;
import javabean.*;


public class rczx_zwxx_search_action extends Action{
//	初始化连接池	
	private ConnectionPool pool;
	
	public rczx_zwxx_search_action()
	{
//		从连接池中获得一个连接池实例
		pool=ConnectionPool.getInstance();
	}

	public ActionForward  execute (
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception 
		{			
			Connection con=null;
			ActionErrors errors=new ActionErrors();
			
			try
			{
				String str="",JOBCATE="",PROVINCE="",WORKMONEY="",NTIME="",SregTime="-1";
				int RegTime=-1;
//				获得查询参数
				if(request.getParameter("JOBCATE")!=null)
				{
					JOBCATE=request.getParameter("JOBCATE");
					JOBCATE=new String(JOBCATE.getBytes("ISO-8859-1"));
				}
				if(request.getParameter("RegTime")!="-1")
				{
					SregTime=request.getParameter("RegTime");
					RegTime=Integer.parseInt(SregTime);
					Date_before_n date_n=new Date_before_n();
					NTIME=date_n.nDate(RegTime);
				}
				if(request.getParameter("PROVINCE")!=null)
				{
					PROVINCE=request.getParameter("PROVINCE");
					PROVINCE=new String(PROVINCE.getBytes("ISO-8859-1"));
				}
				if(request.getParameter("WORKMONEY")!=null)
				{
					WORKMONEY=request.getParameter("WORKMONEY");
					WORKMONEY=new String(WORKMONEY.getBytes("ISO-8859-1"));
				}	
				//  0000			
				if(JOBCATE.equals("")&&RegTime==-1&&PROVINCE.equals("")&&WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID";
				}
					
				//  1000			
				if(!JOBCATE.equals("")&&RegTime==-1&&PROVINCE.equals("")&&WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and JOBCATE="+"'"+JOBCATE+"'";
				}
				//  0100
				if(JOBCATE.equals("")&&RegTime!=-1&&PROVINCE.equals("")&&WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and ZWXX.FBTIME>"+"'"+NTIME+"'";
				}
				//  1100
				if(!JOBCATE.equals("")&&RegTime!=-1&&PROVINCE.equals("")&&WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and JOBCATE="+"'"+JOBCATE+"'"+"and ZWXX.FBTIME>"+"'"+NTIME+"'";
				}
				//  0010
				if(JOBCATE.equals("")&&RegTime==-1&&!PROVINCE.equals("")&&WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and PROVINCE="+"'"+PROVINCE+"'";
				}
				//  1010
				if(!JOBCATE.equals("")&&RegTime==-1&&!PROVINCE.equals("")&&WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and JOBCATE="+"'"+JOBCATE+"'"+"and PROVINCE="+"'"+PROVINCE+"'";
				}
				//  0110
				if(JOBCATE.equals("")&&RegTime!=-1&&!PROVINCE.equals("")&&WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and ZWXX.FBTIME>"+"'"+NTIME+"'"+"and PROVINCE="+"'"+PROVINCE+"'";
				}
				//  1110
				if(!JOBCATE.equals("")&&RegTime!=-1&&!PROVINCE.equals("")&&WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and JOBCATE="+"'"+JOBCATE+"'"+"and ZWXX.FBTIME>"+"'"+NTIME+"'"+"and PROVINCE="+"'"+PROVINCE+"'";
				}
				//  0001
				if(JOBCATE.equals("")&&RegTime==-1&&PROVINCE.equals("")&&!WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and WORKMONEY="+"'"+WORKMONEY+"'";
				}
				//  1001
				if(!JOBCATE.equals("")&&RegTime==-1&&PROVINCE.equals("")&&!WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and JOBCATE="+"'"+JOBCATE+"'"+"and WORKMONEY="+"'"+WORKMONEY+"'";
				}
				//  0101
				if(JOBCATE.equals("")&&RegTime!=-1&&PROVINCE.equals("")&&!WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and and ZWXX.FBTIME>"+"'"+NTIME+"'"+"and WORKMONEY="+"'"+WORKMONEY+"'";;
				}
				//  1101
				if(!JOBCATE.equals("")&&RegTime!=-1&&PROVINCE.equals("")&&!WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and JOBCATE="+"'"+JOBCATE+"'"+"and ZWXX.FBTIME>"+"'"+NTIME+"'"+"and WORKMONEY="+"'"+WORKMONEY+"'";
				}
				//  0011
				if(JOBCATE.equals("")&&RegTime==-1&&!PROVINCE.equals("")&&!WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and PROVINCE="+"'"+PROVINCE+"'"+"and WORKMONEY="+"'"+WORKMONEY+"'";
				}
				//  1011
				if(!JOBCATE.equals("")&&RegTime==-1&&!PROVINCE.equals("")&&!WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and JOBCATE="+"'"+JOBCATE+"'"+"and PROVINCE="+"'"+PROVINCE+"'"+"and WORKMONEY="+"'"+WORKMONEY+"'";
				}
				//  0111
				if(JOBCATE.equals("")&&RegTime!=-1&&!PROVINCE.equals("")&&!WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and ZWXX.FBTIME>"+"'"+NTIME+"'"+"and PROVINCE="+"'"+PROVINCE+"'"+"and WORKMONEY="+"'"+WORKMONEY+"'";
				}
				//  1111
				if(!JOBCATE.equals("")&&RegTime!=-1&&!PROVINCE.equals("")&&!WORKMONEY.equals(""))
				{
					str="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID=ZWXX.UUID and JOBCATE="+"'"+JOBCATE+"'"+"and ZWXX.FBTIME>"+"'"+NTIME+"'"+"and PROVINCE="+"'"+PROVINCE+"'"+"and WORKMONEY="+"'"+WORKMONEY+"'";
				}
					
//				从连接池中获得一个连接										
				con=pool.getConnection();
//				查询执行部分，并为记录的分页做参数处理						
				Vector vec=new Vector();
				ZwxxDAO zwxxDAO=new ZwxxDAO(con);
				Page_Number pagenumber=new Page_Number(con);
				int pagesize=20;
				String code=request.getParameter("code");
				if(code==null) code="1";
				pagenumber.setPagesize(pagesize);
				pagenumber.setRowcount(str);
				pagenumber.setPagecount();
				vec=zwxxDAO.find_fenye(Integer.parseInt(code),pagesize,str);
				request.setAttribute("vec",vec);
				request.setAttribute("code",code);
				request.setAttribute("pagecount",String.valueOf(pagenumber.getPagecount()));
				request.setAttribute("JOBCATE",JOBCATE);
				request.setAttribute("RegTime",SregTime);
				request.setAttribute("PROVINCE",PROVINCE);
				request.setAttribute("WORKMONEY",WORKMONEY);
//				释放连接
				if(con!=null) con.close();
				return mapping.findForward("success");					
			}
//			捕获一些可能的错误            			
			catch(Throwable e)
			{
				e.printStackTrace();
				ActionError error=new ActionError(e.getMessage());
				errors.add(ActionErrors.GLOBAL_ERROR,error);
			}
//			如果连接未释放，释放连接
			if(con!=null) con.close();
			saveErrors(request,errors);
			return new ActionForward(mapping.getInput());
		}
}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -