SignupFrame

import java.awt.BorderLayout;
import java.awt.EventQueue;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.SwingConstants;
import java.awt.Font;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javax.swing.JTextField;
import javax.swing.JRadioButton;
import javax.swing.JComboBox;
import javax.swing.DefaultComboBoxModel;
import javax.swing.ButtonGroup;
import javax.swing.JButton;
import javax.swing.JCheckBox;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;

public class SignupFrame extends JFrame {

    private JPanel contentPane;
    private JTextField nameTF;
    private JTextField emailTF;
    private JTextField usernameTF;
    private JTextField passField;
    private JTextField ageTF;
    private JTextField contactTF;
    private JTextField heightTF;
    private JRadioButton rdbtnMale,rdbtnFemale;
    private JComboBox addressCB;
    private JCheckBox chckbxIAcceptAll;
    private final ButtonGroup buttonGroup = new ButtonGroup();
    String v="";
    Connection conn=null;
    PreparedStatement pst =null;
    ResultSet rs=null;

    /**
     * Launch the application.
     */
    public static void main(String[] args) {
        EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    SignupFrame frame = new SignupFrame();
                    frame.setVisible(true);
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        });
    }

    /**
     * Create the frame.
     */
    public SignupFrame() {
        design();
        conn =SQLConnection.ConnecrDb();
    }
    private void register () {
        try {
            String query ="INSERT INTO Employee (E_Name,E_Mail,E_Username,E_Password,E_Age,E_Contact,E_Gender,E_Height,E_Adress) VALUE(?,?,?,?,?,?,?,?,?)";

            pst =conn.prepareStatement(query);
            pst.setString(1, nameTF.getText());
            pst.setString(2, emailTF.getText());

            pst.setString(3, usernameTF.getText());
            pst.setString(4, passField.getText());
            pst.setString(5, ageTF.getText());
            pst.setString(6, contactTF.getText());
            if(rdbtnMale.isSelected()) {
                 v =rdbtnMale.getText().toString();
            }else if(rdbtnFemale.isSelected()) {
                 v=rdbtnFemale.getText().toString();
            }else {
                JOptionPane.showMessageDialog(null, "Select Gender");
            }

            pst.setString(7, String.valueOf(v) );
            pst.setString(8, heightTF.getText());
            pst.setString(9, addressCB.getSelectedItem().toString());
            pst.execute();
            pst.close();
            JOptionPane.showMessageDialog(null, "Signup Successful");
            FirstJFrame fj = new FirstJFrame();
            fj.setVisible(true);
            dispose();
        }
        catch(Exception e){
            e.printStackTrace();
        }

    }
        private void design()
        {
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setBounds(100, 100, 577, 529);
        contentPane = new JPanel();
        contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
        setContentPane(contentPane);
        contentPane.setLayout(null);

        JLabel lblSignupHere = new JLabel("Signup Here");
        lblSignupHere.setFont(new Font("Tahoma", Font.BOLD, 15));
        lblSignupHere.setHorizontalAlignment(SwingConstants.CENTER);
        lblSignupHere.setBounds(10, 11, 551, 36);
        contentPane.add(lblSignupHere);

        nameTF = new JTextField();
        nameTF.setFont(new Font("Tahoma", Font.PLAIN, 13));
        nameTF.setHorizontalAlignment(SwingConstants.CENTER);
        nameTF.setBounds(127, 58, 369, 28);
        contentPane.add(nameTF);
        nameTF.setColumns(10);

        emailTF = new JTextField();
        emailTF.setFont(new Font("Tahoma", Font.PLAIN, 13));
        emailTF.setHorizontalAlignment(SwingConstants.CENTER);
        emailTF.setBounds(127, 97, 369, 28);
        contentPane.add(emailTF);
        emailTF.setColumns(10);

        usernameTF = new JTextField();
        usernameTF.setFont(new Font("Tahoma", Font.PLAIN, 13));
        usernameTF.setHorizontalAlignment(SwingConstants.CENTER);
        usernameTF.setBounds(127, 136, 369, 28);
        contentPane.add(usernameTF);
        usernameTF.setColumns(10);

        passField = new JTextField();
        passField.setFont(new Font("Tahoma", Font.PLAIN, 13));
        passField.setHorizontalAlignment(SwingConstants.CENTER);
        passField.setBounds(127, 175, 369, 28);
        contentPane.add(passField);
        passField.setColumns(10);

        ageTF = new JTextField();
        ageTF.setFont(new Font("Tahoma", Font.PLAIN, 13));
        ageTF.setHorizontalAlignment(SwingConstants.CENTER);
        ageTF.setBounds(127, 215, 204, 23);
        contentPane.add(ageTF);
        ageTF.setColumns(10);

        contactTF = new JTextField();
        contactTF.setFont(new Font("Tahoma", Font.PLAIN, 13));
        contactTF.setHorizontalAlignment(SwingConstants.CENTER);
        contactTF.setBounds(127, 249, 376, 28);
        contentPane.add(contactTF);
        contactTF.setColumns(10);

         rdbtnMale = new JRadioButton("Male");
        buttonGroup.add(rdbtnMale);
        rdbtnMale.setBounds(127, 295, 109, 23);
        contentPane.add(rdbtnMale);

         rdbtnFemale = new JRadioButton("Female");
        buttonGroup.add(rdbtnFemale);
        rdbtnFemale.setBounds(238, 295, 109, 23);
        contentPane.add(rdbtnFemale);

        heightTF = new JTextField();
        heightTF.setFont(new Font("Tahoma", Font.PLAIN, 13));
        heightTF.setHorizontalAlignment(SwingConstants.CENTER);
        heightTF.setBounds(127, 329, 376, 28);
        contentPane.add(heightTF);
        heightTF.setColumns(10);

         addressCB = new JComboBox();
        addressCB.setModel(new DefaultComboBoxModel(new String[] {"Dhaka", "Rajshahi", "Sylhet", "Barishal"}));
        addressCB.setBounds(126, 368, 221, 28);
        contentPane.add(addressCB);

        JLabel lblName = new JLabel("Name");
        lblName.setFont(new Font("Tahoma", Font.BOLD, 16));
        lblName.setBounds(20, 61, 95, 23);
        contentPane.add(lblName);

        JLabel lblEmail = new JLabel("Email");
        lblEmail.setFont(new Font("Tahoma", Font.BOLD, 16));
        lblEmail.setBounds(22, 97, 95, 23);
        contentPane.add(lblEmail);

        JLabel lblUsername = new JLabel("Username");
        lblUsername.setFont(new Font("Tahoma", Font.BOLD, 16));
        lblUsername.setBounds(22, 136, 95, 23);
        contentPane.add(lblUsername);

        JLabel lblPassword = new JLabel("Password");
        lblPassword.setFont(new Font("Tahoma", Font.BOLD, 16));
        lblPassword.setBounds(22, 175, 95, 23);
        contentPane.add(lblPassword);

        JLabel lblAge = new JLabel("Age");
        lblAge.setFont(new Font("Tahoma", Font.BOLD, 16));
        lblAge.setBounds(22, 219, 95, 23);
        contentPane.add(lblAge);

        JLabel lblContact = new JLabel("Contact");
        lblContact.setFont(new Font("Tahoma", Font.BOLD, 16));
        lblContact.setBounds(22, 254, 95, 23);
        contentPane.add(lblContact);

        JLabel lblHeight = new JLabel("Height");
        lblHeight.setFont(new Font("Tahoma", Font.BOLD, 16));
        lblHeight.setBounds(22, 329, 95, 23);
        contentPane.add(lblHeight);

        JLabel lblGender = new JLabel("Gender");
        lblGender.setFont(new Font("Tahoma", Font.BOLD, 16));
        lblGender.setBounds(20, 293, 95, 23);
        contentPane.add(lblGender);

        JLabel lblAddress = new JLabel("Address");
        lblAddress.setFont(new Font("Tahoma", Font.BOLD, 16));
        lblAddress.setBounds(21, 368, 95, 23);
        contentPane.add(lblAddress);

        JButton btnRegister = new JButton("Register");
        btnRegister.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                if(chckbxIAcceptAll.isSelected()) {
                    register ();
                }else {
                    JOptionPane.showMessageDialog(null, "Read Terms and Conditions");
                }

            }
        });
        btnRegister.setBounds(158, 439, 150, 28);
        contentPane.add(btnRegister);

        chckbxIAcceptAll = new JCheckBox("I accept all the terms and conditions");
        chckbxIAcceptAll.setBounds(127, 403, 390, 23);
        contentPane.add(chckbxIAcceptAll);
    }
}