import java.awt.EventQueue; // import packages
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;


public class Register extends JFrame {   // create component in frame
    JFrame frame;
    JLabel CustomerNameLabel = new JLabel();
    JTextField name = new JTextField();
    JLabel CustomerAddressLabel = new JLabel();
    JTextField address = new JTextField();
    JLabel PhoneNumberLabel = new JLabel();
    JTextField number = new JTextField();
    JLabel Password1Label = new JLabel();
    JTextField passwrd1 = new JTextField();
    JLabel Password2Label = new JLabel();
    JTextField passwrd2 = new JTextField();
    JLabel UserNameLabel = new JLabel();
    JTextField user = new JTextField();
    JButton submit = new JButton();
    JButton clear = new JButton();
    JButton exit = new JButton();


    public static void main(String args[]) {    // initiate frame

        EventQueue.invokeLater(new Runnable() {
            public void run() {          // run
                try {
                    Register frame = new Register();
                    frame.setVisible(true);
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        });
    }


    private void jbInit() throws Exception {    // run Jbinit and throw exception , setting components in frame


        getContentPane().setLayout(null);
        setTitle("Register For Ordering ");

        getContentPane().add(CustomerNameLabel);
        CustomerNameLabel.setText("Name :");
        CustomerNameLabel.setBounds(10, 10, 89, 16);

        getContentPane().add(CustomerAddressLabel);
        CustomerAddressLabel.setText("Address :");
        CustomerAddressLabel.setBounds(10, 42, 89, 16);

        getContentPane().add(PhoneNumberLabel);
        PhoneNumberLabel.setText("Phone Number :");
        PhoneNumberLabel.setBounds(10, 74, 323, 20);

        getContentPane().add(UserNameLabel);
        UserNameLabel.setText("Username :");
        UserNameLabel.setBounds(10, 106, 89, 16);

        getContentPane().add(Password1Label);
        Password1Label.setText("Password :");
        Password1Label.setBounds(10, 138 , 89, 16);

        getContentPane().add(Password2Label);
        Password2Label.setText("Confirm password :");
        Password2Label.setBounds(10, 170, 150, 20);

        getContentPane().add(name);
        name.setBounds(130, 10, 250 , 20);

        getContentPane().add(address);
        address.setBounds(130, 42 , 250 , 20);

        getContentPane().add(number);
        number.setBounds(130, 74 , 150 , 20);

        getContentPane().add(user);
        user.setBounds(130, 106 , 150 , 20);

        getContentPane().add(passwrd1);
        passwrd1.setBounds(130, 138 , 150 , 20);

        getContentPane().add(passwrd2);
        passwrd2.setBounds(130, 170 , 150 , 20);

        getContentPane().add(clear);
        clear.addActionListener(new ClearActionListener());

        clear.setText("CLEAR");
        clear.setBounds(160, 347, 99, 26);

        getContentPane().add(submit);
        submit.addActionListener(new SubmitActionListener());

        submit.setText("SUBMIT");
        submit.setBounds(50, 347, 99, 26);

        getContentPane().add(exit);
        exit.addActionListener(new ExitActionListener());

        exit.setText("EXIT");
        exit.setBounds(270, 347, 99, 26);

    }
        public Register() {   // setting for frame
            super();

        setBounds(100, 100, 430, 430);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        try {                        // try and catch block
            jbInit();
        } catch (Throwable e) {
            e.printStackTrace();
        }

    }

    private class ClearActionListener implements ActionListener {   // action for button clear
        public void actionPerformed(ActionEvent e) {
            clear_actionPerformed(e);
        }
    }
    private class ExitActionListener implements ActionListener {  // action for button exit
        public void actionPerformed(ActionEvent e) {
            exit_actionPerformed(e);
        }
    }

    private class SubmitActionListener implements ActionListener {
        public void actionPerformed(ActionEvent e)
        {
            String value1=user.getText();
            String value2=passwrd1.getText();
            try{

             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
              Connection con = DriverManager.getConnection("jdbc:odbc:NWIND","","");
                 Statement st=con.createStatement();
                 String query="insert into User values("+"Username,Password"+") values ('"+user+"','"+passwrd1+"')";
                 int result=st.executeUpdate(query);
                 st.close();
            }
             catch(Exception ea){}
        }

    }

    protected void clear_actionPerformed(ActionEvent e) {    // clear button
         name.setText("");
         address.setText("");
         number.setText("");
         user.setText("");
         passwrd1.setText("");
         passwrd2.setText("");

        repaint();
    }
    protected void exit_actionPerformed(ActionEvent e) {   // exit button
        System.exit(0);
    }
}