mainframe.java~97~

我从网上下的,好像还行,和大家分享一下,

    Database bean = new Database();
    try {
      bean.OpenConn();
    }
    catch (Exception ex) {
      System.out.println("ex:at login admin");
    }
    /**
     * 构建查询管理员的密码的SQL语句
     */
    String sql = "select * from admin where admin.passWord='" + passWord + "'";
    ResultSet rs = bean.executeQuery(sql);
    try {
      if (rs.next()) {
        y = 0;
        String dID = JOptionPane.showInputDialog(this, "输入要冻结的帐号", "");
        String sql2 = "update userInfo set isEnable=1 where ID=" +
            Integer.parseInt(dID) + " ";
        bean.executeUpdate(sql2);
        JOptionPane.showMessageDialog(this, "冻结成功", "成功", 1);
      }
      else {
        JOptionPane.showMessageDialog(this, "登录系统失败，管理员密码有误！", "错误", 1);
        y++;
        return;
      }
    }
    catch (Exception ex) {
      System.out.println("ex:at select admin's msg");
    }
    /**
     * 关闭数据库连接
     */
    bean.closeStmt();
    bean.closeConn();
  }

  void jMenuItem13_actionPerformed(ActionEvent e) {
    if (h == 3) {
      JOptionPane.showMessageDialog(this,
                                    "错误操作过多，系统将关闭，若有问题请与管理员联系\n QQ:625001993",
                                    "错误", 1);
      System.exit(0);
    }
//调出管理员信息，正确时调出增加用户对话框
    JPasswordField pwd = new JPasswordField();
    Object[] message = {
        "请输入管理员密码:", pwd};
    int res = JOptionPane.showConfirmDialog(this, message, "",
                                            JOptionPane.OK_CANCEL_OPTION,
                                            JOptionPane.QUESTION_MESSAGE);
    String passWord = pwd.getText();

    if (res == JOptionPane.CANCEL_OPTION) {
      return;
    }

    Database bean = new Database();
    try {
      bean.OpenConn();
    }
    catch (Exception ex) {
      System.out.println("ex:at login admin");
    }
    /**
     * 构建查询管理员的密码的SQL语句
     */
    String sql = "select * from admin where admin.passWord='" + passWord + "'";
    ResultSet rs = bean.executeQuery(sql);
    try {
      if (rs.next()) {
        h = 0;
        String dID = JOptionPane.showInputDialog(this, "输入要解冻的帐号", "");
        String sql2 = "update userInfo set isEnable=0 where ID=" +
            Integer.parseInt(dID) + " ";
        bean.executeUpdate(sql2);
        JOptionPane.showMessageDialog(this, "解冻成功", "成功", 1);
      }
      else {
        JOptionPane.showMessageDialog(this, "登录系统失败，管理员密码有误！", "错误", 1);
        h++;
        return;
      }
    }
    catch (Exception ex) {
      System.out.println("ex:at select admin's msg");
    }
    /**
     * 关闭数据库连接
     */
    bean.closeStmt();
    bean.closeConn();

  }

  void jMenuItem12_actionPerformed(ActionEvent e) {
    if (y == 3) {
      JOptionPane.showMessageDialog(this,
                                    "错误操作过多，系统将关闭，若有问题请与管理员联系\n QQ:625001993",
                                    "错误", 1);
      System.exit(0);
    }
    //调出管理员信息，正确时调出增加用户对话框
    JPasswordField pwd = new JPasswordField();
    Object[] message = {
        "请输入管理员密码:", pwd};
    int res = JOptionPane.showConfirmDialog(this, message, "",
                                            JOptionPane.OK_CANCEL_OPTION,
                                            JOptionPane.QUESTION_MESSAGE);
    String passWord = pwd.getText();

    if (res == JOptionPane.CANCEL_OPTION) {
      return;
    }

    Database bean = new Database();
    try {
      bean.OpenConn();
    }
    catch (Exception ex) {
      System.out.println("ex:at login admin");
    }
    /**
     * 构建查询管理员的密码的SQL语句
     */
    String sql = "select * from admin where admin.passWord='" + passWord + "'";
    ResultSet rs = bean.executeQuery(sql);
    try {
      if (rs.next()) {
        y = 0;
        String dID = JOptionPane.showInputDialog(this, "输入要查询信息的帐号", "");
        if(dID==null){
          return;
        }
        String sql2 = "select * from userInfo where ID='" +
            dID + "' ";
        ResultSet rs2=bean.executeQuery(sql2);
        InfoPanel msg=new InfoPanel(rs2,this);
        this.remove(this.getContentPane());
        this.setContentPane(msg);
        this.show();
      }
      else {
        JOptionPane.showMessageDialog(this, "登录系统失败，管理员密码有误！", "错误", 1);
        y++;
        return;
      }
    }
    catch (Exception ex) {
      System.out.println("ex:at select admin's msg");
    }
    /**
     * 关闭数据库连接
     */
    bean.closeStmt();
    bean.closeConn();

  }

  void jMenuItem11_actionPerformed(ActionEvent e) {
    Database bean=new Database();
    try {
      bean.OpenConn();
    }
    catch (Exception ex) {
    }
    String sql="select * from userInfo where ID='"+LoginFrame.ID+"'";
    ResultSet rs=bean.executeQuery(sql);
    String QQmsg="";
    try{
      if(rs.next()){
        QQmsg=rs.getString("QinInfo");
      }
    }catch(Exception ex){
      ex.printStackTrace();
    }
    MsgPanel Qmsg=new MsgPanel(QQmsg);
    this.remove(this.getContentPane());
    this.setContentPane(Qmsg);
    this.show();
  }

}

