back_cpgq_search_action.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 back_cpgq_search_action extends Action{
//	初始化连接池
	private ConnectionPool pool;
	
	public back_cpgq_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 sql="",fblx="",stype="",SregTime="-1",NTIME="";
				int RegTime=-1;
//				获得查询参数
				fblx=request.getParameter("fblx");					
				if(request.getParameter("stype")!=null)
				{
				    stype=request.getParameter("stype");
				    stype=new String(stype.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);
				}						
				
//				根据参数的不同完成不同的查询语句	
				//000
				if(fblx.equals("")&&stype.equals("")&&RegTime==-1)
				{
					sql="SELECT CPGQB.ID,CPGQB.UUID,CPGQB.NAME,CPGQB.STYPE,CPGQB.KIND,CPGQB.DESCRIBE,CPGQB.SPEC,CPGQB.AREA,CPGQB.QUANTITY,CPGQB.PRICE,CPGQB.FBDATE,CPGQB.EDATE,CPGQB.FLAG,CPGQB.PHOTO,MEMBER.COMPANY FROM CPGQB,MEMBER WHERE MEMBER.UUID=CPGQB.UUID ORDER BY FLAG";
				}
				//100
				if(!fblx.equals("")&&stype.equals("")&&RegTime==-1)
				{
					if(fblx.equals("true")||fblx.equals("false"))
					{
						sql="SELECT CPGQB.ID,CPGQB.UUID,CPGQB.NAME,CPGQB.STYPE,CPGQB.KIND,CPGQB.DESCRIBE,CPGQB.SPEC,CPGQB.AREA,CPGQB.QUANTITY,CPGQB.PRICE,CPGQB.FBDATE,CPGQB.EDATE,CPGQB.FLAG,CPGQB.PHOTO,MEMBER.COMPANY FROM CPGQB,MEMBER WHERE MEMBER.UUID=CPGQB.UUID AND FLAG="+"'"+fblx+"'";
					}
					else
					{
						sql="SELECT CPGQB.ID,CPGQB.UUID,CPGQB.NAME,CPGQB.STYPE,CPGQB.KIND,CPGQB.DESCRIBE,CPGQB.SPEC,CPGQB.AREA,CPGQB.QUANTITY,CPGQB.PRICE,CPGQB.FBDATE,CPGQB.EDATE,CPGQB.FLAG,CPGQB.PHOTO,MEMBER.COMPANY FROM CPGQB,MEMBER WHERE MEMBER.UUID=CPGQB.UUID ORDER BY FLAG";
					}
				}
				//010										 										
				if(fblx.equals("")&&!stype.equals("")&&RegTime==-1)
				{
					sql="SELECT CPGQB.ID,CPGQB.UUID,CPGQB.NAME,CPGQB.STYPE,CPGQB.KIND,CPGQB.DESCRIBE,CPGQB.SPEC,CPGQB.AREA,CPGQB.QUANTITY,CPGQB.PRICE,CPGQB.FBDATE,CPGQB.EDATE,CPGQB.FLAG,CPGQB.PHOTO,MEMBER.COMPANY FROM CPGQB,MEMBER WHERE MEMBER.UUID=CPGQB.UUID AND STYPE="+"'"+stype+"'"+"ORDER BY FLAG";
				}
				//110
				if(!fblx.equals("")&&!stype.equals("")&&RegTime==-1)
				{
					if(fblx.equals("true")||fblx.equals("false"))
					{
						sql="SELECT CPGQB.ID,CPGQB.UUID,CPGQB.NAME,CPGQB.STYPE,CPGQB.KIND,CPGQB.DESCRIBE,CPGQB.SPEC,CPGQB.AREA,CPGQB.QUANTITY,CPGQB.PRICE,CPGQB.FBDATE,CPGQB.EDATE,CPGQB.FLAG,CPGQB.PHOTO,MEMBER.COMPANY FROM CPGQB,MEMBER WHERE MEMBER.UUID=CPGQB.UUID AND FLAG="+"'"+fblx+"'"+"AND STYPE="+"'"+stype+"'";
					}
					else
					{
						sql="SELECT CPGQB.ID,CPGQB.UUID,CPGQB.NAME,CPGQB.STYPE,CPGQB.KIND,CPGQB.DESCRIBE,CPGQB.SPEC,CPGQB.AREA,CPGQB.QUANTITY,CPGQB.PRICE,CPGQB.FBDATE,CPGQB.EDATE,CPGQB.FLAG,CPGQB.PHOTO,MEMBER.COMPANY FROM CPGQB,MEMBER WHERE MEMBER.UUID=CPGQB.UUID AND STYPE="+"'"+stype+"'"+"ORDER BY FLAG";
					}
				}
				//001
				if(fblx.equals("")&&stype.equals("")&&RegTime!=-1)
				{
					sql="SELECT CPGQB.ID,CPGQB.UUID,CPGQB.NAME,CPGQB.STYPE,CPGQB.KIND,CPGQB.DESCRIBE,CPGQB.SPEC,CPGQB.AREA,CPGQB.QUANTITY,CPGQB.PRICE,CPGQB.FBDATE,CPGQB.EDATE,CPGQB.FLAG,CPGQB.PHOTO,MEMBER.COMPANY FROM CPGQB,MEMBER WHERE MEMBER.UUID=CPGQB.UUID AND FBDATE>"+"'"+NTIME+"'"+"ORDER BY FLAG";
				}				
				//101
				if(!fblx.equals("")&&stype.equals("")&&RegTime!=-1)
				{
					if(fblx.equals("true")||fblx.equals("false"))
					{
						sql="SELECT CPGQB.ID,CPGQB.UUID,CPGQB.NAME,CPGQB.STYPE,CPGQB.KIND,CPGQB.DESCRIBE,CPGQB.SPEC,CPGQB.AREA,CPGQB.QUANTITY,CPGQB.PRICE,CPGQB.FBDATE,CPGQB.EDATE,CPGQB.FLAG,CPGQB.PHOTO,MEMBER.COMPANY FROM CPGQB,MEMBER WHERE MEMBER.UUID=CPGQB.UUID AND FLAG="+"'"+fblx+"'"+"and FBDATE>"+"'"+NTIME+"'";
					}
					else
					{
						sql="SELECT CPGQB.ID,CPGQB.UUID,CPGQB.NAME,CPGQB.STYPE,CPGQB.KIND,CPGQB.DESCRIBE,CPGQB.SPEC,CPGQB.AREA,CPGQB.QUANTITY,CPGQB.PRICE,CPGQB.FBDATE,CPGQB.EDATE,CPGQB.FLAG,CPGQB.PHOTO,MEMBER.COMPANY FROM CPGQB,MEMBER WHERE MEMBER.UUID=CPGQB.UUID AND FBDATE>"+"'"+NTIME+"'"+"ORDER BY FLAG";
					}
				}
				//011
				if(fblx.equals("")&&!stype.equals("")&&RegTime!=-1)
				{
					sql="SELECT CPGQB.ID,CPGQB.UUID,CPGQB.NAME,CPGQB.STYPE,CPGQB.KIND,CPGQB.DESCRIBE,CPGQB.SPEC,CPGQB.AREA,CPGQB.QUANTITY,CPGQB.PRICE,CPGQB.FBDATE,CPGQB.EDATE,CPGQB.FLAG,CPGQB.PHOTO,MEMBER.COMPANY FROM CPGQB,MEMBER WHERE MEMBER.UUID=CPGQB.UUID AND STYPE="+"'"+stype+"'"+"and FBDATE>"+"'"+NTIME+"'"+"ORDER BY FLAG";
				}
				//111					
				if(!fblx.equals("")&&!stype.equals("")&&RegTime!=-1)
				{
					if(fblx.equals("true")||fblx.equals("false"))
					{
						sql="SELECT CPGQB.ID,CPGQB.UUID,CPGQB.NAME,CPGQB.STYPE,CPGQB.KIND,CPGQB.DESCRIBE,CPGQB.SPEC,CPGQB.AREA,CPGQB.QUANTITY,CPGQB.PRICE,CPGQB.FBDATE,CPGQB.EDATE,CPGQB.FLAG,CPGQB.PHOTO,MEMBER.COMPANY FROM CPGQB,MEMBER WHERE MEMBER.UUID=CPGQB.UUID AND FLAG="+"'"+fblx+"'"+"AND STYPE="+"'"+stype+"'"+"and FBDATE>"+"'"+NTIME+"'";
					}
					else
					{
						sql="SELECT CPGQB.ID,CPGQB.UUID,CPGQB.NAME,CPGQB.STYPE,CPGQB.KIND,CPGQB.DESCRIBE,CPGQB.SPEC,CPGQB.AREA,CPGQB.QUANTITY,CPGQB.PRICE,CPGQB.FBDATE,CPGQB.EDATE,CPGQB.FLAG,CPGQB.PHOTO,MEMBER.COMPANY FROM CPGQB,MEMBER WHERE MEMBER.UUID=CPGQB.UUID AND STYPE="+"'"+stype+"'"+"and FBDATE>"+"'"+NTIME+"'"+"ORDER BY FLAG";
					} 
				}					
//				从连接池中获得一个连接									
				con=pool.getConnection();
//				查询执行部分，并为记录的分页做参数处理						
				Vector vec=new Vector();
				CpgqDAO cpgqDAO=new CpgqDAO(con);
				Page_Number pagenumber=new Page_Number(con);
				int pagesize=5;
				String code=request.getParameter("code");
				if(code==null) code="1";
				pagenumber.setPagesize(pagesize);
				pagenumber.setRowcount(sql);
				pagenumber.setPagecount();
				vec=cpgqDAO.find_fenye(Integer.parseInt(code),pagesize,sql);
				request.setAttribute("vec",vec);
				request.setAttribute("code",code);
				request.setAttribute("pagecount",String.valueOf(pagenumber.getPagecount()));
				request.setAttribute("fblx",fblx);
				request.setAttribute("stype",stype);
				request.setAttribute("regtime",SregTime);					
//				释放连接		
				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());
		}
}