The web front end loads the data table used by the dynamic menu from the Oracle database

When we use a software or a so-and-so management system, we will use a hierarchical menu to show us its functional modules clearly. These hierarchical menus can only be shown to us through calls to the database. Today, I will mainly introduce the data sheets that we will use to make grading menus.

1. Menu list

Create table menu (menu_id number (10) primary key, menu_name varchar (30), menu_url varchar (200), parent_menu_id number (10)); / * if the menu is a first-level menu, p_menu_id is 0 minutes / insert into menu values (1', 0); insert into menu values (2', 0); insert into menu values (3', 0) Insert into menu values (4dint 'system setup','', 0); insert into menu values (5dint 'Book Show','/ system/updatePassword.action',1); insert into menu values ('add Books','', 1); insert into menu values ('order Category','', 2); insert into menu values ('New order','', 2); insert into menu values ('user Information','', 3) Insert into menu values (10line 'user information setting','', 3); insert into menu values ('administrator information','', 4); insert into menu values ('administrator permission setting','', 4)

2. Role table

Create table role (role_id number (10) primary key, role_name varchar (20)); insert into role values (1m 'administrator'); insert into role values (2 'sales director')

3. User table

Create table users (user_id number (30), user_name varchar2 (40), user_password varchar2 (40), user_sex char (3), user_phone varchar2 (50), user_email varchar2 (60), user_img varchar2 (40); create sequence seq_u Insert into users (user_id, user_name, user_password, user_sex, user_phone, user_email, user_img) values (seq_u.nextval,' Huang Feihong', '1111qaZhi Zhi' male', '15000102345' Ji Jian 1234567 "qq.composer"

4. Role menu table

Create table role_menu (id number (10) primary key, role_id number (10), menu_id number (10)); / * enter initial data for roles and menus * / insert into role_menu values (1); insert into role_menu values (2); insert into role_menu values (3); insert into role_menu values (4); insert into role_menu values (5); and insert into role_menu values (6) Insert into role_menu values (7 mine1, 7), insert into role_menu values (8, 1, 8), insert into role_menu values (9, 1, 9), insert into role_menu values (10, 1, 10), insert into role_menu values (11, 1, 11); insert into role_menu values (12, 1, 12)

5. Role user table

Create table role_user (id number (10) primary key, role_id number (10), user_id number (10)); / * enter initial data for roles and menus * / insert into role_user values (1meme 1); insert into role_user values (2meme 2mem2)

After the data table is built, the front end passes the

Select distinct * from users u inner join role_user ru on u.user_id = ru.user_id inner join role_menu rm on ru.role_id = rm.role_id inner join menu m on m.menu_id = rm.menu_id where u.user_id = 1

Such a SQL statement can call the system menu corresponding to the user ID.

Can be shown as above:

Effect picture:

Summary

The above is the data table used by the web front end to load the dynamic menu from the Oracle database. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!