studentmanageframe.java~4~

学生信息管理实例 这里主要是运用Java和SQL Server2000来实现一个学生信息管理系统

      JOptionPane.showMessageDialog(null, "恭喜您，添加成功了！");
      this.tipLabel.setText("请添加下一个学生记录");
      panel.clear();
    }
  }

  /**
   * 提交学生学号
   */

  private boolean submitID() {
    StudentIDInputPanel panel = (StudentIDInputPanel)this.jScrollPane.
        getViewport().
        getComponent(0);
    if (panel.check() == false) {
      JOptionPane.showMessageDialog(null, "请输入学号再点击提交按钮！");
      return false;
    }
    String id = panel.getID();
    String strSQL = "select * from students where id ='" + id + "'";
    try {
      ResultSet rs = DatabaseTool.executeQuery(strSQL);
      if (rs.next()) {
        id = rs.getString("id");
        String sex = rs.getString("sex");
        String name = rs.getString("name");
        String nation = rs.getString("nation");
        String birthday = rs.getString("birthday");

        StudentInfoPanel infoPanel = new StudentInfoPanel();
        infoPanel.setIDEditEnable(false);
        infoPanel.setID(id);
        infoPanel.setName(name);
        infoPanel.setSex(sex);
        infoPanel.setNation(nation);
        infoPanel.setBirthDay(birthday);
        this.jScrollPane.getViewport().remove(0);
        this.jScrollPane.getViewport().add(infoPanel);

        return true;
      }
      else {
        JOptionPane.showMessageDialog(null, "对不起，数据库中不存在此学号！");
        return false;
      }
    }
    catch (Exception exx) {
      exx.printStackTrace();
      JOptionPane.showMessageDialog(null, "抱歉，程序出现异常！");
      return false;
    }
  }

  /**
   * 提交学科
   */
  private void submitSubject() {
    SubjectInputPanel panel = (SubjectInputPanel)this.jScrollPane.getViewport().
        getComponent(0);
    if (panel.check() == false) {
      JOptionPane.showMessageDialog(null, "请选择学科后再点击提交按钮！");
      return;
    }

    String subject = panel.getSubject();
    String strSQL = "select " + subject + "score from students";

    double total = 0.0;
    int num = 0;
    double average = 0.0;
    try {
      ResultSet rs = DatabaseTool.executeQuery(strSQL);
      while (rs.next()) {
        String score = rs.getString(subject + "score");
        if (score == null) score = "0";
        total += Double.parseDouble(score);
        num++;
      }
      if (num == 0) average = 0;
      else {
        average = total / num;
      }
      String str = panel.getSubjectChineseName() + "平均分为:" + average;
      MessagePanel panel2 = new MessagePanel(str);
      this.jScrollPane.getViewport().remove(0);
      this.jScrollPane.getViewport().add(panel2);

    }
    catch (Exception exx) {
      exx.printStackTrace();
      JOptionPane.showMessageDialog(null, "抱歉，程序出现异常！");
      return;
    }

  }

  /**
   * 提交删除学生记录
   */
  private void submitDeleteItem() {
    StudentInfoPanel panel = (StudentInfoPanel)this.jScrollPane.getViewport().
        getComponent(0);
    String id = panel.getID();
    String strSQL = "delete from students where id='" + id + "'";
    try {
      DatabaseTool.executeUpdate(strSQL);
    }
    catch (Exception exx) {
      exx.printStackTrace();
      JOptionPane.showMessageDialog(null, "删除出错");
      return;
    }
    this.jScrollPane.getViewport().remove(0);
    StudentIDInputPanel inputPanel = new StudentIDInputPanel();
    inputPanel.setLabel("请输入要删除的学生学号");
    this.jScrollPane.getViewport().add(inputPanel);

    this.tipLabel.setText("删除成功！可继续删除下一个学生记录");
    this.status = "delete student item:input ID";
  }

  /**
   * 提交修改学生记录
   */
  private void submitModifyItem() {
    StudentInfoPanel panel = (StudentInfoPanel)this.jScrollPane.getViewport().
        getComponent(0);
    if (panel.check() == false) {
      JOptionPane.showMessageDialog(null, "请输入完整信息再点击提交按钮！");
      return;
    }
    else {
      String id = panel.getID();
      String name = panel.getName();
      String sex = panel.getSex();
      String nation = panel.getNation();
      String birthday = panel.getBirthDay();
      String strSQL =
          "update students set name = '" + name + "',sex='" + sex +
          "',birthday='" +
          birthday + "',nation='" + nation + "' where id='" + id + "'";

      try {
        DatabaseTool.executeUpdate(strSQL);
      }
      catch (Exception exx) {
        exx.printStackTrace();
        JOptionPane.showMessageDialog(null, "修改失败！");
        return;
      }
      JOptionPane.showMessageDialog(null, "恭喜您，修改成功了！");

      this.jScrollPane.getViewport().remove(0);
      this.jScrollPane.getViewport().add(new MessagePanel("修改成功!"));
      this.button.setText("确定");
      this.button.setEnabled(false);
    }

  }

  /**
   * 提交添加课程成绩
   */
  private void updataScore(String subject) {
    ScoreInputTable table = (ScoreInputTable)this.jScrollPane.getViewport().
        getComponent(0);
    table.stopEditing();

    Vector v = table.getDefaulttableModel().getDataVector();
    for (Enumeration enu = v.elements(); enu.hasMoreElements(); ) {
      Vector v2 = (Vector) enu.nextElement();
      String id = (String) v2.elementAt(1);
      id = id.trim();
      String name = (String) v2.elementAt(2);
      String score = (String) v2.elementAt(3);
      if (score != null)
        score = score.trim();
      else
        score = "0";
      String strSql = "update students set " + subject + "score='" + score +
          "' where id='" + id + "'";
      try {
        DatabaseTool.executeUpdate(strSql);
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }
  }

  private void updataInterface() {
    if (this.jScrollPane.getViewport().getComponentCount() > 0)
      this.jScrollPane.getViewport().remove(0);
    this.tipLabel.setText("添加成绩成功！");
    this.button.setEnabled(false);
  }

  /**
   * 对总成绩进行排名
   */
  private void sortTotalScores() {
    ScoreSortTable table = (ScoreSortTable)this.jScrollPane.getViewport().
        getComponent(0);
    String strSQL =
        "select id,name,chinesescore,mathscore,englishscore from students";

    SortByTotalScoreList list = new SortByTotalScoreList(20);
    try {
      ResultSet rs = DatabaseTool.executeQuery(strSQL);
      while (rs.next()) {
        String id = rs.getString("id");
        String name = rs.getString("name");
        String chinesescore = rs.getString("chinesescore");
        String mathscore = rs.getString("mathscore");
        String englishscore = rs.getString("englishscore");
        if (chinesescore == null) chinesescore = "0";
        if (mathscore == null) mathscore = "0";
        if (englishscore == null) englishscore = "0";
        chinesescore = chinesescore.trim();
        mathscore = mathscore.trim();
        englishscore = englishscore.trim();
        double total = 0;
        total += Double.parseDouble(chinesescore);
        total += Double.parseDouble(mathscore);
        total += Double.parseDouble(englishscore);
        TotalScoreSortItem item = new TotalScoreSortItem(id, name, chinesescore,
            mathscore, englishscore, String.valueOf(total));
        list.add(item);
      }
      table.setContents(list);
    }
    catch (Exception exx) {
      exx.printStackTrace();
      JOptionPane.showMessageDialog(null, "抱歉，程序出现异常！");
      return;
    }

  }

  /**
   * 关闭窗口时,关闭数据库连接
   */
  void this_windowClosing(WindowEvent e) {
    DatabaseTool.closeDB();
  }
}

