bmgl_bmbg_gg.java~5~

来自「IT行业管理系统针对IT行业管理的具体业务处理工作而开发的管理软件」· JAVA~5~ 代码 · 共 74 行

JAVA~5~
74
字号
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.print("<html><head><title>更新</title></head>");
        out.print("<body><p>&nbsp;</p><hr>");
        out.print("<h1 align="+"center"+"> 更新成功!</h1><hr>");
        out.print("<p align="+"center"+" class="+"style7"+"><a href="+"bmgl_bmbg.jsp"+">返回</a></p>");
        out.print("</body></html>");
      }
      else{
        out.print("<html><head><title>更新</title></head>");
        out.print("<body><p>&nbsp;</p><hr>");
        out.print("<h1 align="+"center"+">更新失败!</h1><hr>");
        out.print("<p align="+"center"+" class="+"style7"+"><a href="+"bmgl_bmbg.jsp"+">返回</a></p>");
        out.print("</body></html>");
      }
  }

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

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

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?