jpa 2条件冬眠5.2嵌套联接

baskwo 发表于 Dev

巴斯沃

我正在尝试为我的原始服务添加指定我所需的嵌套关系的可能性，这样我就不必从数据库中读取所有内容。

例如我有那些实体

公司.java

private List<Department> departments;
private SalaryCode salaryCode;

部门.java

private List<Employee> employees;
private Company company;
private SalaryCode salaryCode;

Employee.java

private Department department;
private SalaryCode salaryCode

我的条件查询现在是这样的：

Session session = sessionFactory.openSession();
CriteriaBuilder builder = session.getCriteriaBuilder();
CriteriaQuery<T> criteriaQuery = builder.createQuery(clazz);
Root<T> root = criteriaQuery.from(clazz);

//nestedRelationships is a varargs passed as parameters
for(String nestedRelationship : nestedRelationships) {
    root.fetch(nestedRelationship, JoinType.LEFT);
}

List<T> result = session.createQuery(criteriaQuery.select(root)).list();

问题是，如果我将“部门”指定为nestedRelationship并查询Employee实体，则效果很好，但是当我尝试指定“ department.salaryCode”时，它说“无法找到具有给定名称的属性”是行不通的。当然，我要先获取“部门”，然后再获取“ department.salaryCode”。

支持吗？如果是，它是如何工作的，如果不受支持，我该怎么办？

巴斯沃

我通过使用Root元素制定算法找到了解决方案

protected void fetch(Root<T> root, String... joins) {
    //Sort the joins so they are like this :
    //A
    //A.F
    //B.E
    //B.E.D
    //B.G
    Arrays.sort(joins);

    Map<String, Fetch> flattenFetches = new HashMap<>();

    for (String join : joins) {
        try {
            if (join.contains(".")) {
                String[] subrelations = join.split("\\.");
                Fetch lastRelation = null;
                int i;

                for (i = subrelations.length - 1; i >= 0; i--) {
                    String subJoin = String.join(".", Arrays.copyOf(subrelations, i));

                    if (flattenFetches.containsKey(subJoin)) {
                        lastRelation = flattenFetches.get(subJoin);
                        break;
                    }
                }

                if (lastRelation == null) {
                    lastRelation = root.fetch(subrelations[0], JoinType.LEFT);
                    flattenFetches.put(subrelations[0], lastRelation);
                    i = 1;
                }

                for (; i < subrelations.length; i++) {
                    String relation = subrelations[i];
                    String path = String.join(".", Arrays.copyOf(subrelations, i + 1));

                    if (i == subrelations.length - 1) {
                        Fetch fetch = lastRelation.fetch(relation, JoinType.LEFT);
                        flattenFetches.put(path, fetch);
                    } else {
                        lastRelation = lastRelation.fetch(relation, JoinType.LEFT);
                        flattenFetches.put(path, lastRelation);
                    }
                }
            } else {
                Fetch fetch = root.fetch(join, JoinType.LEFT);
                flattenFetches.put(join, fetch);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

并使用它，我只需要例如：

employeeController.getAll("punches", "currentSchedule.shifts", "defaultDepartment.currentSchedule.shifts",
            "defaultDepartment.company.currentSchedule.shifts", "bankExtras")

我想评论一下该算法，但是我没有时间，很容易理解

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。