newbroke.java~47~

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

    }

    DataBaseManager db = null;
    ResultSet r;
    XYLayout xYLayout1 = new XYLayout();
    JLabel jLabel1 = new JLabel();
    Border border1 = BorderFactory.createEtchedBorder(Color.white,
            new Color(165, 163, 151));
    JTextField carid_t = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField people_t = new JTextField();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField factory_t = new JTextField();
    JTextField money_t = new JTextField();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JTextField kilometre_t = new JTextField();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    JTextArea change_a = new JTextArea();
    JTextArea reason_a = new JTextArea();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton(new ImageIcon("back.gif"));
    Border border2 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.white, new Color(178, 178, 178));
    Border border3 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.white, new Color(178, 178, 178));
    JLabel jLabel11 = new JLabel();
    JTextField updatedate_t = new JTextField();
    JTextField updatetime_t = new JTextField();
    public void jButton1_actionPerformed(ActionEvent e) {
        carid_t.setText("");
        people_t.setText("");
        factory_t.setText("");
        updatedate_t.setText("");
        updatetime_t.setText("");
        money_t.setText("");
        kilometre_t.setText("");
        change_a.setText("");
        reason_a.setText("");
    }

    public void jButton3_actionPerformed(ActionEvent e) {
        if (db != null)
            db.closeConnection();
        this.dispose();
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        db = new DataBaseManager();
        String str = "select * from car where 车牌号='" +
                     carid_t.getText().trim() + "'";
        try {
            if (!db.getResult(str).first()) {
                JOptionPane.showMessageDialog(null,
                                              "该车辆不存在！");
                carid_t.setText("");
                people_t.setText("");
                factory_t.setText("");
                updatedate_t.setText("");
                updatetime_t.setText("");
                money_t.setText("");
                kilometre_t.setText("");
                change_a.setText("");
                reason_a.setText("");
            } else {
                str = "insert into update_car(维修车号,维修日期,维修时间,修理厂,维修时公里数,维修金额,负责人,维修原因,所更换零配件) values('" +
                      carid_t.getText().trim() + "','" +
                      updatedate_t.getText().trim() + "','" +
                      updatetime_t.getText().trim() + "','" +
                      factory_t.getText().trim() + "','" +
                      kilometre_t.getText().trim() + "','" +
                      money_t.getText().trim() + "','" +
                      people_t.getText().trim() + "','" +
                      reason_a.getText().trim() + "','" +
                      change_a.getText().trim() + "'" + ")";

                if (db.updateSql(str)) {
                    JOptionPane.showMessageDialog(null, "添加信息成功！");
                    carid_t.setText("");
                    carid_t.setText("");
                    people_t.setText("");
                    factory_t.setText("");
                    updatedate_t.setText("");
                    updatetime_t.setText("");
                    money_t.setText("");
                    kilometre_t.setText("");
                    change_a.setText("");
                    reason_a.setText("");
                } else {
                    JOptionPane.showMessageDialog(null, "添加信息失败！");
                }
            }
        } catch (HeadlessException ex1) {
        } catch (SQLException ex1) {
        }
    }


    public void carid_t_focusLost(FocusEvent e) {
        if (carid_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "车号不能为空！");
    }

    public void people_t_focusLost(FocusEvent e) {
        if (people_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "负责人不能为空！");
    }

    public void updatedate_t_focusLost(FocusEvent e) {
        if (updatedate_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "维修日期不能为空！");
        else {
            String s = updatedate_t.getText().trim() + "!";
            char date[] = new char[20];
            int i;
            date = s.toCharArray();
            for (i = 0; date[i] != '!'; i++)
                if ((date[i] >= '0' && date[i] <= '9') || date[i] == '.' ||
                    date[i] == '/' || date[i] == '-')
                    ;
                else {
                    JOptionPane.showMessageDialog(null,
                            "您输入的日期非法或您输入的日期格式不正确，请以“.”、“/”或“-”为分隔符！");
                    updatedate_t.setText("");
                    updatedate_t.setFocusable(true);
                    break;
                }

        }
    }

    public void factory_t_focusLost(FocusEvent e) {
        if (factory_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "维修厂不能为空！");
    }

    public void updatetime_t_focusLost(FocusEvent e) {
        if (updatetime_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "维修时间不能为空！");
    }

    public void money_t_focusLost(FocusEvent e) {
        if (money_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "维修金额不能为空！");
    }

    public void kilometre_t_focusLost(FocusEvent e) {
        if (kilometre_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "维修时公里数不能为空！");
    }

    public void change_a_focusLost(FocusEvent e) {
        if (change_a.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "更换零件不能为空！");
    }

    public void reason_a_focusLost(FocusEvent e) {
        if (reason_a.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "维修原因不能为空！");
    }


    class Newbroke_jButton3_actionAdapter implements ActionListener {
        private Newbroke adaptee;
        Newbroke_jButton3_actionAdapter(Newbroke adaptee) {
            this.adaptee = adaptee;
        }

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


    class Newbroke_jButton1_actionAdapter implements ActionListener {
        private Newbroke adaptee;
        Newbroke_jButton1_actionAdapter(Newbroke adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {

            adaptee.jButton1_actionPerformed(e);
        }
    }
}