updatecar.java~30~

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

                                  new XYConstraints(432, 413, 110, 30));
        this.getContentPane().add(jLabel11, new XYConstraints(335, 413, -1, 31));
        this.getContentPane().add(protecthour_t,
                                  new XYConstraints(432, 371, 110, 30));
        this.getContentPane().add(jLabel15, new XYConstraints(335, 371, -1, 31));
        this.getContentPane().add(jLabel17, new XYConstraints(335, 329, -1, 31));
        this.getContentPane().add(jLabel7, new XYConstraints(335, 289, -1, 31));
        this.getContentPane().add(driveid_t,
                                  new XYConstraints(433, 248, 109, 30));
        this.getContentPane().add(nextyingdate,
                                  new XYConstraints(432, 289, 110, 30));
        this.getContentPane().add(nextyeardate,
                                  new XYConstraints(432, 329, 110, 30));

        this.getContentPane().add(jComboBox2,
                                  new XYConstraints(144, 413, 108, 30));
        this.getContentPane().add(jButton3, new XYConstraints(359, 471, 103, 49));
        jPanel1.add(jButton1, new XYConstraints(401, 1, 115, 33));

        jLabel1.setText("请输入车牌号：");
        this.setSize(590, 588);
         this.setLocation(170, 50);
        this.setVisible(true);
        addWindowListener(new WindowAdapter() {
            public void WindowClosing(WindowEvent e) {
                if(db!=null)
                db.closeConnection();
                dispose();
            }
        });

    }
    DataBaseManager db=null;
    ResultSet r;
    JPanel jPanel1 = new JPanel();
    XYLayout xYLayout1 = new XYLayout();
    Border border1 = BorderFactory.createEtchedBorder(Color.white,
            new Color(148, 145, 140));
    JLabel jLabel1 = new JLabel();
    XYLayout xYLayout2 = new XYLayout();
    JTextField findcarid_t = new JTextField();
    JButton jButton1 = new JButton(new ImageIcon("image\\114.gif"));
    JLabel jLabel2 = new JLabel();
    JTextField countid_t = new JTextField();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField lightid_t = new JTextField();
    JTextField drivername_t = new JTextField();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JTextField startid_t = new JTextField();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JTextField protecthour_t = new JTextField();
    JTextField carid_t = new JTextField();
    JLabel jLabel10 = new JLabel();
    JLabel jLabel11 = new JLabel();
    JLabel jLabel12 = new JLabel();
    JTextField breaklowcount_t = new JTextField();
    JLabel jLabel13 = new JLabel();
    JLabel jLabel14 = new JLabel();
    JLabel jLabel15 = new JLabel();
    JTextField factory_t = new JTextField();
    JComboBox jComboBox1 = new JComboBox();
    JLabel jLabel16 = new JLabel();
    JComboBox jComboBox2 = new JComboBox();
    JTextField underid_t = new JTextField();
    JLabel jLabel17 = new JLabel();
    JTextField businessid_t = new JTextField();
    JLabel jLabel18 = new JLabel();
    JLabel jLabel19 = new JLabel();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton(new ImageIcon("image\\back.gif"));
    JButton jButton4 = new JButton();
    JTextField driveid_t = new JTextField();
    JTextField yingdate = new JTextField();
    JTextField yeardate = new JTextField();
    JTextField toudate = new JTextField();
    JTextField nextyingdate = new JTextField();
    JTextField nextyeardate = new JTextField();
    public void jButton3_actionPerformed(ActionEvent e) {
        if (db != null)
            db.closeConnection();
        this.dispose();
    }

    public void jButton2_actionPerformed(ActionEvent e) {

        try {
            String strSQL = "update car set 车牌号='" +
                            carid_t.getText().trim() + "',制造商='" +
                            factory_t.getText().trim() + "',发动机号='" +
                            startid_t.getText().trim() + "',底盘编号='" +
                            underid_t.getText().trim() + "',燃油类型='" +
                            jComboBox1.getSelectedItem() + "',营运证号='" +
                            businessid_t.getText().trim() + "',计价器号='" +
                            countid_t.getText().trim() + "',顶灯号='" +
                            lightid_t.getText().trim() + "',驾驶员姓名='" +
                            drivername_t.getText().trim() + "',驾驶证号='" +
                            driveid_t.getText().trim() + "',营审日期='" +
                            yingdate.getText().trim() + "',次营审日期='" +
                            nextyingdate.getText().trim() + "',年审日期='" +
                            yeardate.getText().trim() + "',下次年审='" +
                            nextyeardate.getText().trim() + "',投保日期='" +
                            toudate.getText().trim() + "',投保时长='" +
                            protecthour_t.getText().trim() + "',车辆状态='" +
                            jComboBox2.getSelectedItem() + "',违章次数='" +
                            breaklowcount_t.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 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,
                                                  "删除成功！");
                else
                    JOptionPane.showMessageDialog(null,
                                                  "删除失败！");
            }

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

    public void jButton1_actionPerformed(ActionEvent e) {
         db = new DataBaseManager();
        try { //车牌号,制造商,发动机号,底盘编号,燃油类型,营运证号,计价器号,顶灯号,驾驶员姓名,驾驶证号,营审日期 ，次营审日期,年审日期,下次年审,投保日期,投保时长,车辆状态,违章次数
            String str1 = "select * from 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 car where 车牌号='" +
                             findcarid_t.getText().trim() + "'";
                r = db.getResult(str);
                r.first();
                carid_t.setText(findcarid_t.getText());
                factory_t.setText(r.getString("制造商"));
                startid_t.setText(r.getString("发动机号"));
                underid_t.setText(r.getString("底盘编号"));
                jComboBox1.setSelectedItem(r.getString("燃油类型"));
                businessid_t.setText(r.getString("营运证号"));
                countid_t.setText(r.getString("计价器号"));
                lightid_t.setText(r.getString("顶灯号"));
                drivername_t.setText(r.getString("驾驶员姓名"));
                driveid_t.setText(r.getString("驾驶证号"));
                yingdate.setText(r.getString("营审日期"));
                nextyingdate.setText(r.getString("次营审日期"));
                yeardate.setText(r.getString("年审日期"));
                nextyeardate.setText(r.getString("下次年审"));
                nextyeardate.setText(r.getString("投保日期"));
                protecthour_t.setText(r.getString("投保时长"));
                jComboBox2.setSelectedItem(r.getString("车辆状态"));
                breaklowcount_t.setText(r.getString("违章次数"));
            }
        }catch (Exception ex) {
            System.out.println(ex.toString());
        }
}

    public void findcarid_t_focusLost(FocusEvent focusEvent) {
        if (findcarid_t.getText().trim().equals(""))
                  JOptionPane.showMessageDialog(null,
                                          "关键字不能为空！");
    }


    class UpdateCar_jButton1_actionAdapter implements ActionListener {
    private UpdateCar adaptee;
    UpdateCar_jButton1_actionAdapter(UpdateCar adaptee) {
        this.adaptee = adaptee;
    }

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


class UpdateCar_jButton4_actionAdapter implements ActionListener {
    private UpdateCar adaptee;
    UpdateCar_jButton4_actionAdapter(UpdateCar adaptee) {
        this.adaptee = adaptee;
    }

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


class UpdateCar_jButton2_actionAdapter implements ActionListener {
    private UpdateCar adaptee;
    UpdateCar_jButton2_actionAdapter(UpdateCar adaptee) {
        this.adaptee = adaptee;
    }

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


class UpdateCar_jButton3_actionAdapter implements ActionListener {
    private UpdateCar adaptee;
    UpdateCar_jButton3_actionAdapter(UpdateCar adaptee) {
        this.adaptee = adaptee;
    }

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