updateweizhang.java~52~

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

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

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

        }
    }
}


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