newdriver.java~1~

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

    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField positionid_t = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField address_t = new JTextField();
    JLabel jLabel7 = new JLabel();
    JTextField tel_t = new JTextField();
    Border border1 = BorderFactory.createEtchedBorder(Color.white,
            new Color(165, 163, 151));
    Border border2 = BorderFactory.createEtchedBorder(Color.white,
            new Color(165, 163, 151));
    Border border3 = BorderFactory.createEtchedBorder(Color.white,
            new Color(165, 163, 151));
    Border border4 = BorderFactory.createEtchedBorder(Color.white,
            new Color(165, 163, 151));
    Border border5 = BorderFactory.createEtchedBorder(Color.white,
            new Color(165, 163, 151));
    Border border6 = BorderFactory.createEtchedBorder(Color.white,
            new Color(165, 163, 151));
    Border border7 = BorderFactory.createEtchedBorder(Color.white,
            new Color(165, 163, 151));
    Border border8 = BorderFactory.createEtchedBorder(Color.white,
            new Color(165, 163, 151));
    Border border9 = BorderFactory.createEtchedBorder(Color.white,
            new Color(165, 163, 151));
    JLabel jLabel9 = new JLabel();
    JButton jButton1 = new JButton(new ImageIcon("image\\163.gif"));
    JButton jButton2 = new JButton(new ImageIcon("image\\48.gif"));
    JButton jButton3 = new JButton(new ImageIcon("image\\back.gif"));
    JLabel jLabel10 = new JLabel();
    JComboBox jComboBox1 = new JComboBox();
    JComboBox jComboBox2 = new JComboBox();
    JTextField firsttakedate_t = new JTextField();
    JComboBox jComboBox3 = new JComboBox();
    JLabel jLabel8 = new JLabel();
    JComboBox jComboBox4 = new JComboBox();
    JLabel jLabel11 = new JLabel();
    public void jButton2_actionPerformed(ActionEvent e) {
        driveid_t.setText("");
        drivername_id.setText("");
        address_t.setText("");
        firsttakedate_t.setText("");
        positionid_t.setText("");
        tel_t.setText("");

    }

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

    public void jButton1_actionPerformed(ActionEvent e) {
        db=new DataBaseManager();
    //    System.out.print("fdsafdsa") ;
        String str = "select * from driver where 驾驶证号='"+driveid_t.getText() .trim()+"'" ;
                try {
//                    r = db.getResult(str);
//                    r.first();
      //              System.out.print(r.getString("驾驶证号")) ;
                    if (db.getResult(str).first()) {
                        JOptionPane.showMessageDialog(null, "该驾驶员已存在！");
                        driveid_t.setText("");
                        drivername_id.setText("");
                        address_t.setText("") ;
                        firsttakedate_t.setText("") ;
                        positionid_t.setText("");
                        tel_t.setText("");
                    } else {
                        str = "insert into driver(驾驶证号,驾驶员姓名,性别,民族,文化程度,驾证初领日,身份证号,住址,联系电话,准驾类型) values('" +
                              driveid_t.getText().trim() + "','" +
                              drivername_id.getText().trim() + "','" +
                              jComboBox1.getSelectedItem() + "','" +
                              jComboBox3.getSelectedItem() + "','" +
                              jComboBox4.getSelectedItem() + "','" +
                              firsttakedate_t.getText().trim() + "','" +
                              positionid_t.getText().trim() + "','" +
                              address_t.getText().trim() + "','" +
                              tel_t.getText().trim() + "','" +
                              jComboBox2.getSelectedItem() + "')";

                        if (db.updateSql(str)) {
                            JOptionPane.showMessageDialog(null, "添加驾驶员成功！");
                            driveid_t.setText("");
                            drivername_id.setText("");
                            address_t.setText("");
                            firsttakedate_t.setText("");
                            positionid_t.setText("");
                            tel_t.setText("");
                        } else {
                            JOptionPane.showMessageDialog(null, "添加驾驶员失败！");
                        }
                    }
                } catch (HeadlessException ex) {
            //    }catch(NullPointerException ex){
                } catch (SQLException ex) {
        }
    }

    public void driveid_t_focusLost(FocusEvent e) {

        if (driveid_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "驾驶证号不能为空！");
    }

    public void drivername_id_focusLost(FocusEvent e) {

        if (drivername_id.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "驾驶员姓名不能为空！");
    }

    public void firsttakedate_t_focusLost(FocusEvent e) {

        if (firsttakedate_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "驾驶证初领日不能为空！");
        else {
            String s = firsttakedate_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] == '.')
                    ;
                else {
                    JOptionPane.showMessageDialog(null,
                                                  "您输入的日期非法或您输入的日期格式不正确，请以“.”为分隔符！");
                    firsttakedate_t.setText("");
                    firsttakedate_t.setFocusable(true);
                    break;
                }
        }


    }

    public void positionid_t_focusLost(FocusEvent e) {

        if (positionid_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "身份证号不能为空！");
    }

    public void tel_t_focusLost(FocusEvent e) {

        if (tel_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "联系电话不能为空！");
    }

    public void address_t_focusLost(FocusEvent e) {

        if (address_t.getText().trim().equals(""))
            JOptionPane.showMessageDialog(null, "家庭住址不能为空！");
    }

    public void jComboBox2_keyPressed(KeyEvent e) {
        if (e.getKeyCode() == KeyEvent.VK_ENTER) {
            db=new DataBaseManager();
    //    System.out.print("fdsafdsa") ;
        String str = "select * from driver where 驾驶证号='"+driveid_t.getText() .trim()+"'" ;
                try {
//                    r = db.getResult(str);
//                    r.first();
      //              System.out.print(r.getString("驾驶证号")) ;
                    if (db.getResult(str).first()) {
                        JOptionPane.showMessageDialog(null, "该驾驶员已存在！");
                        driveid_t.setText("");
                        drivername_id.setText("");
                        address_t.setText("") ;
                        firsttakedate_t.setText("") ;
                        positionid_t.setText("");
                        tel_t.setText("");
                    } else {
                        str = "insert into driver(驾驶证号,驾驶员姓名,性别,民族,文化程度,驾证初领日,身份证号,住址,联系电话,准驾类型) values('" +
                              driveid_t.getText().trim() + "','" +
                              drivername_id.getText().trim() + "','" +
                              jComboBox1.getSelectedItem() + "','" +
                              jComboBox3.getSelectedItem() + "','" +
                              jComboBox4.getSelectedItem() + "','" +
                              firsttakedate_t.getText().trim() + "','" +
                              positionid_t.getText().trim() + "','" +
                              address_t.getText().trim() + "','" +
                              tel_t.getText().trim() + "','" +
                              jComboBox2.getSelectedItem() + "')";

                        if (db.updateSql(str)) {
                            JOptionPane.showMessageDialog(null, "添加驾驶员成功！");
                            driveid_t.setText("");
                            drivername_id.setText("");
                            address_t.setText("");
                            firsttakedate_t.setText("");
                            positionid_t.setText("");
                            tel_t.setText("");
                        } else {
                            JOptionPane.showMessageDialog(null, "添加驾驶员失败！");
                        }
                    }
                } catch (HeadlessException ex) {
            //    }catch(NullPointerException ex){
                } catch (SQLException ex) {
        }

        }
    }
}


class Newdriver_jButton3_actionAdapter implements ActionListener {
    private Newdriver adaptee;
    Newdriver_jButton3_actionAdapter(Newdriver adaptee) {
        this.adaptee = adaptee;
    }

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


class Newdriver_jButton2_actionAdapter implements ActionListener {
    private Newdriver adaptee;
    Newdriver_jButton2_actionAdapter(Newdriver adaptee) {
        this.adaptee = adaptee;
    }

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