Forums Register Login

ResultSet

+Pie Number of slices to send: Send
Alright, I'm finishing up my login page. Users can login successfully, if they provide the wrong password they are notified, however if they enter a username that doesn't exist the servlet bombs.

My query is simple, I select all from my user table where the login ids match. So if there is no match, then obviously the loginID doesn't exist. How do I test for that though?

For example:
String query = "SELECT * from user where loginID = '"+login+"'";
ResultSet resultSet = statement.executeQuery(query);

now where do I go from here? would all the attributes I would have acquired from the query be null, and simply test to see if one if null??
+Pie Number of slices to send: Send
user resultSet.next() as shown

[ March 24, 2005: Message edited by: Bear Bibeault ]
+Pie Number of slices to send: Send
I already know about the while(resultSet.next()) and that it means there is some results of my query. I'm asking how I can test if there are no results... like if(resultSet==null) ??? I'm new to java and need some help here!! Thanks!
+Pie Number of slices to send: Send
boolean resultExists=false;
ResultSet resultSet = statement.executeQuery(query);
while(resultSet.next())
{
resultExists=true;
//if it enters here, there must be "atleast" one row that has satisfied your query.
//else if it does not enter here, there are ro rows retrieved.
}
you can use the boolean variable in your code to write further logic if required...
this is the only way as I know that you can check whether the resultset has retrieved any rows or not.

Cheers
Sripathi
[ March 24, 2005: Message edited by: Sripathi ]
+Pie Number of slices to send: Send
 

Originally posted by Jenn Person:
I'm asking how I can test if there are no results... like if(resultSet==null) ???



ResultSet wouldn't be null, until and unless you assign it null explicitly.
+Pie Number of slices to send: Send
Don't you just need to do a ..

String sError = null;
String query = "SELECT * from user where loginID = '"+login+"'";
ResultSet resultSet = statement.executeQuery(query);

if (resultSet.next()) {
// check password is correct , set sError if its incorrect..

} else {
sError = "You dont exist !";
}

if (sError != null){
// go login page showing sError
} else {
// do whatever needs to be done after successfull login.
}
BWA HA HA HA HA HA HA! Tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1340 times.
Similar Threads
JPA data retrieval query
User Authentication Mechanism
Problem in fetching records
login problem
org.hibernate.MappingException: Unknown entity:
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 07:53:52.