flowerinfoservlet.java

精美的画面。完善的功能

package Flower.view;
import Flower.model.FlowerInfoBean;
import Flower.model.FlowerTypeBean;
import Flower.model.Flowerinfo;
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 FlowerInfoServlet 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 flowerid=request.getParameter("flowerid");
        String flowername=request.getParameter("flowername");
        String flowertypeid=request.getParameter("flowertypeid");
        String flowercolor=request.getParameter("flowercolor");
        String flowerphoto="images/"+request.getParameter("flowerphoto").substring(request.getParameter("flowerphoto").lastIndexOf("\\")+1);
        
        String flowermark=request.getParameter("flowermark");
        Flowerinfo fi=new Flowerinfo();
        fi.setFlowerid(flowerid);
        fi.setFlowername(flowername);
        fi.setFlowertypeid(flowertypeid);
        fi.setFlowercolor(flowercolor);
        fi.setFlowerphoto(flowerphoto);
        fi.setFlowerdescription(flowermark);
        FlowerInfoBean fib=new FlowerInfoBean();
        FlowerTypeBean ftb=new FlowerTypeBean();
       
        if(fib.getID(flowerid))
        {
            request.setAttribute("result",flowerid+"号花卉已经存在，请重新输入！");
            getServletContext().getRequestDispatcher("Flowerinfoadd.jsp").forward(request,response);
        }
        else
        {
          try 
          {
              if(fib.addFlowerInfo(fi)) 
              {
                request.setAttribute("result",flowerid+"号花卉添加成功！");
                getServletContext().getRequestDispatcher("Flowerinfoadd.jsp").forward(request,response);

              }
          } 
          catch (Exception ex) 
          {
            ex.printStackTrace();
          }
        }
    }
    
    if(action.equals("update"))
    {
        String flowerid=request.getParameter("flowerid");
        String flowername=request.getParameter("flowername");
        String flowertypeid=request.getParameter("flowertypeid");
        String flowercolor=request.getParameter("flowercolor");
        String flowerphoto="images/"+request.getParameter("flowerphoto").substring(request.getParameter("flowerphoto").lastIndexOf("\\")+1);
        
        String flowermark=request.getParameter("flowermark");
        Flowerinfo fi=new Flowerinfo();
        fi.setFlowerid(flowerid);
        fi.setFlowername(flowername);
        fi.setFlowertypeid(flowertypeid);
        fi.setFlowercolor(flowercolor);
        fi.setFlowerphoto(flowerphoto);
        fi.setFlowerdescription(flowermark);
        FlowerInfoBean fib=new FlowerInfoBean();
        FlowerTypeBean ftb=new FlowerTypeBean();
        if(fib.getID(flowerid))
        {
          try
          {
            if(fib.updateFlowerinfo(fi))
            {
               request.setAttribute("result",flowerid+"号花卉修改成功！");
                getServletContext().getRequestDispatcher("Flowerinfoupdate.jsp").forward(request,response);

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

        }
    }
    if(action.equals("find"))
    {
        String flowerid=request.getParameter("flowerid");
        String flowername=request.getParameter("flowername");
        String flowertypeid=request.getParameter("flowertypeid");
        Flowerinfo fi=new Flowerinfo();
        fi.setFlowerid(flowerid);
        fi.setFlowername(flowername);
        fi.setFlowertypeid(flowertypeid);
        FlowerInfoBean fib=new FlowerInfoBean();
        FlowerTypeBean ftb=new FlowerTypeBean();
        try 
        {
          request.setAttribute("FlowerInfo",fib.FindFlowerInfo(fi));
          getServletContext().getRequestDispatcher("displayFloInfo.jsp").forward(request,response);
        } 
        catch (Exception ex) 
        {
          ex.printStackTrace();
        }
        
        
    }
    if(action.equals("del"))
    {
      String flowerid=request.getParameter("flowerid");
      FlowerInfoBean gib=new FlowerInfoBean();
      Connection con=null;
      PreparedStatement pstmt=null;
      ResultSet rs=null;
      try 
      {
        con=DBConnect.getConnection();
        pstmt=con.prepareStatement("select * from goodsinfo where flowerid=?");
        pstmt.setString(1,flowerid);
        rs=pstmt.executeQuery();
        if(rs.next())
        {
          request.setAttribute("result",flowerid+"号记录不能删除，在商品表中有引用");
          getServletContext().getRequestDispatcher("Flowerinfofind.jsp").forward(request,response);
        }
        else
        {
          if(gib.delFlowerinfo(flowerid))
          {
            request.setAttribute("result",flowerid+"记录删除成功！");
            getServletContext().getRequestDispatcher("Flowerinfofind.jsp").forward(request,response);
          }
        }
        rs.close();
        pstmt.close();
        con.close();
      } 
      catch (Exception ex) 
      {
        ex.printStackTrace();
      }
    }
    out.close();
  }
}