import java.awt.BorderLayout;
import java.awt.EventQueue;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Connection;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.text.DefaultEditorKit.InsertBreakAction;

import com.mysql.jdbc.*;

//import com.mysql.jdbc.Statement;

import javax.swing.JLabel;
import javax.swing.JOptionPane;

import java.awt.Font;
import java.awt.Color;
import javax.swing.ImageIcon;
import java.awt.Toolkit;
import javax.swing.JTextField;
import javax.swing.JPasswordField;
import javax.swing.JComboBox;
import javax.swing.JFormattedTextField;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;

public class Registro extends JFrame {

	private JPanel contentPane;
	private JTextField tfUsuario;
	private JTextField tfNombre;
	private JTextField tfTelefono;
	private JPasswordField tfContraseña;
	private JTextField tfEmail;
	/**
	 * Launch the application.
	 */
	int campos = 0, EmailValido = 0;

	public static void main(String[] args) {
		Connection connection = null;
        Statement query = null;
        try{
           //STEP 2: Register JDBC driver
           Class.forName("com.mysql.jdbc.Driver");

           //STEP 3: Open a connection
           System.out.println("Connecting to a selected database...");
           connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/java_project","root", "usbw");
           System.out.println("Connected database successfully...");

           //STEP 4: Execute a query
           System.out.println("Creating statement...");
        }catch(SQLException se){
           //Handle errors for JDBC
           se.printStackTrace();
        }catch(Exception e){
           //Handle errors for Class.forName
           e.printStackTrace();
        }finally{
           //finally block used to close resources
           try{
              if(query!=null)
                  connection.close();
           }catch(SQLException se){
           }// do nothing
           try{
              if(connection!=null)
                  connection.close();
           }catch(SQLException se){
              se.printStackTrace();
           }//end finally try
        }//end try

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

	/**
	 * Create the frame.
	 */
	public class EmailValidator {

	    private Pattern pattern;
	    private Matcher matcher;

	    private static final String EMAIL_PATTERN =
	        "^[_A-Za-z0-9-\\+]+(\\.[_A-Za-z0-9-]+)*@"
	        + "[A-Za-z0-9-]+(\\.[A-Za-z0-9]+)*(\\.[A-Za-z]{2,})$";

	    public EmailValidator() {
	        pattern = Pattern.compile(EMAIL_PATTERN);
	    }

	    /**
	     * Validate hex with regular expression
	     *
	     * @param hex
	     *            hex for validation
	     * @return true valid hex, false invalid hex
	     */
	    public boolean validate(final String hex) {

	        matcher = pattern.matcher(hex);
	        return matcher.matches();

	    }
	}

	public Registro() {
		setForeground(Color.BLACK);
		setTitle("Registro");
		setIconImage(Toolkit.getDefaultToolkit().getImage("C:\\Users\\Gonzalo\\Desktop\\Programaci\u00F3n\\eclipse\\configuration\\org.eclipse.osgi\\379\\0\\.cp\\icons\\elcl16\\add_repository.png"));
		setResizable(false);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 545, 429);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(null);

		JLabel lblRegistro = new JLabel("Registro");
		lblRegistro.setIcon(new ImageIcon("C:\\Users\\Gonzalo\\Desktop\\Programaci\u00F3n\\eclipse\\configuration\\org.eclipse.osgi\\402\\0\\.cp\\themes\\slate\\graphics\\icons\\ctool\\wb_nav.png"));
		lblRegistro.setForeground(new Color(255, 165, 0));
		lblRegistro.setFont(new Font("Trebuchet MS", Font.ITALIC, 20));
		lblRegistro.setBounds(201, 11, 127, 67);
		contentPane.add(lblRegistro);

		tfUsuario = new JTextField();
		tfUsuario.setBounds(91, 93, 127, 20);
		contentPane.add(tfUsuario);
		tfUsuario.setColumns(10);

		tfNombre = new JTextField();
		tfNombre.setBounds(91, 124, 127, 20);
		contentPane.add(tfNombre);
		tfNombre.setColumns(10);

		tfTelefono = new JTextField();
		tfTelefono.setBounds(91, 186, 127, 20);
		contentPane.add(tfTelefono);
		tfTelefono.setColumns(10);

		tfContraseña = new JPasswordField();
		tfContraseña.setBounds(91, 155, 127, 20);
		contentPane.add(tfContraseña);

		JLabel lblNombre = new JLabel("Usuario");
		lblNombre.setBounds(10, 96, 71, 14);
		contentPane.add(lblNombre);

		JLabel lblNombre_1 = new JLabel("Nombre");
		lblNombre_1.setBounds(10, 127, 71, 14);
		contentPane.add(lblNombre_1);

		JLabel lblContrasea = new JLabel("Contrase\u00F1a");
		lblContrasea.setBounds(10, 158, 86, 14);
		contentPane.add(lblContrasea);

		JLabel lblNewLabel = new JLabel("Tel\u00E9fono");
		lblNewLabel.setBounds(10, 189, 86, 14);
		contentPane.add(lblNewLabel);

		JLabel lblPas = new JLabel("Pa\u00EDs");
		lblPas.setBounds(10, 220, 46, 14);
		contentPane.add(lblPas);

		tfEmail = new JTextField();
		tfEmail.setBounds(91, 248, 193, 20);
		contentPane.add(tfEmail);
		tfEmail.setColumns(10);

		JLabel lblNewLabel_1 = new JLabel("Email");
		lblNewLabel_1.setBounds(10, 251, 86, 14);
		contentPane.add(lblNewLabel_1);

		JComboBox comboboxPais = new JComboBox();
		comboboxPais.setModel(new DefaultComboBoxModel(new String[] {" ", "Argentina", "Bolivia", "Chile", "Colombia", "Costa Rica", "Ecuador", "El Salvador", "Espa\u00F1a", "Guatemala", "Guinea Ecuatorial", "Honduras", "M\u00E9xico", "Panam\u00E1", "Paraguay", "Per\u00FA", "Puerto Rico", "Rep\u00FAblica Dominicana", "Uruguay", "Venezuela"}));
		comboboxPais.setBounds(91, 217, 127, 20);
		contentPane.add(comboboxPais);

		JLabel lblUsuarioQueSe = new JLabel("Usuario que se usar\u00E1 para el login.");
		lblUsuarioQueSe.setBounds(238, 96, 260, 14);
		contentPane.add(lblUsuarioQueSe);


		String texto = "<html><body>Nombre y apellido.<br>(Separado por un espacio. Con iniciales may\u00FAscula).</body></html>";
		JLabel lblNombreYApellido = new JLabel(texto);
		lblNombreYApellido.setBounds(238, 113, 301, 62);
		contentPane.add(lblNombreYApellido);

		JLabel lblTelfonoDeContacto = new JLabel("Tel\u00E9fono de contacto.");
		lblTelfonoDeContacto.setBounds(238, 189, 200, 14);
		contentPane.add(lblTelfonoDeContacto);

		JLabel lblPasDeResidencia = new JLabel("Pa\u00EDs de residencia.");
		lblPasDeResidencia.setBounds(238, 220, 154, 14);
		contentPane.add(lblPasDeResidencia);

		JLabel lblCorreoElectrnicoPara = new JLabel("Correo electr\u00F3nico para el contacto.");
		lblCorreoElectrnicoPara.setBounds(294, 251, 235, 14);
		contentPane.add(lblCorreoElectrnicoPara);

		JButton btnregistrarme = new JButton("\u00A1Registrarme!");
		btnregistrarme.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {

				String usuario = tfUsuario.getText();
				System.out.println(usuario);

				String nombre = tfNombre.getText();
				System.out.println(nombre);

				char[] pass = tfContraseña.getPassword();
				System.out.println(pass);

				String telefono = tfTelefono.getText();
				System.out.println(telefono);

				String pais = (String)comboboxPais.getSelectedItem();
				String value = comboboxPais.getSelectedItem().toString();
				System.out.println(pais);

				String email = tfEmail.getText();
				System.out.println(email);

				EmailValidator emailValidator = new EmailValidator();
				   if(!emailValidator.validate(tfEmail.getText().trim())) {
				        System.out.print("Invalid Email ID");
				   }else{
					   EmailValido = 1;
				   }

				if(usuario.isEmpty() || nombre.isEmpty() || telefono.isEmpty() || email.isEmpty() || pais==" " || pass.length == 0 || EmailValido == 0){
					JOptionPane.showMessageDialog(null, "Completa todos los campos.");
					campos = 0;
				} else {
					JOptionPane.showMessageDialog(null, "Registrado con éxito.");
					EmailValido = 0;

					tfUsuario.setText("");
					tfNombre.setText("");
					tfContraseña.setText("");
					tfTelefono.setText("");
					comboboxPais.setSelectedIndex(0);
					tfEmail.setText("");


			       java.sql.Statement query1 = connection.createStatement();
			       ResultSet rs = query1.executeQuery(" insert into usuarios (ID, Usuario, Password, Nombre, Rango,Telefono,email,Pais)"
			        	    + " values (0, 1, 2, 3, 4, 5, 6, 7, 8)");

				}


			}
		});
		btnregistrarme.setIcon(new ImageIcon("C:\\Users\\Gonzalo\\Desktop\\Programaci\u00F3n\\eclipse\\configuration\\org.eclipse.osgi\\218\\0\\.cp\\icons\\full\\obj16\\correction_rename.png"));
		btnregistrarme.setBounds(201, 310, 147, 23);
		contentPane.add(btnregistrarme);
	}
}