mysql - 如何在hibernate中将一个实体类映射到具有相同sql模式的四个表？

Question

I have four tables with the same sql schema

user_1
+------+--------+----------------------+
| code | name   | pass                 |
+------+--------+----------------------+
|    1 | rajiv  | 12345                |
+------+--------+----------------------+

user_2
+------+--------+----------------------+
| code | name   | pass                 |
+------+--------+----------------------+
|    1 | rajiv1  | 12345               |
+------+--------+----------------------+

user_3
+------+--------+----------------------+
| code | name   | pass                 |
+------+--------+----------------------+
|    1 | raji2  | 12345                |
+------+--------+----------------------+


user_4
+------+--------+----------------------+
| code | name   | pass                 |
+------+--------+----------------------+
|    1 | raji3  | 12345                |
+------+--------+----------------------+

I dont want to make 4 entity class for these table

Is there any way so that i can define only one Entity class and map all four tables to that entity so that i can fetch data from whichever table i want to

Answer 1

如果您的数据库支持 View ，我建议创建一个包含所有四个表中的数据的 View ，并将该 View 映射到一个实体。这可能比尝试将 4 个表映射到一个实体更简单、更清晰。