数据库多层数据运用递归算法生成树形数据

第一步：准备表结构及对应的表数据

1.表结构

create table City
(
id char(32) not null,
name varchar2(30),
parent_id char(32) //父级字段
)

2.插入数据

insert into City (id, name, parent_id) values (1, '书籍', 0);
insert into City (id, name, parent_id) values (2, '科普书籍', 1);
insert into City (id, name, parent_id) values (3, '教科书籍', 1);
insert into City (id, name, parent_id) values (4, '童话书籍', 1);
insert into City (id, name, parent_id) values (5, '语文', 3);
insert into City (id, name, parent_id) values (6, '数学', 3);
insert into City (id, name, parent_id) values (7, '九年级上册语文书', 5);
insert into City (id, name, parent_id) values (8, '九年级下册语文书', 5);
insert into City (id, name, parent_id) values (9, '九年级上册数学书', 6);
insert into City (id, name, parent_id) values (10, '九年级下册数学书', 6);
insert into City (id, name, pare