newweizhang.java

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

        if (db != null)
            db.closeConnection();
        this.dispose();
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        db = new DataBaseManager();
        String str = "select * from car where 车牌号='" +
                     breakcarid_t.getText().trim() + "'";
        try {
            if (!db.getResult(str).first()) {
                JOptionPane.showMessageDialog(null,
                                              "该车辆不存在！");
                breakcarid_t.setText("");
                drivername_t.setText("");
                breaklowaddress_t.setText("");
                breakdate_t.setText("");
                penaltymoney_t.setText("");
                unit_t.setText("");
                breaklowreason_a.setText("");

            } else {
                str =
                        "insert into weizhang(违章车号,驾驶员,违章日期,违章地点,罚款金额,处理单位,违章原因) values('" +
                        breakcarid_t.getText().trim() + "','" +
                        drivername_t.getText().trim() + "','" +
                        breakdate_t.getText().trim() + "','" +
                        breaklowaddress_t.getText().trim() + "','" +
                        penaltymoney_t.getText().trim() + "','" +
                        unit_t.getText().trim() + "','" +
                        breaklowreason_a.getText().trim() + "'" + ")";
                if (db.updateSql(str)) {
                    JOptionPane.showMessageDialog(null,
                                                  "添加信息成功！");
                    String strSQL = "update car set 违章次数=违章次数+1" +
                                    " where 车牌号='" +
                                    breakcarid_t.getText().trim() +
                                    "'";
                    if (db.updateSql(strSQL))
                        ;
                    breakcarid_t.setText("");
                    drivername_t.setText("");
                    breaklowaddress_t.setText("");
                    breakdate_t.setText("");
                    penaltymoney_t.setText("");
                    unit_t.setText("");
                    breaklowreason_a.setText("");
                } else {
                    JOptionPane.showMessageDialog(null, "添加信息失败！");
                }
            }
        } catch (HeadlessException ex) {
        } catch (SQLException ex) {
        }
    }

    public void breakcarid_t_focusLost(FocusEvent e) {
        if (breakcarid_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "车牌号不能为空！");
    }

    public void drivername_t_focusLost(FocusEvent e) {
        if (drivername_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "驾驶员姓名不能为空！");
    }

    public void breakdate_t_focusLost(FocusEvent e) {
        if (breakdate_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "违章日期不能为空！");
        else {
            String s = breakdate_t.getText().trim() + "!";

            char date[] = new char[20];
            int i;
            date = s.toCharArray();
            for (i = 0; date[i] != '!'; i++)
                if ((date[i] >= '0' && date[i] <= '9') || date[i] == '.')
                    ;
                else {
                    JOptionPane.showMessageDialog(null,
                                                  "您输入的日期非法或您输入的日期格式不正确，请以“.”为分隔符！");
                    breakdate_t.setText("");
                    breakdate_t.setFocusable(true);
                    break;
                }
        }
    }

    public void breaklowaddress_t_focusLost(FocusEvent e) {
        if (breaklowaddress_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "违章地点不能为空！");
    }

    public void penaltymoney_t_focusLost(FocusEvent e) {
        if (penaltymoney_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "罚款金额不能为空！");
    }

    public void unit_t_focusLost(FocusEvent e) {
        if (unit_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "处理单位不能为空！");
    }

    public void breaklowreason_a_focusLost(FocusEvent e) {
        if (breaklowreason_a.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "违章原因不能为空！");
    }

    public void breaklowreason_a_keyPressed(KeyEvent e) {
        if (e.getKeyCode() == KeyEvent.VK_ENTER) {
            db = new DataBaseManager();
            String str = "select * from car where 车牌号='" +
                         breakcarid_t.getText().trim() + "'";
            try {
                if (!db.getResult(str).first()) {
                    JOptionPane.showMessageDialog(null,"该车辆不存在！");
                    breakcarid_t.setText("");
                    drivername_t.setText("");
                    breaklowaddress_t.setText("");
                    breakdate_t.setText("");
                    penaltymoney_t.setText("");
                    unit_t.setText("");
                    breaklowreason_a.setText("");

                } else {
                    str =
                            "insert into weizhang(违章车号,驾驶员,违章日期,违章地点,罚款金额,处理单位,违章原因) values('" +
                            breakcarid_t.getText().trim() + "','" +
                            drivername_t.getText().trim() + "','" +
                            breakdate_t.getText().trim() + "','" +
                            breaklowaddress_t.getText().trim() + "','" +
                            penaltymoney_t.getText().trim() + "','" +
                            unit_t.getText().trim() + "','" +
                            breaklowreason_a.getText().trim() + "'" + ")";
                    if (db.updateSql(str)) {
                        JOptionPane.showMessageDialog(null,"添加信息成功！");
                        String strSQL = "update car set 违章次数=违章次数+1" +
                                        " where 车牌号='" +
                                        breakcarid_t.getText().trim() +
                                        "'";
                        if (db.updateSql(strSQL))
                            ;
                        breakcarid_t.setText("");
                        drivername_t.setText("");
                        breaklowaddress_t.setText("");
                        breakdate_t.setText("");
                        penaltymoney_t.setText("");
                        unit_t.setText("");
                        breaklowreason_a.setText("");
                    } else {
                        JOptionPane.showMessageDialog(null, "添加信息失败！");
                    }
                }
            } catch (HeadlessException ex) {
            } catch (SQLException ex) {
            }
        }
    }
}


class Newweizhang_breakcarid_t_focusAdapter extends FocusAdapter {
    private Newweizhang adaptee;
    Newweizhang_breakcarid_t_focusAdapter(Newweizhang adaptee) {
        this.adaptee = adaptee;
    }

    public void focusLost(FocusEvent e) {

        adaptee.breakcarid_t_focusLost(e);
    }
}


class Newweizhang_jButton3_actionAdapter implements ActionListener {
    private Newweizhang adaptee;
    Newweizhang_jButton3_actionAdapter(Newweizhang adaptee) {
        this.adaptee = adaptee;
    }

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


class Newweizhang_jButton1_actionAdapter implements ActionListener {
    private Newweizhang adaptee;
    Newweizhang_jButton1_actionAdapter(Newweizhang adaptee) {
        this.adaptee = adaptee;
    }

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


class Newweizhang_jButton2_actionAdapter implements ActionListener {
    private Newweizhang adaptee;
    Newweizhang_jButton2_actionAdapter(Newweizhang adaptee) {
        this.adaptee = adaptee;
    }

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