package user;

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

import java.sql.*;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.JPasswordField;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.awt.Font;
import java.awt.Color;
import javax.swing.UIManager;

public class SupNews extends JFrame {

	private JPanel contentPane;
	private JLabel lblUser;
	private JTextField username;
	private JPasswordField passwordField;

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

	/**
	 * Create the frame.
	 */
	public SupNews() {
		setBackground(UIManager.getColor("CheckBox.light"));
		setTitle("SupNews - 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 lblNewLabel = new JLabel("Password");
		lblNewLabel.setFont(new Font("Times New Roman", Font.PLAIN, 23));
		lblNewLabel.setBounds(64, 120, 107, 25);
		contentPane.add(lblNewLabel);

		lblUser = new JLabel("Username");
		lblUser.setFont(new Font("Times New Roman", Font.PLAIN, 23));
		lblUser.setBounds(63, 38, 97, 22);
		contentPane.add(lblUser);

		username = new JTextField();
		username.setBounds(183, 41, 116, 22);
		contentPane.add(username);
		username.setColumns(10);

		passwordField = new JPasswordField();
		passwordField.setBounds(183, 124, 116, 22);
		contentPane.add(passwordField);

		JButton btnLogin = new JButton("Login");
		btnLogin.setFont(new Font("Times New Roman", Font.PLAIN, 17));
		btnLogin.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {

				try {
					Class.forName("com.mysql.jdbc.Driver");
					Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/supnews?useSSL=true","root","");
					Statement stmt=con.createStatement();
					String sql="Select * from login where UserName='"+username.getText()+"' and Password= MD5('"+passwordField.getText().toString()+"')";
					ResultSet rs=stmt.executeQuery(sql);
					if(rs.next()) {
					 JOptionPane.showMessageDialog(null, "Login Successfully...");
					//create object
					Dashboard Dashboard= new Dashboard();
					Dashboard.setVisible(true);
					}
					else
					JOptionPane.showMessageDialog(null, "Incorrect username and Password...");
					con.close();
				}catch(Exception e) {System.out.print(e);}

				}
		});
		btnLogin.setBounds(300, 186, 97, 25);
		contentPane.add(btnLogin);
	}
}