findcar.java

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

                str2 = "车牌号='" + jTextField2.getText().trim() + "' and 车辆状态='" +
                       jTextField3.getText().trim() + "' and 制造商='" +
                       jTextField4.getText().trim() + "' and 违章次数='" +
                       jTextField5.getText().trim() + "'";
            }
            if (!str1.equals("")) {
                if (!db.getResult(sql + str1).first()) {
                    String s = "没有编号为" + jTextField1.getText().trim() +
                               "的车辆,请重新输入车牌号。";
                    JOptionPane.showMessageDialog(null, s);
                    jTextField1.setText("");
                } else {
                    te.fetch(sql + str1);
                }
            } else {
                if (!db.getResult(sql + str2).first()) {
                    String s = "该记录不存在，请仔细查对您输入的关键字。";
                    JOptionPane.showMessageDialog(null, s);
                    jTextField2.setText("");
                    jTextField3.setText("");
                    jTextField4.setText("");
                    jTextField5.setText("");
                } else {
                    te.fetch(sql + str2);
                }
            }
        } catch (HeadlessException ex) {
        } catch (SQLException ex) {
        }
    }

    public void jRadioButton1_actionPerformed(ActionEvent e) {
        if (jRadioButton1.isSelected()) {
            jRadioButton2.setSelected(false);
            jTextField2.setEnabled(false);
            jTextField3.setEnabled(false);
            jTextField4.setEnabled(false);
            jTextField5.setEnabled(false);
            jTextField1.setEnabled(true);
        }
    }

    public void jRadioButton2_actionPerformed(ActionEvent e) {
        if (jRadioButton2.isSelected()) {
            jRadioButton1.setSelected(false);
            jTextField1.setEnabled(false);
            jTextField2.setEnabled(true);
            jTextField3.setEnabled(true);
            jTextField4.setEnabled(true);
            jTextField5.setEnabled(true);

        }

    }

    public void jTextField1_keyPressed(KeyEvent e) {
        if (e.getKeyCode() == KeyEvent.VK_ENTER) {
            String sql = "select * from car where ";
            String str1 = "";
            String str2 = "";
            db = new DataBaseManager();
            try {
                if (jRadioButton1.isSelected()) {
                    str1 = "车牌号='" + jTextField1.getText().trim() + "'";
                } else if (jRadioButton2.isSelected()) {
                    str2 = "车牌号='" + jTextField2.getText().trim() +
                           "' and 车辆状态='" +
                           jTextField3.getText().trim() + "' and 制造商='" +
                           jTextField4.getText().trim() + "' and 违章次数='" +
                           jTextField5.getText().trim() + "'";
                }
                if (!str1.equals("")) {
                    if (!db.getResult(sql + str1).first()) {
                        String s = "没有编号为" + jTextField1.getText().trim() +
                                   "的车辆,请重新输入车牌号。";
                        JOptionPane.showMessageDialog(null, s);
                        jTextField1.setText("");
                    } else {
                        te.fetch(sql + str1);
                    }
                } else {
                    if (!db.getResult(sql + str2).first()) {
                        String s = "该记录不存在，请仔细查对您输入的关键字。";
                        JOptionPane.showMessageDialog(null, s);
                        jTextField2.setText("");
                        jTextField3.setText("");
                        jTextField4.setText("");
                        jTextField5.setText("");
                    } else {
                        te.fetch(sql + str2);
                    }
                }
            } catch (HeadlessException ex) {
            } catch (SQLException ex) {
            }

        }
    }

    public void jTextField5_keyPressed(KeyEvent e) {
        if (e.getKeyCode() == KeyEvent.VK_ENTER) {
            String sql = "select * from car where ";
            String str1 = "";
            String str2 = "";
            db = new DataBaseManager();
            try {
                if (jRadioButton1.isSelected()) {
                    str1 = "车牌号='" + jTextField1.getText().trim() + "'";
                } else if (jRadioButton2.isSelected()) {
                    str2 = "车牌号='" + jTextField2.getText().trim() +
                           "' and 车辆状态='" +
                           jTextField3.getText().trim() + "' and 制造商='" +
                           jTextField4.getText().trim() + "' and 违章次数='" +
                           jTextField5.getText().trim() + "'";
                }
                if (!str1.equals("")) {
                    if (!db.getResult(sql + str1).first()) {
                        String s = "没有编号为" + jTextField1.getText().trim() +
                                   "的车辆,请重新输入车牌号。";
                        JOptionPane.showMessageDialog(null, s);
                        jTextField1.setText("");
                    } else {
                        te.fetch(sql + str1);
                    }
                } else {
                    if (!db.getResult(sql + str2).first()) {
                        String s = "该记录不存在，请仔细查对您输入的关键字。";
                        JOptionPane.showMessageDialog(null, s);
                        jTextField2.setText("");
                        jTextField3.setText("");
                        jTextField4.setText("");
                        jTextField5.setText("");
                    } else {
                        te.fetch(sql + str2);
                    }
                }
            } catch (HeadlessException ex) {
            } catch (SQLException ex) {
            }

        }
    }
}


class FindCar_jRadioButton2_actionAdapter implements ActionListener {
    private FindCar adaptee;
    FindCar_jRadioButton2_actionAdapter(FindCar adaptee) {
        this.adaptee = adaptee;
    }

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


class FindCar_jRadioButton1_actionAdapter implements ActionListener {
    private FindCar adaptee;
    FindCar_jRadioButton1_actionAdapter(FindCar adaptee) {
        this.adaptee = adaptee;
    }

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


class FindCar_jButton1_actionAdapter implements ActionListener {
    private FindCar adaptee;
    FindCar_jButton1_actionAdapter(FindCar adaptee) {
        this.adaptee = adaptee;
    }

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


class FindCar_jButton2_actionAdapter implements ActionListener {
    private FindCar adaptee;
    FindCar_jButton2_actionAdapter(FindCar adaptee) {
        this.adaptee = adaptee;
    }

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