flowertypeservlet.java

精美的画面。完善的功能

package Flower.view;
import Flower.model.FlowerTypeBean;
import Flower.model.Flowertype;
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 FlowerTypeServlet 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 typeid=request.getParameter("flowerid");
      String typename=request.getParameter("flowername");
      Flowertype ft=new Flowertype();
      FlowerTypeBean ftb=new FlowerTypeBean();
      ft.setFlowertypeid(typeid);
      ft.setFlowertypename(typename);
      try 
      {
        if(ftb.getID(typeid))
        {
            request.setAttribute("result",typeid+"号类别已经存在，请重新输入！");
            getServletContext().getRequestDispatcher("FlowerTypeAdd.jsp").forward(request,response);

        }
        else
        {
            if(ftb.addFlowerType(ft)) 
            {
               request.setAttribute("result",typeid+"号类别添加成功！");
               getServletContext().getRequestDispatcher("FlowerTypeAdd.jsp").forward(request,response);

            }
        }
      } 
      catch (Exception ex) 
      {
        ex.printStackTrace();
      }
      
    }
    if(action.equals("update"))
    {
      String typeid=request.getParameter("flowerid");
      String typename=request.getParameter("flowername");
      Flowertype ft=new Flowertype();
      FlowerTypeBean ftb=new FlowerTypeBean();
      ft.setFlowertypeid(typeid);
      ft.setFlowertypename(typename);
      if(ftb.getID(typeid))
      {
        try
        {
          if(ftb.updateFlowerType(ft))
          {
              request.setAttribute("result",typeid+"号类别修改成功！");
              getServletContext().getRequestDispatcher("FlowerTypeUpdate.jsp").forward(request,response);
          }
        }
        catch(Exception ex)
        {
          ex.printStackTrace();
        }
      }
      else
      {
              request.setAttribute("result",typeid+"号类别不存在！请重新输入！");
              getServletContext().getRequestDispatcher("FlowerTypeUpdate.jsp").forward(request,response);

      }
    }
    if(action.equals("find"))
    {
      String typeid=request.getParameter("flowerid");
      String typename=request.getParameter("flowername");
      Flowertype ft=new Flowertype();
      FlowerTypeBean ftb=new FlowerTypeBean();
      ft.setFlowertypeid(typeid);
      ft.setFlowertypename(typename);
      request.setAttribute("FlowerType",ftb.findFlowerType(ft));
      getServletContext().getRequestDispatcher("displayFloType.jsp").forward(request,response);
    }
    if(action.equals("del"))
    {
      String typeid=request.getParameter("typeid");
      FlowerTypeBean gib=new FlowerTypeBean();
      Connection con=null;
      PreparedStatement pstmt=null;
      ResultSet rs=null;
      try 
      {
        con=DBConnect.getConnection();
        pstmt=con.prepareStatement("select * from flowerinfo where flowertypeid=?");
        pstmt.setString(1,typeid);
        rs=pstmt.executeQuery();
        if(rs.next())
        {
          request.setAttribute("result",typeid+"号记录不能删除，在花卉表中有引用");
          getServletContext().getRequestDispatcher("FLowerTypeFind.jsp").forward(request,response);
        }
        else
        {
          if(gib.delFlowerType(typeid))
          {
            request.setAttribute("result",typeid+"记录删除成功！");
            getServletContext().getRequestDispatcher("FLowerTypeFind.jsp").forward(request,response);
          }
        }
        rs.close();
        pstmt.close();
        con.close();
      } 
      catch (Exception ex) 
      {
        ex.printStackTrace();
      }
//      String typeid=request.getParameter("typeid");
//      FlowerTypeBean ftb=new FlowerTypeBean();
//      if(ftb.getID(typeid))
//      {
//        if(ftb.delFlowerType(typeid))
//        {
//              request.setAttribute("result",typeid+"号类别删除成功！");
//              getServletContext().getRequestDispatcher("FLowerTypeFind.jsp").forward(request,response);
//
//        }
//      }
//      else
//      {
//              request.setAttribute("result",typeid+"号类别不存在！请重新输入！");
//              getServletContext().getRequestDispatcher("FLowerTypeFind.jsp").forward(request,response);
//
//      }
    }
    out.close();
  }
}