person_info.java~138~

一款高校科研管理系统

        } 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", "", "");
            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);
    }
}