I have a sample table as follows



I want to create some tables that have the same structure as the tbl_template table use the same POJO class TblTemplate


If I want to create,update,delete data to any table I call that table by table name

If using sql would be easier but I would like to use HQL or hibernate builtin functions

I searched for commands or documents that could do it, but I did not succeed .Please help me!

TblTemplate can be a @MappedSuperclass while for each specific table you have:



So, if the TblTemplate contains the id and name fields, the TblTemplate1 does not need to declare any attribute since they inherit them from TblTemplate.

If you're using PostgreSQL, you can even use table-level inheritance for your design.



You need to use the actual entity type in order to create, update, delete data in a particular table.



You can use HQL as long as you have to make sure you reference the right entity type.