Java 遞歸查詢部門(mén)樹(shù)形結(jié)構(gòu)數(shù)據(jù)的實(shí)踐
說(shuō)明:在開(kāi)發(fā)中,我們經(jīng)常使用樹(shù)形結(jié)構(gòu)來(lái)展示菜單選項(xiàng),如圖:
那么我們?cè)诤蠖嗽趺慈?shí)現(xiàn)這樣的一個(gè)功能呢?
1、數(shù)據(jù)庫(kù)表:department
2、編寫(xiě)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;//部門(mén)code private String departmentname;//部門(mén)名稱 private String updepartmentcode="0";//上級(jí)部門(mén) private String departmentdesc;//部門(mén)描述 private List<Department> childDept =new ArrayList();//部門(mén)信息樹(shù) 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; /** * 查詢所有部門(mén) 樹(shù)形展示所有部門(mén) 包含模糊查詢 * * @return */ @RequestMapping("/treelist") public Object selectAll(Department department) { ModelMap map = new ModelMap(); try { List<Department> departmentDtos = getDepartmentList(department); map.put("msg", "查詢部門(mén)成功"); map.put("data", departmentDtos); map.put("code", 0); } catch (Exception e) { e.printStackTrace(); map.put("msg", "查詢部門(mén)失敗"); map.put("code", 1); } return map; } /** * 遞歸查詢部門(mén) * @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é)果如下圖
到這里,遞歸查詢部門(mén)樹(shù)形結(jié)構(gòu)數(shù)據(jù)就完成了
到此這篇關(guān)于Java 遞歸查詢部門(mén)樹(shù)形結(jié)構(gòu)數(shù)據(jù)的實(shí)踐的文章就介紹到這了,更多相關(guān)Java 遞歸查詢樹(shù)形結(jié)構(gòu)內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!
- java返回前端樹(shù)形結(jié)構(gòu)數(shù)據(jù)的2種實(shí)現(xiàn)方式
- 詳解如何使用Java流API構(gòu)建樹(shù)形結(jié)構(gòu)數(shù)據(jù)
- java父子節(jié)點(diǎn)parentid樹(shù)形結(jié)構(gòu)數(shù)據(jù)的規(guī)整
- java遞歸實(shí)現(xiàn)樹(shù)形結(jié)構(gòu)數(shù)據(jù)完整案例
- Java?處理樹(shù)形結(jié)構(gòu)數(shù)據(jù)的過(guò)程
- Java樹(shù)形結(jié)構(gòu)數(shù)據(jù)生成導(dǎo)出excel文件方法記錄
- Java如何使用遞歸查詢多級(jí)樹(shù)形結(jié)構(gòu)數(shù)據(jù)(多級(jí)菜單)
相關(guān)文章
mybatis-plus更新策略部分字段不更新問(wèn)題
這篇文章主要介紹了mybatis-plus更新策略部分字段不更新問(wèn)題,具有很好的參考價(jià)值,希望對(duì)大家有所幫助,如有錯(cuò)誤或未考慮完全的地方,望不吝賜教2024-03-03Java和scala實(shí)現(xiàn) Spark RDD轉(zhuǎn)換成DataFrame的兩種方法小結(jié)
今天小編就為大家分享一篇Java和scala實(shí)現(xiàn) Spark RDD轉(zhuǎn)換成DataFrame的兩種方法小結(jié),具有很好的參考價(jià)值,希望對(duì)大家有所幫助。一起跟隨小編過(guò)來(lái)看看吧2018-06-06SpringBoot中使用MQTT實(shí)現(xiàn)消息的訂閱和發(fā)布(示例代碼)
這篇文章主要介紹了SpringBoot中使用MQTT實(shí)現(xiàn)消息的訂閱和發(fā)布的相關(guān)知識(shí),本文通過(guò)實(shí)例代碼給大家介紹的非常詳細(xì),感興趣的朋友跟隨小編一起看看吧2024-06-06Java基礎(chǔ)之Unsafe內(nèi)存操作不安全類詳解
Java是面向?qū)ο笳Z(yǔ)言,在使用Java編程時(shí),大多數(shù)情況下都不會(huì)直接操作內(nèi)存,而且Java也不提倡直接操作內(nèi)存,但是Java中到底有沒(méi)有可以直接操作內(nèi)存的工具類呢?有!Java中提供Unsafe類可以用來(lái)來(lái)直接操作內(nèi)存,文中詳細(xì)介紹了Unsafe內(nèi)存操作不安全類,需要的朋友可以參考下2021-06-06Maven?Web項(xiàng)目使用Cargo插件實(shí)現(xiàn)自動(dòng)化部署的詳細(xì)步驟
cargo ,它是一組幫助用戶實(shí)現(xiàn)自動(dòng)化部署,操作Web容器的工具,并且?guī)缀踔С炙械腤eb容器,這篇文章主要介紹了Maven?Web項(xiàng)目使用Cargo實(shí)現(xiàn)自動(dòng)化部署,需要的朋友可以參考下2023-02-02Spring Boot如何動(dòng)態(tài)創(chuàng)建Bean示例代碼
這篇文章主要給大家介紹了關(guān)于Spring Boot如何動(dòng)態(tài)創(chuàng)建Bean的相關(guān)資料,文中通過(guò)示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧。2017-09-09