Evidence

package us.Login.Frames;

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 us.Login.Frames.Switcher.FrameSwitcher;

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

import java.awt.Font;
import javax.swing.JTextField;
import javax.swing.JPasswordField;
import javax.swing.JButton;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import javax.swing.JMenuBar;

public class Login extends JFrame {

	static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://sql7.freemysqlhosting.net:3306/sql7275618";
    static final String USER = "sql7275618";
     static final String PASS = "K6RKaJJ3IY";

	private JPanel contentPane;
	private static JTextField usernamekey;
	private static JPasswordField passwordkey;
    private static Login frame = new Login();
	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {



		EventQueue.invokeLater(new Runnable() {
			public void run() {


				frame.setVisible(true);
				try {

				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

	/**
	 * Create the frame.
	 */
	public Login() {
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 319, 395);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(null);

		JLabel lblLoginPanel = new JLabel("Login Panel");
		lblLoginPanel.setFont(new Font("Slant", Font.PLAIN, 37));
		lblLoginPanel.setBounds(65, 11, 228, 50);
		contentPane.add(lblLoginPanel);

		JLabel lblUsername = new JLabel("Username");
		lblUsername.setFont(new Font("Source Sans Pro Black", Font.BOLD, 20));
		lblUsername.setBounds(20, 153, 119, 50);
		contentPane.add(lblUsername);

		JLabel lblPassword = new JLabel("Password");
		lblPassword.setFont(new Font("Source Sans Pro Black", Font.BOLD, 20));
		lblPassword.setBounds(20, 214, 219, 22);
		contentPane.add(lblPassword);

		usernamekey = new JTextField();
		usernamekey.setBounds(153, 169, 86, 20);
		contentPane.add(usernamekey);
		usernamekey.setColumns(10);

		passwordkey = new JPasswordField();
		passwordkey.setBounds(153, 215, 86, 22);
		contentPane.add(passwordkey);

		JButton btnNewButton = new JButton("Login");
		btnNewButton.addActionListener(new ActionListener() {
			 String sql="SELECT * FROM `SimpleLogin` WHERE `name` = '" + usernamekey.getText() + "' AND `pass` = '" + passwordkey.getText() + "'";
			public void actionPerformed(ActionEvent arg0) {
				String sql="SELECT * FROM `SimpleLogin` WHERE `name` = '" + usernamekey.getText() + "' AND `pass` = '" + passwordkey.getText() + "'";
				try {
		        Connection conn = null;
		        Statement stmt = null;

				Class.forName("com.mysql.jdbc.Driver");
				 System.out.println("connecting to the database");

				 conn = DriverManager.getConnection(DB_URL, USER, PASS);
				 System.out.println("creating a statement..");

		            stmt = conn.createStatement();


		        	ResultSet rs = stmt.executeQuery(sql);

		        	if(rs.next()){

		        		System.out.println("Logged in");
		        		JOptionPane.showMessageDialog(null, "Login succeeded");

		        	} else {
		        		JOptionPane.showMessageDialog(null, "Login failed");
		        	}






				 rs.close();
		            stmt.close();
		            conn.close();

		       } catch (SQLException e) {

		    	   e.printStackTrace();
		       } catch (Exception e) {
		    	   e.printStackTrace();
		       }


			}
		});
		btnNewButton.setBounds(10, 322, 89, 23);
		contentPane.add(btnNewButton);

		JButton btnReset = new JButton("Reset");
		btnReset.setBounds(204, 322, 89, 23);
		contentPane.add(btnReset);
	}


}