Result set is empty

[sonia pandit]

  ResultSet rs = stmt.executeQuery("select userid,password from login where userid='"+name +"'");
	  while(rs.next()) {
			
			pw= rs.getString(password);
			
			System.out.println("password" + pw);
	  }  

I have checked in Sqlplus there are two entries in the table login. It does not go into the loop while(rs.next());

How do I fix this so it works?

Thanks,

Sonia

[Edwin Dalorzo]

If you do this, what do you get?

System.out.println("select userid,password from login where userid='"+name +"')

[sonia pandit]

I cannot do that. I have to use the connection and stmt to execute a query to the database.

THanks,

SOnia

[Ulf Dittmer]

"System.out.println" has nothing to do with the DB - it serves as a debugging aid. The point Edwin was trying to make is that you should check what the actual query looks like that gets sent to the DB.

As a side note, it is much better to use a PreparedStatement than to construct the query on the fly using string concatenation. Amongst other benefits, it makes sure that the code isn't susceptible to SQL injection attacks.

[sonia pandit]

The examples on prepared statements are not that complete.

  PreparedStatement query = con.prepareStatement(
        "SELECT PASSWORD FROM LOGIN WHERE USER LIKE ?");
         query.setString(1, "administrator");
         int n = query.executeUpdate();
         System.out.println("n" + n);
		//ResultSet rs = stmt.executeQuery("SELECT password from login where userid like 'administrator'");
	    System.out.println("SELECT password from login where userid='"+name+"'");
         	ResultSet rs = stmt.executeQuery("select password from login where userid='"+name +"'");
	   // ResultSet rs = stmt.executeQuery("SELECT PASSWORD FROM LOGIN");
         
         while(rs.next()) {
			
			pw= rs.getString(password);
			
			System.out.println("password" + pw);
	  }   

Is this good? The print statement for the query gives me the following without a semicolon:

 SELECT password from login where userid='administrator'
   

and n=0;

Thanks in advance,

Sonia

[Ulf Dittmer]

What happens if you run that query directly against the DB? Are you getting results returned?

[sonia pandit]

yes; i get results.

Sonia

[Jaikiran Pai]

In your code are you sure you are connecting to the same database which contains these records?

[sonia pandit]

It was a matter of case. I changed the column to uppercase and it works. I did not realize SQL was case sensitive.
I also changed it to use Prepared Statement. Now somebody has adviced me to use Hibernate and Spring. So I have to research that. Sure I will be posting questions with that.

Thanks,

Sonia