xgxjxx.java

用Java开发的学生信息管理系统

  }

  void previous_actionPerformed(ActionEvent e) {
    try {
      if (rs.previous()) {
        xh.setText(rs.getString("student_ID"));
        xm.setText(rs.getString("student_Name"));
        sex.setText(rs.getString("student_Sex"));
        rq.setText(rs.getString("born_Date").substring(0, 10));
        bh.addItem(rs.getString("class_NO"));
        tel.setText(rs.getString("tele_Number"));
        rxrq.setText(rs.getString("ru_Date").substring(0, 10));
        address.setText(rs.getString("address"));
        comment.setText(rs.getString("comment"));

      }
      else
        JOptionPane.showMessageDialog(null, "这是第一条记录");
    }

    catch (SQLException sqle) {
      String error = sqle.getMessage();
      JOptionPane.showMessageDialog(null, error);
      sqle.printStackTrace();

    }

  }

  void last_actionPerformed(ActionEvent e) {
    try {
      if (rs.last()) {
        xh.setText(rs.getString("student_ID"));
        xm.setText(rs.getString("student_Name"));
        sex.setText(rs.getString("student_Sex"));
        rq.setText(rs.getString("born_Date").substring(0, 10));
        bh.addItem(rs.getString("class_NO"));
        tel.setText(rs.getString("tele_Number"));
        rxrq.setText(rs.getString("ru_Date").substring(0, 10));
        address.setText(rs.getString("address"));
        comment.setText(rs.getString("comment"));
      }
      else
        JOptionPane.showMessageDialog(null, "这是最后一条记录");
    }

    catch (SQLException sqle) {
      String error = sqle.getMessage();
      JOptionPane.showMessageDialog(null, error);
      sqle.printStackTrace();

    }
  }

  void gxjl_actionPerformed(ActionEvent e) {
    try {
      rs = ps.executeQuery("select * from student"); //读取数据库
      if (rs.next()) {
        xh.setText(rs.getString("student_ID"));
        xm.setText(rs.getString("student_Name"));
        sex.setText(rs.getString("student_Sex"));
        rq.setText(rs.getString("born_Date").substring(0, 10));
        bh.addItem(rs.getString("class_NO"));
        tel.setText(rs.getString("tele_Number"));
        rxrq.setText(rs.getString("ru_Date").substring(0, 10));
        address.setText(rs.getString("address"));
        comment.setText(rs.getString("comment"));
      }
    }

    catch (SQLException sqle) {
      String error = sqle.getMessage();
      JOptionPane.showMessageDialog(null, error);
      sqle.printStackTrace();

    }
  }

  void xgxl_actionPerformed(ActionEvent e) {
    JOptionPane.showConfirmDialog(null,
                                      "确定修改", "修改学籍", JOptionPane.YES_NO_OPTION);
    try {
      ps.executeUpdate("update student set student_Name='" + xm.getText().trim() +
                       "',student_Sex='" + sex.getText().trim() +
                       "',born_Date='"
                       + rq.getText().trim() + "',class_NO='" +
                      bh.getSelectedItem()+ "',tele_Number='"
                       + tel.getText().trim() + "',ru_Date='" +
                       rxrq.getText().trim() + "',address='" +
                       address.getText().trim() + "',comment='"
                       + comment.getText().trim() + "'where student_ID='" +
                       xh.getText().trim() +
                       "'");
      JOptionPane.showMessageDialog(null, "修改学籍成功");
      //this.dispose();
    }

    catch (SQLException sqle) {
      String error = sqle.getMessage();
      JOptionPane.showMessageDialog(null, error);
      sqle.printStackTrace();
    }

  }

  void delete_actionPerformed(ActionEvent e) {
    int v=JOptionPane.showConfirmDialog(this,"确定删除吗？将删除所有此学生信息","用户确认",
                                             JOptionPane.OK_CANCEL_OPTION,
                                             JOptionPane.INFORMATION_MESSAGE);
           if(v==JOptionPane.OK_OPTION)
           {
    try {
          ps.executeUpdate("delete from student where student_ID='" +
                           xh.getText().trim() +
                           "'");
          ps.executeUpdate("delete from result where student_ID='" +
                           xh.getText().trim() +
                           "'");
           Log log=new Log();
               log.addLog("\r\r","修改"+xh.getText().trim()+"成功");
              log.closeStream();

          JOptionPane.showMessageDialog(null, "删除学籍成功");
          //this.dispose();
        }

        catch (SQLException sqle) {
          String error = sqle.getMessage();
          JOptionPane.showMessageDialog(null, error);
          sqle.printStackTrace();

        }
           }
           try {

     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     Connection con = DriverManager.getConnection(
         "jdbc:odbc:lee",
         "sa", "123");
     ps = con.createStatement(ResultSet.
                              TYPE_SCROLL_INSENSITIVE,
                              ResultSet.CONCUR_READ_ONLY);
   }
   catch (Exception err) {
              String error = err.getMessage();
              Log log=new Log();
               log.addLog("\r\r",error);
              log.closeStream();

     JOptionPane.showMessageDialog(null, error);

   }
   try {
     rs = ps.executeQuery("select * from student"); //读取数据库
     if (rs.next()) {
       xh.setText(rs.getString("student_ID"));
       xm.setText(rs.getString("student_Name"));
       sex.setText(rs.getString("student_Sex"));
       rq.setText(rs.getString("born_Date").substring(0, 10));
      bh.addItem(rs.getString("class_NO"));
       tel.setText(rs.getString("tele_Number"));
       rxrq.setText(rs.getString("ru_Date").substring(0, 10));
       address.setText(rs.getString("address"));
       comment.setText(rs.getString("comment"));
     }
   }

   catch (SQLException sqle) {
     String error = sqle.getMessage();
     Log log=new Log();
     log.addLog("\r\r","修改学籍错误"+error);
              log.closeStream();

     JOptionPane.showMessageDialog(null, error);
     sqle.printStackTrace();

   }

  }

  void cancel_actionPerformed(ActionEvent e) {
 this.dispose();
  }

  void bh_actionPerformed(ActionEvent e) {

  }

}

