## 一、概述 列表的數據，一般依據一個表/視圖的數據查詢出來，得到列表的結果；但是，有時候會出現，單表/視圖的數據還不夠，業務上需要列表中的每條數據的更多關聯信息； 例如：列表是一個人的數據記錄列表，但也沒上，一次性還需要每個人的每一段工作經歷；那么，單一的人員記錄列表列表就不能滿足需要，還需要每個人的每一段工作經歷（列表）； ## 二、解決方案 舉例說明： ### **使用** ``` @RayServiceMethod public ResponseObject list(String keyWord, int curPage, long boardType) throws Exception { Specification<DouyinBoardCommon> spec = new Specification<DouyinBoardCommon>() { @Override public Predicate toPredicate(Root<DouyinBoardCommon> root, CriteriaQuery<?> query, CriteriaBuilder criteriaBuilder) { List<Predicate> predicates = new ArrayList<>(); predicates.add(criteriaBuilder.equal(root.get("boardType"), boardType)); return criteriaBuilder.and(predicates.toArray(new Predicate[predicates.size()])); } }; model.setPageobject(fetchRowExtraObjects(PageProcessor.reasonablePage(douyinBoardCommonDao, spec, curPage, RayGlobalConfig.getGlobalProperties().getRayDefault().getPageSize(), "curRank", OrderDirection.ASC))); return responseObj; } ``` ### **定義復合對象** ``` static class DouyinBoardCommonWithVideos { private DouyinBoardCommon board; private List<DouyinBoardCommonVideo> videoList; public DouyinBoardCommon getBoard() { return board; } public void setBoard(DouyinBoardCommon board) { this.board = board; } public List<DouyinBoardCommonVideo> getVideoList() { return videoList; } public void setVideoList(List<DouyinBoardCommonVideo> videoList) { this.videoList = videoList; } } ``` ### **處理分頁的數據** ``` private Page fetchRowExtraObjects(Page pageObject) { List<DouyinBoardCommon> originalListInPage = pageObject.getContent(); List mixedObjectWithExtraList = new ArrayList(); if (!ListUtil.isEmpty(originalListInPage)) { for (DouyinBoardCommon rowObject : originalListInPage) { DouyinBoardCommonWithVideos mixedObjectWithExtra = new DouyinBoardCommonWithVideos(); mixedObjectWithExtra.setBoard(rowObject); mixedObjectWithExtra.setVideoList(douyinBoardCommonVideoDao.getDouyinBoardCommonVideoOfSpecBoard(rowObject.getBoardId())); mixedObjectWithExtraList.add(mixedObjectWithExtra); } ByteCodeUtil.forcedModifyObjecctValueWhenFieldInHierarchy(pageObject, "content", mixedObjectWithExtraList); } return pageObject; } ``` ### **處理合并對象的版本** ``` private Page fetchRowExtraObjects(Page pageObject) throws Exception { List<SysDomain> originalListInPage = pageObject.getContent(); List mixedObjectWithExtraList = new ArrayList(); if (!ListUtil.isEmpty(originalListInPage)) { for (SysDomain rowObject : originalListInPage) { mixedObjectWithExtraList.add(ObjectCombiner.mergeObjects(rowObject, sysCorporationDao.findByCorporationEntityTypeAndCorporationEntityId(CorporationEntityType.DOMAIN, rowObject.getDomainId()))); } ByteCodeUtil.forcedModifyObjecctValueWhenFieldInHierarchy(pageObject, "content", mixedObjectWithExtraList); } return pageObject; } ``` >[danger] > 1、這里需要注意，前端做分頁的時候，必須注意到，這個 字段是合成的，不能直接拿來傳到后臺做分頁字段； > 2、如果是非分頁的列表，也可以使用本方案，做法一樣；