设为首页收藏本站
开启辅助访问

在路上

 找回密码
 立即注册
在路上 › 站点首页 ›学习 › 查看内容

java根据数据库表内容生产树结构json数据的方法

2017-3-7 12:50| 发布者: zhangjf| 查看: 1005| 评论: 0

摘要: 1、利用场景 组织机构树，通常会有组织机构表，其中有code(代码),pcode(上级代码),name(组织名称)等字段 2、构造数据（以下数据并不是组织机构数据，而纯属本人胡编乱造的数据） ListTreeTest trees = new ArrayList ...

1、利用场景

组织机构树，通常会有组织机构表，其中有code(代码),pcode(上级代码),name(组织名称)等字段

2、构造数据（以下数据并不是组织机构数据，而纯属本人胡编乱造的数据）

  2. List<Tree<Test>> trees = new ArrayList<Tree<Test>>();
  3. tests.add(new Test("0", "", "关于本人"));
  4. tests.add(new Test("1", "0", "技术学习"));
  5. tests.add(new Test("2", "0", "兴趣"));
  6. tests.add(new Test("3", "1", "JAVA"));
  7. tests.add(new Test("4", "1", "oracle"));
  8. tests.add(new Test("5", "1", "spring"));
  9. tests.add(new Test("6", "1", "springmvc"));
  10. tests.add(new Test("7", "1", "fastdfs"));
  11. tests.add(new Test("8", "1", "linux"));
  12. tests.add(new Test("9", "2", "骑行"));
  13. tests.add(new Test("10", "2", "吃喝玩乐"));
  14. tests.add(new Test("11", "2", "学习"));
  15. tests.add(new Test("12", "3", "String"));
  16. tests.add(new Test("13", "4", "sql"));
  17. tests.add(new Test("14", "5", "ioc"));
  18. tests.add(new Test("15", "5", "aop"));
  19. tests.add(new Test("16", "1", "等等"));
  20. tests.add(new Test("17", "2", "等等"));
  21. tests.add(new Test("18", "3", "等等"));
  22. tests.add(new Test("19", "4", "等等"));
  23. tests.add(new Test("20", "5", "等等"));
复制代码

3、源码

Tree.java

  2. package pers.kangxu.datautils.bean.tree;
  4. import java.util.ArrayList;
  5. import java.util.List;
  6. import java.util.Map;
  8. import com.alibaba.fastjson.JSON;
  10. /**
  11. * tree TODO <br>
  12. *
  13. * @author kangxu2 2017-1-7
  14. *
  15. */
  16. public class Tree<T> {
  17. /**
  18. * 节点ID
  19. */
  20. private String id;
  21. /**
  22. * 显示节点文本
  23. */
  24. private String text;
  25. /**
  26. * 节点状态，open closed
  27. */
  28. private String state = "open";
  29. /**
  30. * 节点是否被选中 true false
  31. */
  32. private boolean checked = false;
  33. /**
  34. * 节点属性
  35. */
  36. private List<Map<String, Object>> attributes;
  37. /**
  38. * 节点的子节点
  39. */
  40. private List<Tree<T>> children = new ArrayList<Tree<T>>();
  42. /**
  43. * 父ID
  44. */
  45. private String parentId;
  46. /**
  47. * 是否有父节点
  48. */
  49. private boolean isParent = false;
  50. /**
  51. * 是否有子节点
  52. */
  53. private boolean isChildren = false;
  55. public String getId() {
  56. return id;
  57. }
  59. public void setId(String id) {
  60. this.id = id;
  61. }
  63. public String getText() {
  64. return text;
  65. }
  67. public void setText(String text) {
  68. this.text = text;
  69. }
  71. public String getState() {
  72. return state;
  73. }
  75. public void setState(String state) {
  76. this.state = state;
  77. }
  79. public boolean isChecked() {
  80. return checked;
  81. }
  83. public void setChecked(boolean checked) {
  84. this.checked = checked;
  85. }
  87. public List<Map<String, Object>> getAttributes() {
  88. return attributes;
  89. }
  91. public void setAttributes(List<Map<String, Object>> attributes) {
  92. this.attributes = attributes;
  93. }
  95. public List<Tree<T>> getChildren() {
  96. return children;
  97. }
  99. public void setChildren(List<Tree<T>> children) {
  100. this.children = children;
  101. }
  103. public boolean isParent() {
  104. return isParent;
  105. }
  107. public void setParent(boolean isParent) {
  108. this.isParent = isParent;
  109. }
  111. public boolean isChildren() {
  112. return isChildren;
  113. }
  115. public void setChildren(boolean isChildren) {
  116. this.isChildren = isChildren;
  117. }
  119. public String getParentId() {
  120. return parentId;
  121. }
  123. public void setParentId(String parentId) {
  124. this.parentId = parentId;
  125. }
  127. public Tree(String id, String text, String state, boolean checked,
  128. List<Map<String, Object>> attributes, List<Tree<T>> children,
  129. boolean isParent, boolean isChildren, String parentID) {
  130. super();
  131. this.id = id;
  132. this.text = text;
  133. this.state = state;
  134. this.checked = checked;
  135. this.attributes = attributes;
  136. this.children = children;
  137. this.isParent = isParent;
  138. this.isChildren = isChildren;
  139. this.parentId = parentID;
  140. }
  142. public Tree() {
  143. super();
  144. }
  146. @Override
  147. public String toString() {
  149. return JSON.toJSONString(this);
  150. }
  152. }
