基于jsp,javaweb银行柜员业务绩效考核系统

public class AdminServlet extends HttpServlet {
  /**
   * Constructor of the object.
   */
  public AdminServlet() {
    super();
  }
  /**
   * Destruction of the servlet. <br>
   */
  public void destroy() {
    super.destroy(); // Just puts "destroy" string in log
    // Put your code here
  }
  /**
   * The doGet method of the servlet. <br>
   *
   * This method is called when a form has its tag value method equals to get.
   * 
   * @param request the request send by the client to the server
   * @param response the response send by the server to the client
   * @throws ServletException if an error occurred
   * @throws IOException if an error occurred
   */
  public void doGet(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    doPost(request,response);
  }
  /**
   * The doPost method of the servlet. <br>
   *
   * This method is called when a form has its tag value method equals to post.
   * 
   * @param request the request send by the client to the server
   * @param response the response send by the server to the client
   * @throws ServletException if an error occurred
   * @throws IOException if an error occurred
   */
  public void doPost(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    response.setContentType(Constant.CONTENTTYPE);
    request.setCharacterEncoding(Constant.CHARACTERENCODING);
    try{
      String method=request.getParameter("method").trim();
      AdminBean loginbean = new AdminBean();
      HttpSession session = request.getSession();
      session.setMaxInactiveInterval(1200);
      SystemBean systembean = new SystemBean();
      String sysdir = systembean.getDir();
      if(method.equals("one")){//admin登录
        String username = request.getParameter("username");
        String password = request.getParameter("password");
        if(username == null||username.trim().equals("")){
          request.setAttribute("message", "请正确输入用户名！");
          request.getRequestDispatcher(sysdir+"/login.jsp").forward(request, response);
        }
        else if(password == null||password.trim().equals("")){
          request.setAttribute("message", "请输入密码！");
          request.getRequestDispatcher(sysdir+"/login.jsp").forward(request, response);
        }
        else{
          String md5password = MD5.MD5(password);
          String agent = request.getHeader("user-agent"); 
          StringTokenizer st = new StringTokenizer(agent,";"); 
          String useros=st.nextToken();
          String loginip = request.getRemoteAddr();     
          int flag = loginbean.adminLogin(username,md5password, password,useros,loginip);
          switch (flag){
            case Constant.SUCCESS:
              List list = loginbean.getAdminInfo(username);
              session.setAttribute("user", username);
              session.setAttribute("list", list);
              request.getRequestDispatcher(sysdir+"/").forward(request, response);
              break;
            case Constant.NAME_ERROR:
              request.setAttribute("message", "用户名错误！请确认管理权限！");
              request.getRequestDispatcher(sysdir+"/login.jsp").forward(request, response);
              break;
            case Constant.PASSWORD_ERROR:
              request.setAttribute("message", "密码错误，请确认管理权限！");
              request.getRequestDispatcher(sysdir+"/login.jsp").forward(request, response);
              break;
          }
        }
      }
      else if(method.equals("editpwd")){//admin edit password
        String username2 = (String)session.getAttribute("user");
        if(username2 == null){
          request.getRequestDispatcher("error.jsp").forward(request, response);
        }
        else{
          String oldpwd = MD5.MD5(request.getParameter("oldpwd").trim());
          String newpwd = MD5.MD5(request.getParameter("newpwd").trim());
          String username = (String)session.getAttribute("user");
          int flag = loginbean.editPassword(username, oldpwd, newpwd);
          switch (flag){
            case Constant.SUCCESS:
              request.setAttribute("message", "密码修改成功！");
              request.getRequestDispatcher(sysdir+"/system/editpwd.jsp").forward(request, response);
              break;
            case Constant.PASSWORD_ERROR:
              request.setAttribute("message", "原始密码错误，请确认权限！");
              request.getRequestDispatcher(sysdir+"/system/editpwd.jsp").forward(request, response);
              break;
            case Constant.SYSTEM_ERROR:
              request.setAttribute("message", "系统维护中，请稍后再试！");
              request.getRequestDispatcher(sysdir+"/system/editpwd.jsp").forward(request, response);
              break;
          }
        }   
      }
      else if(method.equals("exit")){//admin exit
        String username2 = (String)session.getAttribute("user");
        if(username2 == null){
          request.getRequestDispatcher("error.jsp").forward(request, response);
        }
        else{
          session.removeAttribute("user");
          session.removeAttribute("list");
          System.gc();
          request.getRequestDispatcher(sysdir+"/login.jsp").forward(request, response);
        }     
      }
      else if(method.equals("manager")){//add,update manager
        String username2 = (String)session.getAttribute("user");
        if(username2 == null){
          request.getRequestDispatcher("error.jsp").forward(request, response);
        }
        else{
          String ra = request.getParameter("ra").trim();
          if(ra.equals("add")){
            String username = request.getParameter("username").trim();
            String password = MD5.MD5(request.getParameter("password").trim());
            String isuse = request.getParameter("isuse").trim();
            if(isuse.equals("在用"))
              isuse = "1";
            else
              isuse = "2";
            int flag = loginbean.addManager(username, password, "2", isuse);
            if(flag == Constant.SUCCESS){
              request.setAttribute("message", "增加管理员成功！");
              request.getRequestDispatcher(sysdir+"/system/user.jsp").forward(request, response);
            }
            else if(flag == Constant.SAME_NAME){
              request.setAttribute("username", username);
              request.setAttribute("message", "该用户名已经存在！");
              request.getRequestDispatcher(sysdir+"/system/user.jsp").forward(request, response);
            }
            else{
              request.setAttribute("message", "系统维护中，请稍后再试！");
              request.getRequestDispatcher(sysdir+"/system/user.jsp").forward(request, response);
            }   
          }
          else if(ra.equals("update")){
            String username = request.getParameter("username").trim();
            String password = request.getParameter("password").trim();
            String isuse = request.getParameter("isuse").trim();
            if(!password.equals("")){
              password = MD5.MD5(password);
            }
            if(isuse.equals("在用"))
              isuse = "1";
            else
              isuse = "2";
            int flag = loginbean.updateManager(username, password, "2", isuse);
            if(flag == Constant.SUCCESS){
              request.setAttribute("message", "修改管理员信息成功！");
              request.getRequestDispatcher(sysdir+"/system/user.jsp").forward(request, response);
            } 
            else{
              request.setAttribute("message", "系统维护中，请稍后再试！");
              request.getRequestDispatcher(sysdir+"/system/user.jsp").forward(request, response);
            }   
          }
        }
      }
      else if(method.equals("delm")){//delete manager
        String username2 = (String)session.getAttribute("user");
        if(username2 == null){
          request.getRequestDispatcher("error.jsp").forward(request, response);
        }
        else{
          int id = Integer.parseInt(request.getParameter("id").trim());
          if(id == 1){
            request.setAttribute("message", "不能删除原始帐号！");
            request.getRequestDispatcher(sysdir+"/system/user.jsp").forward(request, response);
          }
          else{
            int flag = loginbean.delManager(id);
            if(flag == Constant.SUCCESS){
              request.setAttribute("message", "删除成功！");
              request.getRequestDispatcher(sysdir+"/system/user.jsp").forward(request, response);
            } 
            else{
              request.setAttribute("message", "系统维护中，请稍后再试！");
              request.getRequestDispatcher(sysdir+"/system/user.jsp").forward(request, response);
            } 
          }
        }     
      }
      else if(method.equals("dellog")){//delete login note
        String username2 = (String)session.getAttribute("user");
        if(username2 == null){
          request.getRequestDispatcher("error.jsp").forward(request, response);
        }
        else{
          String check[] = request.getParameterValues("checkit");
          if(check == null){
            request.setAttribute("message", "请选择要删除的记录！");
            request.getRequestDispatcher(sysdir+"/system/log.jsp").forward(request, response);
          }
          else{
            int id[]= new int[check.length];
            for(int i = 0;i<check.length;i++){
              int s = Integer.parseInt(check[i]);       
              id[i] = s;
            }
            int flag = loginbean.delLog(id);
            if(flag == Constant.SUCCESS){
              request.setAttribute("message", "删除记录成功！");
              request.getRequestDispatcher(sysdir+"/system/log.jsp").forward(request, response);
            }
            else{
              request.setAttribute("message", "系统维护中，请稍后再试！");
              request.getRequestDispatcher(sysdir+"/system/log.jsp").forward(request, response);
            }
          }
        }     
      }
      else{//无参数传入转到错误页面
        request.getRequestDispatcher("error.jsp").forward(request, response);
      }
    }catch(Exception e){
      e.printStackTrace();
      request.getRequestDispatcher("error.jsp").forward(request, response);
    }
  }
  /**
   * Initialization of the servlet. <br>
   *
   * @throws ServletException if an error occure
   */
  public void init() throws ServletException {
    // Put your code here
  }
}
public class AfficheServlet extends HttpServlet {
  /**
   * Constructor of the object.
   */
  public AfficheServlet() {
    super();
  }
  /**
   * Destruction of the servlet. <br>
   */
  public void destroy() {
    super.destroy(); // Just puts "destroy" string in log
    // Put your code here
  }
  /**
   * The doGet method of the servlet. <br>
   *
   * This method is called when a form has its tag value method equals to get.
   * 
   * @param request the request send by the client to the server
   * @param response the response send by the server to the client
   * @throws ServletException if an error occurred
   * @throws IOException if an error occurred
   */
  public void doGet(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    doPost(request,response);
  }
  /**
   * The doPost method of the servlet. <br>
   *
   * This method is called when a form has its tag value method equals to post.
   * 
   * @param request the request send by the client to the server
   * @param response the response send by the server to the client
   * @throws ServletException if an error occurred
   * @throws IOException if an error occurred
   */
  public void doPost(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    response.setContentType(Constant.CONTENTTYPE);
    request.setCharacterEncoding(Constant.CHARACTERENCODING);
    String sysdir = new SystemBean().getDir();
    HttpSession session = request.getSession();
    try{
      String username2 = (String)session.getAttribute("user");
      if(username2 == null){
        request.getRequestDispatcher("error.jsp").forward(request, response);
      }
      else{
        AfficheBean afficheBean = new AfficheBean();
        String method = request.getParameter("method").trim();
        if(method.equals("addAffiche")){//增加公告
          String title = Filter.escapeHTMLTags(request.getParameter("title").trim());
          String content = Filter.escapeHTMLTags(request.getParameter("content").trim());
          String adder = username2;
          String ifhide = Filter.escapeHTMLTags(request.getParameter("ifhide").trim());
          int flag = afficheBean.addAffiche(title, content, adder, ifhide);
          if(flag == Constant.SUCCESS){
            request.setAttribute("message", "操作成功！");
            request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
          }
          else{
            request.setAttribute("message", "系统维护中请稍后再试！");
            request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
          }
        }
        else if(method.equals("editAffiche")){//修改公告
          String id=Filter.escapeHTMLTags(request.getParameter("id").trim());
          String title = Filter.escapeHTMLTags(request.getParameter("title").trim());
          String content = Filter.escapeHTMLTags(request.getParameter("content").trim());
          String adder = username2;
          String ifhide = Filter.escapeHTMLTags(request.getParameter("ifhide").trim());
          int flag = afficheBean.updateAffiche(Integer.parseInt(id), title, content, adder, ifhide);
          if(flag == Constant.SUCCESS){
            request.setAttribute("message", "操作成功！");
            request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
          }
          else{
            request.setAttribute("message", "系统维护中请稍后再试！");
            request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
          }
        }
        else if(method.equals("hideAffiche")){
          String id = Filter.escapeHTMLTags(request.getParameter("id").trim());
          int flag = afficheBean.hideAffiche(Integer.parseInt(id));
          if(flag == Constant.SUCCESS){
            request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
          }
          else{
            request.setAttribute("message", "系统维护中，请稍后再试！");
            request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
          }
        }
        else if(method.equals("delaffiche")){//删除公告
          String check[] = request.getParameterValues("checkit");
          if(check == null){
            request.setAttribute("message", "请选择要删除的记录！");
            request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
          }
          else{
            int id[]= new int[check.length];
            for(int i = 0;i<check.length;i++){
              int s = Integer.parseInt(check[i]);       
              id[i] = s;
            }
            int flag = afficheBean.delAffiche(id);
            if(flag == Constant.SUCCESS){
              request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
            }
            else{
              request.setAttribute("message", "系统维护中，请稍后再试！");
              request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
            }
          }
        }
      }
    }catch(Exception e){
      e.printStackTrace();
      request.getRequestDispatcher("error.jsp").forward(request, response);
    }
  }
  /**
   * Initialization of the servlet. <br>
   *
   * @throws ServletException if an error occure
   */
  public void init() throws ServletException {
    // Put your code here
  }
}
public class ComServlet extends HttpServlet {
  /**
   * Constructor of the object.
   */
  public ComServlet() {
    super();
  }
  /**
   * Destruction of the servlet. <br>
   */
  public void destroy() {
    super.destroy(); // Just puts "destroy" string in log
    // Put your code here
  }
  /**
   * The doGet method of the servlet. <br>
   *
   * This method is called when a form has its tag value method equals to get.
   * 
   * @param request the request send by the client to the server
   * @param response the response send by the server to the client
   * @throws ServletException if an error occurred
   * @throws IOException if an error occurred
   */
  public void doGet(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    doPost(request,response);
  }
  /**
   * The doPost method of the servlet. <br>
   *
   * This method is called when a form has its tag value method equals to post.
   * 
   * @param request the request send by the client to the server
   * @param response the response send by the server to the client
   * @throws ServletException if an error occurred
   * @throws IOException if an error occurred
   */
  public void doPost(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    response.setContentType(Constant.CONTENTTYPE);
    request.setCharacterEncoding(Constant.CHARACTERENCODING);
    HttpSession session = request.getSession();
    ComBean cBean = new ComBean();
    String date2=new SimpleDateFormat("yyyy-MM-dd").format(Calendar.getInstance().getTime());
    String method = request.getParameter("method");
    if(method.equals("addYW")){  //add  
       String mc = request.getParameter("mc");
       String xm = request.getParameter("xm"); 
       String nr = request.getParameter("nr"); 
       String member=(String)session.getAttribute("member");
         String sql="insert into yw(mc, xm,nr,sj,member) values('"+mc+"', '"+xm+"', '"+nr+"', '"+date2+"', '"+member+"')";
        int flag = cBean.comUp(sql);
        if(flag == Constant.SUCCESS){  
          request.setAttribute("message", "操作成功！");
          request.getRequestDispatcher("member/yw/index.jsp").forward(request, response); 
        }
        else { 
          request.setAttribute("message", "操作失败！");
          request.getRequestDispatcher("member/yw/index.jsp").forward(request, response); 
        }
    }
    else if(method.equals("upYW")){ ///update  
      String id = request.getParameter("id");
      String mc = request.getParameter("mc");
       String xm = request.getParameter("xm"); 
       String nr = request.getParameter("nr"); 
         String sql="update yw set mc='"+mc+"', xm='"+xm+"', nr='"+nr+"'  where id= '"+id+"' ";
        int flag = cBean.comUp(sql);
        if(flag == Constant.SUCCESS){ 
          request.setAttribute("message", "操作成功！");
          request.getRequestDispatcher("member/yw/index.jsp").forward(request, response); 
        }
        else { 
          request.setAttribute("message", "操作失败！");
          request.getRequestDispatcher("member/yw/index.jsp").forward(request, response); 
        }
    }
    else if(method.equals("delYW")){  //del  
      String id = request.getParameter("id"); 
      int flag = cBean.comUp("delete from yw where id='"+id+"'");
      if(flag == Constant.SUCCESS){ 
        request.setAttribute("message", "操作成功！");
        request.getRequestDispatcher("member/yw/index.jsp").forward(request, response); 
      }
      else { 
        request.setAttribute("message", "操作失败！");
        request.getRequestDispatcher("member/yw/index.jsp").forward(request, response); 
      }
    }
    else if(method.equals("delYW2")){  //del  
      String id = request.getParameter("id"); 
      int flag = cBean.comUp("delete from yw where id='"+id+"'");
      if(flag == Constant.SUCCESS){ 
        request.setAttribute("message", "操作成功！");
        request.getRequestDispatcher("admin/yw/index.jsp").forward(request, response); 
      }
      else { 
        request.setAttribute("message", "操作失败！");
        request.getRequestDispatcher("admin/yw/index.jsp").forward(request, response); 
      }
    }
    if(method.equals("addBS")){  //add  
       String member = request.getParameter("member");
       String bs = request.getParameter("bs");  
         String sql="insert into bs(member,bs,sj) values('"+member+"', '"+bs+"','"+date2+"')";
        int flag = cBean.comUp(sql);
        if(flag == Constant.SUCCESS){  
          request.setAttribute("message", "操作成功！");
          request.getRequestDispatcher("admin/bs/index.jsp").forward(request, response); 
        }
        else { 
          request.setAttribute("message", "操作失败！");
          request.getRequestDispatcher("admin/bs/index.jsp").forward(request, response); 
        }
    }
    else if(method.equals("upBS")){ ///update  
      String id = request.getParameter("id");
      String member = request.getParameter("member");
       String bs = request.getParameter("bs");  
         String sql="update bs set member='"+member+"', bs='"+bs+"' where id= '"+id+"' ";
        int flag = cBean.comUp(sql);
        if(flag == Constant.SUCCESS){ 
          request.setAttribute("message", "操作成功！");
          request.getRequestDispatcher("admin/bs/index.jsp").forward(request, response); 
        }
        else { 
          request.setAttribute("message", "操作失败！");
          request.getRequestDispatcher("admin/bs/index.jsp").forward(request, response); 
        }
    }
    else if(method.equals("delBS")){  //del  
      String id = request.getParameter("id"); 
      int flag = cBean.comUp("delete from bs where id='"+id+"'");
      if(flag == Constant.SUCCESS){ 
        request.setAttribute("message", "操作成功！");
        request.getRequestDispatcher("admin/bs/index.jsp").forward(request, response); 
      }
      else { 
        request.setAttribute("message", "操作失败！");
        request.getRequestDispatcher("admin/bs/index.jsp").forward(request, response); 
      }
    }
    else if(method.equals("bfSJK")){  //del  
      //String id = request.getParameter("id"); 
       try {       
                Runtime rt = Runtime.getRuntime();       
                // 调用 mysql 的 cmd 
    Process child = rt.exec("C:/Program Files/MySQL/MySQL Server 5.0/bin/mysqldump -uroot -p123  jxkh");// 设置导出编码为utf8。这里必须是utf8       
                // 把进程执行中的控制台输出信息写入.sql文件，即生成了备份文件。注：如果不对控制台信息进行读出，则会导致进程堵塞无法运行       
                InputStream in = child.getInputStream();// 控制台的输出信息作为输入流       
                InputStreamReader xx = new InputStreamReader(in, "utf8");// 设置输出流编码为utf8。这里必须是utf8，否则从流中读入的是乱 
                String inStr;       
                StringBuffer sb = new StringBuffer("");       
                String outStr;       
                // 组合控制台输出信息字符串       
                BufferedReader br = new BufferedReader(xx);       
                while ((inStr = br.readLine()) != null) {       
                    sb.append(inStr + "\r\n");       
                }       
                outStr = sb.toString();       
                // 要用来做导入用的sql目标文件：       
                FileOutputStream fout = new FileOutputStream(       
                        "c:/xytx.sql");       
                OutputStreamWriter writer = new OutputStreamWriter(fout, "utf8");       
                writer.write(outStr);       
                // 注：这里如果用缓冲方式写入文件的话，会导致中文乱码，用flush()方法则可以避免       
                writer.flush();       
                // 别忘记关闭输入输出流       
                in.close ();       
    xx.close();       
                br.close();       
                writer.close();       
                fout.close();       
                request.setAttribute("message", "操作成功！");
          request.getRequestDispatcher("admin/tj/bf.jsp").forward(request, response);       
            } catch (Exception e) {       
                e.printStackTrace(); 
                request.setAttribute("message", "操作失败！");
          request.getRequestDispatcher("admin/tj/bf.jsp").forward(request, response); 
            }       
      //String sql="SELECT * INTO OUTFILE  'D:\\data\\db_testtemp.txt' fields terminated by ',' from jxkh where std_state='1';Query OK, 1 row affected (0.00 sec)";
      //int flag = cBean.comUp("Backup database jxkh to disk='c:/jxkh_bak.dat' ");
//      int flag = cBean.comUp(sql);
//      if(flag == Constant.SUCCESS){ 
//        request.setAttribute("message", "操作成功！");
//        request.getRequestDispatcher("admin/tj/bf.jsp").forward(request, response); 
//      }
//      else { 
//        request.setAttribute("message", "操作失败！");
//        request.getRequestDispatcher("admin/tj/bf.jsp").forward(request, response); 
//      }
    }
  }
  /**
   * Initialization of the servlet. <br>
   *
   * @throws ServletException if an error occure
   */
  public void init() throws ServletException {
    // Put your code here
  }
}
public class LoginServlet extends HttpServlet {
  /**
   * Constructor of the object.
   */
  public LoginServlet() {
    super();
  }
  /**
   * Destruction of the servlet. <br>
   */
  public void destroy() {
    super.destroy(); // Just puts "destroy" string in log
    // Put your code here
  }
  /**
   * The doGet method of the servlet. <br>
   *
   * This method is called when a form has its tag value method equals to get.
   * 
   * @param request the request send by the client to the server
   * @param response the response send by the server to the client
   * @throws ServletException if an error occurred
   * @throws IOException if an error occurred
   */
  public void doGet(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    doPost(request,response);
  }
  /**
   * The doPost method of the servlet. <br>
   *
   * This method is called when a form has its tag value method equals to post.
   * 
   * @param request the request send by the client to the server
   * @param response the response send by the server to the client
   * @throws ServletException if an error occurred
   * @throws IOException if an error occurred
   */
  public void doPost(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    response.setContentType(Constant.CONTENTTYPE);
    request.setCharacterEncoding(Constant.CHARACTERENCODING);
    HttpSession session = request.getSession();
    MemberBean memberBean = new MemberBean();
    String method = Filter.escapeHTMLTags(request.getParameter("method").trim());
    if(method.equals("HEADUSERLOGIN")){//网页头部会员登陆
      String reg_user = Filter.escapeHTMLTags(request.getParameter("reg_user").trim());
      String reg_pwd = Filter.escapeHTMLTags(request.getParameter("reg_pwd").trim());
      String reg_type = Filter.escapeHTMLTags(request.getParameter("reg_type").trim());
      String lastip = request.getRemoteAddr();
      int flag = memberBean.memberLogin(reg_user, reg_pwd, reg_type);
      if(flag == Constant.SUCCESS){//登陆成功
        String info = memberBean.getLastTimeIP(reg_user);
        int flag2 = memberBean.upmemberLogin(reg_user, lastip);
        if(flag2 == Constant.SUCCESS){
          session.setAttribute("member", reg_user);
          session.setAttribute("type", reg_type);
          session.setAttribute("info", info);
          request.getRequestDispatcher("login1.jsp").forward(request, response);
        }
        else{
          session.setAttribute("member", reg_user);
          session.setAttribute("type", reg_type);
          session.setAttribute("info", info);
          session.setAttribute("message", "登陆成功，登陆信息更新失败！");
          request.getRequestDispatcher("login1.jsp").forward(request, response);
        }
      }
      else if(flag == Constant.NAME_ERROR){//用户名错误
        request.setAttribute("reg_user", reg_user);
        request.setAttribute("message", "该用户名不存在或者已被管理员冻结！");
        request.getRequestDispatcher("login1.jsp").forward(request, response);
      }
      else if(flag == Constant.PASSWORD_ERROR){//密码错误
        request.setAttribute("reg_user", reg_user);
        request.setAttribute("message", "密码错误！");
        request.getRequestDispatcher("login1.jsp").forward(request, response);
      }
    }
    else if(method.equals("PAGEUSERLOGIN")){//登陆页面会员登陆
      String username = Filter.escapeHTMLTags(request.getParameter("username").trim());
      String password = Filter.escapeHTMLTags(request.getParameter("password").trim());
      String reg_type = Filter.escapeHTMLTags(request.getParameter("reg_type").trim());
      String lastip = request.getRemoteAddr();
      int flag = memberBean.memberLogin(username, password, reg_type);
      if(flag == Constant.SUCCESS){//登陆成功
        String info = memberBean.getLastTimeIP(username);
        int flag2 = memberBean.upmemberLogin(username, lastip);
        if(flag2 == Constant.SUCCESS){
          session.setAttribute("member", username);
          session.setAttribute("type", reg_type);
          session.setAttribute("info", info);
          request.getRequestDispatcher("member/index.jsp").forward(request, response);
        }
        else{
          session.setAttribute("member", username);
          session.setAttribute("type", reg_type);
          session.setAttribute("info", info);
          session.setAttribute("message", "登陆成功，登陆信息更新失败！");
          request.getRequestDispatcher("member/index.jsp").forward(request, response);
        }
      }
      else if(flag == Constant.NAME_ERROR){//用户名错误
        request.setAttribute("reg_user", username);
        request.setAttribute("message", "该用户名不存在！");
        request.getRequestDispatcher("login.jsp").forward(request, response);
      }
      else if(flag == Constant.PASSWORD_ERROR){//密码错误
        request.setAttribute("reg_user", username);
        request.setAttribute("message", "密码错误！");
        request.getRequestDispatcher("login.jsp").forward(request, response);
      }
    }
    else if(method.equals("logout")){//从iframe页面退出登陆
      session.removeAttribute("member");
      session.removeAttribute("type");
      request.getRequestDispatcher("login1.jsp").forward(request, response);
    }
    else if(method.equals("pagelogout")||method.equals("memberexit")){//从网页退出登陆
      session.removeAttribute("member");
      session.removeAttribute("type");
      request.getRequestDispatcher("index.jsp").forward(request, response);
    }
    else{
      request.getRequestDispatcher("error.jsp").forward(request, response);
    }
  }
  /**
   * Initialization of the servlet. <br>
   *
   * @throws ServletException if an error occure
   */
  public void init() throws ServletException {
    // Put your code here
  }
}
public class MemberManageServlet extends HttpServlet {
  /**
   * Constructor of the object.
   */
  public MemberManageServlet() {
    super();
  }
  /**
   * Destruction of the servlet. <br>
   */
  public void destroy() {
    super.destroy(); // Just puts "destroy" string in log
    // Put your code here
  }
  /**
   * The doGet method of the servlet. <br>
   *
   * This method is called when a form has its tag value method equals to get.
   * 
   * @param request the request send by the client to the server
   * @param response the response send by the server to the client
   * @throws ServletException if an error occurred
   * @throws IOException if an error occurred
   */
  public void doGet(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    doPost(request,response);
  }
  /**
   * The doPost method of the servlet. <br>
   *
   * This method is called when a form has its tag value method equals to post.
   * 
   * @param request the request send by the client to the server
   * @param response the response send by the server to the client
   * @throws ServletException if an error occurred
   * @throws IOException if an error occurred
   */
  public void doPost(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    response.setContentType(Constant.CONTENTTYPE);
    request.setCharacterEncoding(Constant.CHARACTERENCODING);
    String sysdir = new SystemBean().getDir();
    HttpSession session = request.getSession();
    try{
      String username2 = (String)session.getAttribute("user");
      if(username2 == null){
        request.getRequestDispatcher("error.jsp").forward(request, response);
      }
      else{
        String method = Filter.escapeHTMLTags(request.getParameter("method").trim());
        MemberManageBean mmBean = new MemberManageBean();
        if(method.equals("DELMEMBER")||method.equals("DELCO")||method.equals("DELTODAY")
            ||method.equals("DELALLCLOSE")||method.equals("DELALLUSE")){//删除来自后台各个页面的会员
          String check[] = request.getParameterValues("checkit");
          if(check == null){
            if(method.equals("DELMEMBER")){//来自所有个人会员页面
              request.setAttribute("message", "请选择要删除的记录！");
              request.getRequestDispatcher(sysdir+"/member/person.jsp").forward(request, response);
            }
            else if(method.equals("DELCO")){//来自所有企业会员页面
              request.setAttribute("message", "请选择要删除的记录！");
              request.getRequestDispatcher(sysdir+"/member/co.jsp").forward(request, response);
            }
            else if(method.equals("DELTODAY")){//来自今日注册会员页面
              request.setAttribute("message", "请选择要删除的记录！");
              request.getRequestDispatcher(sysdir+"/member/today.jsp").forward(request, response);
            }
            else if(method.equals("DELALLCLOSE")){//来自所有冻结会员页面
              request.setAttribute("message", "请选择要删除的记录！");
              request.getRequestDispatcher(sysdir+"/member/close.jsp").forward(request, response);
            }
            else if(method.equals("DELALLUSE")){//来自所有在用会员页面
              request.setAttribute("message", "请选择要删除的记录！");
              request.getRequestDispatcher(sysdir+"/member/using.jsp").forward(request, response);
            }
          }
          else{
            int id[]= new int[check.length];
            for(int i = 0;i<check.length;i++){
              int s = Integer.parseInt(check[i]);       
              id[i] = s;
            }
            int flag = mmBean.delMember(id);
            if(flag == Constant.SUCCESS){
              if(method.equals("DELMEMBER")){//来自所有个人会员页面
                request.getRequestDispatcher(sysdir+"/member/person.jsp").forward(request, response);
              }
              else if(method.equals("DELCO")){//来自所有企业会员页面
                request.getRequestDispatcher(sysdir+"/member/co.jsp").forward(request, response);
              }
              else if(method.equals("DELTODAY")){//来自今日注册会员页面
                request.getRequestDispatcher(sysdir+"/member/today.jsp").forward(request, response);
              }
              else if(method.equals("DELALLCLOSE")){//来自所有冻结会员页面
                request.getRequestDispatcher(sysdir+"/member/close.jsp").forward(request, response);
              }
              else if(method.equals("DELALLUSE")){//来自所有在用会员页面
                request.getRequestDispatcher(sysdir+"/member/using.jsp").forward(request, response);
              }
            }
            else{
              if(method.equals("DELMEMBER")){//来自所有个人会员页面
                request.setAttribute("message", "系统维护中，请稍后再试！");
                request.getRequestDispatcher(sysdir+"/member/person.jsp").forward(request, response);
              }
              else if(method.equals("DELCO")){//来自所有企业会员页面
                request.setAttribute("message", "系统维护中，请稍后再试！");
                request.getRequestDispatcher(sysdir+"/member/co.jsp").forward(request, response);
              }
              else if(method.equals("DELTODAY")){//来自今日注册会员页面
                request.setAttribute("message", "系统维护中，请稍后再试！");
                request.getRequestDispatcher(sysdir+"/member/today.jsp").forward(request, response);
              }
              else if(method.equals("DELALLCLOSE")){//来自所有冻结会员页面
                request.setAttribute("message", "系统维护中，请稍后再试！");
                request.getRequestDispatcher(sysdir+"/member/close.jsp").forward(request, response);
              }
              else if(method.equals("DELALLUSE")){//来自所有在用会员页面
                request.setAttribute("message", "系统维护中，请稍后再试！");
                request.getRequestDispatcher(sysdir+"/member/using.jsp").forward(request, response);
              }
            }
          }
        }
        else{
          request.getRequestDispatcher("error.jsp").forward(request, response);
        }
      }
    }catch(Exception e){
      request.getRequestDispatcher("error.jsp").forward(request, response);
    }
  }
  /**
   * Initialization of the servlet. <br>
   *
   * @throws ServletException if an error occure
   */
  public void init() throws ServletException {
    // Put your code here
  }
}
public class NewsServlet extends HttpServlet {
  private ServletConfig config;
  /**
   * Constructor of the object.
   */
  public NewsServlet() {
    super();
  }
  final public void init(ServletConfig config) throws ServletException
    {
        this.config = config;  
    }
    final public ServletConfig getServletConfig()
    {
        return config;
    }
  /**
   * Destruction of the servlet. <br>
   */
  public void destroy() {
    super.destroy(); // Just puts "destroy" string in log
    // Put your code here
  }
  /**
   * The doGet method of the servlet. <br>
   *
   * This method is called when a form has its tag value method equals to get.
   * 
   * @param request the request send by the client to the server
   * @param response the response send by the server to the client
   * @throws ServletException if an error occurred
   * @throws IOException if an error occurred
   */
  public void doGet(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    doPost(request,response);
  }
  /**
   * The doPost method of the servlet. <br>
   *
   * This method is called when a form has its tag value method equals to post.
   * 
   * @param request the request send by the client to the server
   * @param response the response send by the server to the client
   * @throws ServletException if an error occurred
   * @throws IOException if an error occurred
   */
  public void doPost(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    request.setCharacterEncoding(Constant.CHARACTERENCODING);
    response.setContentType(Constant.CONTENTTYPE);
    String sysdir = new SystemBean().getDir();
    HttpSession session = request.getSession();
    try{
      String username2 = (String)session.getAttribute("user");
         String method = request.getParameter("method").trim();
         NewsBean newsBean = new NewsBean();
            System.out.println("aaaaaaaaaaaaaaaaa");
                if(method.equals("ADDNEWS")){//增加新闻
                  String title = Filter.escapeHTMLTags(request.getParameter("title").trim());
                  String fenlei = request.getParameter("fenlei");
            String content = request.getParameter("infoContent");
            if(content.length()>8000){
            request.setAttribute("message", "对不起，新闻内容不能超过8000个字符！");
            request.setAttribute("method", method);
            request.getRequestDispatcher(sysdir+"/news/edit.jsp").forward(request, response);
            }
            else{
              int flag = newsBean.addNews(title,fenlei,content, username2);
                if(flag == Constant.SUCCESS){
                  request.setAttribute("message", "增加成功！");
                  request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
                }
                else{
                  request.setAttribute("message", "系统维护中，请稍后再试！");
                  request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
                }
                        }
                }
                else if(method.equals("editnews")){//修改
                  String id = Filter.escapeHTMLTags(request.getParameter("id").trim());
                  String title = Filter.escapeHTMLTags(request.getParameter("title").trim());
                  String fenlei = request.getParameter("fenlei");
            String content = request.getParameter("infoContent");
              int flag = newsBean.updateNews(Integer.parseInt(id), title,fenlei, content, username2);
              if(flag == Constant.SUCCESS){
                request.setAttribute("message", "修改成功！");
                request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
              }
              else{
                request.setAttribute("message", "系统维护中，请稍后再试！");
                request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
              }
                }
                else if(method.equals("DELNEWS")){//删除 来自普通页面index.jsp
            String check[] = request.getParameterValues("checkit");
                if(check == null){
              request.setAttribute("message", "请选择要删除的记录！");
              request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
            }
            else{
              int id2[]= new int[check.length];
              for(int i = 0;i<check.length;i++){
                int s = Integer.parseInt(check[i]);       
                id2[i] = s;
              }
              int flag = new NewsBean().delNews(id2); 
              if(flag == Constant.SUCCESS){
                request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
              }
              else{
                request.setAttribute("message", "系统维护中，请稍后再试！");
                request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
              }
            }
          }
                else if(method.equals("addFenlei")){
                  String title=request.getParameter("title");
                  int flag = newsBean.addFenlei(title);
            if(flag == Constant.SUCCESS){
              request.setAttribute("message", "操作成功！");
              request.getRequestDispatcher(sysdir+"/fenlei/index.jsp").forward(request, response);
            }
            else{
              request.setAttribute("message", "系统维护中，请稍后再试！");
              request.getRequestDispatcher(sysdir+"/fenlei/index.jsp").forward(request, response);
            }
                }
                else if(method.equals("delFenlei")){
                  String id=request.getParameter("id");
                  int flag = newsBean.delFenlei(id);
            if(flag == Constant.SUCCESS){
              request.setAttribute("message", "操作成功！");
              request.getRequestDispatcher(sysdir+"/fenlei/index.jsp").forward(request, response);
            }
            else{
              request.setAttribute("message", "系统维护中，请稍后再试！");
              request.getRequestDispatcher(sysdir+"/fenlei/index.jsp").forward(request, response);
            }
                }
                else if(method.equals("mdelPl")){
                  String id=request.getParameter("id");
                  int flag = newsBean.delMethod("delete from pl where id='"+id+"'");
            if(flag == Constant.SUCCESS){
              request.setAttribute("message", "操作成功！");
              request.getRequestDispatcher(sysdir+"/news/pl.jsp").forward(request, response);
            }
            else{
              request.setAttribute("message", "系统维护中，请稍后再试！");
              request.getRequestDispatcher(sysdir+"/news/pl.jsp").forward(request, response);
            }
                }
                else if(method.equals("pl")){
                  String nid=request.getParameter("nid");
                  String content=request.getParameter("content");
                  String member = (String)session.getAttribute("member");
                  if(member==null){
                    request.setAttribute("message", "请登录后再评论！");
                    request.setAttribute("id", nid);
              request.getRequestDispatcher("newsinfo.jsp").forward(request, response);
                  }
                  else{
                    int flag = newsBean.delMethod("insert into pl(nid,content,member,addtime) values('"+nid+"','"+content+"','"+member+"','"+new java.util.Date().toLocaleString()+"')");
              if(flag == Constant.SUCCESS){
                request.setAttribute("message", "操作成功！");
                request.setAttribute("id", nid);
                request.getRequestDispatcher("newsinfo.jsp").forward(request, response);
              }
              else{
                request.setAttribute("message", "系统维护中，请稍后再试！");
                request.setAttribute("id", nid);
                request.getRequestDispatcher("newsinfo.jsp").forward(request, response);
              }
                  }
                }
                else{
                  request.getRequestDispatcher("error.jsp").forward(request, response);
                }
    }catch(Exception e){
      e.printStackTrace();
      request.getRequestDispatcher("error.jsp").forward(request, response);
    }
  }
  /**
   * Initialization of the servlet. <br>
   *
   * @throws ServletException if an error occure
   */
  public void init() throws ServletException {
    // Put your code here
  }
}