如何在Hibernate中使用CriteriaBuilder无POJO类查询数据库表？代码有效性确认

Great question! Let’s break down your two questions one by one to make this clear:

1. How to query existing database tables with CriteriaBuilder without relying on POJOs? #

Hibernate is built as an ORM tool, but you absolutely can use CriteriaBuilder to query tables without corresponding POJO entities. The trick is to use tuples or object arrays to hold your query results instead of mapping to a dedicated entity class. Here’s a practical step-by-step example:

• Start by getting your CriteriaBuilder and creating a CriteriaQuery<Tuple> (Tuple lets you hold multiple result fields without needing a POJO):

  CriteriaBuilder builder = session.getCriteriaBuilder();
  CriteriaQuery<Tuple> query = builder.createTupleQuery();
  

• Next, reference your target table directly using query.from() with the table name (Hibernate will recognize the table as long as your database connection is properly configured):

  Root<?> studentRoot = query.from("Student");
  

• Define the specific columns you want to select, using their actual names from the database table:

  query.select(builder.tuple(
      studentRoot.get("id"),
      studentRoot.get("name"),
      studentRoot.get("age")
  ));
  

• Add filters (where clauses) if you need to narrow down results:

  query.where(builder.greaterThan(studentRoot.get("age"), 18));
  

• Execute the query and process the results manually:

  List<Tuple> results = session.createQuery(query).getResultList();
  for (Tuple tuple : results) {
      Integer id = (Integer) tuple.get(0);
      String name = (String) tuple.get(1);
      Integer age = (Integer) tuple.get(2);
      // Work with the retrieved data as needed
  }
  

If you prefer working with arrays instead of Tuples, you can use CriteriaQuery<Object[]> instead:

CriteriaQuery<Object[]> arrayQuery = builder.createQuery(Object[].class);
Root<?> arrayRoot = arrayQuery.from("Student");
arrayQuery.select(arrayRoot.get("id"), arrayRoot.get("name"));
List<Object[]> arrayResults = session.createQuery(arrayQuery).getResultList();

2. Can the code snippet <CriteriaBuilder builder=session.getCriteriaBuilder(); CriteriaQuery query =builder.createQuery();> be used to query a table (like Student) without a corresponding POJO? #

That snippet is a valid starting point, but it’s incomplete on its own—here’s why:

• You’re using a raw CriteriaQuery instead of specifying a return type (like Tuple or Object[]), which means you’ll have to handle untyped results that are harder to work with.
• The query hasn’t been linked to the Student table yet—you need to call query.from("Student") to associate it with your target table.
• You haven’t defined which columns to retrieve with a query.select(...) clause.

To make it work for your Student table without a POJO, extend it like this:

CriteriaBuilder builder = session.getCriteriaBuilder();
// Use Tuple for clearer typed result handling
CriteriaQuery<Tuple> query = builder.createTupleQuery();
Root<?> studentRoot = query.from("Student");
// Select the columns you need from the table
query.select(builder.tuple(studentRoot.get("id"), studentRoot.get("name")));
// Execute and process the results
List<Tuple> results = session.createQuery(query).getResultList();

Without these additional steps, the original snippet doesn’t target any table or define what data to fetch, so it won’t return meaningful results from your Student table.

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