stuframe.java~214~

学生管理系统

            //——————————恢復界面
            jTextField1.setEnabled(false);
            jComboBox4.setVisible(true);
                 jTextField2.setVisible(false);
            jComboBox2.setEnabled(false);
            jComboBox3.setEnabled(false);
            jTextField4.setEnabled(false);
            jTextField5.setEnabled(false);
            jTextArea1.setEnabled(false);
            jButton6.setEnabled(false);
            jButton3.setEnabled(false);
            jButton1.setEnabled(true);
            jButton2.setEnabled(true);
            jButton5.setEnabled(false);
            jButton4.setText("修改");
//————————————————
            try {

                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //驅動加載
                con = DriverManager.getConnection("jdbc:odbc:glxt"); //數據橋連名子為ＯＤＢＣ名為glxt
                //修改SQL語句
                sql = "update stutable set stu_name=?,stu_xl=?,stu_sex=?,stu_tel=?,stu_address=?,stu_birthday=?,stu_td=?,stu_xh=?,stu_photo=?  where stu_xh=?";
                pre = con.prepareStatement(sql);
                pre.setString(1,jTextField1.getText().trim());
                pre.setString(2,String.valueOf(jComboBox2.getSelectedItem()));
                pre.setString(3,String.valueOf(jComboBox3.getSelectedItem()));
                pre.setString(4,jTextField4.getText().trim());
                pre.setString(5,jTextField5.getText().trim());
                pre.setString(6,jTextField3.getText().trim());
                pre.setString(7,jTextArea1.getText().trim());
                pre.setString(8,jTextField2.getText());
                pre.setString(9,Url);
                pre.setString(10,xh);

//                //***********************************************************
//                System.out.println(jTextField1.getText().trim());
//                System.out.println(String.valueOf(jComboBox2.getSelectedItem()));
//                System.out.println(String.valueOf(jComboBox3.getSelectedItem()));
//                System.out.println(jTextField4.getText().trim());
//                System.out.println(jTextField5.getText().trim());
//                System.out.println(jTextField3.getText().trim());
//                System.out.println(jTextArea1.getText().trim());
//                System.out.println(jTextField2.getText());
//                System.out.println(xh);
//                //******************************
                  Url=null;
                pre.executeUpdate();
                pre.close();
                con.close();


            } catch (ClassNotFoundException ex) {
                ex.printStackTrace();
            }catch (SQLException ex1) {
                ex1.printStackTrace();
                }

        }

    }
