java.sql.SQLException Illegal operation on empty result set

Question

Please help me: here is a sample of the code. Everytime i press the login button it gives me java.sql.SQLExcpetion illegal operation on empty result set

Code for the Login Button:

 private void loginBtnActionPerformed(java.awt.event.ActionEvent evt) {                                         
    // TODO add your handling code here:

    con = DatabaseConnection.DBConnect();
    String sql = "SELECT * FROM user_table WHERE user_name = ? AND user_pass = ?";

    try
    {
        getPrivilege(username_Textfield.getText());

        prepStat = con.prepareStatement(sql);
        prepStat.setString(1, username_Textfield.getText());
        prepStat.setString(2,password_Textfield.getText());
        rs = prepStat.executeQuery();

        if(rs.next())
        {
            if (isAdmin == true)
            {
                JOptionPane.showMessageDialog(null,"Login Successful");
                mainDashboard mD = new mainDashboard();
                mD.setVisible(true);
                mD.setPrivilege(isAdmin);
                dispose();


            }else if(isAdmin == false)
            {
                JOptionPane.showMessageDialog(null,"Login Successful");
                userDashboard uD= new userDashboard();
                uD.setVisible(true);
                uD.setPrivilege(isAdmin);
                dispose();
            }

        }else
        {


                JOptionPane.showMessageDialog(null,"The username or password is incorrect","Access Denied", JOptionPane.ERROR_MESSAGE);
                username_Textfield.setBackground(Color.red);
                password_Textfield.setBackground(Color.red);
        }





    }catch(Exception e)
    {
        JOptionPane.showMessageDialog(null, e);
    }


}

code for the connection class: the code here is for the DB connection i have a table called user which consists of user_id, user_name,user_pass, emp_id. all of which are set to not null

package guest_house;

//imports needed for the classs

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import javax.swing.JOptionPane;


 /**
 *
 * @author POWER
 */
public class DatabaseConnection {



public static Connection DBConnect()
{
    Connection con = null;
    PreparedStatement preStat = null;
    ResultSet rs = null;

    try
    {
        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection("jdbc:mysql://localhost:3306/guest_house?","root","");
        return con;
    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null, e);
        return null;
    }
}



}

At which line is the exception happening?

Alain-Michel Chomnoue N
– Alain-Michel Chomnoue N

2017-11-08 11:03:51 +00:00
Commented Nov 8, 2017 at 11:03 — Alain-Michel Chomnoue N
– Alain-Michel Chomnoue N, Commented Nov 8, 2017 at 11:03
It doesnt show me where the Exception is

Stephan Remane
– Stephan Remane

2017-11-08 13:29:18 +00:00
Commented Nov 8, 2017 at 13:29 — Stephan Remane
– Stephan Remane, Commented Nov 8, 2017 at 13:29

Mustafa Çil · Accepted Answer · 2017-11-08 11:04:23Z

3

Your column's name are user_id, user_name,user_pass, emp_id and table's name is user. But your sql sentence use userName, userPass and users words. You must change the sql sentence like this:

"SELECT * FROM user WHERE user_name =? AND user_pass=?"

answered Nov 8, 2017 at 11:04

Mustafa Çil

7769 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Stephan Remane Over a year ago

sorry i edited the post now, i had copied the wrong code. please revise it again gimme feedback

Mustafa Çil Over a year ago

What is your table's name? user or user_table?

Stephan Remane Over a year ago

Table name is user_table. This exception pops up only when I click the login button without any credentials

Mustafa Çil Over a year ago

What is database's name? Is it guest_house? or guest_house

Collectives™ on Stack Overflow

java.sql.SQLException Illegal operation on empty result set

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related