jingpinservlet.java

精美的画面。完善的功能

package Flower.view;
import Flower.model.DBConnect;
import Flower.model.jingpinBean;
import Flower.model.jingpin;
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 jingpinServlet 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 jpid=request.getParameter("jpid");
      String goodsid=request.getParameter("goodsid");
      jingpin gi=new jingpin();
      jingpinBean gib=new jingpinBean();
      gi.setjpid(jpid);
      gi.setGoodsid(goodsid);
      if(gib.getID(jpid))
      {
            request.setAttribute("result",jpid+"号精品已经存在，请重新输入！");
            getServletContext().getRequestDispatcher("jingpinadd.jsp").forward(request,response);
      }
      else
      {
          try
          {
            if(gib.addjingpin(gi))
            {
                request.setAttribute("result",jpid+"号精品添加成功！");
                getServletContext().getRequestDispatcher("jingpinadd.jsp").forward(request,response);

            }
          }
          catch(Exception ex)
          {
            ex.printStackTrace();
          }
      }
      
    }
    if(action.equals("update"))
    {
       String jpid=request.getParameter("jpid");
      String goodsid=request.getParameter("goodsid");
      jingpin gi=new jingpin();
      jingpinBean gib=new jingpinBean();
      gi.setjpid(jpid);
      gi.setGoodsid(goodsid);
      if(gib.getID(jpid))
      {
        try 
        {
          if(gib.updatejingpin(gi))
          {
            request.setAttribute("result",jpid+"号精品更新成功！");
            getServletContext().getRequestDispatcher("jingpinupdate.jsp").forward(request,response);
          }
        } 
        catch (Exception ex) 
        {
          ex.printStackTrace();
        } 
        
      }
      else
      {
        request.setAttribute("result",jpid+"号精品不存在，请重新输入！");
        getServletContext().getRequestDispatcher("jingpinupdate.jsp").forward(request,response);
      }
    }
    if(action.equals("find"))
    {
      String jpid=request.getParameter("jpid");
      String goodsid=request.getParameter("goodsid");
      jingpin gi=new jingpin();
      jingpinBean gib=new jingpinBean();
      gi.setjpid(jpid);
      gi.setGoodsid(goodsid);
      try
      {
      request.setAttribute("jingpingoods",gib.findjingpin(gi));
      getServletContext().getRequestDispatcher("disjingpin.jsp").forward(request,response);
      }
      catch(Exception ex)
      {
        ex.printStackTrace();
      }
    }
    if(action.equals("del"))
    {
      String jpid=request.getParameter("jpid");
      jingpinBean prob=new jingpinBean();
      if(prob.deljingpin(jpid))
      {
            request.setAttribute("result",jpid+"号精品删除成功！");
            getServletContext().getRequestDispatcher("jingpinfind.jsp").forward(request,response);
      }
      out.close();
    }
  }
}