searchorder.java

整个系统采用MVC开发模式

package lp;

import java.io.IOException;
import java.io.PrintWriter;

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

public class searchorder extends HttpServlet {

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		  response.setContentType("text/xml; charset=gbk");
		  
		   String[] boxes= request.getParameterValues("query_way"); 
		   HttpSession session = request.getSession(true);
		  
		   String receiver = null ;
		   int postalcode = 0 ;
		   double min = 0.0;
		   double max = 0.0;
		   String sqlr = null , sql = "select * from goodsorder where username = '" + session.getAttribute("username") 
		   + "' " , 
		   sqlp = null , sqlc = null ; 

		   if (boxes != null && boxes.length != 0) 
		   { 
		      for(int i=0;i<boxes.length;i++)
		      { 
		        System.out.println(boxes[i]); 
		        
		        if("receiver".equals(boxes[i]))
		        {
		        	receiver = request.getParameter("receiver");
		        	sqlr = "receiver = '" + receiver + "'";
		        }	
		      	else if("postalcode".equals(boxes[i]))
		      	{
		      		postalcode = Integer.parseInt(request.getParameter("postalcode").toString().trim());
		      		sqlp = "postalcode = " + postalcode;
		      	}
		      	else if("cost".equals(boxes[i]))
		      	{
		      		min = Double.parseDouble(request.getParameter("min").toString().trim());
		 		    max = Double.parseDouble(request.getParameter("max").toString().trim());
		      		sqlc = "cost between " + min + " and " + max;
		      	}
		   	   }
		    }else
		    { 
		    	 System.out.println("no select"); 
		    } 
		  		   
		   //获取搜索参数值
		   if(boxes.length == 1)
		   {
			   if(null != sqlr) sql = sql + " && " + sqlr;
			   else if(null != sqlp) sql = sql + " && " + sqlp;
			   else sql = sql + " && " + sqlc;
		   }
		   else if(boxes.length == 2)
		   {
			   if(null != sqlr) 
			     {
				   if(null != sqlp)sql = sql + " && " + sqlr + " && " + sqlp; 
				   else sql = sql + " && " + sqlr + "&& " + sqlc; 
				 }
			   else
				   sql = sql + " && " + sqlp + " && " + sqlc;
		   }
		   else if(boxes.length == 3)
			   sql = sql + " && " + sqlr + " && " + sqlp + " && " + sqlc;
	  
		   session.setAttribute("sqlselectorder", sql);
		   response.sendRedirect("select_order.jsp");
		   
		   System.out.println("search servlet 传入的参数 sql = " + sql);
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doGet(request, response);
		}
}