finddriver.java

出租车管理系统,为本人毕业设计. 还请大家多多指教了

        } 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 驾驶证号,驾驶员姓名,性别,民族,文化程度,驾证初领日,身份证号,住址,联系电话,准驾类型 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 驾驶证号,驾驶员姓名,性别,民族,文化程度,驾证初领日,身份证号,住址,联系电话,准驾类型 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 驾驶证号,驾驶员姓名,性别,民族,文化程度,驾证初领日,身份证号,住址,联系电话,准驾类型 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 驾驶证号,驾驶员姓名,性别,民族,文化程度,驾证初领日,身份证号,住址,联系电话,准驾类型 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);
        }
    }
}