import java.awt.BorderLayout;
import java.sql.*;
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.JTextField;
import javax.swing.JPasswordField;
import javax.swing.JButton;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.sql.*;
public class Login extends JFrame {

	private JPanel contentPane;
	private JTextField Username;
	private JPasswordField Password;

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

	/**
	 * Create the frame.
	 */
	public Login() {
		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(null);

		JLabel lblUsername = new JLabel("Username");
		lblUsername.setBounds(41, 30, 80, 40);
		contentPane.add(lblUsername);

		JLabel lblPassword = new JLabel("Password");
		lblPassword.setBounds(41, 93, 80, 40);
		contentPane.add(lblPassword);

		Username = new JTextField();
		Username.setBounds(169, 30, 189, 40);
		contentPane.add(Username);
		Username.setColumns(10);

		Password = new JPasswordField();
		Password.setBounds(169, 103, 183, 40);
		contentPane.add(Password);

		JButton btnLogin = new JButton("Login");
		btnLogin.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				try {
					Class.forName("com.mysql.cj.jdbc.Driver");
					Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/quizgame", "root" ,"");
					Statement stmt = con.createStatement();
					@SuppressWarnings("deprecation")
					String sql = "Select * from quizgame where UserName ='"+Username.getText()+"' and Password='"+Password.getText().toString()+"'";
					ResultSet rs = stmt.executeQuery(sql);

					if (rs.next ()) {

					     DifandDom second= new DifandDom(); //Treci la urmatorul JAR
					     second.setVisible(true);
						//JOptionPane.showMessageDialog(null,"Merge frt");
					}

					else
						JOptionPane.showMessageDialog(null , "Username sau parola gresite");
					con.close();

				}catch(Exception e ) {System.out.print(e);}
			}
		});
		btnLogin.setBounds(88, 165, 89, 23);
		contentPane.add(btnLogin);

		JButton btnCreateNewAccount = new JButton("Create new account");
		btnCreateNewAccount.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				Create second= new Create();
				second.setVisible(true);
			}
		});
		btnCreateNewAccount.setBounds(88, 214, 153, 23);
		contentPane.add(btnCreateNewAccount);
	}
}