orderbyuserservlet.java

该系统具体分为2个部分：前台和后台。 1．前台主要用于用户进行浏览和搜索

package ynuServlet;


import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import ynuBean.UpdateOrderBean;

public class OrderByUserServlet extends HttpServlet {
	public void init()throws ServletException
    {
    	
    }
    
    public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException
    {
    	String kind="";
    	kind = request.getParameter("kind");
    	if(kind.equals("add"))
    	{
    		sendsql(request,response);
    	}
    	else
    	{
    		this.executeSql(request, response);
    	}
    }
    
    public void sendsql(HttpServletRequest request, HttpServletResponse response)
    throws ServletException,IOException
    {  	  
    	HttpSession session = request.getSession();   	
    	
    	String username = (String)session.getAttribute("username");
    	String pname = request.getParameter("pname");
    	int orderqty = Integer.parseInt(request.getParameter("orderqty"));   	
        	
    	if(orderqty>0)
    	{  		
    		executeSql(request,response,username,pname,orderqty);
    	}
    	else
    	{
    		session.setAttribute("message5", "输入大于0的数值");
    		String toJsp = "/searchbyuser.jsp";
    		RequestDispatcher dispatcher = request.getRequestDispatcher(toJsp);	
        	//dispatcher = request.getRequestDispatcher(toJsp);   	
        	response.setHeader("Refresh", "0.1; URL=/PesticideInfoManagement"+toJsp+"");
        	dispatcher.forward(request, response);
    		//session.invalidate();
    	}
        
    }
	
    public void executeSql(HttpServletRequest request, HttpServletResponse response,
    	String username,String pname,int orderqty)
                  throws ServletException,IOException 
    {
    	HttpSession session = request.getSession();
        String toJsp = "/searchbyuser.jsp";
        UpdateOrderBean aBean = new UpdateOrderBean();
       
        String msg = aBean.AddOrder(username, pname, orderqty);
    	String orderway = request.getParameter("orderway");
    	
        if(orderway.equals("order"))
        {
        	toJsp = "/order.jsp";
        }
        else if(orderway.equals("detail"))
        {
        	toJsp = "/detail.jsp";
        }
        else
        {
        	toJsp = "/searchbyuser.jsp";
        }
        
        session.setAttribute("message5", msg);
    	RequestDispatcher dispatcher = request.getRequestDispatcher(toJsp);	
    	//dispatcher = request.getRequestDispatcher(toJsp);   	
    	response.setHeader("Refresh", "0.1; URL=/PesticideInfoManagement"+toJsp+"");
    	dispatcher.forward(request, response);
    }	
    
    public void executeSql(HttpServletRequest request, HttpServletResponse response)
                      throws ServletException,IOException 
     {
        	HttpSession session = request.getSession();
            String toJsp = "/watchorder.jsp";
            UpdateOrderBean aBean = new UpdateOrderBean();
            int ordernum = Integer.parseInt(request.getParameter("ordernum"));
            String pname = request.getParameter("pname");
            int qty = Integer.parseInt(request.getParameter("qty"));  
            String msg = aBean.DeleteOrder(ordernum,qty,pname);
        	
            session.setAttribute("message6", msg);
        	RequestDispatcher dispatcher = request.getRequestDispatcher(toJsp);	
        	//dispatcher = request.getRequestDispatcher(toJsp);   	
        	response.setHeader("Refresh", "0.1; URL=/PesticideInfoManagement"+toJsp+"");
        	dispatcher.forward(request, response);
    }
    
    //Process the HTTP Post request
    public void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException
    {
        doGet(request, response);
    }
}