复制代码

BuildTree.java

  2. package pers.kangxu.datautils.common.tree;
  4. import java.util.ArrayList;
  5. import java.util.List;
  7. import pers.kangxu.datautils.bean.tree.Tree;
  9. /**
  10. * 构建tree
  11. * TODO
  12. * <br>
  13. * @author kangxu2 2017-1-7
  14. *
  15. */
  16. public class BuildTree {
  18. /**
  19. *
  20. * TODO
  21. * <br>
  22. * @author kangxu2 2017-1-7
  23. *
  24. * @param nodes
  25. * @return
  26. */
  27. public static <T> Tree<T> build(List<Tree<T>> nodes) {
  29. if(nodes == null){
  30. return null;
  31. }
  32. List<Tree<T>> topNodes = new ArrayList<Tree<T>>();
  34. for (Tree<T> children : nodes) {
  36. String pid = children.getParentId();
  37. if (pid == null || "".equals(pid)) {
  38. topNodes.add(children);
  40. continue;
  41. }
  43. for (Tree<T> parent : nodes) {
  44. String id = parent.getId();
  45. if (id != null && id.equals(pid)) {
  46. parent.getChildren().add(children);
  47. children.setParent(true);
  48. parent.setChildren(true);
  50. continue;
  51. }
  52. }
  54. }
  56. Tree<T> root = new Tree<T>();
  57. if (topNodes.size() == 0) {
  58. root = topNodes.get(0);
  59. } else {
  60. root.setId("-1");
  61. root.setParentId("");
  62. root.setParent(false);
  63. root.setChildren(true);
  64. root.setChecked(true);
  65. root.setChildren(topNodes);
  66. root.setText("顶级节点");
  68. }
  70. return root;
  71. }
  73. }
复制代码

BuildTreeTester.java

  2. package pers.kangxu.datautils.test;
  4. import java.util.ArrayList;
  5. import java.util.List;
  7. import pers.kangxu.datautils.bean.tree.Tree;
  8. import pers.kangxu.datautils.common.tree.BuildTree;
  10. public class BuildTreeTester {
  12. public static void main(String[] args) {
  15. List<Tree<Test>> trees = new ArrayList<Tree<Test>>();
  16. List<Test> tests = new ArrayList<Test>();
  17. tests.add(new Test("0", "", "关于本人"));
  18. tests.add(new Test("1", "0", "技术学习"));
  19. tests.add(new Test("2", "0", "兴趣"));
  20. tests.add(new Test("3", "1", "JAVA"));
  21. tests.add(new Test("4", "1", "oracle"));
  22. tests.add(new Test("5", "1", "spring"));
  23. tests.add(new Test("6", "1", "springmvc"));
  24. tests.add(new Test("7", "1", "fastdfs"));
  25. tests.add(new Test("8", "1", "linux"));
  26. tests.add(new Test("9", "2", "骑行"));
  27. tests.add(new Test("10", "2", "吃喝玩乐"));
  28. tests.add(new Test("11", "2", "学习"));
  29. tests.add(new Test("12", "3", "String"));
  30. tests.add(new Test("13", "4", "sql"));
  31. tests.add(new Test("14", "5", "ioc"));
  32. tests.add(new Test("15", "5", "aop"));
  33. tests.add(new Test("16", "1", "等等"));
  34. tests.add(new Test("17", "2", "等等"));
  35. tests.add(new Test("18", "3", "等等"));
  36. tests.add(new Test("19", "4", "等等"));
  37. tests.add(new Test("20", "5", "等等"));
  39. for (Test test : tests) {
  40. Tree<Test> tree = new Tree<Test>();
  41. tree.setId(test.getId());
  42. tree.setParentId(test.getPid());
  43. tree.setText(test.getText());
  45. trees.add(tree);
  46. }
  48. Tree<Test> t = BuildTree.build(trees);
  49. System.out.println(t);
  50. }
  51. }
  53. class Test {
  55. private String id;
  56. private String pid;
  57. private String text;
  59. public String getId() {
  60. return id;
  61. }
  63. public void setId(String id) {
  64. this.id = id;
  65. }
  67. public String getPid() {
  68. return pid;
  69. }
  71. public void setPid(String pid) {
  72. this.pid = pid;
  73. }
  75. public String getText() {
  76. return text;
  77. }
  79. public void setText(String text) {
  80. this.text = text;
  81. }
  83. public Test(String id, String pid, String text) {
  84. super();
  85. this.id = id;
  86. this.pid = pid;
  87. this.text = text;
  88. }
  90. public Test() {
  91. super();
  92. }
  94. @Override
  95. public String toString() {
  96. return "Test [id=" + id + ", pid=" + pid + ", text=" + text + "]";
  97. }
  99. }
复制代码

4、运行结果

