Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package us.Login;
- 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.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;
- 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;
- /**
- * Launch the application.
- */
- public static void main(String[] args) {
- EventQueue.invokeLater(new Runnable() {
- public void run() {
- mysql();
- Login frame = new Login();
- 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() {
- public void actionPerformed(ActionEvent arg0) {
- try {
- }catch(Exception e) {System.out.print(e);}
- }
- });
- btnNewButton.setBounds(10, 322, 89, 23);
- contentPane.add(btnNewButton);
- JButton btnReset = new JButton("Reset");
- btnReset.setBounds(204, 322, 89, 23);
- contentPane.add(btnReset);
- }
- public static void mysql() {
- 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();
- String sql="Select * from SimpleLogin where name='"+usernamekey.getText()+"' and pass ='"+passwordkey.getText().toString()+"'";
- ResultSet rs = stmt.executeQuery(sql);
- while(rs.next()){
- }
- rs.close();
- stmt.close();
- conn.close();
- } catch (SQLException e) {
- e.printStackTrace();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement