import java.awt.EventQueue;

import javax.swing.JFrame;
import javax.swing.JButton;

import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;

import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.ImageIcon;

import java.sql.*;
import javax.swing.JPasswordField;

public class Login {

	// Definisi JDBC driver name i URL baze
	static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
	static final String DB_URL = "jdbc:mysql://127.0.0.1:3306/SurveyDB?verifyServerCertificate=false&useSSL=false";

	// Db podaci
	static final String USER = "root";
	static final String PASS = "123456";

	private JFrame frmPoolSystem;
	private JTextField usernameField;
	private JTextField passwordBox;

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

	/**
	 * Create the application.
	 */
	public Login() {
		initialize();
	}

	/**
	 * Initialize the contents of the frame.
	 */
	private void initialize() {
		frmPoolSystem = new JFrame();
		frmPoolSystem.setTitle("Pool System - Login");
		frmPoolSystem.setResizable(false);
		frmPoolSystem.setBounds(100, 100, 335, 276);
		frmPoolSystem.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		frmPoolSystem.getContentPane().setLayout(null);

		JLabel unameText = new JLabel("Username");
		unameText.setBounds(10, 132, 77, 14);
		frmPoolSystem.getContentPane().add(unameText);

		JLabel pwText = new JLabel("Password");
		pwText.setBounds(10, 157, 77, 14);
		frmPoolSystem.getContentPane().add(pwText);

		usernameField = new JTextField();
		usernameField.setBounds(96, 129, 223, 20);
		frmPoolSystem.getContentPane().add(usernameField);
		usernameField.setColumns(10);

		JButton loginButton = new JButton("Login");

		loginButton.addMouseListener(new MouseAdapter() {
			public void mouseClicked(MouseEvent e) {
				Connection conn = null;
				Statement stmt = null;
				try {
					// Registruj JDBC driver
					Class.forName("com.mysql.jdbc.Driver");

					// Zapocni konekciju conn
					conn = DriverManager.getConnection(DB_URL, USER, PASS);

					// Napravi statement i izvrsi query
					stmt = conn.createStatement();
					String sql;
					sql = ("SELECT id, username, password FROM Users WHERE username='"+usernameField.getText()+"' AND password='"+passwordBox.getText()+"'");
					ResultSet rs = stmt.executeQuery(sql);

					// Provjeri da li su uname i pw tacni tj. da li query daje rezultat
					if (rs.next() == false) {
						JOptionPane.showMessageDialog(null, "Pogresni Podaci");
					}

					// Povuci podatke
					// ZA PRIMJER KORISTIMO ID KAO USER_ROLE (1-admin, 2-user)
					int id = rs.getInt("id");
					String username = rs.getString("username");
					String password = rs.getString("password");

					//Provjera
					if (id == 1) {
						// OTVORI ADMINA
						LogovanAdmin lAdmin = new LogovanAdmin();
						lAdmin.Admin();
						frmPoolSystem.dispose();
					}else{
						JOptionPane.showMessageDialog(null, "MoSa Admin");
					}

					// Zatvori resultset, statement i db konekciju i ispisi greske ako postoje
					rs.close();
					stmt.close();
					conn.close();
				} catch (SQLException se) {
					// Errors JDBC
					se.printStackTrace();
				} catch (Exception x) {
					// Errors za Class.forName
					x.printStackTrace();
				} finally {
					try {
						if (stmt != null)
							stmt.close();
					} catch (SQLException se2) {
					}
					try {
						if (conn != null)
							conn.close();
					} catch (SQLException se) {
						se.printStackTrace();
					}// zavrsi try try
				}// zavrsi glavni try try
			}
		});
		loginButton.setBounds(10, 207, 150, 29);
		frmPoolSystem.getContentPane().add(loginButton);

		passwordBox = new JTextField();
		passwordBox.setColumns(10);
		passwordBox.setBounds(96, 154, 223, 20);
		frmPoolSystem.getContentPane().add(passwordBox);

		JButton exitButton = new JButton("Exit");
		exitButton.addMouseListener(new MouseAdapter() {
			@Override
			public void mouseClicked(MouseEvent e) {
				System.exit(0);
			}
		});
		exitButton.setBounds(171, 207, 150, 29);
		frmPoolSystem.getContentPane().add(exitButton);

		JLabel logo = new JLabel("New label");
		logo.setIcon(new ImageIcon(Login.class.getResource("/images/nesto.png")));
		logo.setBounds(0, 0, 331, 118);
		frmPoolSystem.getContentPane().add(logo);
	}
}