bmgl_delete.java~8~

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+"'";

    java.util.Date date=new java.util.Date();
    String userName=null;
    userName=request.getSession().getAttribute("name").toString();
    String opTime=date.toString();
    String opModel="部门管理";

    i = ed.getDelete(sql1,userName,opTime,opModel);
    if (i != 0) {
      i=ed.getUpdate(sql2,userName,opTime,opModel);
      ed.close();
      out.println("<script>");
      out.print("alert(\"部门已删除！\");");
      out.print("document.location=\"bmgl_bmbg.jsp\";");
      out.print("</script>");
      //response.sendRedirect("bmgl_bmbg.jsp");
    }
  }

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

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