Java 遞歸查詢部門樹形結(jié)構(gòu)數(shù)據(jù)的實(shí)踐

更新時(shí)間：2021年09月22日 11:42:34 作者：哥的冷酷，你模仿不來(lái)

本文主要介紹了Java 遞歸查詢部門樹形結(jié)構(gòu)數(shù)據(jù)的實(shí)踐，文中通過(guò)示例代碼介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們可以參考一下

說(shuō)明：在開發(fā)中，我們經(jīng)常使用樹形結(jié)構(gòu)來(lái)展示菜單選項(xiàng)，如圖：

在這里插入圖片描述

那么我們?cè)诤蠖嗽趺慈?shí)現(xiàn)這樣的一個(gè)功能呢？

1、數(shù)據(jù)庫(kù)表：department

在這里插入圖片描述

2、編寫sql映射語(yǔ)句

 <select id="selectDepartmentTrees" resultType="com.welb.entity.Department">
        select * from department
        <where>
            <if test="updepartmentcode!=null">
                and UpDepartmentCode=#{updepartmentcode}
            </if>
           
        </where>
    </select>

3、創(chuàng)建實(shí)體類

public class Department {
    private String departmentcode;//部門code

    private String departmentname;//部門名稱

    private String updepartmentcode="0";//上級(jí)部門

    private String departmentdesc;//部門描述

    private List<Department> childDept =new ArrayList();//部門信息樹


    public String getDepartmentcode() {
        return departmentcode;
    }

    public void setDepartmentcode(String departmentcode) {
        this.departmentcode = departmentcode == null ? null : departmentcode.trim();
    }

    public String getDepartmentname() {
        return departmentname;
    }

    public void setDepartmentname(String departmentname) {
        this.departmentname = departmentname == null ? null : departmentname.trim();
    }

    public String getUpdepartmentcode() {
        return updepartmentcode;
    }

    public void setUpdepartmentcode(String updepartmentcode) {
        this.updepartmentcode = updepartmentcode == null ? null : updepartmentcode.trim();
    }

    public String getDepartmentdesc() {
        return departmentdesc;
    }

    public void setDepartmentdesc(String departmentdesc) {
        this.departmentdesc = departmentdesc == null ? null : departmentdesc.trim();
    }

    public List<Department> getChildDept() {
        return childDept;
    }

    public void setChildDept(List<Department> childDept) {
        this.childDept = childDept;
    }
}

4、定義mapper

@Mapper
public interface DepartmentMapper {
    List<Department>selectDepartmentTrees(Department department);
    }

5、定義service業(yè)務(wù)層實(shí)現(xiàn)

@Service
@Transactional
public class DepartmentImpl implements IDepartmentService {
    @Resource
    DepartmentMapper departmentMapper;
    
    @Override
    public List<Department> selectDepartmentTrees(Department department) {
        return departmentMapper.selectDepartmentTrees(department);
    }
}

6、控制層實(shí)現(xiàn)

@RestController
@RequestMapping("department")
public class DepartmentController {
    @Resource
    IDepartmentService departmentService;
    @Resource
    IStationService stationService;

    /**
     * 查詢所有部門 樹形展示所有部門 包含模糊查詢
     *
     * @return
     */
    @RequestMapping("/treelist")
    public Object selectAll(Department department) {
        ModelMap map = new ModelMap();
        try {
            List<Department> departmentDtos = getDepartmentList(department);
            map.put("msg", "查詢部門成功");
            map.put("data", departmentDtos);
            map.put("code", 0);
        } catch (Exception e) {
            e.printStackTrace();
            map.put("msg", "查詢部門失敗");
            map.put("code", 1);
        }
        return map;
    }

    /**
     * 遞歸查詢部門
     * @param department
     * @return
     */
    private List<Department> getDepartmentList(Department department) {
        List<Department> departments =departmentService.selectDepartmentTrees(department);
        if (departments.size()>0){
            Department department1=new Department();
            for (int i = 0; i <departments.size() ; i++) {
                department1.setUpdepartmentcode(departments.get(i).getDepartmentcode());
                List<Department>dtos=getDepartmentList(department1);
                departments.get(i).setChildDept(dtos);
            }
        }
        return departments;
    }
}

7、進(jìn)行測(cè)試，這里我用postmain工具測(cè)試，結(jié)果如下圖

在這里插入圖片描述

到這里，遞歸查詢部門樹形結(jié)構(gòu)數(shù)據(jù)就完成了

到此這篇關(guān)于Java 遞歸查詢部門樹形結(jié)構(gòu)數(shù)據(jù)的實(shí)踐的文章就介紹到這了,更多相關(guān)Java 遞歸查詢樹形結(jié)構(gòu)內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！

您可能感興趣的文章: