JLabel jLabel1 = new JLabel();
    XYLayout xYLayout1 = new XYLayout();
    JTextField driveid_t = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField drivername_id = new JTextField();
    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();
        String str = "select * from driver where 駕駛證號='" +
                     driveid_t.getText().trim() + "'";
        try {
            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 (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();
            String str = "select * from driver where 駕駛證號='" +
                         driveid_t.getText().trim() + "'";
            try {
                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 (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);
    }
}