java根据数据库表内容生产树结构json数据的方法
1、利用场景
组织机构树，通常会有组织机构表，其中有code(代码),pcode(上级代码),name(组织名称)等字段
2、构造数据（以下数据并不是组织机构数据，而纯属本人胡编乱造的数据）
List<Tree<Test>> trees = new ArrayList<Tree<Test>>();
tests.add(new Test("0", "", "关于本人"));
tests.add(new Test("1", "0", "技术学习"));
tests.add(new Test("2", "0", "兴趣"));
tests.add(new Test("3", "1", "JAVA"));
tests.add(new Test("4", "1", "oracle"));
tests.add(new Test("5", "1", "spring"));
tests.add(new Test("6", "1", "springmvc"));
tests.add(new Test("7", "1", "fastdfs"));
tests.add(new Test("8", "1", "linux"));
tests.add(new Test("9", "2", "骑行"));
tests.add(new Test("10", "2", "吃喝玩乐"));
tests.add(new Test("11", "2", "学习"));
tests.add(new Test("12", "3", "String"));
tests.add(new Test("13", "4", "sql"));
tests.add(new Test("14", "5", "ioc"));
tests.add(new Test("15", "5", "aop"));
tests.add(new Test("16", "1", "等等"));
tests.add(new Test("17", "2", "等等"));
tests.add(new Test("18", "3", "等等"));
tests.add(new Test("19", "4", "等等"));
tests.add(new Test("20", "5", "等等"));登录后复制
3、源码
Tree.java
package pers.kangxu.datautils.bean.tree;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import com.alibaba.fastjson.JSON;
/**
* tree TODO <br>
*
* @author kangxu2 2017-1-7
*
*/
public class Tree<T> {
/**
* 节点ID
*/
private String id;
/**
* 显示节点文本
*/
private String text;
/**
* 节点状态，open closed
*/
private String state = "open";
/**
* 节点是否被选中 true false
*/
private boolean checked = false;
/**
* 节点属性
*/
private List<Map<String, Object>> attributes;
/**
* 节点的子节点
*/
private List<Tree<T>> children = new ArrayList<Tree<T>>();
/**
* 父ID
*/
private String parentId;
/**
* 是否有父节点
*/
private boolean isParent = false;
/**
* 是否有子节点
*/
private boolean isChildren = false;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getText() {
return text;
}
public void setText(String text) {
this.text = text;
}
public String getState() {
return state;
}
public void setState(String state) {
this.state = state;
}
public boolean isChecked() {
return checked;
}
public void setChecked(boolean checked) {
this.checked = checked;
}
public List<Map<String, Object>> getAttributes() {
return attributes;
}
public void setAttributes(List<Map<String, Object>> attributes) {
this.attributes = attributes;
}
public List<Tree<T>> getChildren() {
return children;
}
public void setChildren(List<Tree<T>> children) {
this.children = children;
}
public boolean isParent() {
return isParent;
}
public void setParent(boolean isParent) {
this.isParent = isParent;
}
public boolean isChildren() {
return isChildren;
}
public void setChildren(boolean isChildren) {
this.isChildren = isChildren;
}
public String getParentId() {
return parentId;
}
public void setParentId(String parentId) {
this.parentId = parentId;
}
public Tree(String id, String text, String state, boolean checked,
List<Map<String, Object>> attributes, List<Tree<T>> children,
boolean isParent, boolean isChildren, String parentID) {
super();
this.id = id;
this.text = text;
this.state = state;
this.checked = checked;
this.attributes = attributes;
this.children = children;
this.isParent = isParent;
this.isChildren = isChildren;
this.parentId = parentID;
}
public Tree() {
super();
}
@Override
public String toString() {
return JSON.toJSONString(this);
}
}登录后复制
BuildTree.java
package pers.kangxu.datautils.common.tree;
import java.util.ArrayList;
import java.util.List;
import pers.kangxu.datautils.bean.tree.Tree;
/**
* 构建tree
* TODO
* <br>
* @author kangxu2 2017-1-7
*
*/
public class BuildTree {
/**
*
* TODO
* <br>
* @author kangxu2 2017-1-7
*
* @param nodes
* @return
*/
public static <T> Tree<T> build(List<Tree<T>> nodes) {
if(nodes == null){
return null;
}
List<Tree<T>> topNodes = new ArrayList<Tree<T>>();
for (Tree<T> children : nodes) {
String pid = children.getParentId();
if (pid == null || "".equals(pid)) {
topNodes.add(children);
continue;
}
for (Tree<T> parent : nodes) {
String id = parent.getId();
if (id != null && id.equals(pid)) {
parent.getChildren().add(children);
children.setParent(true);
parent.setChildren(true);
continue;
}
}
}
Tree<T> root = new Tree<T>();
if (topNodes.size() == 0) {
root = topNodes.get(0);
} else {
root.setId("-1");
root.setParentId("");
root.setParent(false);
root.setChildren(true);
root.setChecked(true);
root.setChildren(topNodes);
root.setText("顶级节点");
}
return root;
}
}登录后复制
BuildTreeTester.java
package pers.kangxu.datautils.test;
import java.util.ArrayList;
import java.util.List;
import pers.kangxu.datautils.bean.tree.Tree;
import pers.kangxu.datautils.common.tree.BuildTree;
public class BuildTreeTester {
public static void main(String[] args) {
List<Tree<Test>> trees = new ArrayList<Tree<Test>>();
List<Test> tests = new ArrayList<Test>();
tests.add(new Test("0", "", "关于本人"));
tests.add(new Test("1", "0", "技术学习"));
tests.add(new Test("2", "0", "兴趣"));
tests.add(new Test("3", "1", "JAVA"));
tests.add(new Test("4", "1", "oracle"));
tests.add(new Test("5", "1", "spring"));
tests.add(new Test("6", "1", "springmvc"));
tests.add(new Test("7", "1", "fastdfs"));
tests.add(new Test("8", "1", "linux"));
tests.add(new Test("9", "2", "骑行"));
tests.add(new Test("10", "2", "吃喝玩乐"));
tests.add(new Test("11", "2", "学习"));
tests.add(new Test("12", "3", "String"));
tests.add(new Test("13", "4", "sql"));
tests.add(new Test("14", "5", "ioc"));
tests.add(new Test("15", "5", "aop"));
tests.add(new Test("16", "1", "等等"));
tests.add(new Test("17", "2", "等等"));
tests.add(new Test("18", "3", "等等"));
tests.add(new Test("19", "4", "等等"));
tests.add(new Test("20", "5", "等等"));
for (Test test : tests) {
Tree<Test> tree = new Tree<Test>();
tree.setId(test.getId());
tree.setParentId(test.getPid());
tree.setText(test.getText());
trees.add(tree);
}
Tree<Test> t = BuildTree.build(trees);
System.out.println(t);
}
}
class Test {
private String id;
private String pid;
private String text;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getPid() {
return pid;
}
public void setPid(String pid) {
this.pid = pid;
}
public String getText() {
return text;
}
public void setText(String text) {
this.text = text;
}
public Test(String id, String pid, String text) {
super();
this.id = id;
this.pid = pid;
this.text = text;
}
public Test() {
super();
}
@Override
public String toString() {
return "Test [id=" + id + ", pid=" + pid + ", text=" + text + "]";
}
}登录后复制
4、运行结果
JSON数据：
{
"checked": true,
"children": [
{
"checked": false,
"children": [
{
"checked": false,
"children": [
{
"checked": false,
"children": [
{
"checked": false,
"children": [],
"id": "12",
"parent": true,
"parentId": "3",
"state": "open",
"text": "String"
},
{
"checked": false,
"children": [],
"id": "18",
"parent": true,
"parentId": "3",
"state": "open",
"text": "等等"
}
],
"id": "3",
"parent": true,
"parentId": "1",
"state": "open",
"text": "JAVA"
},
{
"checked": false,
"children": [
{
"checked": false,
"children": [],
"id": "13",
"parent": true,
"parentId": "4",
"state": "open",
"text": "sql"
},
{
"checked": false,
"children": [],
"id": "19",
"parent": true,
"parentId": "4",
"state": "open",
"text": "等等"
}
],
"id": "4",
"parent": true,
"parentId": "1",
"state": "open",
"text": "oracle"
},
{
"checked": false,
"children": [
{
"checked": false,
"children": [],
"id": "14",
"parent": true,
"parentId": "5",
"state": "open",
"text": "ioc"
},
{
"checked": false,
"children": [],
"id": "15",
"parent": true,
"parentId": "5",
"state": "open",
"text": "aop"
},
{
"checked": false,
"children": [],
"id": "20",
"parent": true,
"parentId": "5",
"state": "open",
"text": "等等"
}
],
"id": "5",
"parent": true,
"parentId": "1",
"state": "open",
"text": "spring"
},
{
"checked": false,
"children": [],
"id": "6",
"parent": true,
"parentId": "1",
"state": "open",
"text": "springmvc"
},
{
"checked": false,
"children": [],
"id": "7",
"parent": true,
"parentId": "1",
"state": "open",
"text": "fastdfs"
},
{
"checked": false,
"children": [],
"id": "8",
"parent": true,
"parentId": "1",
"state": "open",
"text": "linux"
},
{
"checked": false,
"children": [],
"id": "16",
"parent": true,
"parentId": "1",
"state": "open",
"text": "等等"
}
],
"id": "1",
"parent": true,
"parentId": "0",
"state": "open",
"text": "技术学习"
},
{
"checked": false,
"children": [
{
"checked": false,
"children": [],
"id": "9",
"parent": true,
"parentId": "2",
"state": "open",
"text": "骑行"
},
{
"checked": false,
"children": [],
"id": "10",
"parent": true,
"parentId": "2",
"state": "open",
"text": "吃喝玩乐"
},
{
"checked": false,
"children": [],
"id": "11",
"parent": true,
"parentId": "2",
"state": "open",
"text": "学习"
},
{
"checked": false,
"children": [],
"id": "17",
"parent": true,
"parentId": "2",
"state": "open",
"text": "等等"
}
],
"id": "2",
"parent": true,
"parentId": "0",
"state": "open",
"text": "兴趣"
}
],
"id": "0",
"parent": false,
"parentId": "",
"state": "open",
"text": "关于本人"
}
],
"id": "-1",
"parent": false,
"parentId": "",
"state": "open",
"text": "顶级节点"
}登录后复制
以上就是小编为大家带来的java根据数据库表内容生产树结构json数据的方法全部内容了，希望大家多多支持PHP中文网~
更多java根据数据库表内容生产树结构json数据的方法相关文章请关注PHP中文网！
本站声明
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
热AI工具
Undresser.AI Undress
人工智能驱动的应用程序，用于创建逼真的裸体照片
AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。
Undress AI Tool
免费脱衣服图片
Clothoff.io
AI脱衣机
Video Face Swap
使用我们完全免费的人工智能换脸工具轻松在任何视频中换脸！
热门文章
如何修复KB5055612无法在Windows 10中安装？
3 周前
By DDD
<🎜>：种植花园 - 完整的突变指南
3 周前
By DDD
<🎜>：泡泡胶模拟器无穷大 - 如何获取和使用皇家钥匙
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
北端：融合系统，解释
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
Mandragora：巫婆树的耳语 - 如何解锁抓钩
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
热工具
记事本++7.3.1
好用且免费的代码编辑器
SublimeText3汉化版
中文版，非常好用
禅工作室 13.0.1
功能强大的PHP集成开发环境
Dreamweaver CS6
视觉化网页开发工具
SublimeText3 Mac版
神级代码编辑软件(SublimeText3)
公司安全软件导致应用无法运行？如何排查和解决？
Apr 19, 2025 pm 04:51 PM
公司安全软件导致部分应用无法正常运行的排查与解决方法许多公司为了保障内部网络安全，会部署安全软件。...
如何将姓名转换为数字以实现排序并保持群组中的一致性？
Apr 19, 2025 pm 11:30 PM
将姓名转换为数字以实现排序的解决方案在许多应用场景中，用户可能需要在群组中进行排序，尤其是在一个用...
如何使用MapStruct简化系统对接中的字段映射问题？
Apr 19, 2025 pm 06:21 PM
系统对接中的字段映射处理在进行系统对接时，常常会遇到一个棘手的问题：如何将A系统的接口字段有效地映�...
IntelliJ IDEA是如何在不输出日志的情况下识别Spring Boot项目的端口号的？
Apr 19, 2025 pm 11:45 PM
在使用IntelliJIDEAUltimate版本启动Spring...
如何优雅地获取实体类变量名构建数据库查询条件？
Apr 19, 2025 pm 11:42 PM
在使用MyBatis-Plus或其他ORM框架进行数据库操作时，经常需要根据实体类的属性名构造查询条件。如果每次都手动...
Java对象如何安全地转换为数组？
Apr 19, 2025 pm 11:33 PM
Java对象与数组的转换：深入探讨强制类型转换的风险与正确方法很多Java初学者会遇到将一个对象转换成数组的�...
如何利用Redis缓存方案高效实现产品排行榜列表的需求？
Apr 19, 2025 pm 11:36 PM
Redis缓存方案如何实现产品排行榜列表的需求？在开发过程中，我们常常需要处理排行榜的需求，例如展示一个�...
电商平台SKU和SPU数据库设计：如何兼顾用户自定义属性和无属性商品？
Apr 19, 2025 pm 11:27 PM
电商平台SKU和SPU表设计详解本文将探讨电商平台中SKU和SPU的数据库设计问题，特别是如何处理用户自定义销售属...
