updatejiaofei.java

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

                String str = "select * from jiaofei where 车牌号='" +
                             findcarid_t.getText().trim() + "'";
                r = db.getResult(str);
                r.first();
                carid_t.setText(findcarid_t.getText());
                jComboBox1.setSelectedItem(r.getString("费用种类"));
                begindate_t.setText(r.getString("起始日期"));
                enddate_t.setText(r.getString("截止日期"));
                givemoney_t.setText(r.getString("交费日期"));
                person_t.setText(r.getString("收款人"));
                unit_t.setText(r.getString("收款单位"));
                money_t.setText(r.getString("费用金额"));
                demo_a.setText(r.getString("备注"));
                if (r.isFirst()) {
                    jButton2.setEnabled(false);
                    jButton6.setEnabled(true);
                } else if (r.isLast()) {
                    jButton6.setEnabled(false);
                    jButton2.setEnabled(true);
                } else {
                    jButton6.setEnabled(true);
                    jButton2.setEnabled(true);
                }
            }
        } catch (Exception ex) {
            System.out.println(ex.toString());
        }
    }

    public void jButton3_actionPerformed(ActionEvent e) {
        try { //车牌号,费用种类,起始日期,截止日期,交费日期,收款人,收款单位,费用金额,备注
            String strSQL = "update jiaofei set 车牌号='" +
                            carid_t.getText().trim() + "',费用种类='" +
                            jComboBox1.getSelectedItem() + "',起始日期='" +
                            begindate_t.getText().trim() + "',截止日期='" +
                            enddate_t.getText().trim() + "',交费日期='" +
                            givemoney_t.getText().trim() + "',收款人='" +
                            person_t.getText().trim() + "',收款单位='" +
                            unit_t.getText().trim() + "',费用金额='" +
                            money_t.getText().trim() + "',备注='" +
                            demo_a.getText().trim() +
                            "' where 维修车号='" + carid_t.getText().trim() + "'";
            if (db.updateSql(strSQL)) {
                JOptionPane.showMessageDialog(null, "信息修改成功！");
            } else {
                JOptionPane.showMessageDialog(null, "信息修改失败！");
            }
        } catch (Exception ex) {
            System.out.println(ex.toString());
        }
    }

    public void jButton4_actionPerformed(ActionEvent e) {
        try {
            String str2 = "delete from jiaofei where 车牌号='" +
                          carid_t.getText().trim() + "' and 费用种类='" +
                          jComboBox1.getSelectedItem() + "' and 起始日期='" +
                          begindate_t.getText().trim() + "' and 截止日期='" +
                          enddate_t.getText().trim() + "' and 交费日期='" +
                          givemoney_t.getText().trim() + "' and 收款人='" +
                          person_t.getText().trim() + "' and 收款单位='" +
                          unit_t.getText().trim() + "' and 费用金额='" +
                          money_t.getText().trim() + "' and 备注='" +
                          demo_a.getText().trim() + "'";
            String q = "确定要删除吗？";
            int ok = JOptionPane.showConfirmDialog(null, q, "确认",
                    JOptionPane.YES_NO_OPTION,
                    JOptionPane.QUESTION_MESSAGE);
            if (ok == JOptionPane.YES_OPTION) {
                if (db.updateSql(str2)) {
                    JOptionPane.showMessageDialog(null, "删除成功！");
                    r.updateRow();
                } else
                    JOptionPane.showMessageDialog(null, "删除失败！");
            }
        } catch (Exception ex) {
            System.out.println(ex.toString());
        }
    }

    public void findcarid_t_focusLost(FocusEvent focusEvent) {
        if (findcarid_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null,
                                          "关键字不能为空！");
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        try {
            r.previous();
            carid_t.setText(findcarid_t.getText());
            jComboBox1.setSelectedItem(r.getString("费用种类"));
            begindate_t.setText(r.getString("起始日期"));
            enddate_t.setText(r.getString("截止日期"));
            givemoney_t.setText(r.getString("交费日期"));
            person_t.setText(r.getString("收款人"));
            unit_t.setText(r.getString("收款单位"));
            money_t.setText(r.getString("费用金额"));
            demo_a.setText(r.getString("备注"));

            if (r.isFirst()) {
                jButton2.setEnabled(false);
                jButton6.setEnabled(true);
            } else if (r.isLast()) {
                jButton6.setEnabled(false);
                jButton2.setEnabled(true);
            } else {
                jButton6.setEnabled(true);
                jButton2.setEnabled(true);
            }
        } catch (SQLException ex) {
        }
    }

    public void jButton6_actionPerformed(ActionEvent e) {
        try {
            r.next();
            carid_t.setText(findcarid_t.getText());
            jComboBox1.setSelectedItem(r.getString("费用种类"));
            begindate_t.setText(r.getString("起始日期"));
            enddate_t.setText(r.getString("截止日期"));
            givemoney_t.setText(r.getString("交费日期"));
            person_t.setText(r.getString("收款人"));
            unit_t.setText(r.getString("收款单位"));
            money_t.setText(r.getString("费用金额"));
            demo_a.setText(r.getString("备注"));

            if (r.isFirst()) {
                jButton2.setEnabled(false);
                jButton6.setEnabled(true);
            } else if (r.isLast()) {
                jButton6.setEnabled(false);
                jButton2.setEnabled(true);
            } else {
                jButton6.setEnabled(true);
                jButton2.setEnabled(true);
            }
        } catch (SQLException ex) {
        }
    }

    public void findcarid_t_keyPressed(KeyEvent e) {
        if (e.getKeyCode() == KeyEvent.VK_ENTER) {
            db = new DataBaseManager();
            try {
                String str1 = "select * from car where 车牌号='" +
                              findcarid_t.getText().trim() + "'";
                String str2 = "select * from jiaofei where 车牌号='" +
                              findcarid_t.getText().trim() + "'";
                if (findcarid_t.getText().trim().equals(""))
                    JOptionPane.showMessageDialog(null, "请输入车牌号！");
                else if (!db.getResult(str1).first()) {
                    String s = "没有编号为" + findcarid_t.getText().trim() +
                               "的车辆,请重新输入车牌号。";
                    JOptionPane.showMessageDialog(null, s);
                    findcarid_t.setText("");

                } else if (!db.getResult(str2).first()) {
                    String s = findcarid_t.getText().trim() +
                               "车辆的缴费信息不存在！";
                    JOptionPane.showMessageDialog(null, s);
                    findcarid_t.setText("");
                } else {
                    String str = "select * from jiaofei where 车牌号='" +
                                 findcarid_t.getText().trim() + "'";
                    r = db.getResult(str);
                    r.first();
                    carid_t.setText(findcarid_t.getText());
                    jComboBox1.setSelectedItem(r.getString("费用种类"));
                    begindate_t.setText(r.getString("起始日期"));
                    enddate_t.setText(r.getString("截止日期"));
                    givemoney_t.setText(r.getString("交费日期"));
                    person_t.setText(r.getString("收款人"));
                    unit_t.setText(r.getString("收款单位"));
                    money_t.setText(r.getString("费用金额"));
                    demo_a.setText(r.getString("备注"));
                    if (r.isFirst()) {
                        jButton2.setEnabled(false);
                        jButton6.setEnabled(true);
                    } else if (r.isLast()) {
                        jButton6.setEnabled(false);
                        jButton2.setEnabled(true);
                    } else {
                        jButton6.setEnabled(true);
                        jButton2.setEnabled(true);
                    }

                }
            } catch (Exception ex) {
                System.out.println(ex.toString());
            }
        }
    }
}


class Updatejiaofei_jButton4_actionAdapter implements ActionListener {
    private Updatejiaofei adaptee;
    Updatejiaofei_jButton4_actionAdapter(Updatejiaofei adaptee) {
        this.adaptee = adaptee;
    }

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


class Updatejiaofei_jButton3_actionAdapter implements ActionListener {
    private Updatejiaofei adaptee;
    Updatejiaofei_jButton3_actionAdapter(Updatejiaofei adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton3_actionPerformed(e);
    }
}


class Updatejiaofei_jButton1_actionAdapter implements ActionListener {
    private Updatejiaofei adaptee;
    Updatejiaofei_jButton1_actionAdapter(Updatejiaofei adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton1_actionPerformed(e);
    }
}


class Updatejiaofei_jButton5_actionAdapter implements ActionListener {
    private Updatejiaofei adaptee;
    Updatejiaofei_jButton5_actionAdapter(Updatejiaofei adaptee) {
        this.adaptee = adaptee;
    }

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