File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Problem with the query in JDBC ,resultset empty Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem with the query in JDBC ,resultset empty" Watch "Problem with the query in JDBC ,resultset empty" New topic

Problem with the query in JDBC ,resultset empty

Bhavik Patel
Ranch Hand

Joined: Jul 12, 2004
Posts: 155
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 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 ]

SCJP 1.4<br />SCWCD 1.4(91%)<br />Working on SCJD -Bodgitt & Scrapper Constructions...<br /> <br />"It takes 43 muscles to frown & 17 to smile but it doen't take any to just sit there with a dumb look on your face .. Keep Smiling "
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33130

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.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Problem with the query in JDBC ,resultset empty
It's not a secret anymore!