class xgxjxx_first_actionAdapter
    implements java.awt.event.ActionListener {
  xgxjxx adaptee;

  xgxjxx_first_actionAdapter(xgxjxx adaptee) {
    this.adaptee = adaptee;
  }

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

class xgxjxx_next_actionAdapter
    implements java.awt.event.ActionListener {
  xgxjxx adaptee;

  xgxjxx_next_actionAdapter(xgxjxx adaptee) {
    this.adaptee = adaptee;
  }

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

class xgxjxx_previous_actionAdapter
    implements java.awt.event.ActionListener {
  xgxjxx adaptee;

  xgxjxx_previous_actionAdapter(xgxjxx adaptee) {
    this.adaptee = adaptee;
  }

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

class xgxjxx_last_actionAdapter
    implements java.awt.event.ActionListener {
  xgxjxx adaptee;

  xgxjxx_last_actionAdapter(xgxjxx adaptee) {
    this.adaptee = adaptee;
  }

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

class xgxjxx_gxjl_actionAdapter
    implements java.awt.event.ActionListener {
  xgxjxx adaptee;

  xgxjxx_gxjl_actionAdapter(xgxjxx adaptee) {
    this.adaptee = adaptee;
  }

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

class xgxjxx_xgxl_actionAdapter
    implements java.awt.event.ActionListener {
  xgxjxx adaptee;

  xgxjxx_xgxl_actionAdapter(xgxjxx adaptee) {
    this.adaptee = adaptee;
  }

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

class xgxjxx_delete_actionAdapter
    implements java.awt.event.ActionListener {
  xgxjxx adaptee;

  xgxjxx_delete_actionAdapter(xgxjxx adaptee) {
    this.adaptee = adaptee;
  }

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

class xgxjxx_cancel_actionAdapter implements java.awt.event.ActionListener {
  xgxjxx adaptee;

  xgxjxx_cancel_actionAdapter(xgxjxx adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.cancel_actionPerformed(e);
  }
}

class xgxjxx_bh_actionAdapter implements java.awt.event.ActionListener {
  xgxjxx adaptee;

  xgxjxx_bh_actionAdapter(xgxjxx adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.bh_actionPerformed(e);
  }
}