package mvc;
import java.io.*;
import javax.servlet.http.*;
import javax.servlet.*;
public class OrderServlet extends HttpServlet
{
	 
	public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException
	{
		doPost(request,response);
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException
	{
		
	  String s1=request.getParameter("state");
	  if(s1!=null)
	    {
	       
	  //訂票
	       if(s1.equals("add"))
	         {
	         	try
	            {
	         	  OrderBean b1=new OrderBean();
	         	  b1.buy(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	             response.sendRedirect("../order1.jsp");
	         }	
	       if(s1.equals("delete"))
	         {
	         	try
	            {
	         	  OrderBean b1=new OrderBean();
	         	  b1.delete(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	             response.sendRedirect("../fy1.jsp");
	         }		
	      if(s1.equals("update"))
	         {
	         	try
	            {
	         	  OrderBean b1=new OrderBean();
	         	  b1.update(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	             response.sendRedirect("../fy1.jsp");
	         }
	         
	   
	       
	  // 用戶登陸 
	       if(s1.equals("login"))
	         {
	         String passCheck=null;
	         	try
	           {
	         	  OrderBean b1=new OrderBean();
	         	 passCheck=b1.login(request);
	         	} 
	          catch(Exception e)
	             {
	              }
	              String aa= request.getParameter("pwd");
	            if(passCheck.equals(aa))
	             {
	           
	             response.sendRedirect("../manager.jsp");	 
	               
	             }
	           else{
	             
	            
	             response.sendRedirect("../userlogin.jsp");	  
	              }
	          } 
	          
	  //飛機管理
	       if(s1.equals("planeAdd"))
	         {
	         	try
	            {
	         	  PlaneBean b1=new PlaneBean();
	         	  b1.addnew(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	             response.sendRedirect("../over.jsp");
	         }	
	       if(s1.equals("planeDelete"))
	         {
	         	try
	            {
	         	  PlaneBean b1=new PlaneBean();
	         	  b1.delete(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	            response.sendRedirect("../over.jsp");
	         }		
	      if(s1.equals("planeUpdate"))
	         {
	         	try
	            {
	         	  PlaneBean b1=new PlaneBean();
	         	  b1.update(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	             response.sendRedirect("../over.jsp");
	         }
	         
	      if(s1.equals("planeSelect"))
	       {
	         try
	            {
	         	  PlaneBean b1=new PlaneBean();
	         	  b1.update(request);
	         	} 
	         catch(Exception e)
	             {
	              }
	           response.sendRedirect("../planequery.jsp");
	        }   
 //公民信息管理  
       
        if(s1.equals("publicAdd"))
	         {
	         	try
	            {
	         	 PubBean b1=new PubBean();
	         	  b1.addnew(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	             response.sendRedirect("../over.jsp");
	         }	
	       if(s1.equals("publicDelete"))
	         {
	         	try
	            {
	         	  PubBean b1=new PubBean();
	         	  b1.delete(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	             response.sendRedirect("../over.jsp");
	         }		
	      if(s1.equals("publicUpdate"))
	         {
	         	try
	            {
	         	  PubBean b1=new PubBean();
	         	  b1.update(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	            response.sendRedirect("../over.jsp");
	         }
	         
	      if(s1.equals("publicSelect"))
	       {
	         //try
	            //{
	         	  //PubBean b1=new PubBean();
	         	  //b1.update(request);
	         	//} 
	         //catch(Exception e)
	            // {
	              //}
	           response.sendRedirect("../publicquery.jsp");
	        } 
	        
 //航班信息管理 
          
          if(s1.equals("hbAdd"))
	         {
	         	try
	            {
	         	 HbBean b1=new HbBean();
	         	  b1.addnew(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	             response.sendRedirect("../over.jsp");
	         }	
	       if(s1.equals("hbDelete"))
	         {
	         	try
	            {
	         	  HbBean b1=new HbBean();
	         	  b1.delete(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	             response.sendRedirect("../over.jsp");
	         }		
	      if(s1.equals("hbUpdate"))
	         {
	         	try
	            {
	         	  HbBean b1=new HbBean();
	         	  b1.update(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	            response.sendRedirect("../over.jsp");
	         }
	         
	      if(s1.equals("hbSelect"))
	       {
	         try
	            {
	         	  HbBean b1=new HbBean();
	         	  b1.update(request);
	         	} 
	         catch(Exception e)
	             {
	              }
	           response.sendRedirect("../hbquery.jsp");
	        } 
	       
 //管理員信息
            
            if(s1.equals("userAdd"))
	         {
	         	try
	            {
	         	 UserBean b1=new UserBean();
	         	  b1.addnew(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	             response.sendRedirect("../over.jsp");
	         }	
	       if(s1.equals("userDelete"))
	         {
	         	try
	            {
	         	  UserBean b1=new UserBean();
	         	  b1.delete(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	             response.sendRedirect("../over.jsp");
	         }		
	      if(s1.equals("userUpdate"))
	         {
	         	try
	            {
	         	  UserBean b1=new UserBean();
	         	  b1.update(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	            response.sendRedirect("../over.jsp");
	         }
	         
	      if(s1.equals("userSelect"))
	       {
	         try
	            {
	         	  UserBean b1=new UserBean();
	         	  b1.update(request);
	         	} 
	         catch(Exception e)
	             {
	              }
	           response.sendRedirect("../userquery.jsp");
	        } 
	        
 //訂票管理信息
        
        
	       if(s1.equals("orderDelete"))
	         {
	         	try
	            {
	         	  OrderBean b1=new OrderBean();
	         	  b1.delete(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	             response.sendRedirect("../over.jsp");
	         }		
	      if(s1.equals("orderUpdate"))
	         {
	         	try
	            {
	         	  OrderBean b1=new OrderBean();
	         	  b1.update(request);
	         	} 
	           catch(Exception e)
	             {
	              }
	            response.sendRedirect("../over.jsp");
	         }
	         
	      if(s1.equals("orderSelect"))
	       {
	         try
	            {
	         	  OrderBean b1=new OrderBean();
	         	  b1.update(request);
	         	} 
	         catch(Exception e)
	             {
	              }
	           response.sendRedirect("../orderquery.jsp");
	        }  
	    }
	    
	}
}