updateweizhang.java~45~

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

                            penaltymoney_t.getText().trim() + "',处理单位='" +
                            unit_t.getText().trim() + "',违章原因='" +
                            breaklowreason_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 weizhang where 违章车号='" +
                            carid_t.getText().trim() + "' and 驾驶员='" +
                            drivername_t.getText().trim() + "' and 违章日期='" +
                            date_t.getText().trim() + "' and 违章地点='" +
                            address_t.getText().trim() + "' and 罚款金额='" +
                            penaltymoney_t.getText().trim() + "' and 处理单位='" +
                            unit_t.getText().trim() + "' and 违章原因='" +
                            breaklowreason_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(SQLException sqle){System.out.println(sqle.toString());
        } 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 jbutton1_actionPerformed(ActionEvent actionEvent) {
        db = new DataBaseManager();
        try {
            String str1 = "select * from car where 车牌号='" +
                          findcarid_t.getText().trim() + "'";
            String str2 = "select * from weizhang 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);
            } else if (!db.getResult(str2).first()) {
                String s = findcarid_t.getText().trim() +
                           "车辆的违章记录不存在！";
                JOptionPane.showMessageDialog(null, s);
            } else {
                String str = "select * from weizhang where 违章车号='" +
                             findcarid_t.getText().trim() + "'";
                r = db.getResult(str);

                r.first();
                carid_t.setText(findcarid_t.getText().trim());
                drivername_t.setText(r.getString("驾驶员"));
                date_t.setText(r.getString("违章日期"));
                address_t.setText(r.getString("违章地点"));
                penaltymoney_t.setText(r.getString("罚款金额"));
                unit_t.setText(r.getString("处理单位"));
                breaklowreason_a.setText(r.getString("违章原因"));
                if (r.isFirst()) {
                    jButton2.setEnabled(false);
                    jButton1.setEnabled(true);
                } else if (r.isLast()) {
                    jButton1.setEnabled(false);
                    jButton2.setEnabled(true);
                } else {
                    jButton1.setEnabled(true);
                    jButton2.setEnabled(true);
                }

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

    public void jButton1_actionPerformed(ActionEvent e) {

        try {
            r.next();
            carid_t.setText(findcarid_t.getText().trim());
            drivername_t.setText(r.getString("驾驶员"));
            date_t.setText(r.getString("违章日期"));
            address_t.setText(r.getString("违章地点"));
            penaltymoney_t.setText(r.getString("罚款金额"));
            unit_t.setText(r.getString("处理单位"));
            breaklowreason_a.setText(r.getString("违章原因"));
            if (r.isFirst()) {
                jButton2.setEnabled(false);
                jButton1.setEnabled(true);
            } else if (r.isLast()) {
                jButton1.setEnabled(false);
                jButton2.setEnabled(true);
            } else {
                jButton1.setEnabled(true);
                jButton2.setEnabled(true);
            }

        } catch (SQLException ex) {
        }
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        try {
            r.previous();
            carid_t.setText(findcarid_t.getText().trim());
            drivername_t.setText(r.getString("驾驶员"));
            date_t.setText(r.getString("违章日期"));
            address_t.setText(r.getString("违章地点"));
            penaltymoney_t.setText(r.getString("罚款金额"));
            unit_t.setText(r.getString("处理单位"));
            breaklowreason_a.setText(r.getString("违章原因"));
            if (r.isFirst()) {
                jButton2.setEnabled(false);
                jButton1.setEnabled(true);
            } else if (r.isLast()) {
                jButton1.setEnabled(false);
                jButton2.setEnabled(true);
            } else {
                jButton1.setEnabled(true);
                jButton2.setEnabled(true);
            }

        } catch (SQLException ex) {
        }
    }
}


class Updateweizhang_jButton4_actionAdapter implements ActionListener {
    private Updateweizhang adaptee;
    Updateweizhang_jButton4_actionAdapter(Updateweizhang adaptee) {
        this.adaptee = adaptee;
    }

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


class Updateweizhang_jButton5_actionAdapter implements ActionListener {
    private Updateweizhang adaptee;
    Updateweizhang_jButton5_actionAdapter(Updateweizhang adaptee) {
        this.adaptee = adaptee;
    }

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


class Updateweizhang_jButton1_actionAdapter implements ActionListener {
    private Updateweizhang adaptee;
    Updateweizhang_jButton1_actionAdapter(Updateweizhang adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

    }
}


class Updateweizhang_jButton3_actionAdapter implements ActionListener {
    private Updateweizhang adaptee;
    Updateweizhang_jButton3_actionAdapter(Updateweizhang adaptee) {
        this.adaptee = adaptee;
    }

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