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 ]
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 "
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.