jpanel1.java

学生管理系统

package guanlixitong;

import java.awt.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.Font;
import javax.swing.table.*;
import javax.swing.BorderFactory;
import java.awt.Color;
import javax.swing.border.TitledBorder;

public class JPanel1
    extends JPanel implements ActionListener {
  public JPanel1() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }

  }

  public void actionPerformed(ActionEvent e) {

    jLabel3.setText("");
    if (e.getSource() == jButton1||e.getSource()==jTextField1) {
      int m = Integer.parseInt(jTextField1.getText());

      if (m <= 109 && m >= 101 && n < 5 && tof(m)) {

        String str = "jdbc:odbc:yangAcess";
        Connection con;
        String select = "select 上课时间,上课地点,学分,课序号 from yang2 where 课序号=" + m;
        ResultSet rs;
        try {
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          con = DriverManager.getConnection(str);
          Statement stmt = con.createStatement();
          rs = stmt.executeQuery(select);

          while (rs.next()) {
            课程[n] = new 课程();

            课程[n].上课时间 = rs.getString(1);
            课程[n].上课地点 = rs.getString(2);
            课程[n].学分 = rs.getString(3);
            课程[n].课序号 = rs.getInt(4);
            n = n + 1;
          }
        }
        catch (Exception ea) {}
        boolean bool = tof(m);
        initCheckBox(n);

        initTabel();

        String update = "update yang1 set 课程1=" + 课程[0].课序号 + ",课程2=" +
            课程[1].课序号 +
            ", 课程3=" + 课程[2].课序号 + ",课程4=" + 课程[3].课序号 +
            ", 课程5=" + 课程[4].课序号 + " where 学号=" + num;
        try {
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          con = DriverManager.getConnection(str);
          Statement up = con.createStatement();
          up.executeUpdate(update);
          up.close();
          con.close();
        }
        catch (Exception ae) {
          System.out.print("fool");
        }

      }

    }
    else if (e.getSource() == jButton2||e.getSource()==jTextField2) {
      for (int i = 0; i < 5; i++) {
        课程[i] = new 课程();
      }

      num = Integer.parseInt(jTextField2.getText());
      int num1 = -1;
      String str = "jdbc:odbc:yangAcess";
      Connection con;

      n = 0;
      String select = "select 学号 from yang1 where 学号=" + num;
      String sSelect =
          "select 上课时间,上课地点,学分,课序号 from yang2 where 课序号=(select 课程1 from yang1 where 学号=" +
          num +

          ")or 课序号=( select 课程2 from yang1 where 学号=" + num +
          ")or 课序号=(select 课程3 from yang1 where 学号=" + num +
          ")or 课序号=(select 课程4 from yang1 where 学号=" + num +
          ")or 课序号=(select 课程5 from yang1 where 学号=" + num + ")";

      ResultSet rs;

      try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        con = DriverManager.getConnection(str);
        Statement stmt = con.createStatement();
        rs = stmt.executeQuery(sSelect);

        while (rs.next()) {
          课程[n] = new 课程();
          课程[n].上课时间 = rs.getString(1);
          课程[n].上课地点 = rs.getString(2);
          课程[n].学分 = rs.getString(3);
          课程[n].课序号 = rs.getInt(4);
          n++;
        }

        rs = stmt.executeQuery(select);
        while (rs.next()) {
          num1 = rs.getInt(1);
        }
        con.close();
        stmt.close();
      }
      catch (Exception ae) {
        System.out.print("Woring");
      }
      if (num == num1) {
        initTabel();
        initCheckBox(n);
        jTextField1.setEnabled(true);
        jButton1.setEnabled(true);
        jLabel1.setEnabled(true);

      }
      else {
        jLabel3.setText(" 你 所 输 学 号 不 存 在");
      }
    }
    else if (e.getSource() == jButton3) {
      delete();
    }


  }

  public void update() {

    String str = "jdbc:odbc:yangAcess";
    Connection con;
    String update = "update yang1 set 课程1=" + 课程[0].课序号 + ",课程2=" +
        课程[1].课序号 +
        ", 课程3=" + 课程[2].课序号 + ",课程4=" + 课程[3].课序号 +
        ", 课程5=" + 课程[4].课序号 + " where 学号=" + num;
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con = DriverManager.getConnection(str);
      Statement up = con.createStatement();
      up.executeUpdate(update);
      up.close();
      con.close();
    }
    catch (Exception ae) {
      System.out.print("fool");
    }

  }

  public void initCheckBox(int a) {
    switch (a) {
      case 0:

        jCheckBox1.setEnabled(false);

        jCheckBox3.setEnabled(false);
        jCheckBox4.setEnabled(false);
        jCheckBox5.setEnabled(false);
        jCheckBox2.setEnabled(false);
        jCheckBox1.setSelected(false);
        jCheckBox2.setSelected(false);
        jCheckBox3.setSelected(false);
        jCheckBox4.setSelected(false);
        jCheckBox5.setSelected(false);
        jButton3.setEnabled(false);
        break;
      case 1:
        jCheckBox1.setEnabled(true);
        jCheckBox3.setEnabled(false);
        jCheckBox4.setEnabled(false);
        jCheckBox5.setEnabled(false);
        jCheckBox2.setEnabled(false);
        jCheckBox1.setSelected(false);
        jCheckBox2.setSelected(false);
        jCheckBox3.setSelected(false);
        jCheckBox4.setSelected(false);
        jCheckBox5.setSelected(false);

        jButton3.setEnabled(true);
        break;
      case 2:
        jCheckBox1.setEnabled(true);
        jCheckBox2.setEnabled(true);
        jCheckBox3.setEnabled(false);
        jCheckBox4.setEnabled(false);
        jCheckBox5.setEnabled(false);
        jCheckBox1.setSelected(false);
        jCheckBox2.setSelected(false);
        jCheckBox3.setSelected(false);
        jCheckBox4.setSelected(false);
        jCheckBox5.setSelected(false);

        jButton3.setEnabled(true);
        break;
      case 3:
        jCheckBox1.setEnabled(true);
        jCheckBox2.setEnabled(true);
        jCheckBox3.setEnabled(true);
        jCheckBox4.setEnabled(false);
        jCheckBox5.setEnabled(false);
        jCheckBox1.setSelected(false);
        jCheckBox2.setSelected(false);
        jCheckBox3.setSelected(false);
        jCheckBox4.setSelected(false);
        jCheckBox5.setSelected(false);

        jButton3.setEnabled(true);
        break;
      case 4:
        jCheckBox1.setEnabled(true);
        jCheckBox3.setEnabled(true);
        jCheckBox4.setEnabled(true);
        jCheckBox2.setEnabled(true);
        jCheckBox5.setEnabled(false);
        jCheckBox1.setSelected(false);
        jCheckBox2.setSelected(false);
        jCheckBox3.setSelected(false);
        jCheckBox4.setSelected(false);
        jCheckBox5.setSelected(false);

        jButton3.setEnabled(true);
        break;
      case 5:
        jCheckBox1.setEnabled(true);
        jCheckBox3.setEnabled(true);
        jCheckBox4.setEnabled(true);
        jCheckBox5.setEnabled(true);
        jCheckBox2.setEnabled(true);
        jCheckBox1.setSelected(false);
        jCheckBox2.setSelected(false);
        jCheckBox3.setSelected(false);
        jCheckBox4.setSelected(false);
        jCheckBox5.setSelected(false);

        jButton3.setEnabled(true);
        break;
    }
  }