i have the sql query:

select count(id) from tab where statues = 2


if i execute the sql query through

hibernate find method

it's return a object

i don't konw


how can i get the count result


please tell me:(

Section 15.14 Tips and Tricks in the Reference doc.

i use the webwork framework and spring hibernate support

so i want to use the spring hibernate support method with find


the find method return a List result

well, how can i work????except the session.iterator method

if you receive a List and wanna know the record count, do list.size();

session.iterate() returns a List too. That's what the .next() is for. It'll return a List that contains one object, an Integer.

hi pksiv
thank you for reply

i use this method get the result

String hql="Select count(id) From RegisterInfo Where status = " + sId;
Integer itmp = (Integer)registerInfoMng.findMng(hql).iterator().next();
System.out.println(itmp);


registerInfoMng has a find method

the method body is


List registerList = this.getHibernateTemplate().find(hql);
return registerList;

this is ok??

why not a output result???

I don't understand your question. You get an output result. A List. I can't speak for the Spring side of things but my guess is that if you take a few seconds and look at the value in the List, you'll find that it's an Integer object.

Hi Preston,

I just used this in place of a regular query because I didn't want to go through retrieving the result set and then getting the size of it to find out the count - and I have a couple of questions about it.

First, I noticed that the current Session class doesn't have iterate methods so I had to go back to classic hibernate. Is this okay? I was under the impression that classic hibernate was old and we shouldn't be using it.

Second, is there some way to use a named query for the string we pass to the interate method? I'm trying to keep my source code free of sql.

Thanks!

I'm sure there are many ways you can do this. Just give it a try.

If you had read the comments in the deprecated iterate() method, you'd see that they suggest using find(). And I can't see why there would be any problems using a Named Query. It will still return a List with the first element being and Integer. WRITE SOME CODE, RUN IT, SEE WHAT HAPPENS.