时间戳

首页 > 解决方案 > 休眠条件加入“和”条件

java - 休眠条件加入“和”条件

问题描述

我有以下实体及其关系

JobAddress - JobHeader jobHeader
JobHeader - List<Job> jobs
Job - JobHeader
ProjectPhaseAddress - Job job, ConstructionMetric cm, JobAddress jobAddress
ConstructionMetric - Job job

尝试为以下查询构建 Hibernate Criteria。如何通过使用 AND 条件连接多个表来构建标准。

SELECT JA.* FROM JOB_ADDRESS JA
JOIN JOB_HEADER JH ON JH.ADDRESS_ID = JA.ADDRESS_ID
JOIN JOB J on J.J_HEADER_ID = JH.ID
JOIN PROJECT_PHASE_ADDRESS PPA ON PPA.ADDRESS_ID = JA.ADDRESS_ID AND   PPA.JOB_ID = J.ID
JOIN CONST_METRIC CM ON CM.ID = PPA.CONST_METRIC_ID AND CM.JOB_ID = J.ID
WHERE JH.ID = 125656

标签： javahibernatejpajakarta-ee

解决方案

推荐阅读