stuinfo.java

这是一个用JAVA编写的学生管理系统

            try {
              if (rs.first()) {
                JOptionPane.showMessageDialog(null, "学号不能重复！");
                setNull();
              }
              else {
                sql =
                    "insert into stuTable(Num,Name,Sex,Ethnic,Class,Birthday,Home) values (";
                sql = sql + "" + Integer.parseInt(jTNum.getText()) + ",";
                sql = sql + "'" + jTName.getText() + "',";
                sql = sql + "'" + jTSex.getText() + "',";
                sql = sql + "'" + jTEthnic.getText() + "',";
                sql = sql + "'" + jTClass.getText() + "',";
                sql = sql + "'" + jTBirth.getText() + "',";
                sql = sql + "'" + jTHome.getText() + "'";
                sql = sql + ")";

                if (DB.executeSql(sql)) {
                  setAbled(false);
                  JOptionPane.showMessageDialog(null, "成功添加信息！");
                  setButton(true, true, true, false, false);
                }
                else {
                  JOptionPane.showMessageDialog(null, "添加信息失败！");
                }
              }
            }
            catch (SQLException ex) {
              JOptionPane.showMessageDialog(null, " 添加信息失败!");
            }
          }
      }
      else if(exeType=="edit"){
           sql="update stuTable SET Name='"+jTName.getText().toString() +"',";
           sql=sql+"Sex='"+jTSex.getText() .toString() +"',";
           sql=sql+"Ethnic='"+jTEthnic.getText() .toString() +"',";
           sql=sql+"Class='"+jTClass.getText() .toString() +"',";
           sql=sql+"Birthday='"+jTBirth.getText()+"',";
           sql=sql+"Home='"+jTHome.getText() .toString() +"'";
           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 jBModify_actionPerformed(ActionEvent e) {
    setExeType("edit");
    setAbled(true);
    setButton(false,false,false,true,true);
  }
 //删除
  void jBDelete_actionPerformed(ActionEvent e) {
         String sql;
         sql="delete  from stuTable where Num="+Integer.parseInt(jTNum.getText()) +"";
         if(DB.executeSql(sql)){
           JOptionPane.showMessageDialog(null, "成功删除信息！");
         }
         else{
           JOptionPane.showMessageDialog(null, "删除信息失败！");
         }
         setNull();
  }

//查看分数
  void jBSee_actionPerformed(ActionEvent e) {
         sql="select * from gradeTable where Num="+Integer.parseInt(jTNum.getText()) +"";
         rs =DB.getResult(sql);
         try {
             if(rs.first())
             {  rs.beforeFirst() ;
                rs.next();
                seeGrade();
                this.dispose() ;
             }
             else{
                 JOptionPane.showMessageDialog(null," 此人无分数信息!");
             }
            }
            catch (SQLException ex) {
            JOptionPane.showMessageDialog(null," 查看分数失败!");
         }
  }


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

  //查询
  void jBSearch_actionPerformed(ActionEvent e) {
      search by=new search();
      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.setLabelText("请选择查询方式：");
      by.jTContent.setEnabled(false);
      by.show() ;
  }

  //切换到成绩管理
  void jBGrade_actionPerformed(ActionEvent e) {
    gradeInfo grade=new gradeInfo();
    Dimension dlgSize = this.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() ;
  }

  //切换到人员统计
  void jBSum_actionPerformed(ActionEvent e) {
    sumPeople people =new sumPeople();
    Dimension dlgSize = people.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() ;
  }
}



//***************  以下为监听类  ************
class stuInfo_jBAdd_actionAdapter implements java.awt.event.ActionListener {
  stuInfo adaptee;

  stuInfo_jBAdd_actionAdapter(stuInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBAdd_actionPerformed(e);
  }
}

class stuInfo_jBCancel_actionAdapter implements java.awt.event.ActionListener {
  stuInfo adaptee;

  stuInfo_jBCancel_actionAdapter(stuInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBCancel_actionPerformed(e);
  }
}

class stuInfo_jBSave_actionAdapter implements java.awt.event.ActionListener {
  stuInfo adaptee;

  stuInfo_jBSave_actionAdapter(stuInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBSave_actionPerformed(e);
  }
}
class stuInfo_jBSave_mouseAdapter extends java.awt.event.MouseAdapter {
  stuInfo adaptee;

  stuInfo_jBSave_mouseAdapter(stuInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jBSave_mouseClicked(e);
  }
}

class stuInfo_jBModify_actionAdapter implements java.awt.event.ActionListener {
  stuInfo adaptee;

  stuInfo_jBModify_actionAdapter(stuInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBModify_actionPerformed(e);
  }
}

class stuInfo_jBDelete_actionAdapter implements java.awt.event.ActionListener {
  stuInfo adaptee;

  stuInfo_jBDelete_actionAdapter(stuInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBDelete_actionPerformed(e);
  }
}

class stuInfo_jBSee_actionAdapter implements java.awt.event.ActionListener {
  stuInfo adaptee;

  stuInfo_jBSee_actionAdapter(stuInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBSee_actionPerformed(e);
  }
}

class stuInfo_jBExit_actionAdapter implements java.awt.event.ActionListener {
  stuInfo adaptee;

  stuInfo_jBExit_actionAdapter(stuInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBExit_actionPerformed(e);
  }
}

class stuInfo_jBSearch_actionAdapter implements java.awt.event.ActionListener {
  stuInfo adaptee;

  stuInfo_jBSearch_actionAdapter(stuInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBSearch_actionPerformed(e);
  }
}

class stuInfo_jBGrade_actionAdapter implements java.awt.event.ActionListener {
  stuInfo adaptee;

  stuInfo_jBGrade_actionAdapter(stuInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBGrade_actionPerformed(e);
  }
}

class stuInfo_jBSum_actionAdapter implements java.awt.event.ActionListener {
  stuInfo adaptee;

  stuInfo_jBSum_actionAdapter(stuInfo adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBSum_actionPerformed(e);
  }
}