updatejiaofei.java~25~

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

    JButton jButton5 = new JButton(new ImageIcon("back.gif"));
    Border border1 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.white, new Color(178, 178, 178));
    JLabel jLabel11 = new JLabel();
    JTextField begindate_t = new JTextField();
    JTextField givemoney_t = new JTextField();
    JTextField enddate_t = new JTextField();
    JButton jButton2 = new JButton();
    JButton jButton6 = new JButton();
    public void jButton5_actionPerformed(ActionEvent e) {
        if (db != null)
            db.closeConnection();
        this.dispose();
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        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.isLast())
                    jButton6.setEnabled(false);
                if (r.isFirst())
                    jButton2.setEnabled(false);

            }
        } 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 车牌号='" +
                          findcarid_t.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);
            }
        } 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.isLast()) {
                jButton6.setEnabled(false);
            }
        } catch (SQLException ex) {
        }
    }
}

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);
    }
}