person_info.java~135~

一款高校科研管理系统

            };

            con.close();


        } catch (SQLException ex) {}


    }

    public void jButton2_actionPerformed(ActionEvent e) {
               Connection con;
                Statement sql;
                ResultSet rs;
                String queryString; // 删除语句
                String queryString1; //查找确认语句
                if (!jTextField13.getText().equals("")) {
            queryString = "DELETE from  人员信息 where 编号=" +
                          Integer.parseInt(jTextField13.getText());
            queryString1 = "select * from  人员信息 where 编号=" +
                           Integer.parseInt(jTextField13.getText());
        } else {
            queryString = "";
            queryString1 = "";
            JOptionPane.showMessageDialog(null, "请输入内容,请确认后认真填写", "提示框",
                                          JOptionPane.INFORMATION_MESSAGE);

        }

        try {
           con = DriverManager.getConnection("jdbc:odbc:scince", "", "");
           sql = con.createStatement();
            rs = sql.executeQuery(queryString1);
            if (rs.next()) {
                JOptionPane.showMessageDialog(null, "删除成功！", "提示框",
                                              JOptionPane.INFORMATION_MESSAGE);
            } else {
                JOptionPane.showMessageDialog(null, "没有找到您要删除的项目！", "提示框",
                                              JOptionPane.INFORMATION_MESSAGE);
            }
            sql.executeUpdate(queryString);
            jTextField1.setText("");
               jTextField2.setText("");
               jTextField3.setText("");
               jTextField4.setText("");
               jTextField5.setText("");
               jTextField6.setText("");
               jTextField7.setText("");
               jTextField8.setText("");
               jTextField9.setText("");
               jTextField10.setText("");
               jTextField11.setText("");
               jTextField12.setText("");
               jTextField13.setText("");
            con.close();
            jTextField13.setText("");

       } catch (SQLException ex) {}

    }

    public void jButton3_actionPerformed(ActionEvent e) {
                          Connection con;
                        Statement sql;
                        String queryString;
                        if (!jTextField1.getText().equals(""))
                         {
                            queryString ="INSERT INTO 人员信息 VALUES('"+Integer.parseInt(jTextField1.getText())+"','"+jTextField2.getText()+"','"+jTextField3.getText()+"','"+jTextField4.getText()+"','"+jTextField5.getText()+"','"+jTextField6.getText()+"','"+jTextField7.getText()+"', '"+jTextField8.getText()+"','"+jTextField9.getText()+"','"+Integer.parseInt(jTextField10.getText())+"','"+Integer.parseInt(jTextField11.getText())+"','"+Integer.parseInt(jTextField12.getText())+"')";
                            JOptionPane.showMessageDialog(null, "添加成功！", "提示框",
                                          JOptionPane.INFORMATION_MESSAGE);

                            }
                             else {
            JOptionPane.showMessageDialog(null, "人员编号为必填信息，请添加完整后在添加！", "提示框",
                                          JOptionPane.INFORMATION_MESSAGE);
            queryString = "";
                             }
                        try {
                            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                        } catch (java.lang.ClassNotFoundException ee) {
                            System.err.print("class not find!");
                            System.err.println(ee.getMessage());
                }
                try {
                   con = DriverManager.getConnection("jdbc:odbc:scince", "", "");
                   con.setAutoCommit(false);
                   sql = con.createStatement();
                   sql.executeUpdate(queryString);
                   con.commit();
                   con.close();
                   jTextField1.setText("");
               jTextField2.setText("");
               jTextField3.setText("");
               jTextField4.setText("");
               jTextField5.setText("");
               jTextField6.setText("");
               jTextField7.setText("");
               jTextField8.setText("");
               jTextField9.setText("");
               jTextField10.setText("");
               jTextField11.setText("");
               jTextField12.setText("");

       } catch (SQLException ex) {}
    }

    public void jButton4_actionPerformed(ActionEvent e) {
               this.dispose();
            }

    public void jButton5_actionPerformed(ActionEvent e) {
               jTextField1.setText("");
               jTextField2.setText("");
               jTextField3.setText("");
               jTextField4.setText("");
               jTextField5.setText("");
               jTextField6.setText("");
               jTextField7.setText("");
               jTextField8.setText("");
               jTextField9.setText("");
               jTextField10.setText("");
               jTextField11.setText("");
               jTextField12.setText("");
               jTextField13.setText("");


    }


    class person_Info_jButton1_actionAdapter implements ActionListener {
        private person_Info adaptee;
        person_Info_jButton1_actionAdapter(person_Info adaptee) {
            this.adaptee = adaptee;
        }

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


}


class person_Info_jButton5_actionAdapter implements ActionListener {
    private person_Info adaptee;
    person_Info_jButton5_actionAdapter(person_Info adaptee) {
        this.adaptee = adaptee;
    }

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


class person_Info_jButton4_actionAdapter implements ActionListener {
    private person_Info adaptee;
    person_Info_jButton4_actionAdapter(person_Info adaptee) {
        this.adaptee = adaptee;
    }

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


class person_Info_jButton2_actionAdapter implements ActionListener {
    private person_Info adaptee;
    person_Info_jButton2_actionAdapter(person_Info adaptee) {
        this.adaptee = adaptee;
    }

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


class person_Info_jButton3_actionAdapter implements ActionListener {
    private person_Info adaptee;
    person_Info_jButton3_actionAdapter(person_Info adaptee) {
        this.adaptee = adaptee;
    }

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