gradeinfo.java

运行在JDK下的学生成绩管理系统源码.可以查询数据

          }
          else if(jTEnglish.getText().toString().equals("")){
             JOptionPane.showMessageDialog(null, "英语成绩不能为空");
          }
          else if(jTComposite.getText().toString().equals("")){
             JOptionPane.showMessageDialog(null, "综合成绩不能为空");
          }

          else {
            total=Integer.parseInt(jTChinese.getText())  +Integer.parseInt(jTMath.getText())  +Integer.parseInt(jTEnglish.getText())  +Integer.parseInt(jTComposite.getText());
            jTTotal.setText(String.valueOf(total) );

            sql = "insert into gradeTable(Num,Total,Chinese,Math,English,Composite) values (";
            sql = sql + "" + jTNum.getText() + ",";
            sql = sql + "" + total + ",";
            sql = sql + "" + Integer.parseInt(jTChinese.getText()) + ",";
            sql = sql + "" + Integer.parseInt(jTMath.getText()) + ",";
            sql = sql + "" + Integer.parseInt(jTEnglish.getText()) + ",";
            sql = sql + "" + Integer.parseInt(jTComposite.getText());
            sql = sql + ")";
            if (DB.executeSql(sql)) {
              setAbled(false);
              JOptionPane.showMessageDialog(null, "成功添加信息!");
              setButton(true,true,true,false,false);
            }
            else {
              JOptionPane.showMessageDialog(null, "添加信息失败!");
            }
          }
        }
        else if(exeType=="edit"){
          if (jTNum.getText().toString().equals("")) {
            JOptionPane.showMessageDialog(null, "学号不能为空");
          }
          else if(jTChinese.getText().toString().equals("")){
             JOptionPane.showMessageDialog(null, "语文成绩不能为空");
          }
          else if(jTMath.getText().toString().equals("")){
             JOptionPane.showMessageDialog(null, "数学成绩不能为空");
          }
          else if(jTEnglish.getText().toString().equals("")){
             JOptionPane.showMessageDialog(null, "英语成绩不能为空");
          }
          else if(jTComposite.getText().toString().equals("")){
             JOptionPane.showMessageDialog(null, "综合成绩不能为空");
          }
          else{
            sql = "update gradeTable set ";
            sql = sql + "Chinese=" + Integer.parseInt(jTChinese.getText()) + ",";
            sql = sql + "Math=" + Integer.parseInt(jTMath.getText()) + ",";
            sql = sql + "English=" + Integer.parseInt(jTEnglish.getText()) + ",";
            sql = sql + "Composite=" + Integer.parseInt(jTComposite.getText()) + ",";
            sql = sql + "Total=" + Integer.parseInt(jTTotal.getText()) + "";
            sql = sql + " where Num=" + Integer.parseInt(jTNum.getText());
            if (DB.executeSql(sql)) {
              JOptionPane.showMessageDialog(null, "成功更新信息！");
              setButton(true, true, true, false, false);
              setAbled(false);
            }
            else {
              JOptionPane.showMessageDialog(null, "更新信息失败！");
            }
          }
        }

  }

  //点击查看人员信息按钮
  void jBSee_actionPerformed(ActionEvent e) {
      try {
        sql="select * from stuTable where Num= "+Integer.parseInt(jTNum.getText());
        rs =DB.getResult(sql);
          if(rs.first())
           {  rs.beforeFirst() ;
              rs.next();
              seeInfo();
              this.dispose() ;
           }
           else{
              JOptionPane.showMessageDialog(null,"人员信息不存在！");
           }
    }
    catch (SQLException ex) {
         JOptionPane.showMessageDialog(null," 查看信息失败!");
    }
  }

 //点击修改按钮
  void jBModify_actionPerformed(ActionEvent e) {
     setAbled(true);
     jTNum.setEnabled(false);
     setExeType("edit");
     setButton(false,false,false,true,true);
  }

 //点击删除按钮
  void jBDelete_actionPerformed(ActionEvent e) {
        String sql;
        sql="delete  from gradeTable where Num="+Integer.parseInt(jTNum.getText()) ;
        if(DB.executeSql(sql)){
               JOptionPane.showMessageDialog(null, "成功删除信息！");
        }
        else{
               JOptionPane.showMessageDialog(null, "删除信息失败！");
        }
        setNull();
  }

  //退出
  void jBExit_actionPerformed(ActionEvent e) {
       this.dispose() ;
  }

 //查询
  void jBSearch_actionPerformed(ActionEvent e) {
    searchGrade by=new searchGrade();
    Dimension dlgSize = by.getPreferredSize();
    Dimension frmSize = getSize();
    Point loc = getLocation();
    by.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
    by.pack() ;
    by.show() ;
  }

  //切换到人员管理
  void jBPeople_actionPerformed(ActionEvent e) {
    stuInfo people=new stuInfo();
    Dimension dlgSize = this.getPreferredSize();
    Dimension frmSize = getSize();
    Point loc = getLocation();
    people.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
    people.pack() ;
    people.show() ;
    this.dispose();
  }

  //切换到成绩统计
  void jBSum_actionPerformed(ActionEvent e) {
    sumGrade grade =new sumGrade();
    Dimension dlgSize = grade.getPreferredSize();
    Dimension frmSize = getSize();
    Point loc = getLocation();
    grade.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
    grade.pack() ;
    grade.show() ;
    this.dispose() ;
  }
}


