providerservlet.java

精美的画面。完善的功能

package Flower.view;
import Flower.model.ProviderBean;
import Flower.model.Providerinfo11;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.PrintWriter;
import java.io.IOException;
import Flower.model.DBConnect;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class ProviderServlet 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("provideradd"))
    {
      String supid=request.getParameter("supid");
      String supname=request.getParameter("supname");
      String address=request.getParameter("address");
      String zipcode=request.getParameter("zipcode");
      String email=request.getParameter("email");
      String tel=request.getParameter("tel");
      Providerinfo11 pro=new Providerinfo11();
      ProviderBean prob=new ProviderBean();
      pro.setSupid(supid);
      pro.setSupname(supname);
      pro.setAddress(address);
      pro.setZipcode(zipcode);
      pro.setEmail(email);
      pro.setTel(tel);
      if(prob.getID(supid))
      {
         
              
                request.setAttribute("result",supid+"号帐号已经存在，请重新输入！");
                getServletContext().getRequestDispatcher("Provider.jsp").forward(request,response);
           
      }
      else
      {
        try
        {
          if(prob.addProvider(pro))
          {
                request.setAttribute("result",supid+"号帐号添加成功！");
                getServletContext().getRequestDispatcher("Provider.jsp").forward(request,response);
          }
        }
        catch(Exception ex)
        {
          ex.printStackTrace();
        }
      }
    }
    if(action.equals("providerfind"))
    {
      String supid=request.getParameter("supid");
      String supname=request.getParameter("supname");
      Providerinfo11 pro=new Providerinfo11();
      ProviderBean prob=new ProviderBean();
      pro.setSupid(supid);
      pro.setSupname(supname);
      request.setAttribute("provider",prob.FindProvider(pro));
      getServletContext().getRequestDispatcher("displayPro.jsp").forward(request,response);
      
    }
    if(action.equals("providerupdate"))
    {
      String supid=request.getParameter("supid");
      String supname=request.getParameter("supname");
      String address=request.getParameter("address");
      String zipcode=request.getParameter("zipcode");
      String email=request.getParameter("email");
      String tel=request.getParameter("tel");
      Providerinfo11 pro=new Providerinfo11();
      ProviderBean prob=new ProviderBean();
      pro.setSupid(supid);
      pro.setSupname(supname);
      pro.setAddress(address);
      pro.setZipcode(zipcode);
      pro.setEmail(email);
      pro.setTel(tel);
      try
      {
        if(prob.updateProvider(pro))
        {
                request.setAttribute("result",supid+"号帐号修改成功！");
                getServletContext().getRequestDispatcher("ProviderFind.jsp").forward(request,response);
        }
      }
      catch(Exception ex)
      {
        ex.printStackTrace();
      }
    }
    if(action.equals("del"))
    {
      String supid=request.getParameter("Supid");
      ProviderBean gib=new ProviderBean();
      Connection con=null;
      PreparedStatement pstmt=null;
      ResultSet rs=null;
      try 
      {
        con=DBConnect.getConnection();
        pstmt=con.prepareStatement("select * from goodsinfo where Supid=?");
        pstmt.setString(1,supid);
        rs=pstmt.executeQuery();
        if(rs.next())
        {
          request.setAttribute("result",supid+"号记录不能删除，在商品表中有引用");
          getServletContext().getRequestDispatcher("ProviderFind.jsp").forward(request,response);
        }
        else
        {
          if(gib.delProvider(supid))
          {
            request.setAttribute("result",supid+"记录删除成功！");
            getServletContext().getRequestDispatcher("ProviderFind.jsp").forward(request,response);
          }
        }
        rs.close();
        pstmt.close();
        con.close();
      } 
      catch (Exception ex) 
      {
        ex.printStackTrace();
      }
//      String supid=request.getParameter("Supid");
//      ProviderBean prob=new ProviderBean();
//      if(prob.delProvider(supid))
//      {
//            request.setAttribute("result",supid+"号帐号删除成功！");
//            getServletContext().getRequestDispatcher("ProviderFind.jsp").forward(request,response);
//      }
    }
    out.close();
  }
}