strtemp=result.getString(3);
               jTextArea1.setText("年級："+ jTextField1.getText()+'\n'+"班級："+
                                  jTextField2.getText()+'\n'+"班主任："+jTextField3.getText()+
                       '\n'+"任課老師："+jTextField4.getText()+'\n'+"班級特點:"+strtemp);
           }
           result.close();
           pre.close();

       } catch (SQLException e4) {

        }



















    }
//修改班級記錄
    public void jButton2_actionPerformed(ActionEvent e) {
        jButton5.setEnabled(false);
        bj=jTextField2.getText();
        bzr=jTextField3.getText();
        rkls=jTextField4.getText();
        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();
      jTextArea1.setText(strtemp.trim());
      add=false;
    }
//選擇班級下拉列表
    public void jComboBox2_actionPerformed(ActionEvent e) {
        try {jTextField2.setText(String.valueOf(jComboBox2.getSelectedItem()));
              sql = "select class_bzr,class_rkls,class_massage from classtable where class_name=? ";
              pre = con.prepareStatement(sql);
              pre.setString(1,String.valueOf(jComboBox2.getSelectedItem()));
              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()+
                          '\n'+"任課老師："+jTextField4.getText()+'\n'+ "班級特點:"+strtemp.trim());
              }
              result.close();
              pre.close();

          } catch (SQLException e4) {

        }

    }
//點中取消按鈕
    public void jButton4_actionPerformed(ActionEvent e) {


        jButton5.setEnabled(true);
        jTextField2.setText(bj);
        jTextField3.setText(bzr);
        jTextField4.setText(rkls);
        jButton3.setEnabled(false);
        jButton2.setEnabled(true);
        jButton1.setEnabled(true);
        jButton4.setEnabled(false);
        jTextField2.setEnabled(false);
        jTextField3.setEnabled(false);
        jTextField4.setEnabled(false);
        jTextArea1.setEnabled(false);
        jComboBox1.setEnabled(true);
        jComboBox2.setEnabled(true);
      jTextArea1.setText(strtemp2.trim());

    }
//保存按鈕
    public void jButton3_actionPerformed(ActionEvent e) {

            if (jTextField2.getText().equals("")) {
                JOptionPane.showMessageDialog(null, "班級名稱不能為空"); //彈出錯誤對話
                return;
            } else if (jTextField3.getText().equals("")) {
                JOptionPane.showMessageDialog(null, "班主任名字不能為空"); //彈出錯誤對話
                return;
            } else if (jTextField4.getText().equals("")) {
                JOptionPane.showMessageDialog(null, "任課老師名字不能為空"); //彈出錯誤對話
                return;
            }
             if(add==false){
            try {
                sql = "update classtable set class_name=?,class_bzr=?,class_rkls=?,class_massage=? where class_name=?";
                pre = con.prepareStatement(sql);
                pre.setString(1, jTextField2.getText());

                pre.setString(2, jTextField3.getText());
                pre.setString(3, jTextField4.getText());
                pre.setString(4, jTextArea1.getText().trim());
                pre.setString(5, String.valueOf(jComboBox2.getSelectedItem()));

                pre.executeUpdate();

                pre.close();
                bj = jTextField2.getText();
                bzr = jTextField3.getText();
                rkls = jTextField4.getText();
                strtemp = jTextArea1.getText().trim();

            } catch (SQLException ex) {

                JOptionPane.showMessageDialog(null, "輸入班名重名或名字太假！"); //彈出錯誤對話
                return;
            }

            JOptionPane.showMessageDialog(null, "資料已經成功修改！");
            firstdata();
        } else if (add) {
            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();
                System.out.println(inttemp);
                try {
                    sql = "insert into classtable(Grade_id,class_name,class_bzr,class_rkls,class_massage)values(?,?,?,?,?) ";

                    pre = con.prepareStatement(sql);
                    pre.setInt(1, inttemp);

                    pre.setString(2, jTextField2.getText());
                    pre.setString(3, jTextField3.getText());
                    pre.setString(4, jTextField4.getText());
                    pre.setString(5,jTextArea1.getText().trim());

                    pre.executeUpdate();

                    pre.close();
                    bj = jTextField2.getText();
                    bzr = jTextField3.getText();
                    rkls = jTextField4.getText();
                    strtemp = jTextArea1.getText().trim();

                } catch (SQLException ex) {

                    JOptionPane.showMessageDialog(null, "輸入班名重名或名字太假！"); //彈出錯誤對話
                    return;
                }

                JOptionPane.showMessageDialog(null, "資料已經成功修改！");
                firstdata();
            } catch (SQLException ex3) {

            }



        }



         jButton5.setEnabled(true);

       jTextField2.setText(bj);
       jTextField3.setText(bzr);
       jTextField4.setText(rkls);
       jButton3.setEnabled(false);
       jButton2.setEnabled(true);
       jButton1.setEnabled(true);
       jButton4.setEnabled(false);
       jTextField2.setEnabled(false);
       jTextField3.setEnabled(false);
       jTextField4.setEnabled(false);
       jTextArea1.setEnabled(false);
       jComboBox1.setEnabled(true);
       jComboBox2.setEnabled(true);
       jTextArea1.setText(strtemp2.trim());


    }
//刪除按鈕
    public void jButton5_actionPerformed(ActionEvent e) {

                try {
                    sql = "delete from classtable where class_name=?";
                    pre = con.prepareStatement(sql);
                    pre.setString(1,jTextField2.getText());
                    pre.executeUpdate();
                    pre.close();
                } catch (SQLException ex) {
                }
                firstdata();
    }


}

//以下為電腦自動生成
class ClassFrame_jButton5_actionAdapter implements ActionListener {
    private ClassFrame adaptee;
    ClassFrame_jButton5_actionAdapter(ClassFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ClassFrame_jButton2_actionAdapter implements ActionListener {
    private ClassFrame adaptee;
    ClassFrame_jButton2_actionAdapter(ClassFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ClassFrame_jComboBox2_actionAdapter implements ActionListener {
    private ClassFrame adaptee;
    ClassFrame_jComboBox2_actionAdapter(ClassFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ClassFrame_jButton4_actionAdapter implements ActionListener {
    private ClassFrame adaptee;
    ClassFrame_jButton4_actionAdapter(ClassFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ClassFrame_jButton3_actionAdapter implements ActionListener {
    private ClassFrame adaptee;
    ClassFrame_jButton3_actionAdapter(ClassFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ClassFrame_jComboBox1_actionAdapter implements ActionListener {
    private ClassFrame adaptee;
    ClassFrame_jComboBox1_actionAdapter(ClassFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ClassFrame_jButton1_actionAdapter implements ActionListener {
    private ClassFrame adaptee;
    ClassFrame_jButton1_actionAdapter(ClassFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}
//以上為電腦自動生成結束