Untitled

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package project;

import java.sql.DriverManager;

import java.awt.Color;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;

/**
 *
 * @author lenovo
 */
public class LoginFrame {
    Connection con = null;
    Statement statement = null; //query statement
    ResultSet resultSet=null;
    JPasswordField passText = new JPasswordField(13);
    JTextField userText = new JTextField(13);
    public LoginFrame(){
    JFrame jf = new JFrame();
    JPanel jp = new JPanel();
    jf.setDefaultCloseOperation(jf.EXIT_ON_CLOSE);

    JLabel userLabel = new JLabel("Username:");


    JLabel passLabel = new JLabel("Password:");


    JButton loginButton = new JButton("Login");

    JLabel account = new JLabel();
    account.setText("Create a new account");

    JLabel signUp = new JLabel("<HTML> <U>SignUp</U> <HTML>");


    jp.add(userLabel);
    jp.add(userText);
    jp.add(passLabel);
    jp.add(passText);
    jp.add(loginButton);
    jp.add(account);
    jp.add(signUp);
    jp.setLayout(null);
    jp.setBackground(Color.orange);

    Font font = new Font("Courier", Font.BOLD,14);
    userLabel.setBounds(100,50,120,130);
    userLabel.setFont(font);
    userText.setBounds(180,105,150,22);
    passLabel.setBounds(100,105,120,130);
    passLabel.setFont(font);
    passText.setBounds(180,160,150,22);
    loginButton.setBounds(160, 230, 90, 30);
    account.setBounds(145,245,140,60);
    signUp.setBounds(185, 272, 100, 50);

    jf.add(jp);
    jf.setTitle("Login");
    jf.setSize(400,400);
    jf.setVisible(true);
    jf.setLocationRelativeTo(null);
    jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

          signUp.addMouseListener(new MouseAdapter(){
              public void mouseClicked(MouseEvent e){
                       new RegisterFrame();
              }
          });

          loginButton.addActionListener(new ActionListener(){
              public void actionPerformed(ActionEvent e){
                 /* getConnection();

                  try{
                      String sql = "INSERT INTO java(Username,Password) values(?,?)";
                      PreparedStatement ps = con.prepareStatement(sql);

                      ps.setString(1, userText.getText());
                      ps.setString(2, passText.getText());
                      ps.execute();
                      ResultSet rs = ps.executeQuery("select * from java class");
                      rs.absolute(2);
                      System.out.println(rs.getString(1)+" "+ rs.getString(2));


                  }
                  catch(Exception ve){
                      System.out.println(ve);
                  }*/
                  getConnection();
                 try{
                 String sql = "SELECT * FROM java WHERE Username = '"+userText.getText()+" ' AND Password = '"+passText.getText()+"'";

                    statement = con.createStatement();
                     resultSet = statement.executeQuery(sql);

                     if(resultSet.next() == true && userText.getText() != null && passText.getText() != null){

                      String s ="Login Successful";
                      JOptionPane.showMessageDialog(null,s);

                      NewJFrame n = new NewJFrame();
                      n.setVisible(true);

                     jf.dispose();


                    }
                   else{
                       System.out.println("Not Connected");

                   }

                   }
                catch(Exception ev){
                       System.out.println(ev);
                  }
              }
          });

    }
    public void getConnection(){
        try{
            con=DriverManager.getConnection("jdbc:mysql://localhost/student","root","");
            System.out.println("connected");
            JOptionPane.showMessageDialog(null, "Connected");
            statement = con.createStatement();

        }catch (SQLException ex){
            JOptionPane.showMessageDialog(null,"Not Connected");
        }
    }

}