search_gqfb_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 org.apache.struts.action.ActionServlet;


import javabean.*;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletException;

import java.io.IOException;

import java.sql.Connection;
import java.sql.SQLException;

import java.util.Vector;

import javabean.*;
import struts.form.*;

public class Search_Gqfb_Action extends Action{
	private ConnectionPool pool;
	
		public Search_Gqfb_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());
		}
	}