Java-Hibernate-Newbie: How do I get values ​​from this list?

Question

I displayed this class

@Entity
@Table(name = "USERS")
public class User {
 private long id;
 private String userName;
}

and I make a request:

Query query = session.createQuery("select id, userName, count(userName) from User order by count(userName) desc");
            return query.list();

How do I access the values ​​returned by a query?

I mean, how should I handle query.list ()? As a user or what?

Answer 1

To strictly answer your question, queries that define a class property in a select clause (and, optionally, calls to aggregate functions) return "scalar" results, i.e. a Object[](or a List<Object[]>). See 10.4.1.3. Scalar results .

But your current request is not working. You will need something like this:

select u.userName, count(u.userName) 
from User2633514 u 
group by u.userName 
order by count(u.userName) desc

Answer 2

, Hibernate , , . (.. "Count ( )" ), "group by" .

, Hibernate , , , , Object [], Hibernate ( ) ) " .

, , Hibernate , / /. , , Hibernate, .