goodsinfoservlet.java

精美的画面。完善的功能

package Flower.view;
import Flower.model.DBConnect;
import Flower.model.GoodsInfoBean;
import Flower.model.Goodsinfo;
import Flower.model.FlowerInfoBean;
import Flower.model.ProviderBean;
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;

public class GoodsInfoServlet 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=request.getParameter("action");
    if(action.equals("add"))
    {
      String goodsid=request.getParameter("goodsid");
      String flowerid=request.getParameter("flowerid");
      String rprice=request.getParameter("rprice");
      String cprice=request.getParameter("cprice");
      String supid=request.getParameter("supid");
      String attr=request.getParameter("attr");
      Goodsinfo gi=new Goodsinfo();
      GoodsInfoBean gib=new GoodsInfoBean();
      gi.setGoodsid(goodsid);
      gi.setFlowerid(flowerid);
      gi.setRetailprice(Double.parseDouble(rprice));
      gi.setCostprice(Double.parseDouble(cprice));
      gi.setSupid(supid);
      gi.setAttr(attr);
      if(gib.getID(goodsid))
      {
            request.setAttribute("result",goodsid+"号商品已经存在，请重新输入！");
            getServletContext().getRequestDispatcher("Goodsinfoadd.jsp").forward(request,response);

      }
      else
      {
          try
          {
            if(gib.addGoodsInfo(gi))
            {
                request.setAttribute("result",goodsid+"号商品添加成功！");
                getServletContext().getRequestDispatcher("Goodsinfoadd.jsp").forward(request,response);

            }
          }
          catch(Exception ex)
          {
            ex.printStackTrace();
          }
      }
      
    }
    if(action.equals("update"))
    {
        String goodsid=request.getParameter("goodsid");
        String flowerid=request.getParameter("flowerid");
        String rprice=request.getParameter("rprice");
        String cprice=request.getParameter("cprice");
        String supid=request.getParameter("supid");    
        String attr=request.getParameter("attr");
        Goodsinfo fi=new Goodsinfo();
        fi.setGoodsid(goodsid);
        fi.setFlowerid(flowerid);
        fi.setRetailprice(Double.parseDouble(rprice));;
        fi.setCostprice(Double.parseDouble(cprice));
        fi.setSupid(supid);
        fi.setAttr(attr);
        GoodsInfoBean fib=new GoodsInfoBean();
        FlowerInfoBean ftb=new FlowerInfoBean();
        ProviderBean pb=new ProviderBean();
        if(fib.getID(goodsid))
        {
          try
          {
            if(fib.updateGoodsInfo(fi))
            {
               request.setAttribute("result",goodsid+"号商品修改成功！");
                getServletContext().getRequestDispatcher("Goodsinfoupdate.jsp").forward(request,response);

            }
          }
          catch(Exception ex)
          {
            ex.printStackTrace();
          }
        }
        else
        {
                request.setAttribute("result",goodsid+"号商品不存在！请重新输入！");
                getServletContext().getRequestDispatcher("Goodsinfoupdate.jsp").forward(request,response);

        }
    }
    if(action.equals("find"))
    {
    
       String goodsid=request.getParameter("goodsid");
      String flowerid=request.getParameter("flowerid");
      String supid=request.getParameter("supid");
      Goodsinfo gi=new Goodsinfo();
      GoodsInfoBean gib=new GoodsInfoBean();
      gi.setGoodsid(goodsid);
      gi.setFlowerid(flowerid);
      gi.setSupid(supid);
      try
      {
      request.setAttribute("goods",gib.findGoodsInfo(gi));
      getServletContext().getRequestDispatcher("displayGoods.jsp").forward(request,response);
      }
      catch(Exception ex)
      {
        ex.printStackTrace();
      }
    }
    if(action.equals("del"))
    {
      String goodsid=request.getParameter("goodsid");
      GoodsInfoBean gib=new GoodsInfoBean();
      Connection con=null;
      PreparedStatement pstmt=null;
      ResultSet rs=null;
      try 
      {
        con=DBConnect.getConnection();
        pstmt=con.prepareStatement("select * from Stock where goodsid=?");
        pstmt.setString(1,goodsid);
        rs=pstmt.executeQuery();
        if(rs.next())
        {
          request.setAttribute("result",goodsid+"号记录不能删除，在库存表中有引用");
          getServletContext().getRequestDispatcher("GoodsinfoFind.jsp").forward(request,response);
        }
        else
        {
          if(gib.delGoodsInfo(goodsid))
          {
            request.setAttribute("result",goodsid+"记录删除成功！");
            getServletContext().getRequestDispatcher("GoodsinfoFind.jsp").forward(request,response);
          }
        }
        rs.close();
        pstmt.close();
        con.close();
      } 
      catch (Exception ex) 
      {
        ex.printStackTrace();
      }
      
      
      
      
    }
    out.close();
  }
}