class StudentManageFrame_jMenuItem1_actionAdapter
    implements java.awt.event.ActionListener {
  StudentManageFrame adaptee;

  StudentManageFrame_jMenuItem1_actionAdapter(StudentManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class StudentManageFrame_button_actionAdapter
    implements java.awt.event.ActionListener {
  StudentManageFrame adaptee;

  StudentManageFrame_button_actionAdapter(StudentManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class StudentManageFrame_this_windowAdapter
    extends java.awt.event.WindowAdapter {
  StudentManageFrame adaptee;

  StudentManageFrame_this_windowAdapter(StudentManageFrame adaptee) {
    this.adaptee = adaptee;
  }

  public void windowClosing(WindowEvent e) {
    adaptee.this_windowClosing(e);
  }
}

class StudentManageFrame_jMenuItem2_actionAdapter
    implements java.awt.event.ActionListener {
  StudentManageFrame adaptee;

  StudentManageFrame_jMenuItem2_actionAdapter(StudentManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class StudentManageFrame_jMenuItem4_actionAdapter
    implements java.awt.event.ActionListener {
  StudentManageFrame adaptee;

  StudentManageFrame_jMenuItem4_actionAdapter(StudentManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class StudentManageFrame_jMenuItem3_actionAdapter
    implements java.awt.event.ActionListener {
  StudentManageFrame adaptee;

  StudentManageFrame_jMenuItem3_actionAdapter(StudentManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class StudentManageFrame_jMenuItem5_actionAdapter
    implements java.awt.event.ActionListener {
  StudentManageFrame adaptee;

  StudentManageFrame_jMenuItem5_actionAdapter(StudentManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class StudentManageFrame_jMenuItem6_actionAdapter
    implements java.awt.event.ActionListener {
  StudentManageFrame adaptee;

  StudentManageFrame_jMenuItem6_actionAdapter(StudentManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class StudentManageFrame_jMenuItem7_actionAdapter
    implements java.awt.event.ActionListener {
  StudentManageFrame adaptee;

  StudentManageFrame_jMenuItem7_actionAdapter(StudentManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class StudentManageFrame_jMenuItem8_actionAdapter
    implements java.awt.event.ActionListener {
  StudentManageFrame adaptee;

  StudentManageFrame_jMenuItem8_actionAdapter(StudentManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class StudentManageFrame_jMenuItem9_actionAdapter
    implements java.awt.event.ActionListener {
  StudentManageFrame adaptee;

  StudentManageFrame_jMenuItem9_actionAdapter(StudentManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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