classframe.java

学生管理系统

                                   '\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);
    }
}
//以上為電腦自動生成結束