bmgl_bmbg_gg.java~6~

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

package iterp;

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

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

  ExecData ed = new ExecData();
  int i;
  //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 str1 = request.getParameter("depid");
    String str2 = request.getParameter("depname");
    String str3 = request.getParameter("depld");
    String str4 = request.getParameter("depmemo");

        HttpSession session=request.getSession();
        String name=session.getAttribute("ld").toString();
        System.out.println(name);

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


    String sql1="update dep set depname='"+str2+"',depmemo='"+str4+"',depld='"+str3+"' where depid='"+str1+"'";
    String sql2="update usr set depid='"+str1+"' where username='"+str3+"'";

    String sql3="delete dep where depld='"+name+"' and depid='"+str1+"'";

      i = ed.getUpdate(sql1,userName,opTime,opModel);
      if(i!=0){
        i=ed.getUpdate(sql2,userName,opTime,opModel);
        i=ed.getDelete(sql3,userName,opTime,opModel);
        out.println("<script>");
        out.print("alert(\"更新成功！\");");
        out.print("window.location=\"bmgl_bmbg.jsp\"");
        out.print("</script>");
      }
      else{
        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() {
  }
}