I am doing a simple login application, where the user needs to provide his username and password in order to sign in. I need to verify username and password using Hibernate.

Now with JDBC i'd
get a connection obj,
get a statement obj
get a result set obj
execute the query viz
(Select id from person where cname ='"+username+"' and passwd ='"+password+"')
if(rs.next() == true){
bla
}else{
bla
}

Now whats the equivalent in hibernate?

Hibernate makes use of hql.
http://docs.jboss.org/hibernate/core/3.3/reference/en/html/queryhql.html

I know it makes use of HQL...and I have gone through the docs. but wasn't able to see the equivalence of rs.next()

I bet you where hoping for a two liner short answer on how to use Hibernate..
Read this tutorial written by Hibernate http://docs.jboss.org/hibernate/core/3. ... orial.html Or any other tutorial that you find about Hibernate using google.

Also the equivalent to rs.next() is to create a List<User> user that you fill up, and then loop through it like a normal list. For that you need to create a domain object User, a SessionFactory, mappings, config file etc etc.

There are several ways to do this depending on how you execute the query. If you just want to check if the given user exists a simple solution is:

Query query = ....


Other options: query.list().size() > 0 or query.iterate().hasNext() or query.scroll().next()

Thanks Nordborg. That was precisely what I was looking for.