class MainFrame_jMenuItem1_actionAdapter
    implements java.awt.event.ActionListener {
  MainFrame adaptee;

  MainFrame_jMenuItem1_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem1_actionPerformed(e);
  }
}

class MainFrame_jMenuItem2_actionAdapter
    implements java.awt.event.ActionListener {
  MainFrame adaptee;

  MainFrame_jMenuItem2_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem2_actionPerformed(e);
  }
}

class MainFrame_jMenuItem3_actionAdapter
    implements java.awt.event.ActionListener {
  MainFrame adaptee;

  MainFrame_jMenuItem3_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem3_actionPerformed(e);
  }
}

class MainFrame_jMenuItem4_actionAdapter
    implements java.awt.event.ActionListener {
  MainFrame adaptee;

  MainFrame_jMenuItem4_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem4_actionPerformed(e);
  }
}

class MainFrame_jMenuItem6_actionAdapter
    implements java.awt.event.ActionListener {
  MainFrame adaptee;

  MainFrame_jMenuItem6_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem6_actionPerformed(e);
  }
}

class MainFrame_jMenuItem5_actionAdapter
    implements java.awt.event.ActionListener {
  MainFrame adaptee;

  MainFrame_jMenuItem5_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem5_actionPerformed(e);
  }
}

class MainFrame_jMenuItem8_actionAdapter
    implements java.awt.event.ActionListener {
  MainFrame adaptee;

  MainFrame_jMenuItem8_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem8_actionPerformed(e);
  }
}

class MainFrame_jMenuItem9_actionAdapter
    implements java.awt.event.ActionListener {
  MainFrame adaptee;

  MainFrame_jMenuItem9_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem9_actionPerformed(e);
  }
}

class MainFrame_jMenuItem13_actionAdapter
    implements java.awt.event.ActionListener {
  MainFrame adaptee;

  MainFrame_jMenuItem13_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem13_actionPerformed(e);
  }
}

class MainFrame_jMenuItem12_actionAdapter
    implements java.awt.event.ActionListener {
  MainFrame adaptee;

  MainFrame_jMenuItem12_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem12_actionPerformed(e);
  }
}

class MainFrame_jMenuItem11_actionAdapter implements java.awt.event.ActionListener {
  MainFrame adaptee;

  MainFrame_jMenuItem11_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem11_actionPerformed(e);
  }
}