form1

package javaapplication10;
import java.awt.PageAttributes;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Arrays;
import javax.swing.JOptionPane;

public class aad extends javax.swing.JFrame {

    javax.swing.JLabel JLabelName;
    javax.swing.JLabel JLabelLastname;
    javax.swing.JLabel JLabelUsername;
    javax.swing.JLabel JLabelPassword;
    javax.swing.JLabel JLabelID;
    javax.swing.JLabel JLabelBirtday;

    javax.swing.JTextField Name;
    javax.swing.JTextField LastName;
    javax.swing.JTextField Username;
    javax.swing.JPasswordField Password;
    javax.swing.JTextField ID;

    javax.swing.JComboBox<Integer> jComboBoxdata;
    javax.swing.JComboBox<String> jComboBoxmount;
    javax.swing.JComboBox<Integer> jComboBoxyear;

    javax.swing.JRadioButton GenderM;
    javax.swing.JRadioButton GenderF;

    javax.swing.JButton ButtonOK;
    javax.swing.JButton ButtonCancle;

    public aad() {
        initComponents();
    }

    private void initComponents() {
        setSize(350, 400);
        setTitle("Customer");
        getContentPane().setLayout(null);

        //++++++++++++Label++++++++++++++++++++++
        JLabelName = new javax.swing.JLabel("Name");
        JLabelName.setBounds(10, 10, 60, 60);
        getContentPane().add(JLabelName);

        JLabelLastname = new javax.swing.JLabel("LastName");
        JLabelLastname.setBounds(10, 40, 60, 60);
        getContentPane().add(JLabelLastname);

        JLabelUsername = new javax.swing.JLabel("Username");
        JLabelUsername.setBounds(10, 70, 60, 60);
        getContentPane().add(JLabelUsername);

        JLabelPassword = new javax.swing.JLabel("Password");
        JLabelPassword.setBounds(10, 100, 60, 60);
        getContentPane().add(JLabelPassword);

        JLabelID = new javax.swing.JLabel("ID");
        JLabelID.setBounds(10, 130, 60, 60);
        getContentPane().add(JLabelID);

        JLabelBirtday = new javax.swing.JLabel("Birtday");
        JLabelBirtday.setBounds(10, 160, 60, 60);
        getContentPane().add(JLabelBirtday);

        JLabelBirtday = new javax.swing.JLabel("Gender");
        JLabelBirtday.setBounds(10, 190, 60, 60);
        getContentPane().add(JLabelBirtday);

        //++++++++++++++TextField++++++++++++++++++
        Name = new javax.swing.JTextField();
        Name.setBounds(80, 30, 150, 20);
        getContentPane().add(Name);

        LastName = new javax.swing.JTextField();
        LastName.setBounds(80, 60, 150, 20);
        getContentPane().add(LastName);

        Username = new javax.swing.JTextField();
        Username.setBounds(80, 90, 150, 20);
        getContentPane().add(Username);

        Password = new javax.swing.JPasswordField();
        Password.setBounds(80, 120, 150, 20);
        getContentPane().add(Password);

        ID = new javax.swing.JTextField();
        ID.setBounds(80, 150, 150, 20);
        getContentPane().add(ID);

        //+++++++++++++++++++Birtday++++++++++++++++++
        String datas[] = new String[32];
        for (int i = 1; i <= 31; i++) {
            if (i < 10) {
                datas[i] = "0" + i;
            } else {
                datas[i] = "" + i;
            }
        }

        jComboBoxdata = new javax.swing.JComboBox(datas);
        jComboBoxdata.setBounds(80, 180, 40, 20);
        getContentPane().add(jComboBoxdata);


        String mountsStr[] = new String[13];
        for (int i = 1; i <= 12; i++) {
            if (i < 10) {
                mountsStr[i] = "0" + i;
            } else {
                mountsStr[i] = "" + i;
            }
        }
        jComboBoxmount = new javax.swing.JComboBox(mountsStr);
        jComboBoxmount.setBounds(130, 180, 80, 20);
        getContentPane().add(jComboBoxmount);

        Integer yeas[] = new Integer[63];
        for (int i = 1; i <= 62; i++) {
            yeas[i] = 1950 + i;
        }

        jComboBoxyear = new javax.swing.JComboBox(yeas);
        jComboBoxyear.setBounds(230, 180, 80, 20);
        getContentPane().add(jComboBoxyear);

        GenderM = new javax.swing.JRadioButton("Male");
        GenderM.setBounds(80, 210, 80, 20);
        getContentPane().add(GenderM);

        GenderF = new javax.swing.JRadioButton("FeMale");
        GenderF.setBounds(160, 210, 80, 20);
        getContentPane().add(GenderF);

        ButtonOK = new javax.swing.JButton("Submit");
        ButtonOK.setBounds(80, 250, 80, 20);
        ButtonOK.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                Connection connect = null;
                Statement s = null;
                try {
                    Class.forName("com.mysql.jdbc.Driver");
                    connect = DriverManager.getConnection("jdbc:mysql://localhost/databaseproject", "root", "");
                    s = connect.createStatement();

                    //jComboBox birdthday
                    String jComboBoxs = jComboBoxyear.getSelectedItem().toString() + "-"
                            + jComboBoxmount.getSelectedItem().toString() + "-"
                            + jComboBoxdata.getSelectedItem().toString();

                    //JRadioButton male
                    int cheakboolGender = 0;
                    if (GenderM.isSelected()) {
                        cheakboolGender = 1;
                    } else if (GenderM.isSelected()) {
                        cheakboolGender = 0;
                    }

                    //conver char to String Password
                    char[] charp = Password.getPassword();
                    String p = String.valueOf(charp);

                    String n = String.valueOf(Name.getText());
                    // SQL Insert
                    String sql = "INSERT INTO customer "
                        + "(Name,Lastname,Username,password,ID,Birdthday,Gender) "
                        + "VALUES ('"
                            + Name.getText()
                            + "','"+ LastName.getText()
                            + "','" + Username.getText()
                            + "','" + p
                            + "','"+ ID.getText()
                            + "','"+ jComboBoxs
                            + "','"+ cheakboolGender
                            + "') ";


                    s.execute(sql);
                    // Reset Text Fields
                    Name.setText("");
                    LastName.setText("");
                    Username.setText("");
                    Password.setText("");
                    ID.setText("");
                    jComboBoxdata.setSelectedIndex(0);
                                        jComboBoxmount.setSelectedIndex(0);
                                        jComboBoxyear.setSelectedIndex(0);
                                        GenderF.setSelected(false);
                                        GenderM.setSelected(false);


                    JOptionPane.showMessageDialog(null,"Record Inserted Successfully","Success",JOptionPane.INFORMATION_MESSAGE);


                } catch (Exception ee) {
                    JOptionPane.showMessageDialog(null,"Incomplete Data","ERROR",JOptionPane.WARNING_MESSAGE);

                }
                finally
                {
                    try{
                     s.close();
                     connect.close();
                    }catch(SQLException ee)
                    {

                    }
                }
            }
        });

        getContentPane().add(ButtonOK);

        ButtonCancle = new javax.swing.JButton("Cancle");
        ButtonCancle.setBounds(170, 250, 80, 20);
        ButtonCancle.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                setVisible(false);
                    dispose();
            }

        });

        getContentPane().add(ButtonCancle);

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
    }


    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new aad().setVisible(true);


            }
        });
    }

}