updatebroke.java

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

    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, "信息修改成功！");
            } else {
                JOptionPane.showMessageDialog(null, "信息修改失败！");
            }
        } 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 (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) {
        }
    }

    public void findcarid_t_keyPressed(KeyEvent e) {
        if (e.getKeyCode() == KeyEvent.VK_ENTER) {
            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());
            }
        }
    }
}


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