xgkcxx.java

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

    }
  }

  void previous_actionPerformed(ActionEvent e) {
    kclx.removeAllItems();
       try {
         if (rs.previous()) {
           kcbh.setText(rs.getString("course_No"));
        mc.setText(rs.getString("course_Name"));
      //  kclx.addItem(rs.getString("course_Type"));
      if (rs.getString("course_Type").trim().equals(bx)) {
           kclx.addItem(bx);
          kclx.addItem(rx);
          kclx.addItem(xx);
        }
        else if (rs.getString("course_Type").trim().equals(rx)) {
          kclx.addItem(rx);
          kclx.addItem(bx);
          kclx.addItem(xx);
        }
        else {
          kclx.addItem(xx);
          kclx.addItem(bx);
          kclx.addItem(rx);
        }

        kcms.setText(rs.getString("course_Des"));


         }
         else {
           JOptionPane.showMessageDialog(null, "这是第一条记录!");
         }
       }
       catch (SQLException ex) {

       }


  }

  void next_actionPerformed(ActionEvent e) {
    kclx.removeAllItems();
    try {
      if (rs.next()) {
        kcbh.setText(rs.getString("course_No"));
          mc.setText(rs.getString("course_Name"));
       //   kclx.addItem(rs.getString("course_Type"));
       if (rs.getString("course_Type").trim().equals(bx)) {
           kclx.addItem(bx);
          kclx.addItem(rx);
          kclx.addItem(xx);
        }
        else if (rs.getString("course_Type").trim().equals(rx)) {
          kclx.addItem(rx);
          kclx.addItem(bx);
          kclx.addItem(xx);
        }
        else {
          kclx.addItem(xx);
          kclx.addItem(bx);
          kclx.addItem(rx);
        }

          kcms.setText(rs.getString("course_Des"));

      }
      else {
        JOptionPane.showMessageDialog(null, "这是最后一条记录!");
      }
    }
    catch (SQLException ex) {

    }

  }

  void gxsj_actionPerformed(ActionEvent e) {
    try {
      rs = ps.executeQuery("select * from course");

      if (rs.next()) {
        kcbh.setText(rs.getString("course_No"));
        mc.setText(rs.getString("course_Name"));
      //  kclx.addItem(rs.getString("course_Type"));
      if (rs.getString("course_Type").trim().equals(bx)) {
           kclx.addItem(bx);
          kclx.addItem(rx);
          kclx.addItem(xx);
        }
        else if (rs.getString("course_Type").trim().equals(rx)) {
          kclx.addItem(rx);
          kclx.addItem(bx);
          kclx.addItem(xx);
        }
        else {
          kclx.addItem(xx);
          kclx.addItem(bx);
          kclx.addItem(rx);
        }

        kcms.setText(rs.getString("course_Des"));

      }
    }
    catch (SQLException ex) {
      String err = ex.getMessage();
      JOptionPane.showMessageDialog(null, err);
    }

  }

  void scjl_actionPerformed(ActionEvent e) {
    JOptionPane.showConfirmDialog(null,
                                      "确定删除？", "删除课程", JOptionPane.YES_NO_OPTION);
    try {
      sc.executeUpdate("delete from result where 'course_Name'=(select course_Name from course where course_No='" +
                          kcbh.getText() +"');");
System.out.println("here");
        ins.executeUpdate("delete from course where course_No='" +
                          kcbh.getText() +
                          "'");

        JOptionPane.showMessageDialog(null, "删除成功!");
        try {
              rs = ps.executeQuery("select * from course");

              if (rs.next()) {
                kcbh.setText(rs.getString("course_No"));
                mc.setText(rs.getString("course_Name"));
              //  kclx.addItem(rs.getString("course_Type"));
              if (rs.getString("course_Type").trim().equals(bx)) {
                   kclx.addItem(bx);
                  kclx.addItem(rx);
                  kclx.addItem(xx);
                }
                else if (rs.getString("course_Type").trim().equals(rx)) {
                  kclx.addItem(rx);
                  kclx.addItem(bx);
                  kclx.addItem(xx);
                }
                else {
                  kclx.addItem(xx);
                  kclx.addItem(bx);
                  kclx.addItem(rx);
                }

                kcms.setText(rs.getString("course_Des"));

              }
            }
            catch (SQLException ex) {
              String err = ex.getMessage();
              JOptionPane.showMessageDialog(null, err);
            }


    }
    catch (SQLException ex) {
      String err = ex.getMessage();
              JOptionPane.showMessageDialog(null, err);
    }

  }

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

class xgkcxx_xgjl_actionAdapter
    implements java.awt.event.ActionListener {
  xgkcxx adaptee;

  xgkcxx_xgjl_actionAdapter(xgkcxx adaptee) {
    this.adaptee = adaptee;
  }

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

class xgkcxx_first_actionAdapter
    implements java.awt.event.ActionListener {
  xgkcxx adaptee;

  xgkcxx_first_actionAdapter(xgkcxx adaptee) {
    this.adaptee = adaptee;
  }

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

class xgkcxx_previous_actionAdapter
    implements java.awt.event.ActionListener {
  xgkcxx adaptee;

  xgkcxx_previous_actionAdapter(xgkcxx adaptee) {
    this.adaptee = adaptee;
  }

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

class xgkcxx_next_actionAdapter
    implements java.awt.event.ActionListener {
  xgkcxx adaptee;

  xgkcxx_next_actionAdapter(xgkcxx adaptee) {
    this.adaptee = adaptee;
  }

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

class xgkcxx_last_actionAdapter
    implements java.awt.event.ActionListener {
  xgkcxx adaptee;

  xgkcxx_last_actionAdapter(xgkcxx adaptee) {
    this.adaptee = adaptee;
  }

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

class xgkcxx_gxsj_actionAdapter
    implements java.awt.event.ActionListener {
  xgkcxx adaptee;

  xgkcxx_gxsj_actionAdapter(xgkcxx adaptee) {
    this.adaptee = adaptee;
  }

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

class xgkcxx_scjl_actionAdapter
    implements java.awt.event.ActionListener {
  xgkcxx adaptee;

  xgkcxx_scjl_actionAdapter(xgkcxx adaptee) {
    this.adaptee = adaptee;
  }

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

class xgkcxx_cencel_actionAdapter
    implements java.awt.event.ActionListener {
  xgkcxx adaptee;

  xgkcxx_cencel_actionAdapter(xgkcxx adaptee) {
    this.adaptee = adaptee;
  }

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