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

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.BoxLayout;
import javax.swing.JLabel;
import javax.swing.JTextField;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.awt.Component;
import javax.swing.Box;
import javax.swing.JButton;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;

public class Login2 extends JFrame {

	private JPanel contentPane;
	private JTextField textFieldUser;
	private JTextField textFieldPass;
	Connection miConexionMySql=null;

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

			Class.forName("com.mysql.jdbc.Driver").newInstance();

			System.out.println("Registro exitoso");

			} catch (Exception e) {

			System.err.println("Error registrando el driver");

			}


		try {
		String cadenaConexion="jdbc:mysql://127.0.0.1/educa?user=root&password=";
		miConexionMySql = DriverManager.getConnection(cadenaConexion);

		// Otros y operaciones sobre la base de datos...

		} catch (SQLException ex) {

			System.err.println("Error en login o no se encuentra BDD");

		}
		ResultSet resultatConsulta=null;

		try {
			Statement stmt=miConexionMySql.createStatement();
			resultatConsulta = stmt.executeQuery("SELECT * FROM USUARIOS");

		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			return resultatConsulta;
		}
	}

	/**
	 * Create the frame.
	 */
	public Login2() {
		ResultSet rs=conectaYConsulta();

		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 450, 300);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(new BoxLayout(contentPane, BoxLayout.Y_AXIS));

		JPanel panel = new JPanel();
		contentPane.add(panel);

		JLabel lblMensaje = new JLabel("Formulario para iniciar sesi\u00F3n o registrarse");
		panel.add(lblMensaje);

		JPanel panel_1 = new JPanel();
		contentPane.add(panel_1);
		panel_1.setLayout(new BoxLayout(panel_1, BoxLayout.Y_AXIS));

		JPanel panel_3 = new JPanel();
		panel_3.setAlignmentY(Component.TOP_ALIGNMENT);
		panel_1.add(panel_3);
		panel_3.setLayout(new BoxLayout(panel_3, BoxLayout.Y_AXIS));

		JPanel panel_5 = new JPanel();
		panel_3.add(panel_5);

		Component verticalStrut_1 = Box.createVerticalStrut(20);
		panel_5.add(verticalStrut_1);

		JPanel panel_6 = new JPanel();
		panel_3.add(panel_6);

		JLabel lblUser = new JLabel("Usuario:");
		panel_6.add(lblUser);

		textFieldUser = new JTextField();
		panel_6.add(textFieldUser);
		textFieldUser.setColumns(10);

		Component verticalStrut = Box.createVerticalStrut(20);
		panel_6.add(verticalStrut);

		JPanel panel_4 = new JPanel();
		panel_1.add(panel_4);

		JLabel lblPass = new JLabel("Contrase\u00F1a:");
		panel_4.add(lblPass);

		textFieldPass = new JTextField();
		panel_4.add(textFieldPass);
		textFieldPass.setColumns(10);

		Component horizontalStrut = Box.createHorizontalStrut(20);
		panel_4.add(horizontalStrut);

		JPanel panel_2 = new JPanel();
		FlowLayout flowLayout = (FlowLayout) panel_2.getLayout();
		flowLayout.setAlignment(FlowLayout.RIGHT);
		contentPane.add(panel_2);

		JButton btnVolver = new JButton("Volver");
		panel_2.add(btnVolver);

		JButton btnRegistrarse = new JButton("Registrarse");
		panel_2.add(btnRegistrarse);

		JButton btnLogin = new JButton("Login");
		btnLogin.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				String usuariotxt=textFieldUser.getText();
				String passtxt=textFieldPass.getText();
				try {
					while(rs.next()){
						if (rs.getString("Usuario").equals(usuariotxt) && rs.getString("Contraseña").equals(passtxt)) {
							System.out.println("Login correcto");
						}

					}
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		});
		panel_2.add(btnLogin);
	}

}