【java】树形结构分页（真分页）

SELECT distinct    firstNodeFROM    Project p where p.name='龙腾集团项目'

 <if test="idList != null">                AND firstNode in                <foreach close=")" collection="idList" index="" item="item" open="(" separator=",">                    #{item}                </foreach> </if>

 public List<Project> getSortProjectList(List<Project> projectList, ProjectVo query) {        List<Project> projects = projectList.stream()                .filter(e -> query.getId() == null || isContaint(e.getId(), query.getId()))                .filter(e -> query.getProjectName() == null || isContaint(e.getProjectName(), query.getProjectName()))                .filter(e -> query.getProjectStatus() == null || query.getProjectStatus().equals(e.getProjectStatus()))                .filter(e -> query.getBusinessId() == null || query.getBusinessId().equals(e.getBusinessId()))                .filter(e -> query.getProjectType() == null || isContaint(e.getProjectType(), query.getProjectType()))                .filter(e -> query.getBusinessName() == null || isContaint(e.getBusinessName(), query.getBusinessName()))                .filter(e -> query.getCustomer() == null || query.getCustomer().equals(e.getCustomer()))                .filter(e -> query.getCreateUser() == null || query.getCreateUser().equals(e.getCreateUser()))                .filter(e -> query.getProjectManager() == null || query.getProjectManager().equals(e.getProjectManager()))                .filter(e -> query.getPriceId() == null || query.getPriceId().equals(e.getPriceId()))                .filter(e -> query.getPriceFlag() == null || isContaint(query.getPriceFlag(), e.getPriceFlag()))                .collect(Collectors.toList());        return projects;    }

 /**     * 从一级向下递归     *     * @param projectFatherList     * @return     */    public List<Project> getProjectTree(List<Project> projectFatherList, HashMap<String, List<Project>> allProjectMap) {        //遍历，拿出所有的pidw为零的项目        List<Project> firstLeaveProject = projectFatherList.stream().filter(project -> StringUtils.isEmpty(project.getPId())).collect(Collectors.toList());        projectFatherList = getAllBottomProject(firstLeaveProject, allProjectMap);        return projectFatherList;    }

/**     * 递归遍历此项目下所有项目     *     * @param leaveProjectList     * @return     */    public List<Project> getAllBottomProject(List<Project> leaveProjectList, HashMap<String, List<Project>> allProjectMap) {        if (leaveProjectList != null && leaveProjectList.size() != 0 && !allProjectMap.isEmpty()) {            for (int i = leaveProjectList.size() - 1; i >= 0; i--) {                if (leaveProjectList.get(i).getId() != null && allProjectMap.get(leaveProjectList.get(i).getId()) != null) {                    leaveProjectList.get(i).setChildrenProjectList(allProjectMap.get(leaveProjectList.get(i).getId()));                    //递归调用，查看子集是否还有子集                    getAllBottomProject(leaveProjectList.get(i).getChildrenProjectList(), allProjectMap);                }            }        }        return leaveProjectList;    }

/**     * 向上递归     *     * @param projectFatherList     * @param projectList     * @param projectAllList     * @throws IOException     * @throws ClassNotFoundException     */public void selectTreeUp(List<Project> projectFatherList, List<Project> projectList, List<Project> projectAllList) {        if (!StringUtils.isEmpty(projectFatherList) && projectFatherList.size() > 0) {            List<Project> projectTempList = new LinkedList<>();            for (Project k : projectFatherList            ) {
                // 如果该项目有父项目，则将父项目放入返回list（projectAllList）                if (!StringUtils.isEmpty(k.getPId())) {                    List<Project> collect = projectList.stream().filter(e -> e.getId().equals(k.getPId())).collect(Collectors.toList());                    if (collect.size() > 0) {                        projectTempList.add(collect.get(0));                    }                }            }            projectAllList.addAll(projectTempList);            projectFatherList = new LinkedList<>();            projectFatherList.addAll(projectTempList);            selectTreeUp(projectFatherList, projectList, projectAllList);        }    }    /**     * 向下递归     *     * @param projectSonList     * @param projectList     * @param projectAllList     * @throws IOException     * @throws ClassNotFoundException     */
    public void selectTreeBottom(List<Project> projectSonList, List<Project> projectList, List<Project> projectAllList) {        if (!StringUtils.isEmpty(projectSonList) && projectSonList.size() > 0) {            List<Project> projectTempList = new LinkedList<>();            List<Project> projectOrList;
            for (Project k : projectSonList            ) {
                projectOrList = projectList.stream().filter(e -> k.getId().equals(e.getPId())).collect(Collectors.toList());                projectAllList.addAll(projectOrList);                projectTempList.addAll(projectOrList);            }            projectSonList = new LinkedList<>();            projectSonList.addAll(projectTempList);            selectTreeBottom(projectSonList, projectList, projectAllList);        }    }

SELECT DISTINCT projectFullPath FROM PSAProject p LEFT JOIN SalesProject a ON a.ID= p.BusinessId  ORDER BY  t1.CreateTime DESC[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法绑定由多个部分组成的标识符 "t1.CreateTime"。 (4104)[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]如果指定了 SELECT DISTINCT，那么 ORDER BY 子句中的项就必须出现在选择列表中

        select p.projectFullPath ,p.CreateTime from PSAProject p where id in(        SELECT DISTINCT        projectFullPathFROM        PSAProject p        LEFT JOIN SalesProject a ON a.ID= p.BusinessId) order by p.CreateTime desc;