bmgl_bmzc.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_bmzc extends HttpServlet {
  private static final String CONTENT_TYPE = "text/html; charset=gb2312";

  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("depmemo");
    String str4 = request.getParameter("depld");

    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 = "select * from dep where depid = "+str1+"' or depname='"+str2+"'" ;
    String sql2 = "insert into dep values('"+str1+"','"+str2+"','"+str3+"','"+str4+"')";
    String sql3 = "update usr set depid='"+str1+"' where username='"+str4+"'";

    i = ed.getInsert(sql1, sql2,userName,opTime,opModel);
    if(i==5){
      out.println("<script>");
      out.print("alert(\"记录重复，注册失败！\");");
      out.print("window.location=\"bmgl_bmbzc.jsp\"");
      out.print("</script>");
    }
    else if(i!=0){
      i = ed.getUpdate(sql3,userName,opTime,opModel);
      out.println("<script>");
      out.print("alert(\"注册成功！\");");
      out.print("window.location=\"bmgl_bmzc.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() {
    ed.close();
  }
}