stockservlet.java

精美的画面。完善的功能

package Flower.view;
import Flower.model.DBConnect;
import Flower.model.Stock;
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 Flower.model.stockBean;
public class StockServlet 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 stockid=request.getParameter("stockid");
        String goodsid=request.getParameter("goodsid");
        String stocknum=request.getParameter("stocknum");
        Stock sk=new Stock();
        stockBean skb=new stockBean();
        sk.setStockid(stockid);
        sk.setGoodsid(goodsid);
        sk.setStocknum(Long.parseLong(stocknum));
        if(skb.getID(stockid))
        {
            request.setAttribute("result",stockid+"号编号记录已经存在，请重新输入！");
            getServletContext().getRequestDispatcher("Stockadd.jsp").forward(request,response);
        }
        else
        {
          try 
          {
              if(skb.addStock(sk)) 
              {
                  request.setAttribute("result",stockid+"号编号记录添加成功！");
                  getServletContext().getRequestDispatcher("Stockadd.jsp").forward(request,response);
              }
          } 
          catch (Exception ex) 
          {
            ex.printStackTrace();
          }
          
        }
    }
    if(action.equals("update"))
    {
        String stockid=request.getParameter("stockid");
        String goodsid=request.getParameter("goodsid");
        String stocknum=request.getParameter("stocknum");
        Stock sk=new Stock();
        stockBean skb=new stockBean();
        sk.setStockid(stockid);
        sk.setGoodsid(goodsid);
        sk.setStocknum(Long.parseLong(stocknum));
        if(skb.getID(stockid))
        {
          try 
          {
              if(skb.updateStock(sk)) 
              {
                request.setAttribute("result",stockid+"号编号记录修改成功！");
                getServletContext().getRequestDispatcher("Stockupdate.jsp").forward(request,response);
              }
          } 
          catch (Exception ex) 
          {
            ex.printStackTrace();
          }
          
        }
        else
        {
            request.setAttribute("result",stockid+"号编号记录不存在，请重新输入！");
            getServletContext().getRequestDispatcher("Stockupdate.jsp").forward(request,response);
        }
    }
    if(action.equals("find"))
    {
       String stockid=request.getParameter("stockid");
        String goodsid=request.getParameter("goodsid");
//        String stocknum=request.getParameter("stocknum");
//        if(stocknum.equals(""))
//        {
//          stocknum="0";
//        }
        Stock sk=new Stock();
        stockBean skb=new stockBean();
        sk.setStockid(stockid);
        sk.setGoodsid(goodsid);
//        sk.setStocknum(Long.parseLong(stocknum));
        request.setAttribute("stock",skb.findStock(sk));
        getServletContext().getRequestDispatcher("displayStock.jsp").forward(request,response);
    }
    if(action.equals("del"))
    {
      String stockid=request.getParameter("stockid");
      stockBean skb=new stockBean();
      Connection con=null;
      PreparedStatement pstmt=null;
      ResultSet rs=null;
      try 
      {
        con=DBConnect.getConnection();
        pstmt=con.prepareStatement("select * from Stock where stockid=?");
        pstmt.setString(1,stockid);
        rs=pstmt.executeQuery();
        if(rs.next())
        {
            if(rs.getLong(3)>0)
            {
                request.setAttribute("result",stockid+"编号记录还有库存！不能删除！");
                getServletContext().getRequestDispatcher("Stockfind.jsp").forward(request,response);
            }
            else
            {
              if(skb.delStock(stockid))
              {
                request.setAttribute("result",stockid+"编号记录删除成功！");
                getServletContext().getRequestDispatcher("Stockfind.jsp").forward(request,response);
              }
            }
        }
        rs.close();
        pstmt.close();
        con.close();
      } catch (Exception ex) 
      {
        ex.printStackTrace();
      } 
      
      
    }
    out.close();
  }
}