JSON数据：

  2. {
  3. "checked": true,
  4. "children": [
  5. {
  6. "checked": false,
  7. "children": [
  8. {
  9. "checked": false,
  10. "children": [
  11. {
  12. "checked": false,
  13. "children": [
  14. {
  15. "checked": false,
  16. "children": [],
  17. "id": "12",
  18. "parent": true,
  19. "parentId": "3",
  20. "state": "open",
  21. "text": "String"
  22. },
  23. {
  24. "checked": false,
  25. "children": [],
  26. "id": "18",
  27. "parent": true,
  28. "parentId": "3",
  29. "state": "open",
  30. "text": "等等"
  31. }
  32. ],
  33. "id": "3",
  34. "parent": true,
  35. "parentId": "1",
  36. "state": "open",
  37. "text": "JAVA"
  38. },
  39. {
  40. "checked": false,
  41. "children": [
  42. {
  43. "checked": false,
  44. "children": [],
  45. "id": "13",
  46. "parent": true,
  47. "parentId": "4",
  48. "state": "open",
  49. "text": "sql"
  50. },
  51. {
  52. "checked": false,
  53. "children": [],
  54. "id": "19",
  55. "parent": true,
  56. "parentId": "4",
  57. "state": "open",
  58. "text": "等等"
  59. }
  60. ],
  61. "id": "4",
  62. "parent": true,
  63. "parentId": "1",
  64. "state": "open",
  65. "text": "oracle"
  66. },
  67. {
  68. "checked": false,
  69. "children": [
  70. {
  71. "checked": false,
  72. "children": [],
  73. "id": "14",
  74. "parent": true,
  75. "parentId": "5",
  76. "state": "open",
  77. "text": "ioc"
  78. },
  79. {
  80. "checked": false,
  81. "children": [],
  82. "id": "15",
  83. "parent": true,
  84. "parentId": "5",
  85. "state": "open",
  86. "text": "aop"
  87. },
  88. {
  89. "checked": false,
  90. "children": [],
  91. "id": "20",
  92. "parent": true,
  93. "parentId": "5",
  94. "state": "open",
  95. "text": "等等"
  96. }
  97. ],
  98. "id": "5",
  99. "parent": true,
  100. "parentId": "1",
  101. "state": "open",
  102. "text": "spring"
  103. },
  104. {
  105. "checked": false,
  106. "children": [],
  107. "id": "6",
  108. "parent": true,
  109. "parentId": "1",
  110. "state": "open",
  111. "text": "springmvc"
  112. },
  113. {
  114. "checked": false,
  115. "children": [],
  116. "id": "7",
  117. "parent": true,
  118. "parentId": "1",
  119. "state": "open",
  120. "text": "fastdfs"
  121. },
  122. {
  123. "checked": false,
  124. "children": [],
  125. "id": "8",
  126. "parent": true,
  127. "parentId": "1",
  128. "state": "open",
  129. "text": "linux"
  130. },
  131. {
  132. "checked": false,
  133. "children": [],
  134. "id": "16",
  135. "parent": true,
  136. "parentId": "1",
  137. "state": "open",
  138. "text": "等等"
  139. }
  140. ],
  141. "id": "1",
  142. "parent": true,
  143. "parentId": "0",
  144. "state": "open",
  145. "text": "技术学习"
  146. },
  147. {
  148. "checked": false,
  149. "children": [
  150. {
  151. "checked": false,
  152. "children": [],
  153. "id": "9",
  154. "parent": true,
  155. "parentId": "2",
  156. "state": "open",
  157. "text": "骑行"
  158. },
  159. {
  160. "checked": false,
  161. "children": [],
  162. "id": "10",
  163. "parent": true,
  164. "parentId": "2",
  165. "state": "open",
  166. "text": "吃喝玩乐"
  167. },
  168. {
  169. "checked": false,
  170. "children": [],
  171. "id": "11",
  172. "parent": true,
  173. "parentId": "2",
  174. "state": "open",
  175. "text": "学习"
  176. },
  177. {
  178. "checked": false,
  179. "children": [],
  180. "id": "17",
  181. "parent": true,
  182. "parentId": "2",
  183. "state": "open",
  184. "text": "等等"
  185. }
  186. ],
  187. "id": "2",
  188. "parent": true,
  189. "parentId": "0",
  190. "state": "open",
  191. "text": "兴趣"
  192. }
  193. ],
  194. "id": "0",
  195. "parent": false,
  196. "parentId": "",
  197. "state": "open",
  198. "text": "关于本人"
  199. }
  200. ],
  201. "id": "-1",
  202. "parent": false,
  203. "parentId": "",
  204. "state": "open",
  205. "text": "顶级节点"
  206. }
复制代码

以上就是小编为大家带来的java根据数据库表内容生产树结构json数据的方法全部内容了，希望大家多多支持程序员之家~

收藏 邀请
上一篇：深入理解Spring AOP下一篇：Java开发中读取XML与properties配置文件的方法

最新评论

相关分类

小黑屋|在路上 ( 蜀ICP备15035742号-1 )  

;

GMT+8, 2025-5-4 02:40

Copyright 2015-2025 djqfx

返回顶部