//增加新學生
    public void jButton1_actionPerformed(ActionEvent e) {
        if (jButton1.getText().equals("增加") ){//如果為增加時
//——————————————————————更改界面
                    jTextField1.setEnabled(true);
                    jTextField1.setText("");
                    jComboBox2.setEnabled(true);
                    jComboBox2.setSelectedItem("");
                    jComboBox3.setEnabled(true);
                    jComboBox3.setSelectedItem("");
                    jTextField4.setEnabled(true);
                    jTextField4.setText("");
                    jTextField5.setEnabled(true);
                    jTextField5.setText("");
                    jTextArea1.setEnabled(true);
                    jTextArea1.setText("");
                    jButton6.setEnabled(true);
                    jTextField3.setText("");
                    jTextField2.setText("");
                    jButton3.setEnabled(true);
                    jButton4.setEnabled(false);
                    jButton2.setEnabled(false);
                    jButton5.setEnabled(true);
                    jButton1.setText("確定");
                    xh=String.valueOf(jComboBox4.getSelectedItem());
                    jComboBox4.setVisible(false);
                    jTextField2.setVisible(true);
                    jTextField2.setText(xh);
//——————————————————————————

                }else if (jButton1.getText().equals("確定")){//如果為確定時
                    //——————————————恢復界面
                    jTextField1.setEnabled(false);
                    jComboBox4.setVisible(true);
                         jTextField2.setVisible(false);
                    jComboBox2.setEnabled(false);
                    jComboBox3.setEnabled(false);
                    jTextField4.setEnabled(false);
                    jTextField5.setEnabled(false);
                    jTextArea1.setEnabled(false);
                    jButton6.setEnabled(false);
                    jButton3.setEnabled(false);
                  jButton4.setEnabled(true);
                    jButton2.setEnabled(true);
                    jButton5.setEnabled(false);
                    jButton1.setText("增加");
//————————————————————

                    try {
                        int class_id=0;
                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //驅動加載
                        con = DriverManager.getConnection("jdbc:odbc:glxt"); //數據橋連名子為ＯＤＢＣ名為glxt
                        String sql1="select class_id from classtable where class_name=?";
                        PreparedStatement pre1=con.prepareStatement(sql1);
                        pre1.setString(1,String.valueOf(jComboBox1.getSelectedItem()));
                        ResultSet sult1=pre1.executeQuery();
                        if(sult1.next()){
                            class_id=sult1.getInt(1);
                        }
                        sult1.close();
                        pre1.close();
             sql = "insert into stutable(stu_name,stu_xl,stu_sex,stu_tel,stu_address,stu_birthday,stu_td,stu_xh,class_id,stu_photo)values (?,?,?,?,?,?,?,?,?,?)";
                        pre = con.prepareStatement(sql);
                        pre.setString(1,jTextField1.getText().trim());
                        pre.setString(2,String.valueOf(jComboBox2.getSelectedItem()));
                        pre.setString(3,String.valueOf(jComboBox3.getSelectedItem()));
                        pre.setString(4,jTextField4.getText().trim());
                        pre.setString(5,jTextField5.getText().trim());
                        pre.setString(6,jTextField3.getText().trim());
                        pre.setString(7,jTextArea1.getText().trim());
                        pre.setString(8,jTextField2.getText());
                        pre.setInt(9,class_id);
                        pre.setString(10,String.valueOf(jLabel11.getIcon()));
//                //***********************************************************
//                System.out.println(jTextField1.getText().trim());
//                System.out.println(String.valueOf(jComboBox2.getSelectedItem()));
//                System.out.println(String.valueOf(jComboBox3.getSelectedItem()));
//                System.out.println(jTextField4.getText().trim());
//                System.out.println(jTextField5.getText().trim());
//                System.out.println(jTextField3.getText().trim());
//                System.out.println(jTextArea1.getText().trim());
//                System.out.println(jTextField2.getText());
//                System.out.println(class_id);
//                //******************************
//
//
//
//
//
                        pre.executeUpdate();
//
//
                        result.close();
                        pre.close();
                        con.close();


                    } catch (ClassNotFoundException ex) {
                    }catch (SQLException ex1) {
                        }







                }




    }

    public void jButton2_actionPerformed(ActionEvent e) {

        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //驅動加載
            con = DriverManager.getConnection("jdbc:odbc:glxt"); //數據橋連名子為ＯＤＢＣ名為glxt
            sql="delete from stutable where stu_xh=?";
            pre=con.prepareStatement(sql);
            pre.setString(1,String.valueOf(jComboBox4.getSelectedItem()));
            pre.executeUpdate();


            {

                    jTextField1.setText("");

                    jComboBox2.setSelectedItem("");

                    jComboBox3.setSelectedItem("");

                    jTextField4.setText("");

                    jTextField5.setText("");

                    jTextArea1.setText("");

                    jTextField3.setText("");
                    jTextField2.setText("");





            }





        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (SQLException ex1) {
            ex1.printStackTrace();
        }






    }

    public void jButton5_actionPerformed(ActionEvent e) {
        fileDialog = new FileDialog(new JFrame(),"选择图片");
        fileDialog.setVisible(true);
        Url = fileDialog.getDirectory()+fileDialog.getFile();
        Image img = Toolkit.getDefaultToolkit().getImage(Url);
        ImageIcon imgIcon = new ImageIcon(img.getScaledInstance(125,145,1));
        jLabel11.setIcon(imgIcon);
    }

}


class StuFrame_jButton5_actionAdapter implements ActionListener {
    private StuFrame adaptee;
    StuFrame_jButton5_actionAdapter(StuFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class StuFrame_jButton2_actionAdapter implements ActionListener {
    private StuFrame adaptee;
    StuFrame_jButton2_actionAdapter(StuFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class StuFrame_jButton1_actionAdapter implements ActionListener {
    private StuFrame adaptee;
    StuFrame_jButton1_actionAdapter(StuFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class StuFrame_jButton4_actionAdapter implements ActionListener {
    private StuFrame adaptee;
    StuFrame_jButton4_actionAdapter(StuFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class StuFrame_jComboBox4_actionAdapter implements ActionListener {
    private StuFrame adaptee;
    StuFrame_jComboBox4_actionAdapter(StuFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class StuFrame_jComboBox1_actionAdapter implements ActionListener {
    private StuFrame adaptee;
    StuFrame_jComboBox1_actionAdapter(StuFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class StuFrame_jButton6_actionAdapter implements ActionListener {
    private StuFrame adaptee;
    StuFrame_jButton6_actionAdapter(StuFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class StuFrame_jTextField3_actionAdapter implements ActionListener {
    private StuFrame adaptee;
    StuFrame_jTextField3_actionAdapter(StuFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class StuFrame_jButton3_actionAdapter implements ActionListener {
    private StuFrame adaptee;
    StuFrame_jButton3_actionAdapter(StuFrame adaptee) {
        this.adaptee = adaptee;
    }

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