updatebroke.java~47~

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

    JLabel jLabel11 = new JLabel();
    JButton jButton2 = new JButton(new ImageIcon("image\\bao.png"));
    JButton jButton3 = new JButton(new ImageIcon("image\\back.gif"));
    JButton jButton4 = new JButton(new ImageIcon("image\\delete.png"));
    JLabel jLabel12 = new JLabel();
    JTextField repairdate_t = new JTextField();
    JTextField repairtime_t = new JTextField();
    JButton jButton5 = new JButton(new ImageIcon("image\\qian.gif") );
    JButton jButton6 = new JButton(new ImageIcon("image\\hou.gif"));
    public void jButton3_actionPerformed(ActionEvent e) {
        if(db!=null)
        db.closeConnection() ;
        dispose();
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        db=new DataBaseManager();
        try { //维修车号,维修日期,维修时间,修理厂,维修时公里数,维修金额,负责人,维修原因,所更换零配件
                    String str1 = "select * from update_car 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 {
                        String str = "select * from update_car where 维修车号='" +
                                     findcarid_t.getText().trim() + "'";
                        r = db.getResult(str);
                        r.first();
                        repaircarid_t.setText(findcarid_t.getText());
                        repairdate_t.setText(r.getString("维修日期"));
                        repairtime_t.setText(r.getString("维修时间"));
                        repairfatory_t.setText(r.getString("修理厂"));
                        kilometre.setText(r.getString("维修时公里数"));
                        repairmoney_t.setText(r.getString("维修金额"));
                        person_t.setText(r.getString("负责人"));
                        reason_a.setText(r.getString("维修原因"));
                        replacement_a.setText(r.getString("所更换零配件"));
                    }
                }catch (Exception ex) {
                    System.out.println(ex.toString());
        }
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        try {
            String strSQL = "update update_car set 维修车号='" +
                            repaircarid_t.getText().trim() + "',维修日期='" +
                            repairdate_t.getText().trim() + "',维修时间='" +
                            repairtime_t.getText().trim() + "',修理厂='" +
                            repairfatory_t.getText().trim() + "',维修时公里数='" +
                            kilometre.getText() .trim()  + "',维修金额='" +
                            repairmoney_t.getText().trim() + "',负责人='" +
                            person_t.getText().trim() + "',维修原因='" +
                            reason_a.getText().trim() + "',所更换零配件='" +
                            replacement_a.getText().trim() +
                            "' where 维修车号='" + findcarid_t.getText().trim() + "'";
            if (db.updateSql(strSQL)) {
                JOptionPane.showMessageDialog(null, "信息修改成功！");
//                db.closeConnection();
//                this.dispose();
            } else {
                JOptionPane.showMessageDialog(null, "信息修改失败！");
//                db.closeConnection();
//                this.dispose();
            }
        } catch (Exception ex) {
            System.out.println(ex.toString());
        }
    }

    public void jButton4_actionPerformed(ActionEvent e) {
        try{
                    String str2 = "delete from update_car 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,
                                                      "删除失败！");
                                      }
                                      if (r.isFirst()) {
                                          jButton5.setEnabled(false);
                                          jButton6.setEnabled(true);
                                      } else if (r.isLast()) {
                                          jButton6.setEnabled(false);
                                          jButton5.setEnabled(true);
                                      } else {
                                          jButton6.setEnabled(true);
                                          jButton5.setEnabled(true);
                                      }


                                      //  }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 jButton5_actionPerformed(ActionEvent e) {
        try {
            r.previous();
            repaircarid_t.setText(findcarid_t.getText());
            repairdate_t.setText(r.getString("维修日期"));
            repairtime_t.setText(r.getString("维修时间"));
            repairfatory_t.setText(r.getString("修理厂"));
            kilometre.setText(r.getString("维修时公里数"));
            repairmoney_t.setText(r.getString("维修金额"));
            person_t.setText(r.getString("负责人"));
            reason_a.setText(r.getString("维修原因"));
            replacement_a.setText(r.getString("所更换零配件"));

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

    public void jButton6_actionPerformed(ActionEvent e) {
        try {
            r.next();
            repaircarid_t.setText(findcarid_t.getText());
            repairdate_t.setText(r.getString("维修日期"));
            repairtime_t.setText(r.getString("维修时间"));
            repairfatory_t.setText(r.getString("修理厂"));
            kilometre.setText(r.getString("维修时公里数"));
            repairmoney_t.setText(r.getString("维修金额"));
            person_t.setText(r.getString("负责人"));
            reason_a.setText(r.getString("维修原因"));
            replacement_a.setText(r.getString("所更换零配件"));

            if (r.isFirst()) {
                jButton5.setEnabled(false);
                jButton6.setEnabled(true);
            }
            else if(r.isLast() )
            {
                jButton6.setEnabled(false);
                jButton5.setEnabled(true);
            }
            else
            {
                jButton6.setEnabled(true);
                jButton5.setEnabled(true);
            }

               } catch (SQLException ex) {
        }
    }
}


class Updatebroke_jButton1_actionAdapter implements ActionListener {
    private Updatebroke adaptee;
    Updatebroke_jButton1_actionAdapter(Updatebroke adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton1_actionPerformed(e);
    }
}


class Updatebroke_jButton3_actionAdapter implements ActionListener {
    private Updatebroke adaptee;
    Updatebroke_jButton3_actionAdapter(Updatebroke adaptee) {
        this.adaptee = adaptee;
    }

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