web前端从Oracle数据库加载动态菜单所用到的数据表

create table menu( 
 menu_id   number(10) primary key, 
 menu_name   varchar(30), 
 menu_url   varchar(200), 
 parent_menu_id   number(10) 
); 
 
/*如果菜单是一级菜单,p_menu_id为0*/ 
insert into menu values(1,"图书管理","",0); 
insert into menu values(2,"订单管理","",0); 
insert into menu values(3,"用户管理","",0); 
insert into menu values(4,"系统设置","",0); 
insert into menu values(5,"图书展示","/system/updatePassword.action",1); 
insert into menu values(6,"新增图书","",1); 
insert into menu values(7,"订单分类","",2); 
insert into menu values(8,"新建订单","",2); 
insert into menu values(9,"用户信息","",3); 
insert into menu values(10,"用户信息设置","",3); 
insert into menu values(11,"管理员信息","",4); 
insert into menu values(12,"管理员权限设置","",4);