package xxglxt;

import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;

import javax.swing.*;

//加載班級頁面
public class ClassFrame extends JPanel {

    public ClassFrame() {

    }

//初始化程序界面
    public JPanel jbInit() {

        setLayout(null);
        jLabel1.setText("年級選擇：");
        jLabel1.setBounds(new Rectangle(31, 31, 77, 64));
        jComboBox2.setBounds(new Rectangle(116, 89, 149, 26));
        jComboBox2.addActionListener(new ClassFrame_jComboBox2_actionAdapter(this));
        jComboBox1.setBounds(new Rectangle(116, 49, 149, 26));
        jComboBox1.addActionListener(new ClassFrame_jComboBox1_actionAdapter(this));
        jTextField1.setEnabled(false);
        jTextField1.setBounds(new Rectangle(98, 148, 120, 26));
        jTextField2.setEnabled(false);
        jTextField2.setBounds(new Rectangle(98, 175, 120, 28));
        jLabel3.setText("年    級：");
        jLabel3.setBounds(new Rectangle(29, 151, 61, 23));
        jLabel4.setText("班    級：");
        jLabel4.setBounds(new Rectangle(29, 183, 61, 20));
        jLabel5.setText("班 主 任：");
        jLabel5.setBounds(new Rectangle(29, 207, 66, 25));
        jTextField3.setEnabled(false);
        jTextField3.setBounds(new Rectangle(98, 203, 119, 28));
        jLabel6.setText("任課老師：");
        jLabel6.setBounds(new Rectangle(29, 232, 63, 26));
        jTextField4.setEnabled(false);
        jTextField4.setBounds(new Rectangle(98, 231, 118, 27));

        jButton5.setBounds(new Rectangle(228, 121, 95, 26));
        jButton5.setText("刪除");
        jButton5.addActionListener(new ClassFrame_jButton5_actionAdapter(this));

        jButton1.setBounds(new Rectangle(228, 148, 95, 26));
        jButton1.setText("增加");
        jButton1.addActionListener(new ClassFrame_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(228, 175, 95, 30));
        jButton2.setText("修改");
        jButton2.addActionListener(new ClassFrame_jButton2_actionAdapter(this));
        jButton3.setBounds(new Rectangle(228, 206, 95, 25));
        jButton3.setText("保存");
        jButton3.addActionListener(new ClassFrame_jButton3_actionAdapter(this));
        jButton3.setEnabled(false);
        jButton4.setBounds(new Rectangle(228, 233, 95, 28));
        jButton4.setText("取消");
        jButton4.setEnabled(false);
        jButton4.addActionListener(new ClassFrame_jButton4_actionAdapter(this));
        jScrollPane1.setAutoscrolls(true);
        jScrollPane1.setBounds(new Rectangle(340, 16, 238, 242));
        jTextArea1.setEnabled(false);
        this.add(jLabel1);
        this.add(jComboBox1);
        this.add(jLabel2);
        this.add(jComboBox2);
        jScrollPane1.getViewport().add(jTextArea1);
        this.add(jTextField3);
        this.add(jLabel3);
        this.add(jTextField1);
        this.add(jLabel4);
        this.add(jTextField2);
        this.add(jLabel5);
        this.add(jLabel6);
        this.add(jTextField4);
        this.add(jButton1);
        this.add(jButton2);
        this.add(jButton3);
        this.add(jButton4);
        this.add(jButton5);
        this.add(jScrollPane1);
        jLabel2.setText("班級選擇：");
        jLabel2.setBounds(new Rectangle(31, 77, 90, 58));
        firstdata(); //初始化程序數據
        return this;
    }

