} catch (SQLException ex) {
        }
    }

    public void jCheckBox1_itemStateChanged(ItemEvent e) {
    }

    public void jCheckBox2_itemStateChanged(ItemEvent e) {
    }

    public void jCheckBox1_actionPerformed(ActionEvent e) {
        if (jCheckBox1.isSelected()) {
            //jButton1.setEnabled(true);
            jTextField1.setEnabled(true);
        } else {
            //jButton1.setEnabled(false);
            jTextField1.setEnabled(false);
        }
    }

    public void jCheckBox2_actionPerformed(ActionEvent e) {
        if (jCheckBox2.isSelected()) {
            //  jButton2.setEnabled(true);
            jComboBox1.setEnabled(true);
        } else {
            // jButton2.setEnabled(false);
            jComboBox1.setEnabled(false);
        }

    }

    public void jTextField1_focusLost(FocusEvent e) {
        if (jTextField1.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "駕駛證號不能為空！");
        else {
            db2 = new DataBaseManager();
            try {
                if (!db2.getResult("select * from driver where 駕駛證號='" +
                                   jTextField1.getText().trim() + "'").first()) {
                    String s = "沒有編號為" + jTextField1.getText().trim() +
                               "的駕駛員!";
                    JOptionPane.showMessageDialog(null, s);
                    jTextField1.setFocusable(true);
                }
            } catch (HeadlessException ex) {
            } catch (SQLException ex) {
            }
        }
    }

    public void jComboBox1_keyPressed(KeyEvent e) {
        if (e.getKeyCode() == KeyEvent.VK_ENTER) {
            String sql =
                    "select 駕駛證號,駕駛員姓名,性別,民族,文化程度,駕證初領日,身份證號,住址,聯(lián)系電話,準駕類型 from driver where ";
            String str = "";
            db = new DataBaseManager();
            try {
                if (jCheckBox1.isSelected() && jCheckBox2.isSelected()) {
                    if (!db.getResult("select * from driver where 駕駛證號='" +
                                      jTextField1.getText().trim() + "'").first()) {
                        String s = "沒有編號為" + jTextField1.getText().trim() +
                                   "的駕駛員,請重新輸入駕駛證號。";
                        JOptionPane.showMessageDialog(null, s);
                        jTextField1.setText("");
                    } else {
                        str = "駕駛證號='" + jTextField1.getText().trim() +
                              "' and 準駕類型='" + jComboBox1.getSelectedItem() +
                              "'";
                    }
                } else if (jCheckBox1.isSelected()) {
                    if (!db.getResult("select * from driver where 駕駛證號='" +
                                      jTextField1.getText().trim() + "'").first()) {
                        String s = "沒有編號為" + jTextField1.getText().trim() +
                                   "的駕駛員,請重新輸入駕駛證號。";
                        JOptionPane.showMessageDialog(null, s);
                        jTextField1.setText("");
                    } else {
                        str = "駕駛證號='" + jTextField1.getText().trim() + "'";
                    }
                } else if (jCheckBox2.isSelected()) {
                    if (db.getResult(
                            "select 駕駛證號,駕駛員姓名,性別,民族,文化程度,駕證初領日,身份證號,住址,聯(lián)系電話,準駕類型 from driver where 準駕類型='" +
                            jComboBox1.getSelectedItem() + "'").first()) {
                        str = "準駕類型='" + jComboBox1.getSelectedItem() + "'";
                    }

                }
                te.fetch(sql + str); //
            } catch (HeadlessException ex) {
            } catch (SQLException ex) {
            }

        }
    }

    public void jTextField1_keyPressed(KeyEvent e) {
        if (e.getKeyCode() == KeyEvent.VK_ENTER) {
            String sql =
                    "select 駕駛證號,駕駛員姓名,性別,民族,文化程度,駕證初領日,身份證號,住址,聯(lián)系電話,準駕類型 from driver where ";
            String str = "";
            db = new DataBaseManager();
            try {
                if (jCheckBox1.isSelected() && jCheckBox2.isSelected()) {
                    if (!db.getResult("select * from driver where 駕駛證號='" +
                                      jTextField1.getText().trim() + "'").first()) {
                        String s = "沒有編號為" + jTextField1.getText().trim() +
                                   "的駕駛員,請重新輸入駕駛證號。";
                        JOptionPane.showMessageDialog(null, s);
                        jTextField1.setText("");
                    } else {
                        str = "駕駛證號='" + jTextField1.getText().trim() +
                              "' and 準駕類型='" + jComboBox1.getSelectedItem() +
                              "'";
                    }
                } else if (jCheckBox1.isSelected()) {
                    if (!db.getResult("select * from driver where 駕駛證號='" +
                                      jTextField1.getText().trim() + "'").first()) {
                        String s = "沒有編號為" + jTextField1.getText().trim() +
                                   "的駕駛員,請重新輸入駕駛證號。";
                        JOptionPane.showMessageDialog(null, s);
                        jTextField1.setText("");
                    } else {
                        str = "駕駛證號='" + jTextField1.getText().trim() + "'";
                    }
                } else if (jCheckBox2.isSelected()) {
                    if (db.getResult(
                            "select 駕駛證號,駕駛員姓名,性別,民族,文化程度,駕證初領日,身份證號,住址,聯(lián)系電話,準駕類型 from driver where 準駕類型='" +
                            jComboBox1.getSelectedItem() + "'").first()) {
                        str = "準駕類型='" + jComboBox1.getSelectedItem() + "'";
                    }

                }
                te.fetch(sql + str); //
            } catch (HeadlessException ex) {
            } catch (SQLException ex) {
            }

        }
    }


    class FindDriver_jCheckBox2_itemAdapter implements ItemListener {
        private FindDriver adaptee;
        FindDriver_jCheckBox2_itemAdapter(FindDriver adaptee) {
            this.adaptee = adaptee;
        }

        public void itemStateChanged(ItemEvent e) {
            adaptee.jCheckBox2_itemStateChanged(e);
        }
    }


    class FindDriver_jCheckBox1_itemAdapter implements ItemListener {
        private FindDriver adaptee;
        FindDriver_jCheckBox1_itemAdapter(FindDriver adaptee) {
            this.adaptee = adaptee;
        }

        public void itemStateChanged(ItemEvent e) {
            adaptee.jCheckBox1_itemStateChanged(e);
        }
    }


    class FindDriver_jCheckBox2_actionAdapter implements ActionListener {
        private FindDriver adaptee;
        FindDriver_jCheckBox2_actionAdapter(FindDriver adaptee) {
            this.adaptee = adaptee;
        }

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


    class FindDriver_jCheckBox1_actionAdapter implements ActionListener {
        private FindDriver adaptee;
        FindDriver_jCheckBox1_actionAdapter(FindDriver adaptee) {
            this.adaptee = adaptee;
        }

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


    class FindDriver_jButton1_actionAdapter implements ActionListener {
        private FindDriver adaptee;
        FindDriver_jButton1_actionAdapter(FindDriver adaptee) {
            this.adaptee = adaptee;
        }

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


    class FindDriver_jButton2_actionAdapter implements ActionListener {
        private FindDriver adaptee;
        FindDriver_jButton2_actionAdapter(FindDriver adaptee) {
            this.adaptee = adaptee;
        }

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