//***************  以下是监听类  ****************
class gradeInfo_jBAdd_actionAdapter implements java.awt.event.ActionListener {
  gradeInfo adaptee;

  gradeInfo_jBAdd_actionAdapter(gradeInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBAdd_actionPerformed(e);
  }
}

class gradeInfo_jBCancel_actionAdapter implements java.awt.event.ActionListener {
  gradeInfo adaptee;

  gradeInfo_jBCancel_actionAdapter(gradeInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBCancel_actionPerformed(e);
  }
}

class gradeInfo_jBSave_actionAdapter implements java.awt.event.ActionListener {
  gradeInfo adaptee;

  gradeInfo_jBSave_actionAdapter(gradeInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBSave_actionPerformed(e);
  }
}

class gradeInfo_jBSee_actionAdapter implements java.awt.event.ActionListener {
  gradeInfo adaptee;

  gradeInfo_jBSee_actionAdapter(gradeInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBSee_actionPerformed(e);
  }
}

class gradeInfo_jBModify_actionAdapter implements java.awt.event.ActionListener {
  gradeInfo adaptee;

  gradeInfo_jBModify_actionAdapter(gradeInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBModify_actionPerformed(e);
  }
}

class gradeInfo_jBDelete_actionAdapter implements java.awt.event.ActionListener {
  gradeInfo adaptee;

  gradeInfo_jBDelete_actionAdapter(gradeInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBDelete_actionPerformed(e);
  }
}

class gradeInfo_jBExit_actionAdapter implements java.awt.event.ActionListener {
  gradeInfo adaptee;

  gradeInfo_jBExit_actionAdapter(gradeInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBExit_actionPerformed(e);
  }
}

class gradeInfo_jBSearch_actionAdapter implements java.awt.event.ActionListener {
  gradeInfo adaptee;

  gradeInfo_jBSearch_actionAdapter(gradeInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBSearch_actionPerformed(e);
  }
}

class gradeInfo_jBPeople_actionAdapter implements java.awt.event.ActionListener {
  gradeInfo adaptee;

  gradeInfo_jBPeople_actionAdapter(gradeInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBPeople_actionPerformed(e);
  }
}

class gradeInfo_jBSum_actionAdapter implements java.awt.event.ActionListener {
  gradeInfo adaptee;

  gradeInfo_jBSum_actionAdapter(gradeInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBSum_actionPerformed(e);
  }
}