updateowerservlet.java~44~

宠物医院

package servlet;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import bean.JDBCBean;

public class updateOwerServlet
    extends HttpServlet {
  private static final String CONTENT_TYPE = "text/html; charset=GBK";

  //Initialize global variables
  public void init() throws ServletException {
  }

  //Process the HTTP Get request
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();
    JDBCBean jdbc=new JDBCBean();
    Connection con=jdbc.getCon();
    PreparedStatement pstm=null;
    String sql;
    String buttonType=request.getParameter("button");
    buttonType=new String(buttonType.getBytes("ISO-8859-1"),"GBK");
    String[] owerID=request.getParameterValues("searchOwerID");
    try
    {
      if((buttonType.equals("查看宠物主人信息")||buttonType.equals("更新宠物主人"))&&(owerID.length>1))
      {
        javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("updateOwer.jsp");
        dis.include(request,response);
        out.println("<script type='text/javascript'>");
        out.println("alert('只能选择一个宠物主人!');");
        out.println("</script>");
      }
      else if(buttonType.equals("删除宠物主人"))
      {
        for(int i=0;i<owerID.length;i++)
        {
          int idINT=Integer.parseInt(owerID[i]);
          sql="exec proc_delete_ower ?";
          pstm=con.prepareStatement(sql);
          pstm.executeUpdate();
        }
        javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("updateOwer.jsp");
        dis.forward(request,response);
      }

    }
    catch(Exception e)
    {
      e.printStackTrace();
    }

  }

  //Process the HTTP Post request
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    doGet(request, response);
  }

  //Clean up resources
  public void destroy() {
  }
}