init.sql

hibernate项目开发宝典该书籍的 源码

delete from function_action;
delete from action;
delete from role_function;
delete from functions;
delete from roles;


insert into roles values( '1', 'admin', '管理员' );
insert into roles values( '2', 'teacher', '教师' );
insert into roles values( '3', 'student', '学生' );


insert into functions values( '1', 'changepassword', '修改密码' );
insert into functions values( '2', 'homepage', '返回首页' );
insert into functions values( '3', 'logoff', '退出登录' );
insert into functions values( '4', 'testpaperlist', '考卷列表' );
insert into functions values( '5', 'testpaperadd', '增加考卷' );
insert into functions values( '6', 'testpaperupdate', '修改考卷信息' );
insert into functions values( '7', 'testpaperdelete', '删除考卷' );
insert into functions values( '8', 'questionlist', '试题列表' );
insert into functions values( '9', 'selectquestionadd', '增加选择题' );
insert into functions values( '10', 'selectquestionupdate', '修改选择题' );
insert into functions values( '11', 'selectquestiondelete', '删除选择题' );
insert into functions values( '12', 'yesnoquestionadd', '增加判断题' );
insert into functions values( '13', 'yesnoquestionupdate', '修改判断题' );
insert into functions values( '14', 'yesnoquestiondelete', '删除判断题' );
insert into functions values( '15', 'testpaperstulist', '考卷列表' );
insert into functions values( '16', 'testpaperstuexam', '参加考试' );

insert into role_function( role_id, function_id ) values ( '1', '1' );
insert into role_function( role_id, function_id ) values ( '2', '1' );
insert into role_function( role_id, function_id ) values ( '3', '1' );
insert into role_function( role_id, function_id ) values ( '1', '2' );
insert into role_function( role_id, function_id ) values ( '2', '2' );
insert into role_function( role_id, function_id ) values ( '3', '2' );
insert into role_function( role_id, function_id ) values ( '1', '3' );
insert into role_function( role_id, function_id ) values ( '2', '3' );
insert into role_function( role_id, function_id ) values ( '3', '3' );
insert into role_function( role_id, function_id ) values ( '2', '4' );
insert into role_function( role_id, function_id ) values ( '2', '5' );
insert into role_function( role_id, function_id ) values ( '2', '6' );
insert into role_function( role_id, function_id ) values ( '2', '7' );
insert into role_function( role_id, function_id ) values ( '2', '8' );
insert into role_function( role_id, function_id ) values ( '2', '9' );
insert into role_function( role_id, function_id ) values ( '2', '10' );
insert into role_function( role_id, function_id ) values ( '2', '11' );
insert into role_function( role_id, function_id ) values ( '2', '12' );
insert into role_function( role_id, function_id ) values ( '2', '13' );
insert into role_function( role_id, function_id ) values ( '2', '14' );
insert into role_function( role_id, function_id ) values ( '3', '15' );
insert into role_function( role_id, function_id ) values ( '3', '16' );

insert into action values ( '1', 'Jump to change password page', '/logon', 'passwordin' );
insert into action values ( '2', 'Change the password', '/logon', 'password' );
insert into action values ( '3', 'Back to Homepage', '/logon', 'homepage' );
insert into action values ( '4', 'Back to Homepage', '/logon', 'logoff' );
insert into action values ( '5', 'List the test paper', '/exam/testpaper', 'list' );
insert into action values ( '6', 'Jump to add test paper page', '/exam/testpaper', 'addin' );
insert into action values ( '7', 'Save the test paper', '/exam/testpaper', 'save' );
insert into action values ( '8', 'Jump to update test paper page', '/exam/testpaper', 'updatein' );
insert into action values ( '9', 'Delete the test paper', '/exam/testpaper', 'delete' );
insert into action values ( '10', 'Jump to question page', '/exam/question', 'list' );
insert into action values ( '11', 'Jump to add select question page', '/exam/selectquestion', 'addin' );
insert into action values ( '12', 'Add the Select Question', '/exam/selectquestion', 'add' );
insert into action values ( '13', 'Save select question', '/exam/selectquestion', 'save' );
insert into action values ( '14', 'Jump to update select question page', '/exam/selectquestion', 'updatein' );
insert into action values ( '15', 'Delete Select Question', '/exam/selectquestion', 'delete' );
insert into action values ( '16', 'Jump to add Yes/No question page', '/exam/yesnoquestion', 'addin' );
insert into action values ( '17', 'Add Yes/No Question', '/exam/yesnoquestion', 'add' );
insert into action values ( '18', 'Save Yes/No question', '/exam/yesnoquestion', 'save' );
insert into action values ( '19', 'Jump to update Yes/No question page', '/exam/yesnoquestion', 'updatein' );
insert into action values ( '20', 'Delete Yes/No Question', '/exam/yesnoquestion', 'delete' );
insert into action values ( '21', 'Student List the test paper', '/exam/testpaper', 'stulist' );
insert into action values ( '22', 'Student Join the Exam', '/exam/question', 'exam' );
insert into action values ( '23', 'Student Finish the Exam', '/exam/testpaper', 'exam' );


insert into function_action( function_id, action_id ) values( '1', '1' );
insert into function_action( function_id, action_id ) values( '1', '2' );
insert into function_action( function_id, action_id ) values( '2', '3' );
insert into function_action( function_id, action_id ) values( '3', '4' );
insert into function_action( function_id, action_id ) values( '4', '5' );
insert into function_action( function_id, action_id ) values( '5', '6' );
insert into function_action( function_id, action_id ) values( '5', '7' );
insert into function_action( function_id, action_id ) values( '6', '8' );
insert into function_action( function_id, action_id ) values( '6', '7' );
insert into function_action( function_id, action_id ) values( '7', '9' );
insert into function_action( function_id, action_id ) values( '8', '10' );
insert into function_action( function_id, action_id ) values( '9', '11' );
insert into function_action( function_id, action_id ) values( '9', '12' );
insert into function_action( function_id, action_id ) values( '10', '14' );
insert into function_action( function_id, action_id ) values( '10', '13' );
insert into function_action( function_id, action_id ) values( '11', '15' );
insert into function_action( function_id, action_id ) values( '12', '16' );
insert into function_action( function_id, action_id ) values( '12', '17' );
insert into function_action( function_id, action_id ) values( '13', '19' );
insert into function_action( function_id, action_id ) values( '13', '18' );
insert into function_action( function_id, action_id ) values( '14', '20' );
insert into function_action( function_id, action_id ) values( '15', '21' );
insert into function_action( function_id, action_id ) values( '16', '22' );
insert into function_action( function_id, action_id ) values( '16', '23' );