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;
    }
  }