关于Criteria与HQL查询返回值的技术咨询

Hey there, let's break down the key differences in return values between these two queries, plus point out some critical mismatches in your current code:

1. Element Type & Method Signature Mismatches #

First, let's clarify what each query actually returns vs. what your method declarations claim:

HQL Query #

Your HQL code:

Query<Object[]> query = manager.getSession().createQuery("select user.firstName from User user",Object[].class);
return query.getResultList();

• Actual return content: Since you're only selecting a single field (firstName, likely a String), Hibernate won't wrap this value in an Object[]. Each element in the list is just the raw firstName scalar value (e.g., a String or whatever type your firstName is mapped to).
• Method signature issue: Your method says it returns List<Object[]>, but this is incorrect. The real return type should be List<String> (or List<Object> for generic use). Using Object[].class here will cause a runtime type mismatch.

Criteria Query #

Your Criteria code snippet:

Criteria criteria = manager.getSession().createCriteria(User.class).setProjection(P...
return criteria.list(); // Method declares return type List<User>

• Actual return content: As soon as you add a Projection (like Projections.property("firstName")), Hibernate stops returning full User entity objects. Instead, it returns just the projected field value (again, a String for firstName).
• Method signature issue: Your method claims to return List<User>, but this is wrong when using projections. You'll hit a ClassCastException at runtime if you try to cast the returned string values to User objects.

2. Content of List Elements #

• HQL: Even with the incorrect signature, each element in the list is a single scalar value (the firstName string). If you selected multiple fields (e.g., select user.firstName, user.lastName), then each element would be an Object[] holding those two values—but that's not your current query.
• Criteria: With projections enabled, each element is a single scalar value (the projected field). If you removed the projection entirely, it would return full User entities, but your code explicitly starts with setProjection(...), so that's not the case here.

3. Type Safety Fixes #

To make both queries type-safe and align their return values with reality:

• Fixed HQL:

  @Override 
  public List<String> getAllLoginHQL() { 
      Query<String> query = manager.getSession().createQuery("select user.firstName from User user", String.class);
      return query.getResultList(); 
  }
  

• Fixed Criteria:

  @Override 
  public List<String> getAllLoginCriteria() { 
      Criteria criteria = manager.getSession().createCriteria(User.class)
          .setProjection(Projections.property("firstName"));
      return (List<String>) criteria.list(); 
  }
  

内容的提问来源于stack exchange，提问作者Suule