Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with the query in JDBC ,resultset empty

 
Bhavik Patel
Ranch Hand
Posts: 155
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i am using chkUser() to check the user's existence in the database.
its also trying to fetch and set all the values for student eg email,phone while fetching the username and password...in both rs1 and rs2 if i set query with just UNAME = 'CHIRAG' then its giving me the result but
it doesn't give me reuslt with UNAME='CHIRAG' AND PASSWORD='chirag'...Is it that it doesn't support AND keyword..... with both UNAME and PASSWORD its giving me following output.....there is one row in database that has UNAME='CHIRAG' and Pasword='chirag' but it gives me rs empty ...not null

I am getting output

errorcode -1
at last errorcode -1


Following code.....
i am calling chkuser() which calls getStudentInfo()



[edited to add code tags]
[ April 12, 2005: Message edited by: Jeanne Boyarsky ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34423
347
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Bhavik,
Why are you doing the query in two steps instead of one?

In any event, try the following query:
ResultSet rs1=stmt.executeQuery("SELECT SID, UNAME, PASSWORD FROM STUDENT WHERE UNAME like '%C%' AND PASSWORD like '%c%'");
This will help narrow down whether there is a typo. The "and" is very straightforward and not the problem. Also, note that the username and password values are case sensitive, so double check that.

Finally, note that the result set will never be null. JDBC drivers return an empty resultset, but not null. So that piece of code is extraneous.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic