bmgl_delete.java~2~

IT行业管理系统针对IT行业管理的具体业务处理工作而开发的管理软件

package iterp;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import iterp.conpack.ExecData;

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

  ExecData ed = new ExecData();
  int i=0;

  //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();

    request.setCharacterEncoding("gb2312");
    String str = request.getParameter("depid");
    String sql1 = "delete dep where depid='" + str + "'";
    String sql2="update usr set depid=0 where depid='"+str+"'";

    i = ed.getDelete(sql1);
    if (i != 0) {
      i=ed.getUpdate(sql2);
      out.println("<script>");
      out.print("alert(\"部门已删除！\");");
      out.print("window.location=\"bmgl_bmbg.jsp\"");
      out.print("</script>");
    }
  }

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

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