cartservlet.java

精美的画面。完善的功能

package Flower.view;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.PrintWriter;
import java.io.IOException;
import java.util.*;
import Flower.model.*;
import java.sql.Date;
public class CartServlet extends HttpServlet 
{
  private static final String CONTENT_TYPE = "text/html; charset=GBK";

  public void init(ServletConfig config) throws ServletException
  {
    super.init(config);
  }

  public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
  {
    this.doPost(request,response);
  }

  public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
  {
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();
    
    String action="";  
    if(request.getParameter("action")==null)
    {
       action="";
    }
    else
    {
      action=request.getParameter("action");
    }
    HttpSession session=request.getSession();
    if(session.getAttribute("cart")==null)//判断session对象存不存在
    {
      session.setAttribute("cart",new shoppingCartBean());
    }
    shoppingCartBean cart=(shoppingCartBean)session.getAttribute("cart");
    if(action.equals("addcart"))
    {
      String goodsid=request.getParameter("goodsid");
      String rprice=request.getParameter("rprice");
      String num=request.getParameter("num");
      if(num==null || num.equals(""))
        num="0";
      if(goodsid!=null&!goodsid.equals(""))
      {
        shoppingCart p=new shoppingCart();
        p.setGoodsid(goodsid);
        p.setPrice(Double.parseDouble(rprice));
        p.setNum(Long.parseLong(num));
        cart.addItem(p);
      }
      response.sendRedirect("FlowerIndex.jsp");
      
      
      
    }
   
    
     if(action.equals("buyorder"))
    {
      String payway=request.getParameter("payway");
      String payflag=request.getParameter("payflag");
      String flag=request.getParameter("flag");
      String orderid=request.getParameter("orderid");
      String cusid=request.getParameter("cusid");
      String orderdate=request.getParameter("orderdate");
      String totalmoney=request.getParameter("totalmoney");
      Ordermain o=new Ordermain();
      OrdermainBean omb=new OrdermainBean();
     // Orderlist ol=new Orderlist();
      o.setOrderid(orderid);
      o.setCustomerid(cusid);
      o.setOrderdate(Date.valueOf(orderdate));
      o.setTotalmoney(Double.parseDouble(totalmoney));
      o.setPaytype(payway);
      o.setPayflag(payflag);
      o.setFlag(flag);
      int num1=0;
      String state="";
      String state1="";
      if(omb.getid(orderid))
      {
          request.setAttribute("result",orderid+"号订单已存在！");
          getServletContext().getRequestDispatcher("display.jsp").forward(request,response);
      }
      else
      {
        try
        {
          if(omb.addOrder(o))
          {
            state="success";
          }
        }
        catch(Exception ex)
        {
          ex.printStackTrace();
        }
      }
      
        Enumeration enum=cart.getOrderedItems();
        shoppingCart pp;
        while(enum.hasMoreElements())
        {
                Orderlist oo=new Orderlist();
                 OrderlistBean olb=new OrderlistBean();      
                 
                 pp=(shoppingCart)enum.nextElement();
                 
                 num1=num1+1;
                 oo.setOrderid(orderid);
                 oo.setListid(String.valueOf(num1));
                 oo.setGoodsid(pp.getGoodsid());
                 oo.setNum(pp.getNum());
                 oo.setPrice(pp.getPrice());
                 try
                 {
                    if(olb.addOrderlist(oo))
                    {
                        state1="success";
                    }
                 }
                 catch(Exception ex)
                 {
                   ex.printStackTrace();
                 }
                 
        }
        if(state.equals("success")&state1.equals("success"))
        {
           request.setAttribute("result",orderid+"号订单添加成功！");
           session.removeAttribute("cart");
            getServletContext().getRequestDispatcher("display.jsp").forward(request,response);
        }
    }
    String action1="";
    String buttonname="";
    if(request.getParameter("remove")!=null)
    {
      buttonname=request.getParameter("remove");
    }
    else
    {
      buttonname="修改";
    }
    if(request.getParameter("action1")!=null)
    {
      action1=request.getParameter("action1");
    }
    else
    {
      action1="";
    }
    if(action1.equals("del")&buttonname.equals("移除"))
    {
      String goodsid=request.getParameter("goodsid");
      if(goodsid!=null&!goodsid.equals(""))
      {
        cart.removeOrderedItem(goodsid);
      }
      response.sendRedirect("buy1.jsp");
    }
    if(action1.equals("del")&buttonname.equals("修改"))
    {
      String goodsid=request.getParameter("goodsid");
      String sum=request.getParameter("num");
      shoppingCartBean scb=new shoppingCartBean();
      shoppingCart pp=new shoppingCart();
      if(goodsid!=null&!goodsid.equals(""))
      {
        pp.setGoodsid(goodsid);
        pp.setNum(Long.parseLong(sum));
        cart.EditNum(pp);
      
        
      }
      response.sendRedirect("buy1.jsp");
    }
    if(action.equals("orderfind"))
    {
      String orderid=request.getParameter("orderid");
      if(orderid==null)
      {
        orderid="";
      }
      String cusid=request.getParameter("cusid");
      if(cusid==null)
      {
        cusid="";
      }
      String payway=request.getParameter("payway");
      String payflag=request.getParameter("payflag");
      String flag=request.getParameter("flag");
      
      Ordermain oo=new Ordermain();
      OrdermainBean omb=new OrdermainBean();
      oo.setOrderid(orderid);
      oo.setCustomerid(cusid);
      oo.setPaytype(payway);
      oo.setPayflag(payflag);
      oo.setFlag(flag);
      request.setAttribute("findorder",omb.FindOrder(oo));
      getServletContext().getRequestDispatcher("displayOrder.jsp").forward(request,response);
      
    }
    if(action.equals("editordermain"))
    {
      String orderid=request.getParameter("orderid");
      String payflag=request.getParameter("payflag");
      String flag=request.getParameter("flag");
      if(payflag.equals("是")&flag.equals("已发货"))
      {
        Connection con1=null;
        PreparedStatement pstmt1=null;
        ResultSet rs1=null;
        try 
        {
            con1=DBConnect.getConnection();
            pstmt1=con1.prepareStatement("select * from OrderList where Orderid=?");
            pstmt1.setString(1,orderid);
            rs1=pstmt1.executeQuery();
            while(rs1.next())
            {
              Connection con2=null;
              PreparedStatement pstmt2=null;
              ResultSet rs2=null;
              try 
              {
                con2=DBConnect.getConnection();
                pstmt2=con2.prepareStatement("update Stock set Stocknum=Stocknum-? where goodsid=?");
                pstmt2.setLong(1,rs1.getLong(4));
                pstmt2.setString(2,rs1.getString(3));
                pstmt2.executeUpdate();
                
                
              }
              catch (Exception ex) 
              {
                ex.printStackTrace();
              }
              rs2.close();
              pstmt2.close();
              con2.close();
            }
            con1.close();
            pstmt1.close();
            rs1.close();
        } 
        catch (Exception ex) 
        {
          ex.printStackTrace();
        }
      }
      Connection con=null;
      PreparedStatement pstmt=null;
      try 
      {
         con=DBConnect.getConnection();
        pstmt=con.prepareStatement("update Ordermain set payflag=?,flag=? where OrderId=?");
        pstmt.setString(1,payflag);
        pstmt.setString(2,flag);
        pstmt.setString(3,orderid);
        pstmt.executeUpdate();
        request.setAttribute("result","修改成功");
      getServletContext().getRequestDispatcher("display.jsp").forward(request,response);
      } 
      catch (Exception ex) 
      {
        ex.printStackTrace();
      }      
     
    }
    if(action.equals("delorder"))
    {
    String orderid=request.getParameter("orderid");
      Connection con=null;
      PreparedStatement pstmt=null;
      ResultSet rs=null;
      OrdermainBean omb=new OrdermainBean();
      OrderlistBean olb=new OrderlistBean();
      try
      {
      con=DBConnect.getConnection();
      pstmt=con.prepareStatement("select * from ordermain where orderid=?");
      pstmt.setString(1,orderid);
      rs=pstmt.executeQuery();
      while(rs.next())
      {
        if((rs.getString(6).equals("是")&rs.getString(7).equals("已发货"))||(rs.getString(6).equals("否")&rs.getString(7).equals("未发货")))
        {
          if(omb.delOrder(orderid)&olb.delOrderList(orderid))
          {
            request.setAttribute("result",orderid+"号订单删除成功");
            getServletContext().getRequestDispatcher("display.jsp").forward(request,response);
          }
        }
        else
        {
           request.setAttribute("result",orderid+"号订单不能删除，该订单未付款或未发货");
            getServletContext().getRequestDispatcher("display.jsp").forward(request,response);
        }
      }
      }
      catch(Exception ex)
      {
        ex.printStackTrace();
      }
      
    }
    out.close();
  }
}