I just want to user'name and count .How to get it with Hibernate 2.1.6?

<sql-query name="QueryUser">
<![
CDATA[
select user.grade,count(*) count from User user
where user.name like 'A%' ]
]>
<return alias="user" class="???"/> (Here how to write)
</sql-query>

Thanks

Why do you want to use an sql-query?
You can use an HQL named query.

<query name="QueryUser">
select new YourClass'sName (user.grade,count(*) count from User user
where user.name like 'A%' group by user.grade
</query>

If you DO wnat to use an sql-query,

<sql-query name="QueryUser">
<return alias="user" class="YourClassName"/>
select new YourClass'sName (user.grade,count(*) count from User user
where user.name like 'A%' group by user.grade
</sql-query>

In the class atribute, you have to write the complete name of the class, starting from the base folder, say, com.yahoo.User

As your way, I have to create a new class to contain the query result. But I just want to query it as a report to display. Does I have another simple way? Can I get a Object[] array to contain the query result?

Thanks

you can do it, but it is better that you use hql

it is little strange on start, but it is very power

<query name="QueryUser">
select new map (user.grade as grade,count(*) as count ) from User user
where user.name like 'A%' group by user.grade
</query>

This will return a Map with aliases as key and the selected values as the corresponding values.