    //初始化程序數據
    private void firstdata() {

        try {

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //驅動加載
            con = DriverManager.getConnection("jdbc:odbc:glxt"); //數據橋連名子為ＯＤＢＣ名為glxt
        } catch (ClassNotFoundException ex) {
            //驅程不存在
            JOptionPane.showMessageDialog(null, "驅程不存在");
        } catch (SQLException ex1) {
            //ODBC連接失敗
            JOptionPane.showMessageDialog(null, "ODBC連接失敗");
        }

        try {
            sql = "select Grade_name from gradetable"; //查詢班級表中的班名
            pre = con.prepareStatement(sql);
            result = pre.executeQuery();
            jComboBox1.removeAllItems();
            while (result.next()) {
                jComboBox1.addItem(result.getString(1)); //查出的班名加入下拉列表中
            }
            result.close();
            pre.close();
        } catch (SQLException ex2) {

        }

        try {
            sql = "select Grade_id from gradetable where Grade_name=?"; //根據班名查出年級ID
            pre = con.prepareStatement(sql);
            pre.setString(1, String.valueOf(jComboBox1.getSelectedItem()));
            result = pre.executeQuery();
            while (result.next()) {
                inttemp = result.getInt(1); //將年級ID存臨時變量
            }
            result.close();
            pre.close();
        } catch (SQLException ex3) {

        }

        try {
            sql = "select class_name from dbo.classtable where Grade_id=?"; //根據年級ID查出班名。
            pre = con.prepareStatement(sql);
            pre.setInt(1, inttemp);
            result = pre.executeQuery();
            jComboBox2.removeAllItems(); //清空下拉列表
            while (result.next()) {
                jComboBox2.addItem(result.getString(1)); //把班級名稱加入到下拉列表
            }
            result.close();
            pre.close();
        } catch (SQLException ex4) {

        }
        jTextField1.setText(String.valueOf(jComboBox1.getSelectedItem()));
        jTextField2.setText(String.valueOf(jComboBox2.getSelectedItem()));

        try {
            sql =
                    "select class_bzr,class_rkls,class_massage from classtable where class_name=? "; //查出當前班的信息
            pre = con.prepareStatement(sql);
            pre.setString(1, jTextField2.getText());
            result = pre.executeQuery();
            if (result.next()) {
                jTextField3.setText(result.getString(1));
                jTextField4.setText(result.getString(2));
                strtemp = result.getString(3).trim();
                jTextArea1.setText("年級：" + jTextField1.getText() + '\n' + "班級：" +
                                   jTextField2.getText() + '\n' + "班主任：" +
                                   jTextField3.getText() +
                                   '\n' + "任課老師：" + jTextField4.getText() +
                                   '\n' + "班級特點:" + strtemp);
            }
            result.close();
            pre.close();

        } catch (SQLException e4) {

        }

    }

    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JComboBox jComboBox1 = new JComboBox();
    JComboBox jComboBox2 = new JComboBox();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField jTextField3 = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField jTextField4 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JButton jButton5 = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTextArea jTextArea1 = new JTextArea();
    String strtemp = ""; //用來存放暫時的字符串
    String strtemp2 = ""; //用來存放暫時的字符串
    int inttemp = 0; //用來存放暫時的數字
    ResultSet result; //保存結果集
    Connection con = null; //連接
    PreparedStatement pre = null; //SQL語句處理
    String sql = ""; //SQL語句
    String bj = ""; //班級存放
    String bzr = ""; //班主任存放
    String rkls = ""; //任課老師
    boolean add;
//增加班級記錄
    public void jButton1_actionPerformed(ActionEvent e) {
        bj = jTextField2.getText();
        bzr = jTextField3.getText();
        rkls = jTextField4.getText();
        jButton5.setEnabled(false);
        jButton4.setEnabled(true);
        jButton2.setEnabled(false);
        jButton3.setEnabled(true);
        jButton1.setEnabled(false);
        jTextField2.setEnabled(true);
        jTextField3.setEnabled(true);
        jTextField4.setEnabled(true);
        jTextArea1.setEnabled(true);
        jComboBox1.setEnabled(false);
        jComboBox2.setEnabled(false);
        strtemp2 = jTextArea1.getText().trim();
        jTextArea1.setText("");
        add = true;
        jTextField2.setText("");
        jTextField3.setText("");
        jTextField4.setText("");


    }

//選擇年級下拉列表
    public void jComboBox1_actionPerformed(ActionEvent e) {

//
        try {

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //驅動加載
            Connection con = DriverManager.getConnection("jdbc:odbc:glxt"); //數據橋連名子為ＯＤＢＣ名為glxt
        } catch (ClassNotFoundException ex) {
            //驅程不存在
            JOptionPane.showMessageDialog(null, "驅程不存在");
        } catch (SQLException ex1) {
            //ODBC連接失敗
            JOptionPane.showMessageDialog(null, "ODBC連接失敗");
        }
        try {
            sql = "select Grade_id from gradetable where Grade_name=?";
            pre = con.prepareStatement(sql);
            pre.setString(1, String.valueOf(jComboBox1.getSelectedItem()));
            result = pre.executeQuery();
            while (result.next()) {
                inttemp = result.getInt(1);
            }
            result.close();
            pre.close();
        } catch (SQLException ex3) {

        }

        try {
            sql = "select class_name from dbo.classtable where Grade_id=?";
            pre = con.prepareStatement(sql);
            pre.setInt(1, inttemp);
            result = pre.executeQuery();
            jComboBox2.removeAllItems();
            while (result.next()) {
                jComboBox2.addItem(result.getString(1));
            }
            result.close();
            pre.close();

        } catch (SQLException ex4) {

        }

        jTextField1.setText(String.valueOf(jComboBox1.getSelectedItem()));
        jTextField2.setText(String.valueOf(jComboBox2.getSelectedItem()));
        try {
            sql =
                    "select class_bzr,class_rkls,class_massage from classtable where class_name=? ";
            pre = con.prepareStatement(sql);
            pre.setString(1, jTextField2.getText());
            result = pre.executeQuery();
            if (result.next()) {
                jTextField3.setText(result.getString(1));
                jTextField4.setText(result.getString(2));
                strtemp = result.getString(3);
                jTextArea1.setText("年級：" + jTextField1.getText() + '\n' + "班級：" +
                                   jTextField2.getText() + '\n' + "班主任：" +
                                   jTextField3.getText() +