mysql - How to implement a DAO in JAVA to query the result sets of two entity classes at the same time

Question

How to implement a DAO in JAVA to query the result sets of two entity classes at the same time
1. The picture is as follows:

Union all query of two tables. Now only one entity set result can be returned. The entity set of the other table is filtered. How to return two entities at the same time? set.

2. There are three pieces of data in the database query: as shown in the figure

3. The current one can only return one solution set, please ask for guidance.

Answer 1

Baidu

hibernate 中createQuery与createSQLQuery两者区别是：
前者用的hql语句进行查询，后者可以用sql语句查询
前者以hibernate生成的Bean为对象装入list返回
后者则是以对象数组进行存储

It seems that you need to use the createSQLQuery method. The return result is an array, not a list