jTextField5.setText(rs.getString(5));
                jTextField6.setText(rs.getString(6));
                jTextField7.setText(rs.getString(7));
                jTextField8.setText(rs.getString(8));
                jTextField9.setText(rs.getString(9));
                jTextField10.setText(Integer.toString(rs.getInt(10)));
                jTextField11.setText(Integer.toString(rs.getInt(11)));
                jTextField12.setText(Integer.toString(rs.getInt(12)));
            } else {
                JOptionPane.showMessageDialog(null, "沒有找到您要求的項目,請重新填寫！", "人員信息查詢對話框",
                                              JOptionPane.INFORMATION_MESSAGE);
                jTextField13.setText("");
            }
            ;

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