用Hibernate映射数据库视图View

最新推荐文章于 2021-07-30 07:17:52 发布

figh

最新推荐文章于 2021-07-30 07:17:52 发布

阅读量342

点赞数

分类专栏： JAVA开发文章标签： hibernate 数据库 immutable database table nested

本文链接：https://blog.csdn.net/figh/article/details/2805357

版权

JAVA开发专栏收录该内容

1 篇文章 0 订阅

订阅专栏

关于用Hibernate映射数据库视图View，在Hibernate官方文档里提到过，如下：

There is no difference between a view and a base table for a Hibernate mapping, as expected this is transparent at the database level (note that some DBMS don't support views properly, especially with updates). Sometimes you want to use a view, but can't create one in the database (ie. with a legacy schema). In this case, you can map an immutable and read-only entity to a given SQL subselect expression:

<class name="Summary">
    <subselect>
        select item.name, max(bid.amount), count(*)
        from item
        join bid on bid.item_id = item.id
        group by item.name
    </subselect>
    <synchronize table="item"/>
    <synchronize table="bid"/>
    <id name="name"/>
    ...
</class>

Declare the tables to synchronize this entity with, ensuring that auto-flush happens correctly, and that queries against the derived entity do not return stale data. The <subselect> is available as both as an attribute and a nested mapping element

figh

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
用Hibernate映射数据库视图View

var htmltype = "diary_browse"; var objtitle="用Hibernate映射数据库视图View "; window.document.title = objtitle; var objid="14198640"; var articleid = 14198640; var diaryi
复制链接

扫一扫

专栏目录